DBA Data[Home] [Help]

APPS.IBY_SUPP_BANK_MERGE_PUB dependencies on HZ_UTILITY_PUB

Line 162: hz_utility_pub.created_by ,

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 ,

Line 163: hz_utility_pub.CREATION_DATE ,

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 ,

Line 164: hz_utility_pub.LAST_UPDATED_BY ,

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 ,

Line 165: hz_utility_pub.LAST_UPDATE_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 ,

Line 166: hz_utility_pub.LAST_UPDATE_LOGIN ,

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 ,

Line 266: hz_utility_pub.CREATED_BY ,

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 ,

Line 267: hz_utility_pub.CREATION_DATE ,

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

Line 268: hz_utility_pub.LAST_UPDATED_BY ,

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: );

Line 269: hz_utility_pub.LAST_UPDATE_DATE ,

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

Line 270: hz_utility_pub.LAST_UPDATE_LOGIN ,

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

Line 297: hz_utility_pub.CREATED_BY ,

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 ,

Line 298: hz_utility_pub.CREATION_DATE ,

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

Line 299: hz_utility_pub.LAST_UPDATED_BY ,

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: );

Line 300: hz_utility_pub.LAST_UPDATE_DATE ,

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;

Line 301: hz_utility_pub.LAST_UPDATE_LOGIN ,

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

Line 329: hz_utility_pub.CREATED_BY ,

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 ,

Line 330: hz_utility_pub.CREATION_DATE ,

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

Line 331: hz_utility_pub.LAST_UPDATED_BY ,

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: );

Line 332: hz_utility_pub.LAST_UPDATE_DATE ,

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;

Line 333: hz_utility_pub.LAST_UPDATE_LOGIN ,

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;

Line 424: hz_utility_pub.CREATED_BY,

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,

Line 425: hz_utility_pub.CREATION_DATE,

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,

Line 426: hz_utility_pub.LAST_UPDATED_BY,

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,

Line 427: hz_utility_pub.LAST_UPDATE_DATE,

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,

Line 428: hz_utility_pub.LAST_UPDATE_LOGIN,

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,