eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_PA_BILLING_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 1500: -- payables (ap_invoice_distributions_all)

1496:
1497: procedure import_taxes_to_payables
1498: --
1499: -- This procedure imports the taxes from project draft invoice (jai_cmn_document_taxes) to
1500: -- payables (ap_invoice_distributions_all)
1501: --
1502: ( errbuf OUT NOCOPY varchar2
1503: , retcode OUT NOCOPY number
1504: , pn_request_id in ap_invoice_distributions_all.request_id%type

Line 1504: , pn_request_id in ap_invoice_distributions_all.request_id%type

1500: -- payables (ap_invoice_distributions_all)
1501: --
1502: ( errbuf OUT NOCOPY varchar2
1503: , retcode OUT NOCOPY number
1504: , pn_request_id in ap_invoice_distributions_all.request_id%type
1505: , pn_invoice_id in ap_invoice_distributions_all.invoice_id%type
1506: , pv_event in varchar2
1507: )
1508: is

Line 1505: , pn_invoice_id in ap_invoice_distributions_all.invoice_id%type

1501: --
1502: ( errbuf OUT NOCOPY varchar2
1503: , retcode OUT NOCOPY number
1504: , pn_request_id in ap_invoice_distributions_all.request_id%type
1505: , pn_invoice_id in ap_invoice_distributions_all.invoice_id%type
1506: , pv_event in varchar2
1507: )
1508: is
1509: begin null; -- Please remove this line and un-comment the code to use this procedure

Line 1511: ln_ap_invoice_distirbution_id ap_invoice_distributions_all.invoice_distribution_id%type;

1507: )
1508: is
1509: begin null; -- Please remove this line and un-comment the code to use this procedure
1510: /*
1511: ln_ap_invoice_distirbution_id ap_invoice_distributions_all.invoice_distribution_id%type;
1512: ln_dist_line_num ap_invoice_distributions_all.distribution_line_number%type;
1513: ln_project_id ap_invoice_distributions_all.project_id%type;
1514: ln_task_id ap_invoice_distributions_all.task_id%type;
1515: lv_exp_type ap_invoice_distributions_all.expenditure_type%type;

Line 1512: ln_dist_line_num ap_invoice_distributions_all.distribution_line_number%type;

1508: is
1509: begin null; -- Please remove this line and un-comment the code to use this procedure
1510: /*
1511: ln_ap_invoice_distirbution_id ap_invoice_distributions_all.invoice_distribution_id%type;
1512: ln_dist_line_num ap_invoice_distributions_all.distribution_line_number%type;
1513: ln_project_id ap_invoice_distributions_all.project_id%type;
1514: ln_task_id ap_invoice_distributions_all.task_id%type;
1515: lv_exp_type ap_invoice_distributions_all.expenditure_type%type;
1516: ld_exp_item_date ap_invoice_distributions_all.expenditure_item_date%type;

Line 1513: ln_project_id ap_invoice_distributions_all.project_id%type;

1509: begin null; -- Please remove this line and un-comment the code to use this procedure
1510: /*
1511: ln_ap_invoice_distirbution_id ap_invoice_distributions_all.invoice_distribution_id%type;
1512: ln_dist_line_num ap_invoice_distributions_all.distribution_line_number%type;
1513: ln_project_id ap_invoice_distributions_all.project_id%type;
1514: ln_task_id ap_invoice_distributions_all.task_id%type;
1515: lv_exp_type ap_invoice_distributions_all.expenditure_type%type;
1516: ld_exp_item_date ap_invoice_distributions_all.expenditure_item_date%type;
1517: ln_exp_organization_id ap_invoice_distributions_all.expenditure_organization_id%type;

Line 1514: ln_task_id ap_invoice_distributions_all.task_id%type;

1510: /*
1511: ln_ap_invoice_distirbution_id ap_invoice_distributions_all.invoice_distribution_id%type;
1512: ln_dist_line_num ap_invoice_distributions_all.distribution_line_number%type;
1513: ln_project_id ap_invoice_distributions_all.project_id%type;
1514: ln_task_id ap_invoice_distributions_all.task_id%type;
1515: lv_exp_type ap_invoice_distributions_all.expenditure_type%type;
1516: ld_exp_item_date ap_invoice_distributions_all.expenditure_item_date%type;
1517: ln_exp_organization_id ap_invoice_distributions_all.expenditure_organization_id%type;
1518: lv_project_accounting_context ap_invoice_distributions_all.project_accounting_context%type;

Line 1515: lv_exp_type ap_invoice_distributions_all.expenditure_type%type;

1511: ln_ap_invoice_distirbution_id ap_invoice_distributions_all.invoice_distribution_id%type;
1512: ln_dist_line_num ap_invoice_distributions_all.distribution_line_number%type;
1513: ln_project_id ap_invoice_distributions_all.project_id%type;
1514: ln_task_id ap_invoice_distributions_all.task_id%type;
1515: lv_exp_type ap_invoice_distributions_all.expenditure_type%type;
1516: ld_exp_item_date ap_invoice_distributions_all.expenditure_item_date%type;
1517: ln_exp_organization_id ap_invoice_distributions_all.expenditure_organization_id%type;
1518: lv_project_accounting_context ap_invoice_distributions_all.project_accounting_context%type;
1519: lv_pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%type;

Line 1516: ld_exp_item_date ap_invoice_distributions_all.expenditure_item_date%type;

1512: ln_dist_line_num ap_invoice_distributions_all.distribution_line_number%type;
1513: ln_project_id ap_invoice_distributions_all.project_id%type;
1514: ln_task_id ap_invoice_distributions_all.task_id%type;
1515: lv_exp_type ap_invoice_distributions_all.expenditure_type%type;
1516: ld_exp_item_date ap_invoice_distributions_all.expenditure_item_date%type;
1517: ln_exp_organization_id ap_invoice_distributions_all.expenditure_organization_id%type;
1518: lv_project_accounting_context ap_invoice_distributions_all.project_accounting_context%type;
1519: lv_pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%type;
1520: lv_assets_tracking_flag ap_invoice_distributions_all.assets_tracking_flag%type;

Line 1517: ln_exp_organization_id ap_invoice_distributions_all.expenditure_organization_id%type;

1513: ln_project_id ap_invoice_distributions_all.project_id%type;
1514: ln_task_id ap_invoice_distributions_all.task_id%type;
1515: lv_exp_type ap_invoice_distributions_all.expenditure_type%type;
1516: ld_exp_item_date ap_invoice_distributions_all.expenditure_item_date%type;
1517: ln_exp_organization_id ap_invoice_distributions_all.expenditure_organization_id%type;
1518: lv_project_accounting_context ap_invoice_distributions_all.project_accounting_context%type;
1519: lv_pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%type;
1520: lv_assets_tracking_flag ap_invoice_distributions_all.assets_tracking_flag%type;
1521: ln_service_rgm_id JAI_RGM_DEFINITIONS.regime_id%type;

Line 1518: lv_project_accounting_context ap_invoice_distributions_all.project_accounting_context%type;

1514: ln_task_id ap_invoice_distributions_all.task_id%type;
1515: lv_exp_type ap_invoice_distributions_all.expenditure_type%type;
1516: ld_exp_item_date ap_invoice_distributions_all.expenditure_item_date%type;
1517: ln_exp_organization_id ap_invoice_distributions_all.expenditure_organization_id%type;
1518: lv_project_accounting_context ap_invoice_distributions_all.project_accounting_context%type;
1519: lv_pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%type;
1520: lv_assets_tracking_flag ap_invoice_distributions_all.assets_tracking_flag%type;
1521: ln_service_rgm_id JAI_RGM_DEFINITIONS.regime_id%type;
1522: lv_dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%type;

Line 1519: lv_pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%type;

1515: lv_exp_type ap_invoice_distributions_all.expenditure_type%type;
1516: ld_exp_item_date ap_invoice_distributions_all.expenditure_item_date%type;
1517: ln_exp_organization_id ap_invoice_distributions_all.expenditure_organization_id%type;
1518: lv_project_accounting_context ap_invoice_distributions_all.project_accounting_context%type;
1519: lv_pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%type;
1520: lv_assets_tracking_flag ap_invoice_distributions_all.assets_tracking_flag%type;
1521: ln_service_rgm_id JAI_RGM_DEFINITIONS.regime_id%type;
1522: lv_dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%type;
1523: ln_lines_to_insert number;

Line 1520: lv_assets_tracking_flag ap_invoice_distributions_all.assets_tracking_flag%type;

1516: ld_exp_item_date ap_invoice_distributions_all.expenditure_item_date%type;
1517: ln_exp_organization_id ap_invoice_distributions_all.expenditure_organization_id%type;
1518: lv_project_accounting_context ap_invoice_distributions_all.project_accounting_context%type;
1519: lv_pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%type;
1520: lv_assets_tracking_flag ap_invoice_distributions_all.assets_tracking_flag%type;
1521: ln_service_rgm_id JAI_RGM_DEFINITIONS.regime_id%type;
1522: lv_dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%type;
1523: ln_lines_to_insert number;
1524: ln_nrec_tax_amt number;

Line 1522: lv_dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%type;

1518: lv_project_accounting_context ap_invoice_distributions_all.project_accounting_context%type;
1519: lv_pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%type;
1520: lv_assets_tracking_flag ap_invoice_distributions_all.assets_tracking_flag%type;
1521: ln_service_rgm_id JAI_RGM_DEFINITIONS.regime_id%type;
1522: lv_dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%type;
1523: ln_lines_to_insert number;
1524: ln_nrec_tax_amt number;
1525: ln_rec_tax_amt number;
1526: ln_tax_amt number;

Line 1548: from ap_invoice_distributions_all apd

1544: , nvl(exchange_rate, 1) exchange_rate
1545: , invoice_currency_code
1546: from ap_invoices_all
1547: where invoice_id in ( select distinct apd.invoice_id
1548: from ap_invoice_distributions_all apd
1549: where ( (pn_request_id is not null and apd.request_id = pn_request_id)
1550: or (pn_invoice_id is not null and apd.invoice_id = pn_invoice_id)
1551: )
1552: )

Line 1555: cursor c_get_inv_distributions (cpn_invoice_id ap_invoice_distributions_all.invoice_id%type)

1551: )
1552: )
1553: order by invoice_id;
1554:
1555: cursor c_get_inv_distributions (cpn_invoice_id ap_invoice_distributions_all.invoice_id%type)
1556: is
1557: select accounting_date
1558: , accts_pay_code_combination_id
1559: , amount

Line 1593: from ap_invoice_distributions_all

1589: , project_id
1590: , rcv_transaction_id
1591: , set_of_books_id
1592: , task_id
1593: from ap_invoice_distributions_all
1594: where line_type_lookup_code in ('LINE', 'MISCELLANEOUS')
1595: and invoice_id = cpn_invoice_id;
1596:
1597: cursor c_get_max_dist_line_num (cpn_invoice_id ap_invoice_distributions_all.invoice_id%type)

Line 1597: cursor c_get_max_dist_line_num (cpn_invoice_id ap_invoice_distributions_all.invoice_id%type)

1593: from ap_invoice_distributions_all
1594: where line_type_lookup_code in ('LINE', 'MISCELLANEOUS')
1595: and invoice_id = cpn_invoice_id;
1596:
1597: cursor c_get_max_dist_line_num (cpn_invoice_id ap_invoice_distributions_all.invoice_id%type)
1598: is
1599: select max(distribution_line_number)
1600: from ap_invoice_distributions_all
1601: where invoice_id = cpn_invoice_id;

Line 1600: from ap_invoice_distributions_all

1596:
1597: cursor c_get_max_dist_line_num (cpn_invoice_id ap_invoice_distributions_all.invoice_id%type)
1598: is
1599: select max(distribution_line_number)
1600: from ap_invoice_distributions_all
1601: where invoice_id = cpn_invoice_id;
1602:
1603: cursor c_get_pa_hdr_from_ar_ref ( cpn_pa_cc_ar_invoice_id ap_invoice_distributions_all.pa_cc_ar_invoice_id%type)
1604: is

Line 1603: cursor c_get_pa_hdr_from_ar_ref ( cpn_pa_cc_ar_invoice_id ap_invoice_distributions_all.pa_cc_ar_invoice_id%type)

1599: select max(distribution_line_number)
1600: from ap_invoice_distributions_all
1601: where invoice_id = cpn_invoice_id;
1602:
1603: cursor c_get_pa_hdr_from_ar_ref ( cpn_pa_cc_ar_invoice_id ap_invoice_distributions_all.pa_cc_ar_invoice_id%type)
1604: is
1605: select jpdi.organization_id
1606: , jpdi.location_id
1607: , pdi.system_reference

Line 1620: ,cpn_ar_invoice_line_num ap_invoice_distributions_all.pa_cc_ar_invoice_line_num%type

1616: r_pa_hdr c_get_pa_hdr_from_ar_ref%rowtype;
1617:
1618: cursor c_get_taxes_from_ar_ref (cpn_project_id jai_pa_draft_invoices.project_id%type
1619: ,cpn_draft_invoice_num jai_pa_draft_invoices.draft_invoice_num%type
1620: ,cpn_ar_invoice_line_num ap_invoice_distributions_all.pa_cc_ar_invoice_line_num%type
1621: )
1622: is
1623: select jcdt.tax_id
1624: , jcdt.modvat_flag

Line 1681: update ap_invoice_distributions_all apd

1677:
1678: begin --> attempt_to_lock
1679:
1680: -- Lock the rows to get the maximum sequence number
1681: update ap_invoice_distributions_all apd
1682: set last_update_date = last_update_date
1683: where ( (pn_request_id is not null and apd.request_id = pn_request_id)
1684: or (pn_invoice_id is not null and apd.invoice_id = pn_invoice_id)
1685: );

Line 1884: 'Before inserting into ap_invoice_distributions_all for distribution line no :'|| ln_dist_line_num);

1880: ln_precision := 0;
1881: end if;
1882:
1883: fnd_file.put_line(fnd_file.log,
1884: 'Before inserting into ap_invoice_distributions_all for distribution line no :'|| ln_dist_line_num);
1885:
1886: ln_request_id := fnd_profile.value ('CONC_REQUEST_ID');
1887: ln_program_application_id := r_inv_dist.program_application_id;
1888: ln_program_id := r_inv_dist.program_id;

Line 1895: insert into ap_invoice_distributions_all

1891: open c_get_invoice_distribution;
1892: fetch c_get_invoice_distribution into ln_ap_invoice_distirbution_id;
1893: close c_get_invoice_distribution;
1894:
1895: insert into ap_invoice_distributions_all
1896: (
1897: accounting_date
1898: ,accrual_posted_flag
1899: ,assets_addition_flag

Line 2205: p_table_name => ''AP_INVOICE_DISTRIBUTIONS_ALL'',

2201: begin
2202:
2203: v_mrc_string := 'BEGIN AP_MRC_ENGINE_PKG.Maintain_MRC_Data (
2204: p_operation_mode => ''INSERT'',
2205: p_table_name => ''AP_INVOICE_DISTRIBUTIONS_ALL'',
2206: p_key_value => :a,
2207: p_key_value_list => NULL,
2208: p_calling_sequence =>
2209: ''India Local Tax line as Miscellaneous distribution line (Distribution_matching procedure)''