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_TAX_PROCESSING_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 84: from ap_invoice_distributions_all

80: --get distribution lines in one invoice
81: cursor c_get_inv_dists(cp_trx_id ap_invoices_all.INVOICE_ID%TYPE)
82: is
83: select *
84: from ap_invoice_distributions_all
85: where invoice_id = cp_trx_id;
86:
87: -- cursor to get prepay distribution lines for unapplication
88: cursor c_get_inv_dist_line(cp_trx_id ap_invoices_all.INVOICE_ID%TYPE)

Line 91: from ap_invoice_distributions_all aida

87: -- cursor to get prepay distribution lines for unapplication
88: cursor c_get_inv_dist_line(cp_trx_id ap_invoices_all.INVOICE_ID%TYPE)
89: is
90: select aida.*
91: from ap_invoice_distributions_all aida
92: where aida.invoice_id = cp_trx_id
93: and aida.line_type_lookup_code = 'PREPAY'
94: and aida.amount > 0
95: and aida.prepay_distribution_id is not null

Line 110: from ap_invoice_distributions_all

106: is
107: select invoice_id
108: ,invoice_distribution_id
109: ,match_status_flag
110: from ap_invoice_distributions_all
111: where invoice_id = cp_trx_id
112: and match_status_flag is not null;
113: ------------------------------------------------------------------------------------
114: --Added by Cholei for bug#14189751 end

Line 616: from ap_invoice_distributions_all

612: -- cursor to get invoice distribution line with match status flag
613: cursor c_get_inv_dist(cp_trx_id ap_invoices_all.INVOICE_ID%TYPE)
614: is
615: select *
616: from ap_invoice_distributions_all
617: where invoice_id = cp_trx_id
618: and match_status_flag is not null
619: and line_type_lookup_code <> 'PREPAY'; --Added by Chong for bug#13802244, sync flag should exclude prepayements line
620:

Line 625: from ap_invoice_distributions_all aida

621: -- cursor to get invoice distribution line for prepay
622: cursor c_get_inv_dist_prepay(cp_trx_id ap_invoices_all.INVOICE_ID%TYPE)
623: is
624: select aida.*
625: from ap_invoice_distributions_all aida
626: where aida.invoice_id = cp_trx_id
627: and line_type_lookup_code = 'PREPAY'
628: and amount < 0
629: and prepay_distribution_id is not null

Line 1424: from ap_invoice_distributions_all aida

1420: -- cursor to get invoice distributions
1421: cursor c_get_inv_dists(cp_trx_id ap_invoices_all.INVOICE_ID%TYPE)
1422: is
1423: select aida.*
1424: from ap_invoice_distributions_all aida
1425: where aida.invoice_id = cp_trx_id;
1426:
1427: le_error exception;
1428: lv_action VARCHAR2(100);

Line 1500: ( pr_rec ap_invoice_distributions_all%rowtype ,

1496: | pv_return_code IN NUMBER yes Return status |
1497: | pv_return_message IN VARCHAR2 yes Return message |
1498: ---------------------------------------------------------------------------------------------------------------------------------*/
1499: PROCEDURE CREATE_ACCOUNTING
1500: ( pr_rec ap_invoice_distributions_all%rowtype ,
1501: pv_action varchar2 ,
1502: pv_return_code out nocopy varchar2 ,
1503: pv_return_message out nocopy varchar2
1504: )

Line 1648: where jje.source_table_name = 'AP_INVOICE_DISTRIBUTIONS_ALL'

1644:
1645: cursor get_posted_flag( P_INVOICE_DISTRIBUTION_ID NUMBER ) IS
1646: select 'Y'
1647: from jai_cmn_journal_entries jje
1648: where jje.source_table_name = 'AP_INVOICE_DISTRIBUTIONS_ALL'
1649: AND jje.source_trx_id = P_INVOICE_DISTRIBUTION_ID;
1650:
1651:
1652: lv_posted_flag VARCHAR2(1);

Line 1693: FROM ap_invoice_distributions_all

1689: PRAGMA AUTONOMOUS_TRANSACTION;
1690:
1691: CURSOR check_same_period_cur IS
1692: SELECT 'Y'
1693: FROM ap_invoice_distributions_all
1694: WHERE invoice_id = pr_rec.invoice_id
1695: AND invoice_distribution_id = pr_rec.parent_reversal_id
1696: AND period_name = pr_rec.period_name;
1697:

Line 1842: RAISE_APPLICATION_ERROR(-20007, 'Error - trigger ja_in_ap_aida_after_trg on ap_invoice_distributions_all: '

1838:
1839: IF ln_charge_account_id IS NULL THEN
1840:
1841: lv_process_message := 'Recovery/Liability Accounts are not defined at the regime registration. Review Invoice ID: ' || pr_rec.invoice_id;
1842: RAISE_APPLICATION_ERROR(-20007, 'Error - trigger ja_in_ap_aida_after_trg on ap_invoice_distributions_all: '
1843: ||lv_process_message);
1844: END IF;
1845:
1846: jai_cmn_rgm_recording_pkg.post_accounting(

Line 1853: p_source_table_name => 'AP_INVOICE_DISTRIBUTIONS_ALL',

1849: p_organization_type => jai_constants.service_tax_orgn_type,
1850: p_organization_id => ln_organization_id,
1851: p_source => jai_constants.source_ap,
1852: p_source_trx_type => lv_source_trx_type,
1853: p_source_table_name => 'AP_INVOICE_DISTRIBUTIONS_ALL',
1854: p_source_document_id => ln_invoice_dist_id,
1855: p_code_combination_id => ln_charge_account_id,
1856: p_entered_cr => NULL,
1857: p_entered_dr => ln_entered_amt,

Line 1865: p_reference_name => 'AP_INVOICE_DISTRIBUTIONS_ALL',

1861: p_transaction_date => ld_transaction_date,
1862: p_calling_object => lv_called_from,
1863: p_repository_name => 'invoice_distribution_id',
1864: p_repository_id => NULL,
1865: p_reference_name => 'AP_INVOICE_DISTRIBUTIONS_ALL',
1866: p_reference_id => ln_invoice_dist_id,
1867: p_currency_code => lv_currency_code,
1868: p_curr_conv_date => ld_curr_conv_date,
1869: p_curr_conv_type => lv_curr_conv_type,

Line 1906: RAISE_APPLICATION_ERROR(-20007, 'Error - trigger ja_in_ap_aida_after_trg on ap_invoice_distributions_all: '

1902: , p_account_name => lv_account_name);
1903: IF ln_charge_account_id IS NULL THEN
1904:
1905: lv_process_message := 'Recovery/Liability Accounts are not defined at the regime registration. Review Invoice ID: ' || pr_rec.invoice_id;
1906: RAISE_APPLICATION_ERROR(-20007, 'Error - trigger ja_in_ap_aida_after_trg on ap_invoice_distributions_all: '
1907: ||lv_process_message);
1908: END IF;
1909:
1910: jai_cmn_rgm_recording_pkg.post_accounting(

Line 1917: p_source_table_name => 'AP_INVOICE_DISTRIBUTIONS_ALL',

1913: p_organization_type => jai_constants.service_tax_orgn_type,
1914: p_organization_id => ln_organization_id,
1915: p_source => jai_constants.source_ap,
1916: p_source_trx_type => lv_source_trx_type,
1917: p_source_table_name => 'AP_INVOICE_DISTRIBUTIONS_ALL',
1918: p_source_document_id => ln_invoice_dist_id,
1919: p_code_combination_id => ln_charge_account_id,
1920: p_entered_cr => ln_entered_amt,
1921: p_entered_dr => NULL,

Line 1929: p_reference_name => 'AP_INVOICE_DISTRIBUTIONS_ALL',

1925: p_transaction_date => ld_transaction_date,
1926: p_calling_object => lv_called_from,
1927: p_repository_name => 'invoice_distribution_id',
1928: p_repository_id => NULL,
1929: p_reference_name => 'AP_INVOICE_DISTRIBUTIONS_ALL',
1930: p_reference_id => ln_invoice_dist_id,
1931: p_currency_code => lv_currency_code,
1932: p_curr_conv_date => ld_curr_conv_date,
1933: p_curr_conv_type => lv_curr_conv_type,

Line 2032: inv_dist_rec AP_INVOICE_DISTRIBUTIONS_ALL%ROWTYPE;

2028:
2029: ln_parent_inv_payment_priority jai_ap_tds_thhold_trxs.parent_inv_payment_priority%type;
2030: inv_rec AP_INVOICES_ALL%ROWTYPE;
2031: inv_line_rec AP_INVOICE_LINES_ALL%ROWTYPE;
2032: inv_dist_rec AP_INVOICE_DISTRIBUTIONS_ALL%ROWTYPE;
2033: inv_ps_rec AP_PAYMENT_SCHEDULES%ROWTYPE;
2034: lv_action VARCHAR2(100);
2035: lv_return_code VARCHAR2(100);
2036: lv_return_message VARCHAR2(2000);