APPS.RRS_PARTY_MERGE_PKG dependencies on RRS_SITES_B

Line 17: -- When an External Party is getting merged update the records in RRS_SITES_B.

13: -- p_batch_party_id Id uniquely identifies the batch and party record that is being merged
14: -- x_return_status Returns the staus of call
15: --
16: -- COMMENT : Merge of Real Estate party with another Real Estate or Non-Real Estate party is not allowed.
17: -- When an External Party is getting merged update the records in RRS_SITES_B.
18: --========================================================================
19: PROCEDURE MERGE_SITE_PARTY(
20: p_entity_name IN VARCHAR2,
21: p_from_id IN NUMBER,

Line 35: FROM rrs_sites_b

31: Cursor c_sites(c_party_id NUMBER,c_site_type VARCHAR2) IS
32: SELECT 1 FROM dual
33: WHERE EXISTS(
34: SELECT site_party_id
35: FROM rrs_sites_b
36: WHERE site_type_code = c_site_type
37: AND site_party_id = c_party_id);
38: l_from_sites NUMBER;
39: l_to_sites NUMBER;

Line 71: UPDATE rrs_sites_b

67:
68: OPEN c_sites(p_from_fk_id,'E');
69: FETCH c_sites into l_sites_external;
70: IF (c_sites%FOUND) THEN
71: UPDATE rrs_sites_b
72: SET site_party_id = p_to_fk_id,
73: last_update_date = SYSDATE,
74: last_updated_by = FND_GLOBAL.user_id,
75: last_update_login = FND_GLOBAL.user_id

Line 103: -- COMMENT : When an Legal Entity Party is getting merged update the records in RRS_SITES_B.

99: -- p_batch_id Id of the Batch
100: -- p_batch_party_id Id uniquely identifies the batch and party record that is being merged
101: -- x_return_status Returns the staus of call
102: --
103: -- COMMENT : When an Legal Entity Party is getting merged update the records in RRS_SITES_B.
104: --========================================================================
105:
106: PROCEDURE MERGE_LE_PARTY(
107: p_entity_name IN VARCHAR2,

Line 121: FROM rrs_sites_b

117: Cursor get_sites_for_update(c_party_id IN NUMBER) IS
118: SELECT 1 FROM DUAL
119: WHERE EXISTS(
120: SELECT le_party_id
121: FROM rrs_sites_b
122: WHERE le_party_id = c_party_id);
123:
124: l_from_site_num NUMBER;
125:

Line 136: UPDATE rrs_sites_b

132:
133: OPEN get_sites_for_update(p_from_fk_id);
134: FETCH get_sites_for_update INTO l_from_site_num;
135: IF ( get_sites_for_update%FOUND ) THEN
136: UPDATE rrs_sites_b
137: SET le_party_id = p_to_fk_id,
138: last_update_date = SYSDATE,
139: last_updated_by = FND_GLOBAL.user_id,
140: last_update_login = FND_GLOBAL.user_id