DBA Data[Home] [Help]

APPS.OKS_PARTY_MERGE_PKG dependencies on HZ_MERGE_PARTIES

Line 14: p_from_fk_id in hz_merge_parties.from_party_id%type,

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,
18: p_batch_party_id in hz_merge_party_details.batch_party_id%type,

Line 15: p_to_fk_id in hz_merge_parties.to_party_id%type,

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,
18: p_batch_party_id in hz_merge_party_details.batch_party_id%type,
19: x_return_status out nocopy varchar2) IS

Line 72: p_from_fk_id in hz_merge_parties.from_party_id%type,

68: PROCEDURE OKS_DEFAULTS(
69: p_entity_name in hz_merge_dictionary.entity_name%type,
70: p_from_id in oks_k_defaults.id%type,
71: x_to_id in out nocopy oks_k_defaults.id%type,
72: p_from_fk_id in hz_merge_parties.from_party_id%type,
73: p_to_fk_id in hz_merge_parties.to_party_id%type,
74: p_parent_entity_name in hz_merge_dictionary.parent_entity_name%type,
75: p_batch_id in hz_merge_batch.batch_id%type,
76: p_batch_party_id in hz_merge_party_details.batch_party_id%type,

Line 73: p_to_fk_id in hz_merge_parties.to_party_id%type,

69: p_entity_name in hz_merge_dictionary.entity_name%type,
70: p_from_id in oks_k_defaults.id%type,
71: x_to_id in out nocopy oks_k_defaults.id%type,
72: p_from_fk_id in hz_merge_parties.from_party_id%type,
73: p_to_fk_id in hz_merge_parties.to_party_id%type,
74: p_parent_entity_name in hz_merge_dictionary.parent_entity_name%type,
75: p_batch_id in hz_merge_batch.batch_id%type,
76: p_batch_party_id in hz_merge_party_details.batch_party_id%type,
77: x_return_status out nocopy varchar2) IS

Line 92: cursor default_cur(p_fk_id hz_merge_parties.from_party_id%type) IS

88: l_to_start_date1 date;
89: l_to_end_date date;
90: l_to_end_date1 date;
91: l_row_count_exists boolean;
92: cursor default_cur(p_fk_id hz_merge_parties.from_party_id%type) IS
93: SELECT start_date,end_date
94: FROM oks_k_defaults
95: where segment_id1 =p_fk_id;
96: from_rec default_cur%ROWTYPE;

Line 227: p_from_fk_id in hz_merge_parties.from_party_id%type,

223: PROCEDURE OKS_SERVICE_EXCEPTS(
224: p_entity_name in hz_merge_dictionary.entity_name%type,
225: p_from_id in oks_serv_avail_excepts.id%type,
226: x_to_id in out nocopy oks_serv_avail_excepts.id%type,
227: p_from_fk_id in hz_merge_parties.from_party_id%type,
228: p_to_fk_id in hz_merge_parties.to_party_id%type,
229: p_parent_entity_name in hz_merge_dictionary.parent_entity_name%type,
230: p_batch_id in hz_merge_batch.batch_id%type,
231: p_batch_party_id in hz_merge_party_details.batch_party_id%type,

Line 228: p_to_fk_id in hz_merge_parties.to_party_id%type,

224: p_entity_name in hz_merge_dictionary.entity_name%type,
225: p_from_id in oks_serv_avail_excepts.id%type,
226: x_to_id in out nocopy oks_serv_avail_excepts.id%type,
227: p_from_fk_id in hz_merge_parties.from_party_id%type,
228: p_to_fk_id in hz_merge_parties.to_party_id%type,
229: p_parent_entity_name in hz_merge_dictionary.parent_entity_name%type,
230: p_batch_id in hz_merge_batch.batch_id%type,
231: p_batch_party_id in hz_merge_party_details.batch_party_id%type,
232: x_return_status out nocopy varchar2) IS