I need to write a PL/SQL function depending
on Operating Unit address where Invoice is being processed, we need to get
local date and time stamp.
e.g.
if US-XXYY is an OU, say its address is California, US and hence when this
invoice is being processed / inserted into Interface table GL Date column (of AP_INVOICES_ALL TABLE) need
to have time stamp at that time. At the same time (after Few seconds) if
another invoice but in JP-XXYY Operating Unit of Japan is being processed GL date need to have
Japan's local time at that time.
Regards,
Ankush Tiwari