APPS.JAI_AP_DTC_PREPAYMENTS_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 64: FROM ap_invoice_distributions_all

60: BEGIN
61: BEGIN
62: SELECT invoice_id
63: INTO p_prepay_inv_id
64: FROM ap_invoice_distributions_all
65: WHERE invoice_distribution_id = p_prepay_inv_dist_id;
66: EXCEPTION
67: WHEN NO_DATA_FOUND THEN
68: p_prepay_inv_id := null;

Line 78: FROM ap_invoice_distributions_all

74: IS
75: PRAGMA AUTONOMOUS_TRANSACTION;
76: CURSOR c_get_reversal_flag(p_inv_dist_id NUMBER) is
77: SELECT reversal_flag
78: FROM ap_invoice_distributions_all
79: WHERE invoice_distribution_id = p_inv_dist_id;
80: v_reversal_flag VARCHAR2(1);
81: BEGIN
82: OPEN c_get_reversal_flag(pn_invoice_dist_id);

Line 502: ln_inv_dist_id_apply ap_invoice_distributions_all.invoice_distribution_id%TYPE ;

498: lv_ppu_tds_inv_num ap_invoices_all.invoice_num%type;
499: lv_ppu_tds_cm_num ap_invoices_all.invoice_num%type;
500: /*Bug 5751783 - End*/
501: -- Bug 6031679. Added by Lakshmi Gopalsami
502: ln_inv_dist_id_apply ap_invoice_distributions_all.invoice_distribution_id%TYPE ;
503: --Added by Wenqiong for bug13359892 begin
504: ln_tax_category_id jai_ap_tds_inv_taxes.tax_category_id%TYPE;
505: lv_section_code jai_ap_tds_inv_taxes.actual_section_code%TYPE;
506: ln_tot_tds_amt NUMBER;

Line 508: pre_pay_inv_id ap_invoice_distributions_all.invoice_id%TYPE; -- Added by Chong.Lei for bug#13787158

504: ln_tax_category_id jai_ap_tds_inv_taxes.tax_category_id%TYPE;
505: lv_section_code jai_ap_tds_inv_taxes.actual_section_code%TYPE;
506: ln_tot_tds_amt NUMBER;
507: --Added by Wenqiong for bug13359892 end
508: pre_pay_inv_id ap_invoice_distributions_all.invoice_id%TYPE; -- Added by Chong.Lei for bug#13787158
509: l_api_name CONSTANT VARCHAR2(50) := 'process_unapply()';
510: begin
511: jai_cmn_utils_pkg.WRITE_FND_LOG(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name||'.BEGIN', G_PKG_NAME || ': '||l_api_name||'()+');
512: p_codepath := jai_general_pkg.plot_codepath(1, p_codepath, 'jai_ap_tds_prepayemnts_pkg.process_unapply', 'START'); /* 1 */

Line 1243: pre_pay_inv_id ap_invoice_distributions_all.invoice_id%TYPE; -- Added by Jia for FP bug6929483

1239: lv_wct_applicable_flag jai_ap_tds_prepayments.wct_applicable_flag%type;
1240: ln_essi_tax_id_other jai_ap_tds_prepayments.essi_tax_id_other%type;
1241: lv_essi_applicable_flag jai_ap_tds_prepayments.essi_applicable_flag%type;
1242:
1243: pre_pay_inv_id ap_invoice_distributions_all.invoice_id%TYPE; -- Added by Jia for FP bug6929483
1244:
1245:
1246: begin
1247:

Line 1623: pre_pay_inv_id ap_invoice_distributions_all.invoice_id%TYPE; -- Added by Jia for FP bug6929483

1619: ln_tds_application_amt jai_ap_tds_prepayments.application_amount%TYPE ;
1620: r_pp_jai_ap_tds_thhold_grps c_get_thgrp_det%ROWTYPE ;
1621: r_si_jai_ap_tds_thhold_grps c_get_thgrp_det%ROWTYPE ;
1622: \*Bug 6363056 - End*\
1623: pre_pay_inv_id ap_invoice_distributions_all.invoice_id%TYPE; -- Added by Jia for FP bug6929483
1624: \*START, Bgowrava for Bug#7626202*\
1625: ln_tot_tds_amt number := 0;
1626: ln_tot_appln_amt number := 0;
1627: \*END, Bgowrava for Bug#7626202*\

Line 3226: pre_pay_inv_id ap_invoice_distributions_all.invoice_id%TYPE;

3222: ln_pp_thhold_grp_id jai_ap_tds_thhold_grps.threshold_grp_id%TYPE;
3223: ln_tds_application_amt jai_ap_tds_prepayments.application_amount%TYPE ;
3224: r_pp_jai_ap_tds_thhold_grps c_get_thgrp_det%ROWTYPE ;
3225: r_si_jai_ap_tds_thhold_grps c_get_thgrp_det%ROWTYPE ;
3226: pre_pay_inv_id ap_invoice_distributions_all.invoice_id%TYPE;
3227: ln_tot_tds_amt number := 0;
3228: ln_tot_appln_amt number := 0;
3229: ln_application_mode VARCHAR2(1);
3230: ln_taxable_amount NUMBER;

Line 4060: FROM ap_invoice_distributions_all

4056: BEGIN
4057: BEGIN
4058: SELECT accounting_date
4059: INTO p_prepay_gl_date
4060: FROM ap_invoice_distributions_all
4061: WHERE invoice_distribution_id = p_prepay_inv_dist_id;
4062: EXCEPTION
4063: WHEN NO_DATA_FOUND THEN
4064: p_prepay_gl_date := NULL;