APPS.AS_SALES_LEADS_MERGE_PKG dependencies on AS_SALES_LEADS

Line 1: PACKAGE BODY AS_SALES_LEADS_MERGE_PKG as

1: PACKAGE BODY AS_SALES_LEADS_MERGE_PKG as
2: /* $Header: asxpmslb.pls 115.6 2003/02/11 22:27:59 solin ship $ */
3: --
4: -- NAME
5: -- AS_SALES_LEADS_MERGE_PKG

Line 5: -- AS_SALES_LEADS_MERGE_PKG

1: PACKAGE BODY AS_SALES_LEADS_MERGE_PKG as
2: /* $Header: asxpmslb.pls 115.6 2003/02/11 22:27:59 solin ship $ */
3: --
4: -- NAME
5: -- AS_SALES_LEADS_MERGE_PKG
6: --
7: -- HISTORY
8: -- 02/20/2001 SOLIN CREATED
9: --

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30):='AS_SALES_LEADS_MERGE_PKG';

7: -- HISTORY
8: -- 02/20/2001 SOLIN CREATED
9: --
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):='AS_SALES_LEADS_MERGE_PKG';
12:
13: PROCEDURE SALES_LEAD_MERGE
14: ( p_entity_name IN VARCHAR2
15: ,p_from_id IN NUMBER

Line 28: FND_FILE.PUT_LINE(FND_FILE.LOG,'AS_SALES_LEADS_MERGE_PKG.SALES_LEAD_MERGE starts : ' || to_char(sysdate,'DD-MON-YYYY HH24:MI'));

24: l_api_name CONSTANT VARCHAR2(30) := 'SALES_LEAD_MERGE';
25: l_api_version_number CONSTANT NUMBER := 2.0;
26: l_merge_reason_code VARCHAR2(30);
27: BEGIN
28: FND_FILE.PUT_LINE(FND_FILE.LOG,'AS_SALES_LEADS_MERGE_PKG.SALES_LEAD_MERGE starts : ' || to_char(sysdate,'DD-MON-YYYY HH24:MI'));
29: x_return_status := FND_API.G_RET_STS_SUCCESS;
30:
31: select merge_reason_code into l_merge_reason_code
32: from HZ_MERGE_BATCH

Line 86: UPDATE AS_SALES_LEADS

82:
83: IF p_from_fk_id <> p_to_fk_id THEN
84: BEGIN
85: IF p_parent_entity_name = 'HZ_PARTIES' THEN -- merge party
86: UPDATE AS_SALES_LEADS
87: set customer_id = p_to_fk_id,
88: last_update_date = hz_utility_pub.last_update_date,
89: last_updated_by = hz_utility_pub.user_id,
90: last_update_login = hz_utility_pub.last_update_login,

Line 97: UPDATE AS_SALES_LEADS

93: program_id = hz_utility_pub.program_id,
94: program_update_date = sysdate
95: where customer_id = p_from_fk_id;
96:
97: UPDATE AS_SALES_LEADS
98: set incumbent_partner_party_id = p_to_fk_id,
99: last_update_date = hz_utility_pub.last_update_date,
100: last_updated_by = hz_utility_pub.user_id,
101: last_update_login = hz_utility_pub.last_update_login,

Line 108: UPDATE AS_SALES_LEADS

104: program_id = hz_utility_pub.program_id,
105: program_update_date = sysdate
106: where incumbent_partner_party_id = p_from_fk_id;
107:
108: UPDATE AS_SALES_LEADS
109: set primary_contact_party_id = p_to_fk_id,
110: last_update_date = hz_utility_pub.last_update_date,
111: last_updated_by = hz_utility_pub.user_id,
112: last_update_login = hz_utility_pub.last_update_login,

Line 119: UPDATE AS_SALES_LEADS

115: program_id = hz_utility_pub.program_id,
116: program_update_date = sysdate
117: where primary_contact_party_id = p_from_fk_id;
118:
119: UPDATE AS_SALES_LEADS
120: set primary_cnt_person_party_id = p_to_fk_id,
121: last_update_date = hz_utility_pub.last_update_date,
122: last_updated_by = hz_utility_pub.user_id,
123: last_update_login = hz_utility_pub.last_update_login,

Line 130: UPDATE AS_SALES_LEADS

126: program_id = hz_utility_pub.program_id,
127: program_update_date = sysdate
128: where primary_cnt_person_party_id = p_from_fk_id;
129:
130: UPDATE AS_SALES_LEADS
131: set referred_by = p_to_fk_id,
132: last_update_date = hz_utility_pub.last_update_date,
133: last_updated_by = hz_utility_pub.user_id,
134: last_update_login = hz_utility_pub.last_update_login,

Line 141: UPDATE AS_SALES_LEADS

137: program_id = hz_utility_pub.program_id,
138: program_update_date = sysdate
139: where referred_by = p_from_fk_id;
140: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES' THEN -- merge party_site
141: UPDATE AS_SALES_LEADS
142: set address_id = p_to_fk_id,
143: last_update_date = hz_utility_pub.last_update_date,
144: last_updated_by = hz_utility_pub.user_id,
145: last_update_login = hz_utility_pub.last_update_login,

Line 152: UPDATE AS_SALES_LEADS

148: program_id = hz_utility_pub.program_id,
149: program_update_date = sysdate
150: where address_id = p_from_fk_id;
151: ELSIF p_parent_entity_name = 'HZ_CONTACT_POINTS' THEN -- merge contact_points
152: UPDATE AS_SALES_LEADS
153: set primary_contact_phone_id = p_to_fk_id,
154: last_update_date = hz_utility_pub.last_update_date,
155: last_updated_by = hz_utility_pub.user_id,
156: last_update_login = hz_utility_pub.last_update_login,

Line 171: FND_FILE.PUT_LINE(FND_FILE.LOG,'AS_SALES_LEADS_MERGE_PKG.SALES_LEAD_MERGE end : ' || to_char(sysdate,'DD-MON-YYYY HH24:MI'));

167: raise;
168: END;
169: END IF;
170:
171: FND_FILE.PUT_LINE(FND_FILE.LOG,'AS_SALES_LEADS_MERGE_PKG.SALES_LEAD_MERGE end : ' || to_char(sysdate,'DD-MON-YYYY HH24:MI'));
172:
173: END SALES_LEAD_MERGE;
174:
175: PROCEDURE LEAD_CONTACT_MERGE

Line 190: FND_FILE.PUT_LINE(FND_FILE.LOG,'AS_SALES_LEADS_MERGE_PKG.LEAD_CONTACT_MERGE starts : ' || to_char(sysdate,'DD-MON-YYYY HH24:MI'));

186: l_api_name CONSTANT VARCHAR2(30) := 'LEAD_CONTACT_MERGE';
187: l_api_version_number CONSTANT NUMBER := 2.0;
188: l_merge_reason_code VARCHAR2(30);
189: BEGIN
190: FND_FILE.PUT_LINE(FND_FILE.LOG,'AS_SALES_LEADS_MERGE_PKG.LEAD_CONTACT_MERGE starts : ' || to_char(sysdate,'DD-MON-YYYY HH24:MI'));
191: x_return_status := FND_API.G_RET_STS_SUCCESS;
192:
193: select merge_reason_code into l_merge_reason_code
194: from HZ_MERGE_BATCH

Line 311: FND_FILE.PUT_LINE(FND_FILE.LOG,'AS_SALES_LEADS_MERGE_PKG.LEAD_CONTACT_MERGE end : ' || to_char(sysdate,'DD-MON-YYYY HH24:MI'));

307: raise;
308: END;
309: END IF;
310:
311: FND_FILE.PUT_LINE(FND_FILE.LOG,'AS_SALES_LEADS_MERGE_PKG.LEAD_CONTACT_MERGE end : ' || to_char(sysdate,'DD-MON-YYYY HH24:MI'));
312:
313: END LEAD_CONTACT_MERGE;
314:
315:

Line 316: END AS_SALES_LEADS_MERGE_PKG;

312:
313: END LEAD_CONTACT_MERGE;
314:
315:
316: END AS_SALES_LEADS_MERGE_PKG;