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_AR_RGM_PROCESSING_PKG dependencies on AR_RECEIVABLES_TRX_ALL

Line 240: p_org_id AR_RECEIVABLES_TRX_ALL.ORG_ID%TYPE ,

236: p_error_message := 'Unexpected Error Occured in procedure jai_ar_rgm_processing_pkg.get_regime_info - '||substr(sqlerrm,1,300);
237: END get_regime_info;
238:
239: procedure get_ar_tax_disc_accnt ( p_receivable_application_id AR_RECEIVABLE_APPLICATIONS_ALL.RECEIVABLE_APPLICATION_ID%TYPE ,
240: p_org_id AR_RECEIVABLES_TRX_ALL.ORG_ID%TYPE ,
241: p_total_disc_amount JAI_RGM_TRX_REFS.DISCOUNTED_AMOUNT%TYPE ,/*Parameter added for the bug 4193633 */
242: p_tax_ediscounted OUT NOCOPY AR_RECEIVABLE_APPLICATIONS_ALL.TAX_EDISCOUNTED%TYPE ,
243: p_earned_disc_ccid OUT NOCOPY AR_RECEIVABLES_TRX_ALL.CODE_COMBINATION_ID%TYPE ,
244: p_tax_uediscounted OUT NOCOPY AR_RECEIVABLE_APPLICATIONS_ALL.TAX_UEDISCOUNTED%TYPE ,

Line 243: p_earned_disc_ccid OUT NOCOPY AR_RECEIVABLES_TRX_ALL.CODE_COMBINATION_ID%TYPE ,

239: procedure get_ar_tax_disc_accnt ( p_receivable_application_id AR_RECEIVABLE_APPLICATIONS_ALL.RECEIVABLE_APPLICATION_ID%TYPE ,
240: p_org_id AR_RECEIVABLES_TRX_ALL.ORG_ID%TYPE ,
241: p_total_disc_amount JAI_RGM_TRX_REFS.DISCOUNTED_AMOUNT%TYPE ,/*Parameter added for the bug 4193633 */
242: p_tax_ediscounted OUT NOCOPY AR_RECEIVABLE_APPLICATIONS_ALL.TAX_EDISCOUNTED%TYPE ,
243: p_earned_disc_ccid OUT NOCOPY AR_RECEIVABLES_TRX_ALL.CODE_COMBINATION_ID%TYPE ,
244: p_tax_uediscounted OUT NOCOPY AR_RECEIVABLE_APPLICATIONS_ALL.TAX_UEDISCOUNTED%TYPE ,
245: p_unearned_disc_ccid OUT NOCOPY AR_RECEIVABLES_TRX_ALL.CODE_COMBINATION_ID%TYPE ,
246: p_process_flag OUT NOCOPY VARCHAR2 ,
247: p_process_message OUT NOCOPY VARCHAR2

Line 245: p_unearned_disc_ccid OUT NOCOPY AR_RECEIVABLES_TRX_ALL.CODE_COMBINATION_ID%TYPE ,

241: p_total_disc_amount JAI_RGM_TRX_REFS.DISCOUNTED_AMOUNT%TYPE ,/*Parameter added for the bug 4193633 */
242: p_tax_ediscounted OUT NOCOPY AR_RECEIVABLE_APPLICATIONS_ALL.TAX_EDISCOUNTED%TYPE ,
243: p_earned_disc_ccid OUT NOCOPY AR_RECEIVABLES_TRX_ALL.CODE_COMBINATION_ID%TYPE ,
244: p_tax_uediscounted OUT NOCOPY AR_RECEIVABLE_APPLICATIONS_ALL.TAX_UEDISCOUNTED%TYPE ,
245: p_unearned_disc_ccid OUT NOCOPY AR_RECEIVABLES_TRX_ALL.CODE_COMBINATION_ID%TYPE ,
246: p_process_flag OUT NOCOPY VARCHAR2 ,
247: p_process_message OUT NOCOPY VARCHAR2
248: )
249:

Line 308: CURSOR cur_get_disc_ccid (cp_type AR_RECEIVABLES_TRX_ALL.TYPE%TYPE,p_lookup_type ar_lookups.lookup_type%type,p_status ar_receivables_trx_all.status%TYPE )--rchandan for bug#4428980

304: WHERE
305: receivable_application_id = p_receivable_application_id AND
306: org_id = p_org_id;
307:
308: CURSOR cur_get_disc_ccid (cp_type AR_RECEIVABLES_TRX_ALL.TYPE%TYPE,p_lookup_type ar_lookups.lookup_type%type,p_status ar_receivables_trx_all.status%TYPE )--rchandan for bug#4428980
309: IS
310: SELECT
311: code_combination_id
312: FROM

Line 313: ar_receivables_trx_all rtrx,

309: IS
310: SELECT
311: code_combination_id
312: FROM
313: ar_receivables_trx_all rtrx,
314: ar_lookups lkup
315: WHERE
316: rtrx.type = lkup.lookup_code AND
317: lkup.lookup_code = cp_type AND

Line 397: p_process_message := 'Earned Discount Account Setup not found in ar_receivables_trx_all ';

393: IF CUR_GET_DISC_CCID%NOTFOUND THEN
394: CLOSE cur_get_receivable_app;
395: CLOSE cur_get_disc_ccid;
396: p_process_flag := jai_constants.expected_error ;
397: p_process_message := 'Earned Discount Account Setup not found in ar_receivables_trx_all ';
398: fnd_file.put_line(fnd_file.LOG,' 6 EXPECTED ERROR - Earned Discount Account Setup not found in ar_receivables_trx_all ');
399: return;
400: END IF;
401: p_earned_disc_ccid := rec_cur_get_disc_ccid.code_combination_id ;

Line 398: fnd_file.put_line(fnd_file.LOG,' 6 EXPECTED ERROR - Earned Discount Account Setup not found in ar_receivables_trx_all ');

394: CLOSE cur_get_receivable_app;
395: CLOSE cur_get_disc_ccid;
396: p_process_flag := jai_constants.expected_error ;
397: p_process_message := 'Earned Discount Account Setup not found in ar_receivables_trx_all ';
398: fnd_file.put_line(fnd_file.LOG,' 6 EXPECTED ERROR - Earned Discount Account Setup not found in ar_receivables_trx_all ');
399: return;
400: END IF;
401: p_earned_disc_ccid := rec_cur_get_disc_ccid.code_combination_id ;
402: CLOSE cur_get_disc_ccid;

Line 418: p_process_message := 'UnEarned Discount Account Setup not found in ar_receivables_trx_all ';

414: IF CUR_GET_DISC_CCID%NOTFOUND THEN
415: CLOSE cur_get_receivable_app;
416: CLOSE cur_get_disc_ccid;
417: p_process_flag := jai_constants.expected_error ;
418: p_process_message := 'UnEarned Discount Account Setup not found in ar_receivables_trx_all ';
419: fnd_file.put_line(fnd_file.LOG,' 8 EXPECTED ERROR - UnEarned Discount Account Setup not found in ar_receivables_trx_all ');
420: return;
421: END IF;
422: p_unearned_disc_ccid := rec_cur_get_disc_ccid.code_combination_id ;

Line 419: fnd_file.put_line(fnd_file.LOG,' 8 EXPECTED ERROR - UnEarned Discount Account Setup not found in ar_receivables_trx_all ');

415: CLOSE cur_get_receivable_app;
416: CLOSE cur_get_disc_ccid;
417: p_process_flag := jai_constants.expected_error ;
418: p_process_message := 'UnEarned Discount Account Setup not found in ar_receivables_trx_all ';
419: fnd_file.put_line(fnd_file.LOG,' 8 EXPECTED ERROR - UnEarned Discount Account Setup not found in ar_receivables_trx_all ');
420: return;
421: END IF;
422: p_unearned_disc_ccid := rec_cur_get_disc_ccid.code_combination_id ;
423: CLOSE cur_get_disc_ccid;