APPS.OKS_PARTY_MERGE_PKG dependencies on OKS_K_DEFAULTS

Line 66: /* Merge the records in OKS_K_DEFAULTS */

62: end if;
63: END OKS_BILLING_PROFILES;
64:
65:
66: /* Merge the records in OKS_K_DEFAULTS */
67:
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,

Line 70: p_from_id in oks_k_defaults.id%type,

66: /* Merge the records in OKS_K_DEFAULTS */
67:
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,

Line 71: x_to_id in out nocopy oks_k_defaults.id%type,

67:
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,

Line 94: FROM oks_k_defaults

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;
97: to_rec default_cur%ROWTYPE;
98:

Line 151: update oks_k_defaults

147: BEGIN
148: -- Updateing from(source) record -- Party getting merged
149:
150: IF not l_row_count_exists THEN
151: update oks_k_defaults
152: set segment_id1 = p_to_fk_id,
153: last_update_date = sysdate,
154: last_updated_by = g_user_id,
155: object_version_number = object_version_number+1

Line 162: update oks_k_defaults

158: ELSE
159: IF l_to_start_date1<> l_to_start_date
160: AND l_to_end_date1 <> l_to_end_date
161: THEN
162: update oks_k_defaults
163: set
164: start_date = l_to_start_date1,
165: end_date = l_to_end_date1,
166: last_update_date = sysdate,

Line 173: update oks_k_defaults

169: where segment_id1 = p_to_fk_id
170: and jtot_object_code = 'OKX_PARTY';
171: ELSIF l_to_start_date1<> l_to_start_date
172: AND l_to_end_date1 = l_to_end_date THEN
173: update oks_k_defaults
174: set
175: start_date = l_to_start_date1,
176: last_update_date = sysdate,
177: last_updated_by = g_user_id,

Line 183: update oks_k_defaults

179: where segment_id1 = p_to_fk_id
180: and jtot_object_code = 'OKX_PARTY';
181: ELSIF l_to_start_date1 = l_to_start_date
182: AND l_to_end_date1 <> l_to_end_date THEN
183: update oks_k_defaults
184: set
185: end_date = l_to_end_date1,
186: last_update_date = sysdate,
187: last_updated_by = g_user_id,

Line 196: update oks_k_defaults

192: END IF;
193: l_count := sql%rowcount;
194: arp_message.set_name('AR','AR_ROWS_UPDATED');
195: arp_message.set_token('NUM_ROWS',to_char(l_count));
196: update oks_k_defaults
197: set segment_id1 = p_to_fk_id,
198: last_update_date = sysdate,
199: last_updated_by = g_user_id,
200: start_date = l_from_start_date,

Line 208: arp_message.set_line('Updating OKS_K_DEFAULTS...');

204: and jtot_object_code = 'OKX_PARTY';
205: l_count := sql%rowcount;
206: arp_message.set_name('AR','AR_ROWS_UPDATED');
207: arp_message.set_token('NUM_ROWS',to_char(l_count));
208: arp_message.set_line('Updating OKS_K_DEFAULTS...');
209:
210: END IF;
211:
212: EXCEPTION