DBA Data[Home] [Help]

APPS.ITG_SYNCPOINBOUND_PVT dependencies on FND_GLOBAL

Line 576: last_updated_by = FND_GLOBAL.user_id

572: FOR i IN 1 .. l_disttab.COUNT LOOP
573: UPDATE po_distributions_all
574: SET quantity_delivered = l_disttab(i).quantity_delivered,
575: last_update_date = SYSDATE,
576: last_updated_by = FND_GLOBAL.user_id
577: WHERE po_distribution_id = l_disttab(i).po_distribution_id;
578: ITG_Debug.msg('AAD', 'po_distribution_id',
579: l_disttab(i).po_distribution_id);
580: ITG_Debug.msg('AAD', 'quantity_delivered',

Line 591: last_updated_by = FND_GLOBAL.user_id

587: amount_billed = NVL(amount_billed,0) +
588: (l_disttab(i).quantity_billed / p_quantity) *
589: p_total_amount,
590: last_update_date = SYSDATE,
591: last_updated_by = FND_GLOBAL.user_id
592: WHERE po_distribution_id = l_disttab(i).po_distribution_id;
593: ITG_Debug.msg('AAD', 'po_distribution_id',
594: l_disttab(i).po_distribution_id);
595: ITG_Debug.msg('AAD', 'quantity_billed',

Line 728: last_updated_by = FND_GLOBAL.user_id

724: FOR i IN 1 .. l_reqlltab.COUNT LOOP
725: UPDATE po_requisition_lines_all
726: SET quantity_delivered = l_reqlltab(i).quantity_delivered,
727: last_update_date = SYSDATE,
728: last_updated_by = FND_GLOBAL.user_id
729: WHERE requisition_line_id = l_reqlltab(i).requisition_line_id;
730: ITG_Debug.msg('ARL', 'requisition_line_id',
731: l_reqlltab(i).requisition_line_id);
732: ITG_Debug.msg('ARL', 'quantity_delivered',

Line 791: last_updated_by = FND_GLOBAL.user_id

787: ITG_Debug.msg('PRD', 'update po_line_locations_all');
788: UPDATE po_line_locations_all
789: SET quantity_received = l_lltab(i).quantity_received,
790: last_update_date = SYSDATE,
791: last_updated_by = FND_GLOBAL.user_id
792: WHERE line_location_id = l_lltab(i).line_location_id;
793: ITG_Debug.msg('PRD', 'quantity_received',
794: l_lltab(i).quantity_received);
795:

Line 872: last_updated_by = FND_GLOBAL.user_id

868: FOR i IN 1 .. l_lltab.count LOOP
869: UPDATE po_line_locations_all
870: SET quantity_accepted = l_lltab(i).quantity_accepted,
871: last_update_date = SYSDATE,
872: last_updated_by = FND_GLOBAL.user_id
873: WHERE line_location_id = l_lltab(i).line_location_id;
874: ITG_Debug.msg('PID', 'Update po_line_locations_all');
875: ITG_Debug.msg('PID', 'quantity_accepted',
876: l_lltab(i).quantity_accepted);

Line 940: last_updated_by = FND_GLOBAL.user_id

936: ITG_Debug.msg('PI', 'line_location_id', l_lltab(i).line_location_id);
937: UPDATE po_line_locations_all
938: SET quantity_billed = l_lltab(i).quantity_billed,
939: last_update_date = SYSDATE,
940: last_updated_by = FND_GLOBAL.user_id
941: WHERE line_location_id = l_lltab(i).line_location_id;
942:
943: IF l_release_id IS NULL THEN
944: l_doc_type := 'PO';