DBA Data[Home] [Help]

APPS.IGC_VENDOR_MERGE_PVT dependencies on PO_HEADERS

Line 14: -- This API will update the igc_cc_headers table and the po_headers table

10: --
11: -- *************************************************************************
12: -- Procedure : Merge_Vendor
13: -- If CC is enabled,IGI_VENDOR_MERGE_GRP.merge_vendor will call this API.
14: -- This API will update the igc_cc_headers table and the po_headers table
15: -- It will update the PO headers table only for those records which are
16: -- CC related.
17: -- *************************************************************************
18:

Line 15: -- It will update the PO headers table only for those records which are

11: -- *************************************************************************
12: -- Procedure : Merge_Vendor
13: -- If CC is enabled,IGI_VENDOR_MERGE_GRP.merge_vendor will call this API.
14: -- This API will update the igc_cc_headers table and the po_headers table
15: -- It will update the PO headers table only for those records which are
16: -- CC related.
17: -- *************************************************************************
18:
19: PROCEDURE merge_vendor(p_api_version IN NUMBER

Line 55: -- Update the PO headers table for the CC related rows.

51:
52: -- Initialize API return status to success
53: x_return_status := FND_API.G_RET_STS_SUCCESS;
54:
55: -- Update the PO headers table for the CC related rows.
56: UPDATE po_headers
57: SET vendor_id = p_new_vendor_id,
58: vendor_site_id = p_new_vendor_site_id,
59: last_update_date = SYSDATE,

Line 56: UPDATE po_headers

52: -- Initialize API return status to success
53: x_return_status := FND_API.G_RET_STS_SUCCESS;
54:
55: -- Update the PO headers table for the CC related rows.
56: UPDATE po_headers
57: SET vendor_id = p_new_vendor_id,
58: vendor_site_id = p_new_vendor_site_id,
59: last_update_date = SYSDATE,
60: last_update_login = FND_GLOBAL.login_id,