158: rec_get_from_instr_use_dtls.INSTRUMENT_TYPE ,
159: rec_get_from_instr_use_dtls.INSTRUMENT_ID ,
160: rec_get_from_instr_use_dtls.PAYMENT_FUNCTION ,
161: DECODE(l_max_order_of_pref, 0, rec_get_from_instr_use_dtls.order_of_preference,l_max_order_of_pref+1),
162: hz_utility_pub.created_by ,
163: hz_utility_pub.CREATION_DATE ,
164: hz_utility_pub.LAST_UPDATED_BY ,
165: hz_utility_pub.LAST_UPDATE_DATE ,
166: hz_utility_pub.LAST_UPDATE_LOGIN ,
159: rec_get_from_instr_use_dtls.INSTRUMENT_ID ,
160: rec_get_from_instr_use_dtls.PAYMENT_FUNCTION ,
161: DECODE(l_max_order_of_pref, 0, rec_get_from_instr_use_dtls.order_of_preference,l_max_order_of_pref+1),
162: hz_utility_pub.created_by ,
163: hz_utility_pub.CREATION_DATE ,
164: hz_utility_pub.LAST_UPDATED_BY ,
165: hz_utility_pub.LAST_UPDATE_DATE ,
166: hz_utility_pub.LAST_UPDATE_LOGIN ,
167: 1 ,
160: rec_get_from_instr_use_dtls.PAYMENT_FUNCTION ,
161: DECODE(l_max_order_of_pref, 0, rec_get_from_instr_use_dtls.order_of_preference,l_max_order_of_pref+1),
162: hz_utility_pub.created_by ,
163: hz_utility_pub.CREATION_DATE ,
164: hz_utility_pub.LAST_UPDATED_BY ,
165: hz_utility_pub.LAST_UPDATE_DATE ,
166: hz_utility_pub.LAST_UPDATE_LOGIN ,
167: 1 ,
168: rec_get_from_instr_use_dtls.START_DATE ,
161: DECODE(l_max_order_of_pref, 0, rec_get_from_instr_use_dtls.order_of_preference,l_max_order_of_pref+1),
162: hz_utility_pub.created_by ,
163: hz_utility_pub.CREATION_DATE ,
164: hz_utility_pub.LAST_UPDATED_BY ,
165: hz_utility_pub.LAST_UPDATE_DATE ,
166: hz_utility_pub.LAST_UPDATE_LOGIN ,
167: 1 ,
168: rec_get_from_instr_use_dtls.START_DATE ,
169: rec_get_from_instr_use_dtls.END_DATE ,
162: hz_utility_pub.created_by ,
163: hz_utility_pub.CREATION_DATE ,
164: hz_utility_pub.LAST_UPDATED_BY ,
165: hz_utility_pub.LAST_UPDATE_DATE ,
166: hz_utility_pub.LAST_UPDATE_LOGIN ,
167: 1 ,
168: rec_get_from_instr_use_dtls.START_DATE ,
169: rec_get_from_instr_use_dtls.END_DATE ,
170: rec_get_from_instr_use_dtls.DEBIT_AUTH_FLAG ,
262: from_bank_account_id_list(I) ,
263: P_to_party_id ,
264: NULL ,
265: 'Y' ,
266: hz_utility_pub.CREATED_BY ,
267: hz_utility_pub.CREATION_DATE ,
268: hz_utility_pub.LAST_UPDATED_BY ,
269: hz_utility_pub.LAST_UPDATE_DATE ,
270: hz_utility_pub.LAST_UPDATE_LOGIN ,
263: P_to_party_id ,
264: NULL ,
265: 'Y' ,
266: hz_utility_pub.CREATED_BY ,
267: hz_utility_pub.CREATION_DATE ,
268: hz_utility_pub.LAST_UPDATED_BY ,
269: hz_utility_pub.LAST_UPDATE_DATE ,
270: hz_utility_pub.LAST_UPDATE_LOGIN ,
271: 1
264: NULL ,
265: 'Y' ,
266: hz_utility_pub.CREATED_BY ,
267: hz_utility_pub.CREATION_DATE ,
268: hz_utility_pub.LAST_UPDATED_BY ,
269: hz_utility_pub.LAST_UPDATE_DATE ,
270: hz_utility_pub.LAST_UPDATE_LOGIN ,
271: 1
272: );
265: 'Y' ,
266: hz_utility_pub.CREATED_BY ,
267: hz_utility_pub.CREATION_DATE ,
268: hz_utility_pub.LAST_UPDATED_BY ,
269: hz_utility_pub.LAST_UPDATE_DATE ,
270: hz_utility_pub.LAST_UPDATE_LOGIN ,
271: 1
272: );
273: ELSIF l_is_primary = 'N' AND l_is_ownership_exist IS NULL THEN
266: hz_utility_pub.CREATED_BY ,
267: hz_utility_pub.CREATION_DATE ,
268: hz_utility_pub.LAST_UPDATED_BY ,
269: hz_utility_pub.LAST_UPDATE_DATE ,
270: hz_utility_pub.LAST_UPDATE_LOGIN ,
271: 1
272: );
273: ELSIF l_is_primary = 'N' AND l_is_ownership_exist IS NULL THEN
274: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
293: from_bank_account_id_list(I) ,
294: P_to_party_id ,
295: NULL ,
296: 'N' ,
297: hz_utility_pub.CREATED_BY ,
298: hz_utility_pub.CREATION_DATE ,
299: hz_utility_pub.LAST_UPDATED_BY ,
300: hz_utility_pub.LAST_UPDATE_DATE ,
301: hz_utility_pub.LAST_UPDATE_LOGIN ,
294: P_to_party_id ,
295: NULL ,
296: 'N' ,
297: hz_utility_pub.CREATED_BY ,
298: hz_utility_pub.CREATION_DATE ,
299: hz_utility_pub.LAST_UPDATED_BY ,
300: hz_utility_pub.LAST_UPDATE_DATE ,
301: hz_utility_pub.LAST_UPDATE_LOGIN ,
302: 1
295: NULL ,
296: 'N' ,
297: hz_utility_pub.CREATED_BY ,
298: hz_utility_pub.CREATION_DATE ,
299: hz_utility_pub.LAST_UPDATED_BY ,
300: hz_utility_pub.LAST_UPDATE_DATE ,
301: hz_utility_pub.LAST_UPDATE_LOGIN ,
302: 1
303: );
296: 'N' ,
297: hz_utility_pub.CREATED_BY ,
298: hz_utility_pub.CREATION_DATE ,
299: hz_utility_pub.LAST_UPDATED_BY ,
300: hz_utility_pub.LAST_UPDATE_DATE ,
301: hz_utility_pub.LAST_UPDATE_LOGIN ,
302: 1
303: );
304: END IF;
297: hz_utility_pub.CREATED_BY ,
298: hz_utility_pub.CREATION_DATE ,
299: hz_utility_pub.LAST_UPDATED_BY ,
300: hz_utility_pub.LAST_UPDATE_DATE ,
301: hz_utility_pub.LAST_UPDATE_LOGIN ,
302: 1
303: );
304: END IF;
305: ELSIF l_is_ownership_exist IS NULL THEN
325: from_bank_account_id_list(I) ,
326: P_to_party_id ,
327: NULL ,
328: 'N' ,
329: hz_utility_pub.CREATED_BY ,
330: hz_utility_pub.CREATION_DATE ,
331: hz_utility_pub.LAST_UPDATED_BY ,
332: hz_utility_pub.LAST_UPDATE_DATE ,
333: hz_utility_pub.LAST_UPDATE_LOGIN ,
326: P_to_party_id ,
327: NULL ,
328: 'N' ,
329: hz_utility_pub.CREATED_BY ,
330: hz_utility_pub.CREATION_DATE ,
331: hz_utility_pub.LAST_UPDATED_BY ,
332: hz_utility_pub.LAST_UPDATE_DATE ,
333: hz_utility_pub.LAST_UPDATE_LOGIN ,
334: 1
327: NULL ,
328: 'N' ,
329: hz_utility_pub.CREATED_BY ,
330: hz_utility_pub.CREATION_DATE ,
331: hz_utility_pub.LAST_UPDATED_BY ,
332: hz_utility_pub.LAST_UPDATE_DATE ,
333: hz_utility_pub.LAST_UPDATE_LOGIN ,
334: 1
335: );
328: 'N' ,
329: hz_utility_pub.CREATED_BY ,
330: hz_utility_pub.CREATION_DATE ,
331: hz_utility_pub.LAST_UPDATED_BY ,
332: hz_utility_pub.LAST_UPDATE_DATE ,
333: hz_utility_pub.LAST_UPDATE_LOGIN ,
334: 1
335: );
336: END IF;
329: hz_utility_pub.CREATED_BY ,
330: hz_utility_pub.CREATION_DATE ,
331: hz_utility_pub.LAST_UPDATED_BY ,
332: hz_utility_pub.LAST_UPDATE_DATE ,
333: hz_utility_pub.LAST_UPDATE_LOGIN ,
334: 1
335: );
336: END IF;
337: END IF;
420: p_ext_payee_id,
421: ext_payee_rec.Payee_Party_Id,
422: ext_payee_rec.Payment_Function,
423: ext_payee_rec.EXCLUSIVE_PAYMENT_FLAG,
424: hz_utility_pub.CREATED_BY,
425: hz_utility_pub.CREATION_DATE,
426: hz_utility_pub.LAST_UPDATED_BY,
427: hz_utility_pub.LAST_UPDATE_DATE,
428: hz_utility_pub.LAST_UPDATE_LOGIN,
421: ext_payee_rec.Payee_Party_Id,
422: ext_payee_rec.Payment_Function,
423: ext_payee_rec.EXCLUSIVE_PAYMENT_FLAG,
424: hz_utility_pub.CREATED_BY,
425: hz_utility_pub.CREATION_DATE,
426: hz_utility_pub.LAST_UPDATED_BY,
427: hz_utility_pub.LAST_UPDATE_DATE,
428: hz_utility_pub.LAST_UPDATE_LOGIN,
429: 1.0,
422: ext_payee_rec.Payment_Function,
423: ext_payee_rec.EXCLUSIVE_PAYMENT_FLAG,
424: hz_utility_pub.CREATED_BY,
425: hz_utility_pub.CREATION_DATE,
426: hz_utility_pub.LAST_UPDATED_BY,
427: hz_utility_pub.LAST_UPDATE_DATE,
428: hz_utility_pub.LAST_UPDATE_LOGIN,
429: 1.0,
430: ext_payee_rec.PARTY_SITE_ID,
423: ext_payee_rec.EXCLUSIVE_PAYMENT_FLAG,
424: hz_utility_pub.CREATED_BY,
425: hz_utility_pub.CREATION_DATE,
426: hz_utility_pub.LAST_UPDATED_BY,
427: hz_utility_pub.LAST_UPDATE_DATE,
428: hz_utility_pub.LAST_UPDATE_LOGIN,
429: 1.0,
430: ext_payee_rec.PARTY_SITE_ID,
431: ext_payee_rec.Supplier_Site_Id,
424: hz_utility_pub.CREATED_BY,
425: hz_utility_pub.CREATION_DATE,
426: hz_utility_pub.LAST_UPDATED_BY,
427: hz_utility_pub.LAST_UPDATE_DATE,
428: hz_utility_pub.LAST_UPDATE_LOGIN,
429: 1.0,
430: ext_payee_rec.PARTY_SITE_ID,
431: ext_payee_rec.Supplier_Site_Id,
432: ext_payee_rec.Org_Id,