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.

[Home] [Help]

APPS.JAI_CMN_RGM_VAT_ACCNT_PKG dependencies on JAI_RGM_TRX_RECORDS

Line 66: jai_rgm_trx_records.

62: cur_get_man_ar_inv_taxes for performance issue
63: reported.
64: It increased the performance
65: as these columns have index defined on them in
66: jai_rgm_trx_records.
67:
68: *****************************************************************************************************************************************************************/
69: AS
70: /* */

Line 128: ln_repository_id JAI_RGM_TRX_RECORDS.REPOSITORY_ID%TYPE ;

124: Modified the cursor cur_get_man_ar_inv_taxes, Changed jrttv1.tax_type to jrttv1.regime_code in where clause.
125: ***************************************************************************************************/
126: AS
127:
128: ln_repository_id JAI_RGM_TRX_RECORDS.REPOSITORY_ID%TYPE ;
129: ln_liab_acct_ccid GL_CODE_COMBINATIONS.code_combination_id%TYPE ;
130: ln_intliab_acct_ccid GL_CODE_COMBINATIONS.code_combination_id%TYPE ;
131: ln_charge_ac_id GL_CODE_COMBINATIONS.code_combination_id%TYPE ;
132: ln_balancing_ac_id GL_CODE_COMBINATIONS.code_combination_id%TYPE ;

Line 136: ln_debit_amount JAI_RGM_TRX_RECORDS.DEBIT_AMOUNT%TYPE ;

132: ln_balancing_ac_id GL_CODE_COMBINATIONS.code_combination_id%TYPE ;
133:
134: lv_process_flag VARCHAR2(2) ;
135: lv_process_message VARCHAR2(1996) ;
136: ln_debit_amount JAI_RGM_TRX_RECORDS.DEBIT_AMOUNT%TYPE ;
137: ln_credit_amount JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE ;
138:
139: --Date 14/06/2007 by sacsethi for bug 6072461 (for VAT Reversal)
140: ln_recov_acct_ccid GL_CODE_COMBINATIONS.code_combination_id%TYPE ;

Line 137: ln_credit_amount JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE ;

133:
134: lv_process_flag VARCHAR2(2) ;
135: lv_process_message VARCHAR2(1996) ;
136: ln_debit_amount JAI_RGM_TRX_RECORDS.DEBIT_AMOUNT%TYPE ;
137: ln_credit_amount JAI_RGM_TRX_RECORDS.CREDIT_AMOUNT%TYPE ;
138:
139: --Date 14/06/2007 by sacsethi for bug 6072461 (for VAT Reversal)
140: ln_recov_acct_ccid GL_CODE_COMBINATIONS.code_combination_id%TYPE ;
141: ln_expense_acct_ccid GL_CODE_COMBINATIONS.code_combination_id%TYPE ;

Line 149: jai_rgm_trx_records jrtr

145: --start
146: CURSOR c_chk_rgm_trxs(cp_transaction_header_id in number,cp_transaction_temp_id in number,cp_tax_id in number) IS
147: SELECT 1
148: FROM
149: jai_rgm_trx_records jrtr
150: WHERE
151: jrtr.attribute1 = cp_transaction_header_id AND
152: jrtr.source_document_id = cp_transaction_temp_id AND
153: jrtr.reference_id = cp_tax_id AND

Line 201: ( cp_source IN jai_rgm_trx_records.source%TYPE,

197: * Included source, source_trx_type and source_table_name in the inner
198: * query for performance issue reported.
199: */
200: CURSOR cur_get_deliveries
201: ( cp_source IN jai_rgm_trx_records.source%TYPE,
202: cp_source_trx_type IN jai_rgm_trx_records.source_trx_type%TYPE,
203: cp_source_table_name IN jai_rgm_trx_records.source_table_name%TYPE
204: )
205: IS

Line 202: cp_source_trx_type IN jai_rgm_trx_records.source_trx_type%TYPE,

198: * query for performance issue reported.
199: */
200: CURSOR cur_get_deliveries
201: ( cp_source IN jai_rgm_trx_records.source%TYPE,
202: cp_source_trx_type IN jai_rgm_trx_records.source_trx_type%TYPE,
203: cp_source_table_name IN jai_rgm_trx_records.source_table_name%TYPE
204: )
205: IS
206: SELECT

Line 203: cp_source_table_name IN jai_rgm_trx_records.source_table_name%TYPE

199: */
200: CURSOR cur_get_deliveries
201: ( cp_source IN jai_rgm_trx_records.source%TYPE,
202: cp_source_trx_type IN jai_rgm_trx_records.source_trx_type%TYPE,
203: cp_source_table_name IN jai_rgm_trx_records.source_table_name%TYPE
204: )
205: IS
206: SELECT
207: jspl.delivery_id ,

Line 238: FROM jai_rgm_trx_records jrtr

234: jsptl.tax_id = jtc.tax_id AND
235: jtc.tax_type = jrttv.tax_type AND
236: -- jrttv.regime_code = jai_constants.vat_regime AND --Date 14/06/2007 by sacsethi for bug 6072461
237: NOT EXISTS ( SELECT 1
238: FROM jai_rgm_trx_records jrtr
239: WHERE
240: -- Bug 5739005. Added by vkantamn
241: jrtr.source = cp_source AND
242: jrtr.source_trx_type = cp_source_trx_type AND

Line 294: ( cp_source IN jai_rgm_trx_records.source%TYPE,

290: * Included source, source_trx_type and source_table_name in the inner
291: * query for performance issue reported.
292: */
293: CURSOR cur_get_man_ar_inv_taxes
294: ( cp_source IN jai_rgm_trx_records.source%TYPE,
295: cp_source_trx_type IN jai_rgm_trx_records.source_trx_type%TYPE,
296: cp_source_table_name IN jai_rgm_trx_records.source_table_name%TYPE
297: )
298: IS

Line 295: cp_source_trx_type IN jai_rgm_trx_records.source_trx_type%TYPE,

291: * query for performance issue reported.
292: */
293: CURSOR cur_get_man_ar_inv_taxes
294: ( cp_source IN jai_rgm_trx_records.source%TYPE,
295: cp_source_trx_type IN jai_rgm_trx_records.source_trx_type%TYPE,
296: cp_source_table_name IN jai_rgm_trx_records.source_table_name%TYPE
297: )
298: IS
299: SELECT

Line 296: cp_source_table_name IN jai_rgm_trx_records.source_table_name%TYPE

292: */
293: CURSOR cur_get_man_ar_inv_taxes
294: ( cp_source IN jai_rgm_trx_records.source%TYPE,
295: cp_source_trx_type IN jai_rgm_trx_records.source_trx_type%TYPE,
296: cp_source_table_name IN jai_rgm_trx_records.source_table_name%TYPE
297: )
298: IS
299: SELECT
300: jctl.customer_trx_id ,

Line 330: jai_rgm_trx_records jrtr

326: jtc.tax_type = jrttv.tax_type AND
327: NOT EXISTS ( SELECT
328: 1
329: FROM
330: jai_rgm_trx_records jrtr
331: WHERE
332: -- Bug 5739005. Added by vkantamn
333: jrtr.source = cp_source AND
334: jrtr.source_trx_type = cp_source_trx_type AND

Line 346: lv_source_trx_type jai_rgm_trx_records.source_trx_type%type;

342: ) ;
343:
344:
345: /* Following variables added for Projects Billing. Bug# 6012570 (5876390) */
346: lv_source_trx_type jai_rgm_trx_records.source_trx_type%type;
347: lv_source_table_name VARCHAR2(30);
348: lv_called_from VARCHAR2(100); /*ssumaith - changed the width to 100 from 30 */
349: lv_attribute_context VARCHAR2(30);
350: ln_source_id NUMBER(15);