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 1536: -- payables (ap_invoice_distributions_all)

1532:
1533: procedure import_taxes_to_payables
1534: --
1535: -- This procedure imports the taxes from project draft invoice (jai_cmn_document_taxes) to
1536: -- payables (ap_invoice_distributions_all)
1537: --
1538: ( errbuf OUT NOCOPY varchar2
1539: , retcode OUT NOCOPY number
1540: , pn_request_id in ap_invoice_distributions_all.request_id%type

Line 1540: , pn_request_id in ap_invoice_distributions_all.request_id%type

1536: -- payables (ap_invoice_distributions_all)
1537: --
1538: ( errbuf OUT NOCOPY varchar2
1539: , retcode OUT NOCOPY number
1540: , pn_request_id in ap_invoice_distributions_all.request_id%type
1541: , pn_invoice_id in ap_invoice_distributions_all.invoice_id%type
1542: , pv_event in varchar2
1543: )
1544: is

Line 1541: , pn_invoice_id in ap_invoice_distributions_all.invoice_id%type

1537: --
1538: ( errbuf OUT NOCOPY varchar2
1539: , retcode OUT NOCOPY number
1540: , pn_request_id in ap_invoice_distributions_all.request_id%type
1541: , pn_invoice_id in ap_invoice_distributions_all.invoice_id%type
1542: , pv_event in varchar2
1543: )
1544: is
1545: begin null; -- Please remove this line and un-comment the code to use this procedure

Line 1547: ln_ap_invoice_distirbution_id ap_invoice_distributions_all.invoice_distribution_id%type;

1543: )
1544: is
1545: begin null; -- Please remove this line and un-comment the code to use this procedure
1546: /*
1547: ln_ap_invoice_distirbution_id ap_invoice_distributions_all.invoice_distribution_id%type;
1548: ln_dist_line_num ap_invoice_distributions_all.distribution_line_number%type;
1549: ln_project_id ap_invoice_distributions_all.project_id%type;
1550: ln_task_id ap_invoice_distributions_all.task_id%type;
1551: lv_exp_type ap_invoice_distributions_all.expenditure_type%type;

Line 1548: ln_dist_line_num ap_invoice_distributions_all.distribution_line_number%type;

1544: is
1545: begin null; -- Please remove this line and un-comment the code to use this procedure
1546: /*
1547: ln_ap_invoice_distirbution_id ap_invoice_distributions_all.invoice_distribution_id%type;
1548: ln_dist_line_num ap_invoice_distributions_all.distribution_line_number%type;
1549: ln_project_id ap_invoice_distributions_all.project_id%type;
1550: ln_task_id ap_invoice_distributions_all.task_id%type;
1551: lv_exp_type ap_invoice_distributions_all.expenditure_type%type;
1552: ld_exp_item_date ap_invoice_distributions_all.expenditure_item_date%type;

Line 1549: ln_project_id ap_invoice_distributions_all.project_id%type;

1545: begin null; -- Please remove this line and un-comment the code to use this procedure
1546: /*
1547: ln_ap_invoice_distirbution_id ap_invoice_distributions_all.invoice_distribution_id%type;
1548: ln_dist_line_num ap_invoice_distributions_all.distribution_line_number%type;
1549: ln_project_id ap_invoice_distributions_all.project_id%type;
1550: ln_task_id ap_invoice_distributions_all.task_id%type;
1551: lv_exp_type ap_invoice_distributions_all.expenditure_type%type;
1552: ld_exp_item_date ap_invoice_distributions_all.expenditure_item_date%type;
1553: ln_exp_organization_id ap_invoice_distributions_all.expenditure_organization_id%type;

Line 1550: ln_task_id ap_invoice_distributions_all.task_id%type;

1546: /*
1547: ln_ap_invoice_distirbution_id ap_invoice_distributions_all.invoice_distribution_id%type;
1548: ln_dist_line_num ap_invoice_distributions_all.distribution_line_number%type;
1549: ln_project_id ap_invoice_distributions_all.project_id%type;
1550: ln_task_id ap_invoice_distributions_all.task_id%type;
1551: lv_exp_type ap_invoice_distributions_all.expenditure_type%type;
1552: ld_exp_item_date ap_invoice_distributions_all.expenditure_item_date%type;
1553: ln_exp_organization_id ap_invoice_distributions_all.expenditure_organization_id%type;
1554: lv_project_accounting_context ap_invoice_distributions_all.project_accounting_context%type;

Line 1551: lv_exp_type ap_invoice_distributions_all.expenditure_type%type;

1547: ln_ap_invoice_distirbution_id ap_invoice_distributions_all.invoice_distribution_id%type;
1548: ln_dist_line_num ap_invoice_distributions_all.distribution_line_number%type;
1549: ln_project_id ap_invoice_distributions_all.project_id%type;
1550: ln_task_id ap_invoice_distributions_all.task_id%type;
1551: lv_exp_type ap_invoice_distributions_all.expenditure_type%type;
1552: ld_exp_item_date ap_invoice_distributions_all.expenditure_item_date%type;
1553: ln_exp_organization_id ap_invoice_distributions_all.expenditure_organization_id%type;
1554: lv_project_accounting_context ap_invoice_distributions_all.project_accounting_context%type;
1555: lv_pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%type;

Line 1552: ld_exp_item_date ap_invoice_distributions_all.expenditure_item_date%type;

1548: ln_dist_line_num ap_invoice_distributions_all.distribution_line_number%type;
1549: ln_project_id ap_invoice_distributions_all.project_id%type;
1550: ln_task_id ap_invoice_distributions_all.task_id%type;
1551: lv_exp_type ap_invoice_distributions_all.expenditure_type%type;
1552: ld_exp_item_date ap_invoice_distributions_all.expenditure_item_date%type;
1553: ln_exp_organization_id ap_invoice_distributions_all.expenditure_organization_id%type;
1554: lv_project_accounting_context ap_invoice_distributions_all.project_accounting_context%type;
1555: lv_pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%type;
1556: lv_assets_tracking_flag ap_invoice_distributions_all.assets_tracking_flag%type;

Line 1553: ln_exp_organization_id ap_invoice_distributions_all.expenditure_organization_id%type;

1549: ln_project_id ap_invoice_distributions_all.project_id%type;
1550: ln_task_id ap_invoice_distributions_all.task_id%type;
1551: lv_exp_type ap_invoice_distributions_all.expenditure_type%type;
1552: ld_exp_item_date ap_invoice_distributions_all.expenditure_item_date%type;
1553: ln_exp_organization_id ap_invoice_distributions_all.expenditure_organization_id%type;
1554: lv_project_accounting_context ap_invoice_distributions_all.project_accounting_context%type;
1555: lv_pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%type;
1556: lv_assets_tracking_flag ap_invoice_distributions_all.assets_tracking_flag%type;
1557: ln_service_rgm_id JAI_RGM_DEFINITIONS.regime_id%type;

Line 1554: lv_project_accounting_context ap_invoice_distributions_all.project_accounting_context%type;

1550: ln_task_id ap_invoice_distributions_all.task_id%type;
1551: lv_exp_type ap_invoice_distributions_all.expenditure_type%type;
1552: ld_exp_item_date ap_invoice_distributions_all.expenditure_item_date%type;
1553: ln_exp_organization_id ap_invoice_distributions_all.expenditure_organization_id%type;
1554: lv_project_accounting_context ap_invoice_distributions_all.project_accounting_context%type;
1555: lv_pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%type;
1556: lv_assets_tracking_flag ap_invoice_distributions_all.assets_tracking_flag%type;
1557: ln_service_rgm_id JAI_RGM_DEFINITIONS.regime_id%type;
1558: lv_dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%type;

Line 1555: lv_pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%type;

1551: lv_exp_type ap_invoice_distributions_all.expenditure_type%type;
1552: ld_exp_item_date ap_invoice_distributions_all.expenditure_item_date%type;
1553: ln_exp_organization_id ap_invoice_distributions_all.expenditure_organization_id%type;
1554: lv_project_accounting_context ap_invoice_distributions_all.project_accounting_context%type;
1555: lv_pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%type;
1556: lv_assets_tracking_flag ap_invoice_distributions_all.assets_tracking_flag%type;
1557: ln_service_rgm_id JAI_RGM_DEFINITIONS.regime_id%type;
1558: lv_dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%type;
1559: ln_lines_to_insert number;

Line 1556: lv_assets_tracking_flag ap_invoice_distributions_all.assets_tracking_flag%type;

1552: ld_exp_item_date ap_invoice_distributions_all.expenditure_item_date%type;
1553: ln_exp_organization_id ap_invoice_distributions_all.expenditure_organization_id%type;
1554: lv_project_accounting_context ap_invoice_distributions_all.project_accounting_context%type;
1555: lv_pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%type;
1556: lv_assets_tracking_flag ap_invoice_distributions_all.assets_tracking_flag%type;
1557: ln_service_rgm_id JAI_RGM_DEFINITIONS.regime_id%type;
1558: lv_dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%type;
1559: ln_lines_to_insert number;
1560: ln_nrec_tax_amt number;

Line 1558: lv_dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%type;

1554: lv_project_accounting_context ap_invoice_distributions_all.project_accounting_context%type;
1555: lv_pa_addition_flag ap_invoice_distributions_all.pa_addition_flag%type;
1556: lv_assets_tracking_flag ap_invoice_distributions_all.assets_tracking_flag%type;
1557: ln_service_rgm_id JAI_RGM_DEFINITIONS.regime_id%type;
1558: lv_dist_code_combination_id ap_invoice_distributions_all.dist_code_combination_id%type;
1559: ln_lines_to_insert number;
1560: ln_nrec_tax_amt number;
1561: ln_rec_tax_amt number;
1562: ln_tax_amt number;

Line 1584: from ap_invoice_distributions_all apd

1580: , nvl(exchange_rate, 1) exchange_rate
1581: , invoice_currency_code
1582: from ap_invoices_all
1583: where invoice_id in ( select distinct apd.invoice_id
1584: from ap_invoice_distributions_all apd
1585: where ( (pn_request_id is not null and apd.request_id = pn_request_id)
1586: or (pn_invoice_id is not null and apd.invoice_id = pn_invoice_id)
1587: )
1588: )

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

1587: )
1588: )
1589: order by invoice_id;
1590:
1591: cursor c_get_inv_distributions (cpn_invoice_id ap_invoice_distributions_all.invoice_id%type)
1592: is
1593: select accounting_date
1594: , accts_pay_code_combination_id
1595: , amount

Line 1629: from ap_invoice_distributions_all

1625: , project_id
1626: , rcv_transaction_id
1627: , set_of_books_id
1628: , task_id
1629: from ap_invoice_distributions_all
1630: where line_type_lookup_code in ('LINE', 'MISCELLANEOUS')
1631: and invoice_id = cpn_invoice_id;
1632:
1633: cursor c_get_max_dist_line_num (cpn_invoice_id ap_invoice_distributions_all.invoice_id%type)

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

1629: from ap_invoice_distributions_all
1630: where line_type_lookup_code in ('LINE', 'MISCELLANEOUS')
1631: and invoice_id = cpn_invoice_id;
1632:
1633: cursor c_get_max_dist_line_num (cpn_invoice_id ap_invoice_distributions_all.invoice_id%type)
1634: is
1635: select max(distribution_line_number)
1636: from ap_invoice_distributions_all
1637: where invoice_id = cpn_invoice_id;

Line 1636: from ap_invoice_distributions_all

1632:
1633: cursor c_get_max_dist_line_num (cpn_invoice_id ap_invoice_distributions_all.invoice_id%type)
1634: is
1635: select max(distribution_line_number)
1636: from ap_invoice_distributions_all
1637: where invoice_id = cpn_invoice_id;
1638:
1639: cursor c_get_pa_hdr_from_ar_ref ( cpn_pa_cc_ar_invoice_id ap_invoice_distributions_all.pa_cc_ar_invoice_id%type)
1640: is

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

1635: select max(distribution_line_number)
1636: from ap_invoice_distributions_all
1637: where invoice_id = cpn_invoice_id;
1638:
1639: cursor c_get_pa_hdr_from_ar_ref ( cpn_pa_cc_ar_invoice_id ap_invoice_distributions_all.pa_cc_ar_invoice_id%type)
1640: is
1641: select jpdi.organization_id
1642: , jpdi.location_id
1643: , pdi.system_reference

Line 1656: ,cpn_ar_invoice_line_num ap_invoice_distributions_all.pa_cc_ar_invoice_line_num%type

1652: r_pa_hdr c_get_pa_hdr_from_ar_ref%rowtype;
1653:
1654: cursor c_get_taxes_from_ar_ref (cpn_project_id jai_pa_draft_invoices.project_id%type
1655: ,cpn_draft_invoice_num jai_pa_draft_invoices.draft_invoice_num%type
1656: ,cpn_ar_invoice_line_num ap_invoice_distributions_all.pa_cc_ar_invoice_line_num%type
1657: )
1658: is
1659: select jcdt.tax_id
1660: , jcdt.modvat_flag

Line 1717: update ap_invoice_distributions_all apd

1713:
1714: begin --> attempt_to_lock
1715:
1716: -- Lock the rows to get the maximum sequence number
1717: update ap_invoice_distributions_all apd
1718: set last_update_date = last_update_date
1719: where ( (pn_request_id is not null and apd.request_id = pn_request_id)
1720: or (pn_invoice_id is not null and apd.invoice_id = pn_invoice_id)
1721: );

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

1916: ln_precision := 0;
1917: end if;
1918:
1919: fnd_file.put_line(fnd_file.log,
1920: 'Before inserting into ap_invoice_distributions_all for distribution line no :'|| ln_dist_line_num);
1921:
1922: ln_request_id := fnd_profile.value ('CONC_REQUEST_ID');
1923: ln_program_application_id := r_inv_dist.program_application_id;
1924: ln_program_id := r_inv_dist.program_id;

Line 1931: insert into ap_invoice_distributions_all

1927: open c_get_invoice_distribution;
1928: fetch c_get_invoice_distribution into ln_ap_invoice_distirbution_id;
1929: close c_get_invoice_distribution;
1930:
1931: insert into ap_invoice_distributions_all
1932: (
1933: accounting_date
1934: ,accrual_posted_flag
1935: ,assets_addition_flag

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

2237: begin
2238:
2239: v_mrc_string := 'BEGIN AP_MRC_ENGINE_PKG.Maintain_MRC_Data (
2240: p_operation_mode => ''INSERT'',
2241: p_table_name => ''AP_INVOICE_DISTRIBUTIONS_ALL'',
2242: p_key_value => :a,
2243: p_key_value_list => NULL,
2244: p_calling_sequence =>
2245: ''India Local Tax line as Miscellaneous distribution line (Distribution_matching procedure)''