APPS.OKS_PARTY_MERGE_PKG dependencies on OKS_BILLING_PROFILES_B

Line 8: /* Merge the records in OKS_BILLING_PROFILES_B */

4: g_api_name constant varchar2(30) := 'OKS_PARTY_MERGE_PKG';
5: g_user_id constant number(15) := arp_standard.profile.user_id;
6: g_login_id constant number(15) := arp_standard.profile.last_update_login;
7:
8: /* Merge the records in OKS_BILLING_PROFILES_B */
9:
10: PROCEDURE OKS_BILLING_PROFILES(
11: p_entity_name in hz_merge_dictionary.entity_name%type,
12: p_from_id in oks_billing_profiles_b.id%type,

Line 12: p_from_id in oks_billing_profiles_b.id%type,

8: /* Merge the records in OKS_BILLING_PROFILES_B */
9:
10: PROCEDURE OKS_BILLING_PROFILES(
11: p_entity_name in hz_merge_dictionary.entity_name%type,
12: p_from_id in oks_billing_profiles_b.id%type,
13: x_to_id in out nocopy oks_billing_profiles_b.id%type,
14: p_from_fk_id in hz_merge_parties.from_party_id%type,
15: p_to_fk_id in hz_merge_parties.to_party_id%type,
16: p_parent_entity_name in hz_merge_dictionary.parent_entity_name%type,

Line 13: x_to_id in out nocopy oks_billing_profiles_b.id%type,

9:
10: PROCEDURE OKS_BILLING_PROFILES(
11: p_entity_name in hz_merge_dictionary.entity_name%type,
12: p_from_id in oks_billing_profiles_b.id%type,
13: x_to_id in out nocopy oks_billing_profiles_b.id%type,
14: p_from_fk_id in hz_merge_parties.from_party_id%type,
15: p_to_fk_id in hz_merge_parties.to_party_id%type,
16: p_parent_entity_name in hz_merge_dictionary.parent_entity_name%type,
17: p_batch_id in hz_merge_batch.batch_id%type,

Line 42: arp_message.set_line('Updating OKS_BILLING_PROFILES_B...');

38:
39: if p_from_fk_id <> p_to_fk_id then
40: BEGIN
41:
42: arp_message.set_line('Updating OKS_BILLING_PROFILES_B...');
43:
44: update oks_billing_profiles_b
45: set owned_party_id1 = p_to_fk_id,
46: last_update_date = sysdate,

Line 44: update oks_billing_profiles_b

40: BEGIN
41:
42: arp_message.set_line('Updating OKS_BILLING_PROFILES_B...');
43:
44: update oks_billing_profiles_b
45: set owned_party_id1 = p_to_fk_id,
46: last_update_date = sysdate,
47: last_updated_by = g_user_id,
48: last_update_login = g_login_id,