APPS.POS_PARTY_MERGE_PKG dependencies on POS_SUPPLIER_MAPPINGS

Line 36: FROM pos_address_requests par, pos_supplier_mappings psm

32: l_change BOOLEAN;
33:
34: CURSOR l_address IS
35: SELECT 1
36: FROM pos_address_requests par, pos_supplier_mappings psm
37: WHERE psm.party_id = p_party_id
38: AND psm.mapping_id = par.mapping_id
39: AND par.request_status = 'PENDING';
40:

Line 43: FROM pos_bus_class_reqs pbcr, pos_supplier_mappings psm

39: AND par.request_status = 'PENDING';
40:
41: CURSOR l_bus_class IS
42: SELECT 1
43: FROM pos_bus_class_reqs pbcr, pos_supplier_mappings psm
44: WHERE psm.party_id = p_party_id
45: AND psm.mapping_id = pbcr.mapping_id
46: AND pbcr.request_status = 'PENDING';
47:

Line 50: FROM pos_contact_requests pcr, pos_supplier_mappings psm

46: AND pbcr.request_status = 'PENDING';
47:
48: CURSOR l_contacts IS
49: SELECT 1
50: FROM pos_contact_requests pcr, pos_supplier_mappings psm
51: WHERE psm.party_id = p_party_id
52: AND psm.mapping_id = pcr.mapping_id
53: AND pcr.request_status = 'PENDING';
54:

Line 57: FROM pos_cont_addr_requests pcar, pos_supplier_mappings psm

53: AND pcr.request_status = 'PENDING';
54:
55: CURSOR l_cont_addr IS
56: SELECT 1
57: FROM pos_cont_addr_requests pcar, pos_supplier_mappings psm
58: WHERE psm.party_id = p_party_id
59: AND psm.mapping_id = pcar.mapping_id
60: AND pcar.request_status = 'PENDING';
61:

Line 64: FROM pos_product_service_requests ppsr, pos_supplier_mappings psm

60: AND pcar.request_status = 'PENDING';
61:
62: CURSOR l_product_service IS
63: SELECT 1
64: FROM pos_product_service_requests ppsr, pos_supplier_mappings psm
65: WHERE psm.party_id = p_party_id
66: AND psm.mapping_id = ppsr.mapping_id
67: AND ppsr.request_status = 'PENDING';
68:

Line 72: from POS_ACNT_GEN_REQ req, IBY_TEMP_EXT_BANK_ACCTS temp, POS_SUPPLIER_MAPPINGS pmap

68:
69: CURSOR l_acnt_cur IS
70:
71: SELECT 1
72: from POS_ACNT_GEN_REQ req, IBY_TEMP_EXT_BANK_ACCTS temp, POS_SUPPLIER_MAPPINGS pmap
73: where req.mapping_id = pmap.mapping_id
74: and pmap.party_id = p_party_id
75: and temp.status in ('CORRECTED', 'NEW', 'IN_VERIFICATION', 'CHANGE_PENDING')
76: and req.temp_ext_bank_acct_id = temp.temp_ext_bank_acct_id

Line 82: from pos_acnt_addr_req req, pos_supplier_mappings pmap, hz_party_sites hps

78:
79: UNION
80:
81: select 1
82: from pos_acnt_addr_req req, pos_supplier_mappings pmap, hz_party_sites hps
83: where req.request_status = 'PENDING'
84: and req.request_type = 'ADDRESS'
85: and req.mapping_id = pmap.mapping_id
86: and hps.party_site_id = req.party_site_id

Line 94: from pos_acnt_addr_req req, pos_supplier_mappings pmap

90:
91: UNION
92:
93: select 1
94: from pos_acnt_addr_req req, pos_supplier_mappings pmap
95: where req.request_status = 'PENDING'
96: and req.request_type = 'SUPPLIER'
97: and req.mapping_id = pmap.mapping_id
98: and req.party_site_id is null

Line 250: UPDATE pos_supplier_mappings

246: IS
247:
248: BEGIN
249:
250: UPDATE pos_supplier_mappings
251: SET party_id = p_new_party_id,
252: last_updated_by = FND_GLOBAL.user_id,
253: last_update_date = SYSDATE,
254: last_update_login = FND_GLOBAL.login_id

Line 257: FROM pos_supplier_mappings

253: last_update_date = SYSDATE,
254: last_update_login = FND_GLOBAL.login_id
255: WHERE mapping_id IN
256: (SELECT mapping_id
257: FROM pos_supplier_mappings
258: WHERE party_id = p_old_party_id
259: );
260:
261: x_return_status := fnd_api.g_ret_sts_success;