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.CE_AUTO_BANK_CLEAR1 dependencies on CE_AUTO_BANK_REC

Line 363: --Y_org_id := nvl(CE_AUTO_BANK_REC.G_org_id,CE_AUTO_BANK_REC.G_legal_entity_id);

359: IF l_DEBUG in ('Y', 'C') THEN
360: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.insert_reconciliation');
361: END IF;
362:
363: --Y_org_id := nvl(CE_AUTO_BANK_REC.G_org_id,CE_AUTO_BANK_REC.G_legal_entity_id);
364: --Y_org_id := nvl(CE_AUTO_BANK_REC.G_org_id,CE_AUTO_BANK_MATCH.bau_org_id);
365: --Y_legal_entity_id := nvl(CE_AUTO_BANK_REC.G_legal_entity_id,CE_AUTO_BANK_MATCH.bau_legal_entity_id);
366:
367: Y_org_id := nvl(nvl(CE_AUTO_BANK_CLEAR.G_org_id,CE_AUTO_BANK_MATCH.trx_org_id),CE_AUTO_BANK_REC.G_org_id) ;

Line 364: --Y_org_id := nvl(CE_AUTO_BANK_REC.G_org_id,CE_AUTO_BANK_MATCH.bau_org_id);

360: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.insert_reconciliation');
361: END IF;
362:
363: --Y_org_id := nvl(CE_AUTO_BANK_REC.G_org_id,CE_AUTO_BANK_REC.G_legal_entity_id);
364: --Y_org_id := nvl(CE_AUTO_BANK_REC.G_org_id,CE_AUTO_BANK_MATCH.bau_org_id);
365: --Y_legal_entity_id := nvl(CE_AUTO_BANK_REC.G_legal_entity_id,CE_AUTO_BANK_MATCH.bau_legal_entity_id);
366:
367: Y_org_id := nvl(nvl(CE_AUTO_BANK_CLEAR.G_org_id,CE_AUTO_BANK_MATCH.trx_org_id),CE_AUTO_BANK_REC.G_org_id) ;
368: Y_legal_entity_id := nvl(nvl(CE_AUTO_BANK_CLEAR.G_legal_entity_id,CE_AUTO_BANK_MATCH.trx_legal_entity_id),

Line 365: --Y_legal_entity_id := nvl(CE_AUTO_BANK_REC.G_legal_entity_id,CE_AUTO_BANK_MATCH.bau_legal_entity_id);

361: END IF;
362:
363: --Y_org_id := nvl(CE_AUTO_BANK_REC.G_org_id,CE_AUTO_BANK_REC.G_legal_entity_id);
364: --Y_org_id := nvl(CE_AUTO_BANK_REC.G_org_id,CE_AUTO_BANK_MATCH.bau_org_id);
365: --Y_legal_entity_id := nvl(CE_AUTO_BANK_REC.G_legal_entity_id,CE_AUTO_BANK_MATCH.bau_legal_entity_id);
366:
367: Y_org_id := nvl(nvl(CE_AUTO_BANK_CLEAR.G_org_id,CE_AUTO_BANK_MATCH.trx_org_id),CE_AUTO_BANK_REC.G_org_id) ;
368: Y_legal_entity_id := nvl(nvl(CE_AUTO_BANK_CLEAR.G_legal_entity_id,CE_AUTO_BANK_MATCH.trx_legal_entity_id),
369: CE_AUTO_BANK_REC.G_legal_entity_id);

Line 367: Y_org_id := nvl(nvl(CE_AUTO_BANK_CLEAR.G_org_id,CE_AUTO_BANK_MATCH.trx_org_id),CE_AUTO_BANK_REC.G_org_id) ;

363: --Y_org_id := nvl(CE_AUTO_BANK_REC.G_org_id,CE_AUTO_BANK_REC.G_legal_entity_id);
364: --Y_org_id := nvl(CE_AUTO_BANK_REC.G_org_id,CE_AUTO_BANK_MATCH.bau_org_id);
365: --Y_legal_entity_id := nvl(CE_AUTO_BANK_REC.G_legal_entity_id,CE_AUTO_BANK_MATCH.bau_legal_entity_id);
366:
367: Y_org_id := nvl(nvl(CE_AUTO_BANK_CLEAR.G_org_id,CE_AUTO_BANK_MATCH.trx_org_id),CE_AUTO_BANK_REC.G_org_id) ;
368: Y_legal_entity_id := nvl(nvl(CE_AUTO_BANK_CLEAR.G_legal_entity_id,CE_AUTO_BANK_MATCH.trx_legal_entity_id),
369: CE_AUTO_BANK_REC.G_legal_entity_id);
370:
371: IF l_DEBUG in ('Y', 'C') THEN

Line 369: CE_AUTO_BANK_REC.G_legal_entity_id);

365: --Y_legal_entity_id := nvl(CE_AUTO_BANK_REC.G_legal_entity_id,CE_AUTO_BANK_MATCH.bau_legal_entity_id);
366:
367: Y_org_id := nvl(nvl(CE_AUTO_BANK_CLEAR.G_org_id,CE_AUTO_BANK_MATCH.trx_org_id),CE_AUTO_BANK_REC.G_org_id) ;
368: Y_legal_entity_id := nvl(nvl(CE_AUTO_BANK_CLEAR.G_legal_entity_id,CE_AUTO_BANK_MATCH.trx_legal_entity_id),
369: CE_AUTO_BANK_REC.G_legal_entity_id);
370:
371: IF l_DEBUG in ('Y', 'C') THEN
372: cep_standard.debug('Y_org_id = ' ||Y_org_id || ', Y_legal_entity_id = ' ||Y_legal_entity_id||
373: ', CE_AUTO_BANK_MATCH.csl_reconcile_flag = ' ||CE_AUTO_BANK_MATCH.csl_reconcile_flag ||

Line 573: CE_AUTO_BANK_REC.G_gl_date := gl_date;

569: END IF;
570: auto_reconcile_flag := 'N';
571: CE_AUTO_BANK_MATCH.csh_statement_header_id := X_statement_header_id;
572: CE_AUTO_BANK_MATCH.csh_statement_date := X_statement_date;
573: CE_AUTO_BANK_REC.G_gl_date := gl_date;
574: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
575: CE_AUTO_BANK_REC.G_dr_vat_tax_code := X_dr_vat_tax_id;
576: CE_AUTO_BANK_REC.G_cr_vat_tax_code := X_cr_vat_tax_id;
577: CE_AUTO_BANK_MATCH.aba_bank_currency := bank_currency;

Line 575: CE_AUTO_BANK_REC.G_dr_vat_tax_code := X_dr_vat_tax_id;

571: CE_AUTO_BANK_MATCH.csh_statement_header_id := X_statement_header_id;
572: CE_AUTO_BANK_MATCH.csh_statement_date := X_statement_date;
573: CE_AUTO_BANK_REC.G_gl_date := gl_date;
574: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
575: CE_AUTO_BANK_REC.G_dr_vat_tax_code := X_dr_vat_tax_id;
576: CE_AUTO_BANK_REC.G_cr_vat_tax_code := X_cr_vat_tax_id;
577: CE_AUTO_BANK_MATCH.aba_bank_currency := bank_currency;
578: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
579: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;

Line 576: CE_AUTO_BANK_REC.G_cr_vat_tax_code := X_cr_vat_tax_id;

572: CE_AUTO_BANK_MATCH.csh_statement_date := X_statement_date;
573: CE_AUTO_BANK_REC.G_gl_date := gl_date;
574: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
575: CE_AUTO_BANK_REC.G_dr_vat_tax_code := X_dr_vat_tax_id;
576: CE_AUTO_BANK_REC.G_cr_vat_tax_code := X_cr_vat_tax_id;
577: CE_AUTO_BANK_MATCH.aba_bank_currency := bank_currency;
578: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
579: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
580: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_rate_date;

Line 635: --IF (to_date(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD') < to_date(receipt_gl_date,'YYYY/MM/DD')) THEN

631: set reconciled_status_flag = 'Y'
632: where seq_id = l_gt_seq_id;
633: END IF;
634: */
635: --IF (to_date(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD') < to_date(receipt_gl_date,'YYYY/MM/DD')) THEN
636: IF (to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD') < to_date(to_char(receipt_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD')) THEN
637: CE_AUTO_BANK_REC.G_gl_date := receipt_gl_date;
638: END IF;
639:

Line 636: IF (to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD') < to_date(to_char(receipt_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD')) THEN

632: where seq_id = l_gt_seq_id;
633: END IF;
634: */
635: --IF (to_date(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD') < to_date(receipt_gl_date,'YYYY/MM/DD')) THEN
636: IF (to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD') < to_date(to_char(receipt_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD')) THEN
637: CE_AUTO_BANK_REC.G_gl_date := receipt_gl_date;
638: END IF;
639:
640: --IF (to_date(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD') <

Line 637: CE_AUTO_BANK_REC.G_gl_date := receipt_gl_date;

633: END IF;
634: */
635: --IF (to_date(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD') < to_date(receipt_gl_date,'YYYY/MM/DD')) THEN
636: IF (to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD') < to_date(to_char(receipt_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD')) THEN
637: CE_AUTO_BANK_REC.G_gl_date := receipt_gl_date;
638: END IF;
639:
640: --IF (to_date(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD') <
641: --to_date(receipt_gl_date,'YYYY/MM/DD')) THEN

Line 652: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

648: IF (amount_to_clear = trx_amount) THEN
649: ARP_CASHBOOK.clear(
650: p_cr_id => receipt_id,
651: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
652: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
653: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
654: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
655: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
656: p_exchange_rate => to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate),

Line 674: cep_standard.debug('(CE_AUTO_BANK_REC.G_gl_date) = '||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'));

670: -- bug 3911424 used the new xrate, xrate date, xrate type and xrate amount cleared
671: IF l_DEBUG in ('Y', 'C') THEN
672: cep_standard.debug('receipt_id = '|| receipt_id);
673: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_trx_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD') );
674: cep_standard.debug('(CE_AUTO_BANK_REC.G_gl_date) = '||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
675: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
676: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
677: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
678:

Line 717: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

713:
714: ARP_CASHBOOK.clear(
715: p_cr_id => receipt_id,
716: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
717: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
718: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
719: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'), --trx_exchange_rate_date,
720: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type, --trx_exchange_rate_type,
721: p_exchange_rate => to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate), --amount_to_clear/trx_amount,

Line 739: cep_standard.debug('(CE_AUTO_BANK_REC.G_gl_date) = '||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'));

735: IF l_DEBUG in ('Y', 'C') THEN
736: cep_standard.debug('after call');
737: cep_standard.debug('receipt_id = '|| receipt_id);
738: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_trx_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
739: cep_standard.debug('(CE_AUTO_BANK_REC.G_gl_date) = '||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
740: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
741: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
742: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
743:

Line 791: --IF (to_date(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD') < to_date(receipt_gl_date,'YYYY/MM/DD')) THEN

787: trx_exchange_rate_type,
788: X_org_id;
789: EXIT WHEN manual_rbatch_cursor%NOTFOUND OR manual_rbatch_cursor%NOTFOUND IS NULL;
790:
791: --IF (to_date(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD') < to_date(receipt_gl_date,'YYYY/MM/DD')) THEN
792: IF (to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD') < to_date(to_char(receipt_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD')) THEN
793: CE_AUTO_BANK_REC.G_gl_date := receipt_gl_date;
794: END IF;
795:

Line 792: IF (to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD') < to_date(to_char(receipt_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD')) THEN

788: X_org_id;
789: EXIT WHEN manual_rbatch_cursor%NOTFOUND OR manual_rbatch_cursor%NOTFOUND IS NULL;
790:
791: --IF (to_date(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD') < to_date(receipt_gl_date,'YYYY/MM/DD')) THEN
792: IF (to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD') < to_date(to_char(receipt_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD')) THEN
793: CE_AUTO_BANK_REC.G_gl_date := receipt_gl_date;
794: END IF;
795:
796: --IF (to_date(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD') <

Line 793: CE_AUTO_BANK_REC.G_gl_date := receipt_gl_date;

789: EXIT WHEN manual_rbatch_cursor%NOTFOUND OR manual_rbatch_cursor%NOTFOUND IS NULL;
790:
791: --IF (to_date(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD') < to_date(receipt_gl_date,'YYYY/MM/DD')) THEN
792: IF (to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD') < to_date(to_char(receipt_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD')) THEN
793: CE_AUTO_BANK_REC.G_gl_date := receipt_gl_date;
794: END IF;
795:
796: --IF (to_date(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD') <
797: --to_date(receipt_gl_date,'YYYY/MM/DD')) THEN

Line 808: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

804: IF (amount_to_clear = trx_amount) THEN
805: ARP_CASHBOOK.clear(
806: p_cr_id => receipt_id,
807: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
808: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
809: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
810: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
811: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
812: p_exchange_rate => to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate),

Line 829: cep_standard.debug('(CE_AUTO_BANK_REC.G_gl_date) = '||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'));

825: -- bug 3911424 used the new xrate, xrate date, xrate type and xrate amount cleared
826: IF l_DEBUG in ('Y', 'C') THEN
827: cep_standard.debug('receipt_id = '|| receipt_id);
828: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_trx_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD') );
829: cep_standard.debug('(CE_AUTO_BANK_REC.G_gl_date) = '||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
830: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
831: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
832: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
833:

Line 872: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

868:
869: ARP_CASHBOOK.clear(
870: p_cr_id => receipt_id,
871: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
872: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
873: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
874: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'), --trx_exchange_rate_date,
875: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type, --trx_exchange_rate_type,
876: p_exchange_rate => to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate), --amount_to_clear/trx_amount,

Line 894: cep_standard.debug('(CE_AUTO_BANK_REC.G_gl_date) = '||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'));

890: IF l_DEBUG in ('Y', 'C') THEN
891: cep_standard.debug('after call');
892: cep_standard.debug('receipt_id = '|| receipt_id);
893: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_trx_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
894: cep_standard.debug('(CE_AUTO_BANK_REC.G_gl_date) = '||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
895: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
896: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
897: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
898:

Line 1247: CE_AUTO_BANK_REC.G_gl_date := X_gl_date;

1243: FETCH C_STATEMENT_LINE_SEQ INTO X_statement_line_id;
1244: CLOSE C_STATEMENT_LINE_SEQ;
1245: END IF;
1246: IF (X_passin_mode IN ('MANUAL_REC','MANUAL_NO_REC','MANUAL', 'MANUAL_H')) THEN
1247: CE_AUTO_BANK_REC.G_gl_date := X_gl_date;
1248: CE_AUTO_BANK_MATCH.csl_trx_date := X_trx_date;
1249: CE_AUTO_BANK_MATCH.csl_effective_date := X_value_date;
1250: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := X_exchange_rate_date;
1251: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := X_exchange_rate_type;

Line 1253: CE_AUTO_BANK_REC.G_payment_method_id := X_receipt_method_id;

1249: CE_AUTO_BANK_MATCH.csl_effective_date := X_value_date;
1250: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := X_exchange_rate_date;
1251: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := X_exchange_rate_type;
1252: CE_AUTO_BANK_MATCH.csl_exchange_rate := X_exchange_rate;
1253: CE_AUTO_BANK_REC.G_payment_method_id := X_receipt_method_id;
1254: CE_AUTO_BANK_MATCH.csh_bank_account_id := X_bank_account_id;
1255: CE_AUTO_BANK_REC.G_receivables_trx_id := X_activity_type_id;
1256: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
1257: CE_AUTO_BANK_MATCH.aba_bank_currency := X_clear_currency_code;

Line 1255: CE_AUTO_BANK_REC.G_receivables_trx_id := X_activity_type_id;

1251: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := X_exchange_rate_type;
1252: CE_AUTO_BANK_MATCH.csl_exchange_rate := X_exchange_rate;
1253: CE_AUTO_BANK_REC.G_payment_method_id := X_receipt_method_id;
1254: CE_AUTO_BANK_MATCH.csh_bank_account_id := X_bank_account_id;
1255: CE_AUTO_BANK_REC.G_receivables_trx_id := X_activity_type_id;
1256: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
1257: CE_AUTO_BANK_MATCH.aba_bank_currency := X_clear_currency_code;
1258: CE_AUTO_BANK_REC.G_set_of_books_id := X_set_of_books_id;
1259: CE_AUTO_BANK_REC.G_cr_vat_tax_code := X_cr_vat_tax_id;

Line 1258: CE_AUTO_BANK_REC.G_set_of_books_id := X_set_of_books_id;

1254: CE_AUTO_BANK_MATCH.csh_bank_account_id := X_bank_account_id;
1255: CE_AUTO_BANK_REC.G_receivables_trx_id := X_activity_type_id;
1256: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
1257: CE_AUTO_BANK_MATCH.aba_bank_currency := X_clear_currency_code;
1258: CE_AUTO_BANK_REC.G_set_of_books_id := X_set_of_books_id;
1259: CE_AUTO_BANK_REC.G_cr_vat_tax_code := X_cr_vat_tax_id;
1260: CE_AUTO_BANK_REC.G_dr_vat_tax_code := X_dr_vat_tax_id;
1261: temp := CE_AUTO_BANK_MATCH.validate_payment_method;
1262: --CE_AUTO_BANK_REC.G_org_id := X_org_id;

Line 1259: CE_AUTO_BANK_REC.G_cr_vat_tax_code := X_cr_vat_tax_id;

1255: CE_AUTO_BANK_REC.G_receivables_trx_id := X_activity_type_id;
1256: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
1257: CE_AUTO_BANK_MATCH.aba_bank_currency := X_clear_currency_code;
1258: CE_AUTO_BANK_REC.G_set_of_books_id := X_set_of_books_id;
1259: CE_AUTO_BANK_REC.G_cr_vat_tax_code := X_cr_vat_tax_id;
1260: CE_AUTO_BANK_REC.G_dr_vat_tax_code := X_dr_vat_tax_id;
1261: temp := CE_AUTO_BANK_MATCH.validate_payment_method;
1262: --CE_AUTO_BANK_REC.G_org_id := X_org_id;
1263: CE_AUTO_BANK_CLEAR.G_org_id := X_org_id;

Line 1260: CE_AUTO_BANK_REC.G_dr_vat_tax_code := X_dr_vat_tax_id;

1256: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
1257: CE_AUTO_BANK_MATCH.aba_bank_currency := X_clear_currency_code;
1258: CE_AUTO_BANK_REC.G_set_of_books_id := X_set_of_books_id;
1259: CE_AUTO_BANK_REC.G_cr_vat_tax_code := X_cr_vat_tax_id;
1260: CE_AUTO_BANK_REC.G_dr_vat_tax_code := X_dr_vat_tax_id;
1261: temp := CE_AUTO_BANK_MATCH.validate_payment_method;
1262: --CE_AUTO_BANK_REC.G_org_id := X_org_id;
1263: CE_AUTO_BANK_CLEAR.G_org_id := X_org_id;
1264: END IF;

Line 1262: --CE_AUTO_BANK_REC.G_org_id := X_org_id;

1258: CE_AUTO_BANK_REC.G_set_of_books_id := X_set_of_books_id;
1259: CE_AUTO_BANK_REC.G_cr_vat_tax_code := X_cr_vat_tax_id;
1260: CE_AUTO_BANK_REC.G_dr_vat_tax_code := X_dr_vat_tax_id;
1261: temp := CE_AUTO_BANK_MATCH.validate_payment_method;
1262: --CE_AUTO_BANK_REC.G_org_id := X_org_id;
1263: CE_AUTO_BANK_CLEAR.G_org_id := X_org_id;
1264: END IF;
1265: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
1266: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;

Line 1286: CE_AUTO_BANK_REC.G_payment_method_name),

1282: -- CE_AUTO_BANK_MATCH.get_vat_tax_id(l_vat_tax_id, l_tax_rate);
1283: l_valid_seq := CE_AUTO_BANK_IMPORT.get_sequence_info(
1284: 222,
1285: nvl(CE_AUTO_BANK_MATCH.csl_receipt_method_name,
1286: CE_AUTO_BANK_REC.G_payment_method_name),
1287: CE_AUTO_BANK_REC.G_set_of_books_id,
1288: 'A',
1289: CE_AUTO_BANK_MATCH.csl_trx_date,
1290: l_dbseqname,

Line 1287: CE_AUTO_BANK_REC.G_set_of_books_id,

1283: l_valid_seq := CE_AUTO_BANK_IMPORT.get_sequence_info(
1284: 222,
1285: nvl(CE_AUTO_BANK_MATCH.csl_receipt_method_name,
1286: CE_AUTO_BANK_REC.G_payment_method_name),
1287: CE_AUTO_BANK_REC.G_set_of_books_id,
1288: 'A',
1289: CE_AUTO_BANK_MATCH.csl_trx_date,
1290: l_dbseqname,
1291: l_doc_seq_id,

Line 1441: to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

1437: IF (X_passin_mode NOT IN ('MANUAL_NO_REC','AUTO_TRX')) THEN
1438: IF (l_status not in ('CLEARED', 'RISK_ELIMINATED'))THEN
1439: ARP_CASHBOOK.clear(X_cr_id,
1440: to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1441: to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1442: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1443: to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1444: CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
1445: CE_AUTO_BANK_CLEAR.G_exchange_rate,

Line 1537: CE_AUTO_BANK_REC.G_gl_date := gl_date;

1533: CLOSE C_STATEMENT_LINE_SEQ;
1534: END IF;
1535: CE_AUTO_BANK_MATCH.csh_statement_header_id := X_statement_header_id;
1536: CE_AUTO_BANK_MATCH.csh_statement_date := statement_header_date;
1537: CE_AUTO_BANK_REC.G_gl_date := gl_date;
1538: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
1539: CE_AUTO_BANK_MATCH.csl_statement_line_id := statement_line_id;
1540: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
1541: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_rate_date;

Line 1647: 'X_ACCOUNTING_DATE: '||CE_AUTO_BANK_REC.G_gl_date|| chr(10) ||

1643: IF l_DEBUG in ('Y', 'C') THEN
1644: cep_standard.debug('reconcile_pbatch: ' || '>>>AP_RECONCILIATION_PKG.recon_payment_history'|| chr(10) ||
1645: 'X_CHECKRUN_ID: '||to_char(pbatch_id)|| chr(10) ||
1646: 'pgroup_id: '||to_char(pgroup_id)|| chr(10) ||
1647: 'X_ACCOUNTING_DATE: '||CE_AUTO_BANK_REC.G_gl_date|| chr(10) ||
1648: 'X_CLEARED_DATE: '||CE_AUTO_BANK_MATCH.csl_trx_date|| chr(10) ||
1649: 'X_TRANSACTION_AMOUNT: '||to_char(amount_to_clear)|| chr(10) ||
1650: 'X_ERROR_AMOUNT: '||to_char(errors_amount)|| chr(10) ||
1651: 'X_CHARGE_AMOUNT: '||to_char(charges_amount)|| chr(10) ||

Line 1662: cep_standard.debug('pbatch_id='||pbatch_id||', CE_AUTO_BANK_REC.G_gl_date='||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD')||

1658: END IF;
1659: */
1660: ------------------------------------------------------------------------------
1661: IF l_DEBUG in ('Y', 'C') THEN
1662: cep_standard.debug('pbatch_id='||pbatch_id||', CE_AUTO_BANK_REC.G_gl_date='||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD')||
1663: ', CE_AUTO_BANK_MATCH.csl_trx_date='||to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
1664:
1665: cep_standard.debug('amount_to_clear='||NVL(amount_to_clear,0)||', errors_amount='||NVL(errors_amount,0)||
1666: ', charges_amount='||NVL(charges_amount,0)||', X_bank_currency_code='||X_bank_currency_code);

Line 1684: X_ACCOUNTING_DATE => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

1680:
1681: AP_RECONCILIATION_PKG.recon_payment_history(
1682: X_CHECKRUN_ID => pbatch_id,
1683: X_CHECK_ID => to_number(NULL),
1684: X_ACCOUNTING_DATE => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1685: X_CLEARED_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1686: X_TRANSACTION_AMOUNT => NVL(amount_to_clear,0),
1687: X_TRANSACTION_TYPE => 'PAYMENT CLEARING',
1688: X_ERROR_AMOUNT => NVL(errors_amount,0),

Line 1717: P_ACCOUNTING_DATE => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

1713:
1714: cep_standard.debug('call IBY_CE_BATCH_RECON_PKG.Payment_Instruction_Clearing');
1715: IBY_CE_BATCH_RECON_PKG.Payment_Instruction_Clearing(
1716: P_PAYMENT_INSTRUCTION_ID => pbatch_id,
1717: P_ACCOUNTING_DATE => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1718: P_CLEARED_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1719: P_TRANSACTION_AMOUNT => NVL(amount_to_clear,0), -- in bank curr.
1720: P_ERROR_AMOUNT => NVL(errors_amount,0), -- in bank curr.
1721: P_CHARGE_AMOUNT => NVL(charges_amount,0), -- in bank curr.

Line 1844: CE_AUTO_BANK_REC.G_gl_date := gl_date;

1840: CE_AUTO_BANK_MATCH.csl_trx_type := tx_type;
1841: CE_AUTO_BANK_MATCH.csh_statement_header_id := X_statement_header_id;
1842: -- CE_AUTO_BANK_MATCH.csh_statement_date := X_statement_header_date;
1843: CE_AUTO_BANK_MATCH.aba_bank_currency := X_bank_currency;
1844: CE_AUTO_BANK_REC.G_gl_date := gl_date;
1845: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
1846: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
1847: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_date;
1848: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;

Line 1922: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

1918: END IF;
1919: ARP_CASHBOOK.clear(
1920: p_cr_id => to_number(ar_cash_receipt_id),
1921: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1922: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1923: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1924: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1925: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
1926: p_exchange_rate => CE_AUTO_BANK_CLEAR.G_exchange_rate,

Line 1930: p_module_name => 'CE_AUTO_BANK_REC',

1926: p_exchange_rate => CE_AUTO_BANK_CLEAR.G_exchange_rate,
1927: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
1928: p_amount_cleared => amount_cleared * clearing_sign,
1929: p_amount_factored => charges_amount,
1930: p_module_name => 'CE_AUTO_BANK_REC',
1931: p_module_version => '1.0',
1932: p_crh_id => cleared_trx_id );
1933: -- Bug 16298972 Start
1934: IF cleared_trx_id IS NOT NULL THEN

Line 1953: CE_AUTO_BANK_REC.G_gl_date := CE_AUTO_BANK_MATCH.trx_gl_date;

1949: clearing_sign := 1;
1950: end if;
1951: if (passin_mode = 'AUTO') then
1952: if (CE_AUTO_BANK_MATCH.trx_gl_date is not null) then
1953: CE_AUTO_BANK_REC.G_gl_date := CE_AUTO_BANK_MATCH.trx_gl_date;
1954: end if;
1955: if (CE_AUTO_BANK_MATCH.trx_cleared_date is not null) then
1956: CE_AUTO_BANK_MATCH.csl_trx_date :=
1957: CE_AUTO_BANK_MATCH.trx_cleared_date;

Line 1964: 'X_ACCOUNTING_DATE: '||CE_AUTO_BANK_REC.G_gl_date);

1960:
1961: IF l_DEBUG in ('Y', 'C') THEN
1962: cep_standard.debug('reconcile_stmt: ' || '>>>AP_RECONCILIATION_PKG.recon_payment_history'||
1963: 'X_CHECK_ID: '||to_char(CE_AUTO_BANK_MATCH.trx_id)||
1964: 'X_ACCOUNTING_DATE: '||CE_AUTO_BANK_REC.G_gl_date);
1965: cep_standard.debug('X_CLEARED_DATE: '||CE_AUTO_BANK_MATCH.csl_trx_date||
1966: 'X_TRANSACTION_AMOUNT: '||to_char(amount_cleared*clearing_sign)||
1967: 'X_ERROR_AMOUNT: '||to_char(errors_amount)||
1968: 'X_CHARGE_AMOUNT: '||to_char(charges_amount));

Line 1983: X_ACCOUNTING_DATE => CE_AUTO_BANK_REC.G_gl_date,

1979:
1980: AP_RECONCILIATION_PKG.recon_payment_history(
1981: X_CHECKRUN_ID => to_number(NULL),
1982: X_CHECK_ID => CE_AUTO_BANK_MATCH.trx_id,
1983: X_ACCOUNTING_DATE => CE_AUTO_BANK_REC.G_gl_date,
1984: X_CLEARED_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1985: X_TRANSACTION_AMOUNT => NVL(amount_cleared,0) * clearing_sign,
1986: X_TRANSACTION_TYPE => 'PAYMENT CLEARING',
1987: X_ERROR_AMOUNT => NVL(errors_amount,0),

Line 2281: CE_AUTO_BANK_REC.G_gl_date := gl_date;

2277: CE_AUTO_BANK_MATCH.csl_trx_type := tx_type;
2278: CE_AUTO_BANK_MATCH.csh_statement_header_id := X_statement_header_id;
2279: CE_AUTO_BANK_MATCH.csh_statement_date := X_statement_header_date;
2280: CE_AUTO_BANK_MATCH.aba_bank_currency := X_bank_currency;
2281: CE_AUTO_BANK_REC.G_gl_date := gl_date;
2282: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
2283: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_date;
2284: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
2285: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;

Line 2339: X_status => nvl(CE_AUTO_BANK_REC.G_open_interface_clear_status,CE_AUTO_BANK_MATCH.trx_status),

2335: THEN
2336: CE_999_PKG.clear(
2337: X_trx_id => CE_AUTO_BANK_MATCH.trx_id,
2338: X_trx_type => CE_AUTO_BANK_MATCH.csl_match_type,
2339: X_status => nvl(CE_AUTO_BANK_REC.G_open_interface_clear_status,CE_AUTO_BANK_MATCH.trx_status),
2340: X_trx_number => CE_AUTO_BANK_MATCH.csl_bank_trx_number,
2341: X_trx_date => CE_AUTO_BANK_MATCH.csl_trx_date,
2342: X_trx_currency => CE_AUTO_BANK_MATCH.csl_currency_code,
2343: X_gl_date => CE_AUTO_BANK_REC.G_gl_date,

Line 2343: X_gl_date => CE_AUTO_BANK_REC.G_gl_date,

2339: X_status => nvl(CE_AUTO_BANK_REC.G_open_interface_clear_status,CE_AUTO_BANK_MATCH.trx_status),
2340: X_trx_number => CE_AUTO_BANK_MATCH.csl_bank_trx_number,
2341: X_trx_date => CE_AUTO_BANK_MATCH.csl_trx_date,
2342: X_trx_currency => CE_AUTO_BANK_MATCH.csl_currency_code,
2343: X_gl_date => CE_AUTO_BANK_REC.G_gl_date,
2344: X_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
2345: X_cleared_amount => NVL(amount_cleared,0),
2346: X_cleared_date => CE_AUTO_BANK_MATCH.csl_trx_date,
2347: X_charges_amount => charges_amount,

Line 2382: X_ACCOUNTING_DATE => nvl(gl_date,CE_AUTO_BANK_REC.G_gl_date),

2378: X_CASHFLOW_ID => CE_AUTO_BANK_MATCH.trx_id,
2379: X_TRX_STATUS => CE_AUTO_BANK_MATCH.trx_status,
2380: x_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2381: /* 14840476: Use GL_DATE passed to reconcile_trx */
2382: X_ACCOUNTING_DATE => nvl(gl_date,CE_AUTO_BANK_REC.G_gl_date),
2383: X_CLEARED_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2384: X_CLEARED_AMOUNT => NVL(amount_cleared,0),
2385: X_CLEARED_ERROR_AMOUNT => NVL(errors_amount,0),
2386: X_CLEARED_CHARGE_AMOUNT => NVL(charges_amount,0),

Line 2467: ' X_ACCOUNTING_DATE: '||CE_AUTO_BANK_REC.G_gl_date);

2463: end if;
2464: end if;
2465:
2466: cep_standard.debug('X_CHECK_ID: '||to_char(CE_AUTO_BANK_MATCH.trx_id)||
2467: ' X_ACCOUNTING_DATE: '||CE_AUTO_BANK_REC.G_gl_date);
2468: cep_standard.debug('X_CLEARED_DATE: '||CE_AUTO_BANK_MATCH.csl_trx_date||
2469: ' X_TRANSACTION_AMOUNT: '||to_char(amount_cleared));
2470: cep_standard.debug('X_ERROR_AMOUNT: '||to_char(errors_amount)||
2471: ' X_CHARGE_AMOUNT: '||to_char(charges_amount));

Line 2482: X_ACCOUNTING_DATE => CE_AUTO_BANK_REC.G_gl_date,

2478:
2479: AP_RECONCILIATION_PKG.recon_payment_history(
2480: X_CHECKRUN_ID => to_number(NULL),
2481: X_CHECK_ID => to_number(CE_AUTO_BANK_MATCH.trx_id),
2482: X_ACCOUNTING_DATE => CE_AUTO_BANK_REC.G_gl_date,
2483: X_CLEARED_DATE => CE_AUTO_BANK_MATCH.csl_trx_date,
2484: X_TRANSACTION_AMOUNT => NVL(amount_cleared,0),
2485: X_TRANSACTION_TYPE => 'PAYMENT CLEARING',
2486: X_ERROR_AMOUNT => NVL(errors_amount,0),

Line 2518: CE_AUTO_BANK_REC.G_nsf_handling = 'REVERSE' AND

2514: RAISE APP_EXCEPTION.application_exception;
2515: ELSE
2516: IF (passin_mode = 'AUTO' AND
2517: CE_AUTO_BANK_MATCH.csl_trx_type IN ('NSF','REJECTED') AND
2518: CE_AUTO_BANK_REC.G_nsf_handling = 'REVERSE' AND
2519: CE_AUTO_BANK_MATCH.trx_status <> 'REVERSED')
2520: THEN
2521: ARP_CASHBOOK.reverse(
2522: p_cr_id => ar_cash_receipt_id,

Line 2523: p_reversal_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

2519: CE_AUTO_BANK_MATCH.trx_status <> 'REVERSED')
2520: THEN
2521: ARP_CASHBOOK.reverse(
2522: p_cr_id => ar_cash_receipt_id,
2523: p_reversal_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2524: p_reversal_date => sysdate,
2525: p_reversal_comments => NULL,
2526: p_reversal_reason_code => NULL,
2527: p_reversal_category => NULL,

Line 2528: p_module_name => 'CE_AUTO_BANK_REC',

2524: p_reversal_date => sysdate,
2525: p_reversal_comments => NULL,
2526: p_reversal_reason_code => NULL,
2527: p_reversal_category => NULL,
2528: p_module_name => 'CE_AUTO_BANK_REC',
2529: p_module_version => '1.0',
2530: p_crh_id => cleared_trx_id);
2531: cleared_trx_type := CE_AUTO_BANK_MATCH.csl_match_type;
2532:

Line 2535: CE_AUTO_BANK_REC.G_nsf_handling = 'DM REVERSE' AND

2531: cleared_trx_type := CE_AUTO_BANK_MATCH.csl_match_type;
2532:
2533: ELSIF (passin_mode = 'AUTO' AND
2534: CE_AUTO_BANK_MATCH.csl_trx_type IN ('NSF','REJECTED') AND
2535: CE_AUTO_BANK_REC.G_nsf_handling = 'DM REVERSE' AND
2536: CE_AUTO_BANK_MATCH.trx_status <> 'REVERSED')
2537: THEN
2538: IF (CE_AUTO_BANK_MATCH.csl_match_type = 'CASH' AND
2539: CE_AUTO_BANK_MATCH.trx_customer_id is not null)

Line 2566: CE_AUTO_BANK_REC.G_set_of_books_id,

2562:
2563: l_valid_seq := CE_AUTO_BANK_IMPORT.get_sequence_info(
2564: 222,
2565: cust_trx_type,
2566: CE_AUTO_BANK_REC.G_set_of_books_id,
2567: 'A',
2568: CE_AUTO_BANK_MATCH.csl_trx_date,
2569: l_dbseqname,
2570: l_doc_seq_id,

Line 2580: to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

2576: p_cc_id => cc_id,
2577: p_dm_cust_trx_type_id => cust_trx_type_id,
2578: p_dm_cust_trx_type => cust_trx_type,
2579: p_reversal_gl_date =>
2580: to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2581: p_reversal_date =>
2582: to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2583: p_reversal_category => 'NSF',
2584: p_reversal_reason_code => 'NSF',

Line 2590: p_module_name => 'CE_AUTO_BANK_REC',

2586: p_dm_number => out_trx_number,
2587: p_dm_doc_sequence_value => l_doc_seq_value,
2588: p_dm_doc_sequence_id => l_doc_seq_id,
2589: p_tw_status => out_status,
2590: p_module_name => 'CE_AUTO_BANK_REC',
2591: p_module_version => '1.0');
2592:
2593: if (out_status = 'OK') then
2594: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;

Line 2639: ' CE_AUTO_BANK_REC.G_gl_date= '|| CE_AUTO_BANK_REC.G_gl_date);

2635: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
2636: ELSE
2637: cep_standard.debug('reconcile_trx: ' || ' ar_cash_receipt_id= '|| ar_cash_receipt_id ||
2638: ' CE_AUTO_BANK_MATCH.csl_trx_date = '|| CE_AUTO_BANK_MATCH.csl_trx_date ||
2639: ' CE_AUTO_BANK_REC.G_gl_date= '|| CE_AUTO_BANK_REC.G_gl_date);
2640: cep_standard.debug(' CE_AUTO_BANK_MATCH.csl_effective_date= '|| CE_AUTO_BANK_MATCH.csl_effective_date ||
2641: ' CE_AUTO_BANK_CLEAR.G_exchange_date= '|| CE_AUTO_BANK_CLEAR.G_exchange_date ||
2642: ' CE_AUTO_BANK_CLEAR.G_exchange_rate_type= '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
2643: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate= '|| CE_AUTO_BANK_CLEAR.G_exchange_rate ||

Line 2654: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

2650:
2651: ARP_CASHBOOK.clear(
2652: p_cr_id => to_number(ar_cash_receipt_id),
2653: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2654: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2655: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2656: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2657: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
2658: p_exchange_rate => CE_AUTO_BANK_CLEAR.G_exchange_rate,

Line 2662: p_module_name => 'CE_AUTO_BANK_REC',

2658: p_exchange_rate => CE_AUTO_BANK_CLEAR.G_exchange_rate,
2659: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
2660: p_amount_cleared => amount_cleared,
2661: p_amount_factored => charges_amount,
2662: p_module_name => 'CE_AUTO_BANK_REC',
2663: p_module_version => '1.0',
2664: p_crh_id => cleared_trx_id );
2665:
2666: -- Bug 16298972 Start

Line 2790: --CE_AUTO_BANK_REC.G_org_id := org_id;

2786: IF (passin_mode <> 'MANUAL_UC') THEN
2787: clearing_flag := 'Y';
2788: END IF;
2789: -- Bug 13803033 End
2790: --CE_AUTO_BANK_REC.G_org_id := org_id;
2791: --CE_AUTO_BANK_REC.G_legal_entity_id := legal_entity_id;
2792: CE_AUTO_BANK_CLEAR.G_org_id := org_id;
2793: CE_AUTO_BANK_CLEAR.G_legal_entity_id := legal_entity_id;
2794:

Line 2791: --CE_AUTO_BANK_REC.G_legal_entity_id := legal_entity_id;

2787: clearing_flag := 'Y';
2788: END IF;
2789: -- Bug 13803033 End
2790: --CE_AUTO_BANK_REC.G_org_id := org_id;
2791: --CE_AUTO_BANK_REC.G_legal_entity_id := legal_entity_id;
2792: CE_AUTO_BANK_CLEAR.G_org_id := org_id;
2793: CE_AUTO_BANK_CLEAR.G_legal_entity_id := legal_entity_id;
2794:
2795: IF (org_id is not null) THEN

Line 2897: X_status => nvl(CE_AUTO_BANK_REC.G_open_interface_float_status, status),

2893: END IF;
2894: ELSIF (clearing_trx_type = 'ROI_LINE' ) THEN
2895: CE_999_PKG.unclear( X_trx_id => trx_id,
2896: X_trx_type => tx_type,
2897: X_status => nvl(CE_AUTO_BANK_REC.G_open_interface_float_status, status),
2898: X_trx_date => trx_date,
2899: X_gl_date => gl_date);
2900: -- after unreconcile, update the reconciled_status of this trx in the GT table to 'N'
2901: CE_AUTO_BANK_MATCH.update_gt_reconciled_status(999, trx_id, 'N');