APPS.AP_DBI_PKG dependencies on AP_DBI_PKG

Line 1: PACKAGE BODY AP_DBI_PKG AS

1: PACKAGE BODY AP_DBI_PKG AS
2: /* $Header: apdbigeb.pls 120.1 2005/10/02 03:15:32 sfeng noship $ */
3: -- Public Procedure Specifications
4:
5: -- Procedure Definitions

Line 13: ap_dbi_pkg.r_dbi_key_value_arr DEFAULT NULL,

9: p_operation IN VARCHAR2,
10: p_key_value1 IN NUMBER DEFAULT NULL,
11: p_key_value2 IN NUMBER DEFAULT NULL,
12: p_key_value_list IN
13: ap_dbi_pkg.r_dbi_key_value_arr DEFAULT NULL,
14: p_calling_sequence in VARCHAR2) IS
15:
16: l_curr_calling_sequence varchar2(2000);
17: l_debug_info varchar2(100);

Line 334: l_curr_calling_sequence := 'AP_DBI_PKG.Insert_Payment_Confirm_DBI<-'||

330:
331: BEGIN
332:
333:
334: l_curr_calling_sequence := 'AP_DBI_PKG.Insert_Payment_Confirm_DBI<-'||
335: P_calling_sequence;
336:
337:
338: IF (p_key_table = 'AP_INVOICES_ALL') THEN

Line 347: AP_DBI_PKG.Maintain_DBI_Summary

343: INTO l_invoice_id;
344: EXIT WHEN invoice_cur%NOTFOUND;
345: --l_num_fetches_inv := l_num_fetches_inv + 1;
346:
347: AP_DBI_PKG.Maintain_DBI_Summary
348: (p_table_name => 'AP_INVOICES',
349: p_operation => 'I',
350: p_key_value1 => l_invoice_id,
351: p_calling_sequence => l_curr_calling_sequence);

Line 362: AP_DBI_PKG.Maintain_DBI_Summary

358: FETCH invoice_dist_cur
359: INTO l_invoice_dist_id,l_invoice_id;
360: EXIT WHEN invoice_dist_cur%NOTFOUND;
361:
362: AP_DBI_PKG.Maintain_DBI_Summary
363: (p_table_name => 'AP_INVOICE_DISTRIBUTIONS',
364: p_operation => 'I',
365: p_key_value1 => l_invoice_id,
366: p_key_value2 => l_invoice_dist_id,

Line 377: AP_DBI_PKG.Maintain_DBI_Summary

373: FETCH sched_cur
374: INTO l_invoice_id, l_payment_num;
375: EXIT WHEN sched_cur%NOTFOUND;
376:
377: AP_DBI_PKG.Maintain_DBI_Summary
378: (p_table_name => 'AP_PAYMENT_SCHEDULES',
379: p_operation => 'I',
380: p_key_value1 => l_invoice_id,
381: p_key_value2 => l_payment_num,

Line 394: AP_DBI_PKG.Maintain_DBI_Summary

390: FETCH invoice_payments_cur
391: INTO l_invoice_pay_id;
392: EXIT WHEN invoice_payments_cur%NOTFOUND;
393:
394: AP_DBI_PKG.Maintain_DBI_Summary
395: (p_table_name => 'AP_INVOICE_PAYMENTS',
396: p_operation => 'I',
397: p_key_value1 => l_invoice_pay_id,
398: p_calling_sequence => l_curr_calling_sequence);

Line 419: END AP_DBI_PKG;

415:
416:
417: END Insert_Payment_Confirm_DBI;
418:
419: END AP_DBI_PKG;