DBA Data[Home] [Help]

APPS.PO_AP_MERGE_GRP dependencies on FND_GLOBAL

Line 806: PGOA.last_updated_by = FND_GLOBAL.user_id,

802: UPDATE po_ga_org_assignments PGOA
803: SET PGOA.vendor_site_id = p_to_site_id,
804: -- Bug 3387904 START - Need to update the WHO columns:
805: PGOA.last_update_date = SYSDATE,
806: PGOA.last_updated_by = FND_GLOBAL.user_id,
807: PGOA.last_update_login = FND_GLOBAL.login_id
808: -- Bug 3387904 END
809: WHERE PGOA.vendor_site_id = p_from_site_id;
810:

Line 807: PGOA.last_update_login = FND_GLOBAL.login_id

803: SET PGOA.vendor_site_id = p_to_site_id,
804: -- Bug 3387904 START - Need to update the WHO columns:
805: PGOA.last_update_date = SYSDATE,
806: PGOA.last_updated_by = FND_GLOBAL.user_id,
807: PGOA.last_update_login = FND_GLOBAL.login_id
808: -- Bug 3387904 END
809: WHERE PGOA.vendor_site_id = p_from_site_id;
810:
811: UPDATE po_ga_org_assignments_archive PGOA

Line 815: PGOA.last_updated_by = FND_GLOBAL.user_id,

811: UPDATE po_ga_org_assignments_archive PGOA
812: SET PGOA.vendor_site_id = p_to_site_id,
813: -- Bug 3387904 START - Need to update the WHO columns:
814: PGOA.last_update_date = SYSDATE,
815: PGOA.last_updated_by = FND_GLOBAL.user_id,
816: PGOA.last_update_login = FND_GLOBAL.login_id
817: -- Bug 3387904 END
818: WHERE PGOA.vendor_site_id = p_from_site_id;
819:

Line 816: PGOA.last_update_login = FND_GLOBAL.login_id

812: SET PGOA.vendor_site_id = p_to_site_id,
813: -- Bug 3387904 START - Need to update the WHO columns:
814: PGOA.last_update_date = SYSDATE,
815: PGOA.last_updated_by = FND_GLOBAL.user_id,
816: PGOA.last_update_login = FND_GLOBAL.login_id
817: -- Bug 3387904 END
818: WHERE PGOA.vendor_site_id = p_from_site_id;
819:
820: l_progress := '020';

Line 1020: last_updated_by = FND_GLOBAL.user_id,

1016: WHERE PVS.vendor_site_id = p_to_site_id),
1017: vendor_id = p_to_vendor_id,
1018: vendor_site_id = p_to_site_id,
1019: last_update_date = SYSDATE,
1020: last_updated_by = FND_GLOBAL.user_id,
1021: last_update_login = FND_GLOBAL.login_id
1022: WHERE vendor_id = p_from_vendor_id
1023: AND vendor_site_id = p_from_site_id;
1024:

Line 1021: last_update_login = FND_GLOBAL.login_id

1017: vendor_id = p_to_vendor_id,
1018: vendor_site_id = p_to_site_id,
1019: last_update_date = SYSDATE,
1020: last_updated_by = FND_GLOBAL.user_id,
1021: last_update_login = FND_GLOBAL.login_id
1022: WHERE vendor_id = p_from_vendor_id
1023: AND vendor_site_id = p_from_site_id;
1024:
1025: IF (g_debug_stmt) THEN

Line 1047: last_updated_by = FND_GLOBAL.user_id,

1043: FROM po_vendors PV
1044: WHERE PV.vendor_id = p_to_vendor_id),
1045: vendor_id = p_to_vendor_id,
1046: last_update_date = SYSDATE,
1047: last_updated_by = FND_GLOBAL.user_id,
1048: last_update_login = FND_GLOBAL.login_id
1049: WHERE vendor_id = p_from_vendor_id
1050: AND vendor_site_id IS NULL
1051: AND EXISTS

Line 1048: last_update_login = FND_GLOBAL.login_id

1044: WHERE PV.vendor_id = p_to_vendor_id),
1045: vendor_id = p_to_vendor_id,
1046: last_update_date = SYSDATE,
1047: last_updated_by = FND_GLOBAL.user_id,
1048: last_update_login = FND_GLOBAL.login_id
1049: WHERE vendor_id = p_from_vendor_id
1050: AND vendor_site_id IS NULL
1051: AND EXISTS
1052: (SELECT vendor_id

Line 1138: PRL.last_updated_by = FND_GLOBAL.user_id,

1134: UPDATE po_reqexpress_lines_all PRL
1135: SET PRL.suggested_vendor_id = p_to_vendor_id,
1136: PRL.suggested_vendor_site_id = p_to_site_id,
1137: PRL.last_update_date = SYSDATE,
1138: PRL.last_updated_by = FND_GLOBAL.user_id,
1139: PRL.last_update_login = FND_GLOBAL.login_id
1140: WHERE PRL.suggested_vendor_id = p_from_vendor_id
1141: AND PRL.suggested_vendor_site_id = p_from_site_id;
1142:

Line 1139: PRL.last_update_login = FND_GLOBAL.login_id

1135: SET PRL.suggested_vendor_id = p_to_vendor_id,
1136: PRL.suggested_vendor_site_id = p_to_site_id,
1137: PRL.last_update_date = SYSDATE,
1138: PRL.last_updated_by = FND_GLOBAL.user_id,
1139: PRL.last_update_login = FND_GLOBAL.login_id
1140: WHERE PRL.suggested_vendor_id = p_from_vendor_id
1141: AND PRL.suggested_vendor_site_id = p_from_site_id;
1142:
1143:

Line 1164: last_updated_by = FND_GLOBAL.user_id,

1160:
1161: UPDATE po_reqexpress_lines_all PRL
1162: SET PRL.suggested_vendor_id = p_to_vendor_id,
1163: last_update_date = SYSDATE,
1164: last_updated_by = FND_GLOBAL.user_id,
1165: last_update_login = FND_GLOBAL.login_id
1166: WHERE PRL.suggested_vendor_id = p_from_vendor_id
1167: AND PRL.suggested_vendor_site_id IS NULL
1168: AND EXISTS (

Line 1165: last_update_login = FND_GLOBAL.login_id

1161: UPDATE po_reqexpress_lines_all PRL
1162: SET PRL.suggested_vendor_id = p_to_vendor_id,
1163: last_update_date = SYSDATE,
1164: last_updated_by = FND_GLOBAL.user_id,
1165: last_update_login = FND_GLOBAL.login_id
1166: WHERE PRL.suggested_vendor_id = p_from_vendor_id
1167: AND PRL.suggested_vendor_site_id IS NULL
1168: AND EXISTS (
1169: SELECT NULL