APPS.AS_OPP_MERGE_PKG dependencies on AS_LEADS_ALL

Line 52: l_col_name := 'AS_LEADS_ALL.customer_id';

48: IF p_from_fk_id <> p_to_fk_id THEN
49: BEGIN
50: IF p_parent_entity_name = 'HZ_PARTIES' THEN
51:
52: l_col_name := 'AS_LEADS_ALL.customer_id';
53:
54: UPDATE AS_LEADS_ALL
55: set object_version_number = nvl(object_version_number,0) + 1, customer_id = p_to_fk_id,
56: last_update_date = hz_utility_pub.last_update_date,

Line 54: UPDATE AS_LEADS_ALL

50: IF p_parent_entity_name = 'HZ_PARTIES' THEN
51:
52: l_col_name := 'AS_LEADS_ALL.customer_id';
53:
54: UPDATE AS_LEADS_ALL
55: set object_version_number = nvl(object_version_number,0) + 1, customer_id = p_to_fk_id,
56: last_update_date = hz_utility_pub.last_update_date,
57: last_updated_by = hz_utility_pub.user_id,
58: last_update_login = hz_utility_pub.last_update_login,

Line 65: l_col_name := 'AS_LEADS_ALL.close_competitor_id';

61: program_id = hz_utility_pub.program_id,
62: program_update_date = sysdate
63: where customer_id = p_from_fk_id;
64:
65: l_col_name := 'AS_LEADS_ALL.close_competitor_id';
66:
67: UPDATE AS_LEADS_ALL
68: set object_version_number = nvl(object_version_number,0) + 1, close_competitor_id = p_to_fk_id,
69: last_update_date = hz_utility_pub.last_update_date,

Line 67: UPDATE AS_LEADS_ALL

63: where customer_id = p_from_fk_id;
64:
65: l_col_name := 'AS_LEADS_ALL.close_competitor_id';
66:
67: UPDATE AS_LEADS_ALL
68: set object_version_number = nvl(object_version_number,0) + 1, close_competitor_id = p_to_fk_id,
69: last_update_date = hz_utility_pub.last_update_date,
70: last_updated_by = hz_utility_pub.user_id,
71: last_update_login = hz_utility_pub.last_update_login,

Line 79: l_col_name := 'AS_LEADS_ALL.end_user_customer_id';

75: program_update_date = sysdate
76: where close_competitor_id = p_from_fk_id;
77:
78: /*
79: l_col_name := 'AS_LEADS_ALL.end_user_customer_id';
80:
81: UPDATE AS_LEADS_ALL
82: set object_version_number = nvl(object_version_number,0) + 1, end_user_customer_id = p_to_fk_id,
83: last_update_date = hz_utility_pub.last_update_date,

Line 81: UPDATE AS_LEADS_ALL

77:
78: /*
79: l_col_name := 'AS_LEADS_ALL.end_user_customer_id';
80:
81: UPDATE AS_LEADS_ALL
82: set object_version_number = nvl(object_version_number,0) + 1, end_user_customer_id = p_to_fk_id,
83: last_update_date = hz_utility_pub.last_update_date,
84: last_updated_by = hz_utility_pub.user_id,
85: last_update_login = hz_utility_pub.last_update_login,

Line 93: l_col_name := 'AS_LEADS_ALL.incumbent_partner_party_id';

89: program_update_date = sysdate
90: where end_user_customer_id = p_from_fk_id;
91: */
92:
93: l_col_name := 'AS_LEADS_ALL.incumbent_partner_party_id';
94:
95: UPDATE AS_LEADS_ALL
96: set object_version_number = nvl(object_version_number,0) + 1, incumbent_partner_party_id = p_to_fk_id,
97: incumbent_partner_resource_id=( select resource_id

Line 95: UPDATE AS_LEADS_ALL

91: */
92:
93: l_col_name := 'AS_LEADS_ALL.incumbent_partner_party_id';
94:
95: UPDATE AS_LEADS_ALL
96: set object_version_number = nvl(object_version_number,0) + 1, incumbent_partner_party_id = p_to_fk_id,
97: incumbent_partner_resource_id=( select resource_id
98: from jtf_rs_resource_extns
99: where category = 'PARTNER'

Line 233: l_col_name := 'AS_LEADS_ALL.address_id';

229:
230:
231: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES' THEN
232:
233: l_col_name := 'AS_LEADS_ALL.address_id';
234:
235: UPDATE AS_LEADS_ALL
236: set object_version_number = nvl(object_version_number,0) + 1, address_id = p_to_fk_id,
237: last_update_date = hz_utility_pub.last_update_date,

Line 235: UPDATE AS_LEADS_ALL

231: ELSIF p_parent_entity_name = 'HZ_PARTY_SITES' THEN
232:
233: l_col_name := 'AS_LEADS_ALL.address_id';
234:
235: UPDATE AS_LEADS_ALL
236: set object_version_number = nvl(object_version_number,0) + 1, address_id = p_to_fk_id,
237: last_update_date = hz_utility_pub.last_update_date,
238: last_updated_by = hz_utility_pub.user_id,
239: last_update_login = hz_utility_pub.last_update_login,

Line 247: l_col_name := 'AS_LEADS_ALL.end_user_address_id';

243: program_update_date = sysdate
244: where address_id = p_from_fk_id;
245:
246: /*
247: l_col_name := 'AS_LEADS_ALL.end_user_address_id';
248:
249: UPDATE AS_LEADS_ALL
250: set object_version_number = nvl(object_version_number,0) + 1, end_user_address_id = p_to_fk_id,
251: last_update_date = hz_utility_pub.last_update_date,

Line 249: UPDATE AS_LEADS_ALL

245:
246: /*
247: l_col_name := 'AS_LEADS_ALL.end_user_address_id';
248:
249: UPDATE AS_LEADS_ALL
250: set object_version_number = nvl(object_version_number,0) + 1, end_user_address_id = p_to_fk_id,
251: last_update_date = hz_utility_pub.last_update_date,
252: last_updated_by = hz_utility_pub.user_id,
253: last_update_login = hz_utility_pub.last_update_login,