DBA Data[Home] [Help]

APPS.JAI_AR_RGM_PROCESSING_PKG dependencies on AR_RECEIVABLES_TRX_ALL

Line 542: p_org_id AR_RECEIVABLES_TRX_ALL.ORG_ID%TYPE ,

538: p_error_message := 'Unexpected Error Occured in procedure jai_ar_rgm_processing_pkg.get_regime_info - '||substr(sqlerrm,1,300);
539: END get_regime_info;
540:
541: procedure get_ar_tax_disc_accnt ( p_receivable_application_id AR_RECEIVABLE_APPLICATIONS_ALL.RECEIVABLE_APPLICATION_ID%TYPE ,
542: p_org_id AR_RECEIVABLES_TRX_ALL.ORG_ID%TYPE ,
543: p_total_disc_amount JAI_RGM_TRX_REFS.DISCOUNTED_AMOUNT%TYPE ,/*Parameter added for the bug 4193633 */
544: p_tax_ediscounted OUT NOCOPY AR_RECEIVABLE_APPLICATIONS_ALL.TAX_EDISCOUNTED%TYPE ,
545: p_earned_disc_ccid OUT NOCOPY AR_RECEIVABLES_TRX_ALL.CODE_COMBINATION_ID%TYPE ,
546: p_tax_uediscounted OUT NOCOPY AR_RECEIVABLE_APPLICATIONS_ALL.TAX_UEDISCOUNTED%TYPE ,

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

541: procedure get_ar_tax_disc_accnt ( p_receivable_application_id AR_RECEIVABLE_APPLICATIONS_ALL.RECEIVABLE_APPLICATION_ID%TYPE ,
542: p_org_id AR_RECEIVABLES_TRX_ALL.ORG_ID%TYPE ,
543: p_total_disc_amount JAI_RGM_TRX_REFS.DISCOUNTED_AMOUNT%TYPE ,/*Parameter added for the bug 4193633 */
544: p_tax_ediscounted OUT NOCOPY AR_RECEIVABLE_APPLICATIONS_ALL.TAX_EDISCOUNTED%TYPE ,
545: p_earned_disc_ccid OUT NOCOPY AR_RECEIVABLES_TRX_ALL.CODE_COMBINATION_ID%TYPE ,
546: p_tax_uediscounted OUT NOCOPY AR_RECEIVABLE_APPLICATIONS_ALL.TAX_UEDISCOUNTED%TYPE ,
547: p_unearned_disc_ccid OUT NOCOPY AR_RECEIVABLES_TRX_ALL.CODE_COMBINATION_ID%TYPE ,
548: p_process_flag OUT NOCOPY VARCHAR2 ,
549: p_process_message OUT NOCOPY VARCHAR2

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

543: p_total_disc_amount JAI_RGM_TRX_REFS.DISCOUNTED_AMOUNT%TYPE ,/*Parameter added for the bug 4193633 */
544: p_tax_ediscounted OUT NOCOPY AR_RECEIVABLE_APPLICATIONS_ALL.TAX_EDISCOUNTED%TYPE ,
545: p_earned_disc_ccid OUT NOCOPY AR_RECEIVABLES_TRX_ALL.CODE_COMBINATION_ID%TYPE ,
546: p_tax_uediscounted OUT NOCOPY AR_RECEIVABLE_APPLICATIONS_ALL.TAX_UEDISCOUNTED%TYPE ,
547: p_unearned_disc_ccid OUT NOCOPY AR_RECEIVABLES_TRX_ALL.CODE_COMBINATION_ID%TYPE ,
548: p_process_flag OUT NOCOPY VARCHAR2 ,
549: p_process_message OUT NOCOPY VARCHAR2
550: )
551:

Line 610: 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

606: WHERE
607: receivable_application_id = p_receivable_application_id AND
608: org_id = p_org_id;
609:
610: 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
611: IS
612: SELECT
613: code_combination_id
614: FROM

Line 615: ar_receivables_trx_all rtrx,

611: IS
612: SELECT
613: code_combination_id
614: FROM
615: ar_receivables_trx_all rtrx,
616: ar_lookups lkup
617: WHERE
618: rtrx.type = lkup.lookup_code AND
619: lkup.lookup_code = cp_type AND

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

695: IF CUR_GET_DISC_CCID%NOTFOUND THEN
696: CLOSE cur_get_receivable_app;
697: CLOSE cur_get_disc_ccid;
698: p_process_flag := jai_constants.expected_error ;
699: p_process_message := 'Earned Discount Account Setup not found in ar_receivables_trx_all ';
700: fnd_file.put_line(fnd_file.LOG,' 6 EXPECTED ERROR - Earned Discount Account Setup not found in ar_receivables_trx_all ');
701: return;
702: END IF;
703: p_earned_disc_ccid := rec_cur_get_disc_ccid.code_combination_id ;

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

696: CLOSE cur_get_receivable_app;
697: CLOSE cur_get_disc_ccid;
698: p_process_flag := jai_constants.expected_error ;
699: p_process_message := 'Earned Discount Account Setup not found in ar_receivables_trx_all ';
700: fnd_file.put_line(fnd_file.LOG,' 6 EXPECTED ERROR - Earned Discount Account Setup not found in ar_receivables_trx_all ');
701: return;
702: END IF;
703: p_earned_disc_ccid := rec_cur_get_disc_ccid.code_combination_id ;
704: CLOSE cur_get_disc_ccid;

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

716: IF CUR_GET_DISC_CCID%NOTFOUND THEN
717: CLOSE cur_get_receivable_app;
718: CLOSE cur_get_disc_ccid;
719: p_process_flag := jai_constants.expected_error ;
720: p_process_message := 'UnEarned Discount Account Setup not found in ar_receivables_trx_all ';
721: fnd_file.put_line(fnd_file.LOG,' 8 EXPECTED ERROR - UnEarned Discount Account Setup not found in ar_receivables_trx_all ');
722: return;
723: END IF;
724: p_unearned_disc_ccid := rec_cur_get_disc_ccid.code_combination_id ;

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

717: CLOSE cur_get_receivable_app;
718: CLOSE cur_get_disc_ccid;
719: p_process_flag := jai_constants.expected_error ;
720: p_process_message := 'UnEarned Discount Account Setup not found in ar_receivables_trx_all ';
721: fnd_file.put_line(fnd_file.LOG,' 8 EXPECTED ERROR - UnEarned Discount Account Setup not found in ar_receivables_trx_all ');
722: return;
723: END IF;
724: p_unearned_disc_ccid := rec_cur_get_disc_ccid.code_combination_id ;
725: CLOSE cur_get_disc_ccid;