APPS.RCV_BILL_UPDATING_SV dependencies on FND_GLOBAL

Line 66: pod.last_updated_by = fnd_global.user_id,

62: --Bug 12886371. Added the updation of who columns
63: UPDATE po_distributions_all pod
64: SET pod.quantity_billed = nvl(pod.quantity_billed,0) + X_po_quantity_billed,
65: pod.amount_billed = nvl(pod.amount_billed,0) + X_po_amount_billed,
66: pod.last_updated_by = fnd_global.user_id,
67: pod.last_update_date=sysdate,
68: pod.last_update_login=fnd_global.login_id
69: WHERE po_distribution_id = X_po_distribution_id
70: OR ( pod.distribution_type = 'PLANNED'

Line 68: pod.last_update_login=fnd_global.login_id

64: SET pod.quantity_billed = nvl(pod.quantity_billed,0) + X_po_quantity_billed,
65: pod.amount_billed = nvl(pod.amount_billed,0) + X_po_amount_billed,
66: pod.last_updated_by = fnd_global.user_id,
67: pod.last_update_date=sysdate,
68: pod.last_update_login=fnd_global.login_id
69: WHERE po_distribution_id = X_po_distribution_id
70: OR ( pod.distribution_type = 'PLANNED'
71: AND pod.po_distribution_id = ( SELECT pod2.source_distribution_id
72: FROM po_distributions pod2

Line 148: pll.last_updated_by = fnd_global.user_id,

144: --Bug 12886371. Added the updation of who columns
145: UPDATE po_line_locations_all pll
146: SET pll.quantity_billed = nvl(pll.quantity_billed,0) + X_po_quantity_billed,
147: pll.amount_billed = nvl(pll.amount_billed,0) + X_po_amount_billed,
148: pll.last_updated_by = fnd_global.user_id,
149: pll.last_update_date=sysdate,
150: pll.last_update_login=fnd_global.login_id
151: WHERE pll.line_location_id = X_po_line_location_id
152: OR ( pll.shipment_type = 'PLANNED'

Line 150: pll.last_update_login=fnd_global.login_id

146: SET pll.quantity_billed = nvl(pll.quantity_billed,0) + X_po_quantity_billed,
147: pll.amount_billed = nvl(pll.amount_billed,0) + X_po_amount_billed,
148: pll.last_updated_by = fnd_global.user_id,
149: pll.last_update_date=sysdate,
150: pll.last_update_login=fnd_global.login_id
151: WHERE pll.line_location_id = X_po_line_location_id
152: OR ( pll.shipment_type = 'PLANNED'
153: AND pll.line_location_id = ( SELECT pll2.source_shipment_id
154: FROM po_line_locations pll2

Line 230: last_updated_by = fnd_global.user_id,

226: rcv_transactions
227: SET
228: quantity_billed = round(X_rcv_quantity_billed,15),
229: amount_billed = X_rcv_amount_billed,
230: last_updated_by = fnd_global.user_id,
231: last_update_date=sysdate,
232: last_update_login=fnd_global.login_id
233: WHERE
234: transaction_id = X_rcv_transaction_id;

Line 232: last_update_login=fnd_global.login_id

228: quantity_billed = round(X_rcv_quantity_billed,15),
229: amount_billed = X_rcv_amount_billed,
230: last_updated_by = fnd_global.user_id,
231: last_update_date=sysdate,
232: last_update_login=fnd_global.login_id
233: WHERE
234: transaction_id = X_rcv_transaction_id;
235:
236: X_progress := '004';