DBA Data[Home] [Help]

APPS.CSP_MERGE_PKG dependencies on CSP_MOVEORDER_HEADERS

Line 8: -- CSP_MOVEORDER_HEADERS

4: -- Package name : CSP_MERGE_PKG
5: -- Purpose : Merges duplicate parties in Spares tables. The
6: -- Spares tables that need to be considered for
7: -- Party Merge are:
8: -- CSP_MOVEORDER_HEADERS
9: -- CSP_PACKLIST_HEADERS
10: -- CSP_RS_CUST_RELATIONS
11:
12: --

Line 84: update csp_moveorder_headers

80: -- not transfer and return the id of the duplicate record as the Merged To Id
81:
82: if p_from_fk_id <> p_to_fk_id then
83: begin
84: update csp_moveorder_headers
85: set party_site_id = decode(party_site_id, p_from_fk_id, p_to_fk_id, party_site_id),
86: last_update_date = SYSDATE,
87: last_updated_by = G_USER_ID,
88: last_update_login = G_LOGIN_ID