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 668: 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'));

664: -- bug 3911424 used the new xrate, xrate date, xrate type and xrate amount cleared
665: IF l_DEBUG in ('Y', 'C') THEN
666: cep_standard.debug('receipt_id = '|| receipt_id);
667: 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') );
668: 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'));
669: 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'));
670: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
671: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
672:

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

707:
708: ARP_CASHBOOK.clear(
709: p_cr_id => receipt_id,
710: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
711: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
712: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
713: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'), --trx_exchange_rate_date,
714: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type, --trx_exchange_rate_type,
715: p_exchange_rate => to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate), --amount_to_clear/trx_amount,

Line 728: 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'));

724: IF l_DEBUG in ('Y', 'C') THEN
725: cep_standard.debug('after call');
726: cep_standard.debug('receipt_id = '|| receipt_id);
727: 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'));
728: 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'));
729: 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'));
730: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
731: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
732:

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

776: trx_exchange_rate_type,
777: X_org_id;
778: EXIT WHEN manual_rbatch_cursor%NOTFOUND OR manual_rbatch_cursor%NOTFOUND IS NULL;
779:
780: --IF (to_date(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD') < to_date(receipt_gl_date,'YYYY/MM/DD')) THEN
781: 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
782: CE_AUTO_BANK_REC.G_gl_date := receipt_gl_date;
783: END IF;
784:

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

777: X_org_id;
778: EXIT WHEN manual_rbatch_cursor%NOTFOUND OR manual_rbatch_cursor%NOTFOUND IS NULL;
779:
780: --IF (to_date(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD') < to_date(receipt_gl_date,'YYYY/MM/DD')) THEN
781: 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
782: CE_AUTO_BANK_REC.G_gl_date := receipt_gl_date;
783: END IF;
784:
785: --IF (to_date(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD') <

Line 782: CE_AUTO_BANK_REC.G_gl_date := receipt_gl_date;

778: EXIT WHEN manual_rbatch_cursor%NOTFOUND OR manual_rbatch_cursor%NOTFOUND IS NULL;
779:
780: --IF (to_date(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD') < to_date(receipt_gl_date,'YYYY/MM/DD')) THEN
781: 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
782: CE_AUTO_BANK_REC.G_gl_date := receipt_gl_date;
783: END IF;
784:
785: --IF (to_date(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD') <
786: --to_date(receipt_gl_date,'YYYY/MM/DD')) THEN

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

793: IF (amount_to_clear = trx_amount) THEN
794: ARP_CASHBOOK.clear(
795: p_cr_id => receipt_id,
796: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
797: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
798: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
799: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
800: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
801: p_exchange_rate => to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate),

Line 813: 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'));

809: -- bug 3911424 used the new xrate, xrate date, xrate type and xrate amount cleared
810: IF l_DEBUG in ('Y', 'C') THEN
811: cep_standard.debug('receipt_id = '|| receipt_id);
812: 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') );
813: 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'));
814: 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'));
815: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
816: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
817:

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

852:
853: ARP_CASHBOOK.clear(
854: p_cr_id => receipt_id,
855: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
856: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
857: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
858: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'), --trx_exchange_rate_date,
859: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type, --trx_exchange_rate_type,
860: p_exchange_rate => to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate), --amount_to_clear/trx_amount,

Line 873: 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'));

869: IF l_DEBUG in ('Y', 'C') THEN
870: cep_standard.debug('after call');
871: cep_standard.debug('receipt_id = '|| receipt_id);
872: 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'));
873: 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'));
874: 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'));
875: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
876: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
877:

Line 1226: CE_AUTO_BANK_REC.G_gl_date := X_gl_date;

1222: FETCH C_STATEMENT_LINE_SEQ INTO X_statement_line_id;
1223: CLOSE C_STATEMENT_LINE_SEQ;
1224: END IF;
1225: IF (X_passin_mode IN ('MANUAL_REC','MANUAL_NO_REC','MANUAL', 'MANUAL_H')) THEN
1226: CE_AUTO_BANK_REC.G_gl_date := X_gl_date;
1227: CE_AUTO_BANK_MATCH.csl_trx_date := X_trx_date;
1228: CE_AUTO_BANK_MATCH.csl_effective_date := X_value_date;
1229: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := X_exchange_rate_date;
1230: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := X_exchange_rate_type;

Line 1232: CE_AUTO_BANK_REC.G_payment_method_id := X_receipt_method_id;

1228: CE_AUTO_BANK_MATCH.csl_effective_date := X_value_date;
1229: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := X_exchange_rate_date;
1230: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := X_exchange_rate_type;
1231: CE_AUTO_BANK_MATCH.csl_exchange_rate := X_exchange_rate;
1232: CE_AUTO_BANK_REC.G_payment_method_id := X_receipt_method_id;
1233: CE_AUTO_BANK_MATCH.csh_bank_account_id := X_bank_account_id;
1234: CE_AUTO_BANK_REC.G_receivables_trx_id := X_activity_type_id;
1235: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
1236: CE_AUTO_BANK_MATCH.aba_bank_currency := X_clear_currency_code;

Line 1234: CE_AUTO_BANK_REC.G_receivables_trx_id := X_activity_type_id;

1230: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := X_exchange_rate_type;
1231: CE_AUTO_BANK_MATCH.csl_exchange_rate := X_exchange_rate;
1232: CE_AUTO_BANK_REC.G_payment_method_id := X_receipt_method_id;
1233: CE_AUTO_BANK_MATCH.csh_bank_account_id := X_bank_account_id;
1234: CE_AUTO_BANK_REC.G_receivables_trx_id := X_activity_type_id;
1235: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
1236: CE_AUTO_BANK_MATCH.aba_bank_currency := X_clear_currency_code;
1237: CE_AUTO_BANK_REC.G_set_of_books_id := X_set_of_books_id;
1238: CE_AUTO_BANK_REC.G_cr_vat_tax_code := X_cr_vat_tax_id;

Line 1237: CE_AUTO_BANK_REC.G_set_of_books_id := X_set_of_books_id;

1233: CE_AUTO_BANK_MATCH.csh_bank_account_id := X_bank_account_id;
1234: CE_AUTO_BANK_REC.G_receivables_trx_id := X_activity_type_id;
1235: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
1236: CE_AUTO_BANK_MATCH.aba_bank_currency := X_clear_currency_code;
1237: CE_AUTO_BANK_REC.G_set_of_books_id := X_set_of_books_id;
1238: CE_AUTO_BANK_REC.G_cr_vat_tax_code := X_cr_vat_tax_id;
1239: CE_AUTO_BANK_REC.G_dr_vat_tax_code := X_dr_vat_tax_id;
1240: temp := CE_AUTO_BANK_MATCH.validate_payment_method;
1241: --CE_AUTO_BANK_REC.G_org_id := X_org_id;

Line 1238: CE_AUTO_BANK_REC.G_cr_vat_tax_code := X_cr_vat_tax_id;

1234: CE_AUTO_BANK_REC.G_receivables_trx_id := X_activity_type_id;
1235: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
1236: CE_AUTO_BANK_MATCH.aba_bank_currency := X_clear_currency_code;
1237: CE_AUTO_BANK_REC.G_set_of_books_id := X_set_of_books_id;
1238: CE_AUTO_BANK_REC.G_cr_vat_tax_code := X_cr_vat_tax_id;
1239: CE_AUTO_BANK_REC.G_dr_vat_tax_code := X_dr_vat_tax_id;
1240: temp := CE_AUTO_BANK_MATCH.validate_payment_method;
1241: --CE_AUTO_BANK_REC.G_org_id := X_org_id;
1242: CE_AUTO_BANK_CLEAR.G_org_id := X_org_id;

Line 1239: CE_AUTO_BANK_REC.G_dr_vat_tax_code := X_dr_vat_tax_id;

1235: CE_AUTO_BANK_MATCH.csl_statement_line_id := X_statement_line_id;
1236: CE_AUTO_BANK_MATCH.aba_bank_currency := X_clear_currency_code;
1237: CE_AUTO_BANK_REC.G_set_of_books_id := X_set_of_books_id;
1238: CE_AUTO_BANK_REC.G_cr_vat_tax_code := X_cr_vat_tax_id;
1239: CE_AUTO_BANK_REC.G_dr_vat_tax_code := X_dr_vat_tax_id;
1240: temp := CE_AUTO_BANK_MATCH.validate_payment_method;
1241: --CE_AUTO_BANK_REC.G_org_id := X_org_id;
1242: CE_AUTO_BANK_CLEAR.G_org_id := X_org_id;
1243: END IF;

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

1237: CE_AUTO_BANK_REC.G_set_of_books_id := X_set_of_books_id;
1238: CE_AUTO_BANK_REC.G_cr_vat_tax_code := X_cr_vat_tax_id;
1239: CE_AUTO_BANK_REC.G_dr_vat_tax_code := X_dr_vat_tax_id;
1240: temp := CE_AUTO_BANK_MATCH.validate_payment_method;
1241: --CE_AUTO_BANK_REC.G_org_id := X_org_id;
1242: CE_AUTO_BANK_CLEAR.G_org_id := X_org_id;
1243: END IF;
1244: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
1245: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;

Line 1265: CE_AUTO_BANK_REC.G_payment_method_name),

1261: -- CE_AUTO_BANK_MATCH.get_vat_tax_id(l_vat_tax_id, l_tax_rate);
1262: l_valid_seq := CE_AUTO_BANK_IMPORT.get_sequence_info(
1263: 222,
1264: nvl(CE_AUTO_BANK_MATCH.csl_receipt_method_name,
1265: CE_AUTO_BANK_REC.G_payment_method_name),
1266: CE_AUTO_BANK_REC.G_set_of_books_id,
1267: 'A',
1268: CE_AUTO_BANK_MATCH.csl_trx_date,
1269: l_dbseqname,

Line 1266: CE_AUTO_BANK_REC.G_set_of_books_id,

1262: l_valid_seq := CE_AUTO_BANK_IMPORT.get_sequence_info(
1263: 222,
1264: nvl(CE_AUTO_BANK_MATCH.csl_receipt_method_name,
1265: CE_AUTO_BANK_REC.G_payment_method_name),
1266: CE_AUTO_BANK_REC.G_set_of_books_id,
1267: 'A',
1268: CE_AUTO_BANK_MATCH.csl_trx_date,
1269: l_dbseqname,
1270: l_doc_seq_id,

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

1416: IF (X_passin_mode NOT IN ('MANUAL_NO_REC','AUTO_TRX')) THEN
1417: IF (l_status not in ('CLEARED', 'RISK_ELIMINATED'))THEN
1418: ARP_CASHBOOK.clear(X_cr_id,
1419: to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1420: to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1421: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1422: to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1423: CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
1424: CE_AUTO_BANK_CLEAR.G_exchange_rate,

Line 1506: CE_AUTO_BANK_REC.G_gl_date := gl_date;

1502: CLOSE C_STATEMENT_LINE_SEQ;
1503: END IF;
1504: CE_AUTO_BANK_MATCH.csh_statement_header_id := X_statement_header_id;
1505: CE_AUTO_BANK_MATCH.csh_statement_date := statement_header_date;
1506: CE_AUTO_BANK_REC.G_gl_date := gl_date;
1507: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
1508: CE_AUTO_BANK_MATCH.csl_statement_line_id := statement_line_id;
1509: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
1510: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_rate_date;

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

1612: IF l_DEBUG in ('Y', 'C') THEN
1613: cep_standard.debug('reconcile_pbatch: ' || '>>>AP_RECONCILIATION_PKG.recon_payment_history'|| chr(10) ||
1614: 'X_CHECKRUN_ID: '||to_char(pbatch_id)|| chr(10) ||
1615: 'pgroup_id: '||to_char(pgroup_id)|| chr(10) ||
1616: 'X_ACCOUNTING_DATE: '||CE_AUTO_BANK_REC.G_gl_date|| chr(10) ||
1617: 'X_CLEARED_DATE: '||CE_AUTO_BANK_MATCH.csl_trx_date|| chr(10) ||
1618: 'X_TRANSACTION_AMOUNT: '||to_char(amount_to_clear)|| chr(10) ||
1619: 'X_ERROR_AMOUNT: '||to_char(errors_amount)|| chr(10) ||
1620: 'X_CHARGE_AMOUNT: '||to_char(charges_amount)|| chr(10) ||

Line 1631: 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')||

1627: END IF;
1628: */
1629: ------------------------------------------------------------------------------
1630: IF l_DEBUG in ('Y', 'C') THEN
1631: 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')||
1632: ', CE_AUTO_BANK_MATCH.csl_trx_date='||to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
1633:
1634: cep_standard.debug('amount_to_clear='||NVL(amount_to_clear,0)||', errors_amount='||NVL(errors_amount,0)||
1635: ', charges_amount='||NVL(charges_amount,0)||', X_bank_currency_code='||X_bank_currency_code);

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

1649:
1650: AP_RECONCILIATION_PKG.recon_payment_history(
1651: X_CHECKRUN_ID => pbatch_id,
1652: X_CHECK_ID => to_number(NULL),
1653: X_ACCOUNTING_DATE => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1654: X_CLEARED_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1655: X_TRANSACTION_AMOUNT => NVL(amount_to_clear,0),
1656: X_TRANSACTION_TYPE => 'PAYMENT CLEARING',
1657: X_ERROR_AMOUNT => NVL(errors_amount,0),

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

1682:
1683: cep_standard.debug('call IBY_CE_BATCH_RECON_PKG.Payment_Instruction_Clearing');
1684: IBY_CE_BATCH_RECON_PKG.Payment_Instruction_Clearing(
1685: P_PAYMENT_INSTRUCTION_ID => pbatch_id,
1686: P_ACCOUNTING_DATE => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1687: P_CLEARED_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1688: P_TRANSACTION_AMOUNT => NVL(amount_to_clear,0), -- in bank curr.
1689: P_ERROR_AMOUNT => NVL(errors_amount,0), -- in bank curr.
1690: P_CHARGE_AMOUNT => NVL(charges_amount,0), -- in bank curr.

Line 1813: CE_AUTO_BANK_REC.G_gl_date := gl_date;

1809: CE_AUTO_BANK_MATCH.csl_trx_type := tx_type;
1810: CE_AUTO_BANK_MATCH.csh_statement_header_id := X_statement_header_id;
1811: -- CE_AUTO_BANK_MATCH.csh_statement_date := X_statement_header_date;
1812: CE_AUTO_BANK_MATCH.aba_bank_currency := X_bank_currency;
1813: CE_AUTO_BANK_REC.G_gl_date := gl_date;
1814: CE_AUTO_BANK_MATCH.csl_effective_date := value_date;
1815: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
1816: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_date;
1817: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;

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

1887: END IF;
1888: ARP_CASHBOOK.clear(
1889: p_cr_id => to_number(ar_cash_receipt_id),
1890: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1891: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1892: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1893: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1894: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
1895: p_exchange_rate => CE_AUTO_BANK_CLEAR.G_exchange_rate,

Line 1899: p_module_name => 'CE_AUTO_BANK_REC',

1895: p_exchange_rate => CE_AUTO_BANK_CLEAR.G_exchange_rate,
1896: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
1897: p_amount_cleared => amount_cleared * clearing_sign,
1898: p_amount_factored => charges_amount,
1899: p_module_name => 'CE_AUTO_BANK_REC',
1900: p_module_version => '1.0',
1901: p_crh_id => cleared_trx_id );
1902: END IF;
1903: elsif (CE_AUTO_BANK_MATCH.trx_match_type = 'PAYMENT') then

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

1912: clearing_sign := 1;
1913: end if;
1914: if (passin_mode = 'AUTO') then
1915: if (CE_AUTO_BANK_MATCH.trx_gl_date is not null) then
1916: CE_AUTO_BANK_REC.G_gl_date := CE_AUTO_BANK_MATCH.trx_gl_date;
1917: end if;
1918: if (CE_AUTO_BANK_MATCH.trx_cleared_date is not null) then
1919: CE_AUTO_BANK_MATCH.csl_trx_date :=
1920: CE_AUTO_BANK_MATCH.trx_cleared_date;

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

1923:
1924: IF l_DEBUG in ('Y', 'C') THEN
1925: cep_standard.debug('reconcile_stmt: ' || '>>>AP_RECONCILIATION_PKG.recon_payment_history'||
1926: 'X_CHECK_ID: '||to_char(CE_AUTO_BANK_MATCH.trx_id)||
1927: 'X_ACCOUNTING_DATE: '||CE_AUTO_BANK_REC.G_gl_date);
1928: cep_standard.debug('X_CLEARED_DATE: '||CE_AUTO_BANK_MATCH.csl_trx_date||
1929: 'X_TRANSACTION_AMOUNT: '||to_char(amount_cleared*clearing_sign)||
1930: 'X_ERROR_AMOUNT: '||to_char(errors_amount)||
1931: 'X_CHARGE_AMOUNT: '||to_char(charges_amount));

Line 1946: X_ACCOUNTING_DATE => CE_AUTO_BANK_REC.G_gl_date,

1942:
1943: AP_RECONCILIATION_PKG.recon_payment_history(
1944: X_CHECKRUN_ID => to_number(NULL),
1945: X_CHECK_ID => CE_AUTO_BANK_MATCH.trx_id,
1946: X_ACCOUNTING_DATE => CE_AUTO_BANK_REC.G_gl_date,
1947: X_CLEARED_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1948: X_TRANSACTION_AMOUNT => NVL(amount_cleared,0) * clearing_sign,
1949: X_TRANSACTION_TYPE => 'PAYMENT CLEARING',
1950: X_ERROR_AMOUNT => NVL(errors_amount,0),

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

2206: ', CE_AUTO_BANK_CLEAR1.csl_reconcile_flag = '||CE_AUTO_BANK_MATCH.csl_reconcile_flag);
2207: END IF;
2208:
2209: IF (X_org_id is not null or X_legal_entity_id is not null) THEN
2210: --CE_AUTO_BANK_REC.G_org_id := X_org_id;
2211: --CE_AUTO_BANK_REC.G_legal_entity_id := X_legal_entity_id;
2212: CE_AUTO_BANK_CLEAR.G_org_id := X_org_id;
2213: CE_AUTO_BANK_CLEAR.G_legal_entity_id := X_legal_entity_id;
2214: END IF;

Line 2211: --CE_AUTO_BANK_REC.G_legal_entity_id := X_legal_entity_id;

2207: END IF;
2208:
2209: IF (X_org_id is not null or X_legal_entity_id is not null) THEN
2210: --CE_AUTO_BANK_REC.G_org_id := X_org_id;
2211: --CE_AUTO_BANK_REC.G_legal_entity_id := X_legal_entity_id;
2212: CE_AUTO_BANK_CLEAR.G_org_id := X_org_id;
2213: CE_AUTO_BANK_CLEAR.G_legal_entity_id := X_legal_entity_id;
2214: END IF;
2215:

Line 2216: --fnd_message.debug('CE_AUTO_BANK_REC.G_org_id = '||CE_AUTO_BANK_REC.G_org_id);

2212: CE_AUTO_BANK_CLEAR.G_org_id := X_org_id;
2213: CE_AUTO_BANK_CLEAR.G_legal_entity_id := X_legal_entity_id;
2214: END IF;
2215:
2216: --fnd_message.debug('CE_AUTO_BANK_REC.G_org_id = '||CE_AUTO_BANK_REC.G_org_id);
2217:
2218: IF (passin_mode <> 'MANUAL_C') THEN
2219: clearing_flag := 'Y';
2220: CE_AUTO_BANK_CLEAR1.validate_effective_date( passin_mode,

Line 2234: CE_AUTO_BANK_REC.G_gl_date := gl_date;

2230: CE_AUTO_BANK_MATCH.csl_trx_type := tx_type;
2231: CE_AUTO_BANK_MATCH.csh_statement_header_id := X_statement_header_id;
2232: CE_AUTO_BANK_MATCH.csh_statement_date := X_statement_header_date;
2233: CE_AUTO_BANK_MATCH.aba_bank_currency := X_bank_currency;
2234: CE_AUTO_BANK_REC.G_gl_date := gl_date;
2235: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := exchange_rate_type;
2236: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := exchange_date;
2237: CE_AUTO_BANK_MATCH.csl_exchange_rate := exchange_rate;
2238: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;

Line 2281: X_status => nvl(CE_AUTO_BANK_REC.G_open_interface_clear_status,

2277: IF (CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'OI') THEN
2278: CE_999_PKG.clear(
2279: X_trx_id => CE_AUTO_BANK_MATCH.trx_id,
2280: X_trx_type => CE_AUTO_BANK_MATCH.csl_match_type,
2281: X_status => nvl(CE_AUTO_BANK_REC.G_open_interface_clear_status,
2282: CE_AUTO_BANK_MATCH.trx_status),
2283: X_trx_number => CE_AUTO_BANK_MATCH.csl_bank_trx_number,
2284: X_trx_date => CE_AUTO_BANK_MATCH.csl_trx_date,
2285: X_trx_currency => CE_AUTO_BANK_MATCH.csl_currency_code,

Line 2286: X_gl_date => CE_AUTO_BANK_REC.G_gl_date,

2282: CE_AUTO_BANK_MATCH.trx_status),
2283: X_trx_number => CE_AUTO_BANK_MATCH.csl_bank_trx_number,
2284: X_trx_date => CE_AUTO_BANK_MATCH.csl_trx_date,
2285: X_trx_currency => CE_AUTO_BANK_MATCH.csl_currency_code,
2286: X_gl_date => CE_AUTO_BANK_REC.G_gl_date,
2287: X_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
2288: X_cleared_amount => NVL(amount_cleared,0),
2289: X_cleared_date => CE_AUTO_BANK_MATCH.csl_trx_date,
2290: X_charges_amount => charges_amount,

Line 2316: X_ACCOUNTING_DATE => CE_AUTO_BANK_REC.G_gl_date,

2312: CE_CASHFLOW_PKG.CLEAR_CASHFLOW(
2313: X_CASHFLOW_ID => CE_AUTO_BANK_MATCH.trx_id,
2314: X_TRX_STATUS => CE_AUTO_BANK_MATCH.trx_status,
2315: x_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2316: X_ACCOUNTING_DATE => CE_AUTO_BANK_REC.G_gl_date,
2317: X_CLEARED_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2318: X_CLEARED_AMOUNT => NVL(amount_cleared,0),
2319: X_CLEARED_ERROR_AMOUNT => NVL(errors_amount,0),
2320: X_CLEARED_CHARGE_AMOUNT => NVL(charges_amount,0),

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

2386: ELSIF( trx_status NOT IN ( 'STOP INITIATED', 'VOIDED' )) THEN
2387: if (passin_mode = 'AUTO') then
2388: /* bug 2260411
2389: if (CE_AUTO_BANK_MATCH.trx_gl_date is not null) then
2390: CE_AUTO_BANK_REC.G_gl_date := CE_AUTO_BANK_MATCH.trx_gl_date;
2391: end if;
2392: */
2393: if (CE_AUTO_BANK_MATCH.trx_cleared_date is not null) then
2394: CE_AUTO_BANK_MATCH.csl_trx_date :=

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

2397: end if;
2398:
2399: IF l_DEBUG in ('Y', 'C') THEN
2400: cep_standard.debug('X_CHECK_ID: '||to_char(CE_AUTO_BANK_MATCH.trx_id)||
2401: ' X_ACCOUNTING_DATE: '||CE_AUTO_BANK_REC.G_gl_date);
2402: cep_standard.debug('X_CLEARED_DATE: '||CE_AUTO_BANK_MATCH.csl_trx_date||
2403: ' X_TRANSACTION_AMOUNT: '||to_char(amount_cleared));
2404: cep_standard.debug('X_ERROR_AMOUNT: '||to_char(errors_amount)||
2405: ' X_CHARGE_AMOUNT: '||to_char(charges_amount));

Line 2417: X_ACCOUNTING_DATE => CE_AUTO_BANK_REC.G_gl_date,

2413:
2414: AP_RECONCILIATION_PKG.recon_payment_history(
2415: X_CHECKRUN_ID => to_number(NULL),
2416: X_CHECK_ID => to_number(CE_AUTO_BANK_MATCH.trx_id),
2417: X_ACCOUNTING_DATE => CE_AUTO_BANK_REC.G_gl_date,
2418: X_CLEARED_DATE => CE_AUTO_BANK_MATCH.csl_trx_date,
2419: X_TRANSACTION_AMOUNT => NVL(amount_cleared,0),
2420: X_TRANSACTION_TYPE => 'PAYMENT CLEARING',
2421: X_ERROR_AMOUNT => NVL(errors_amount,0),

Line 2456: CE_AUTO_BANK_REC.G_nsf_handling = 'REVERSE' AND

2452: RAISE APP_EXCEPTION.application_exception;
2453: ELSE
2454: IF (passin_mode = 'AUTO' AND
2455: CE_AUTO_BANK_MATCH.csl_trx_type IN ('NSF','REJECTED') AND
2456: CE_AUTO_BANK_REC.G_nsf_handling = 'REVERSE' AND
2457: CE_AUTO_BANK_MATCH.trx_status <> 'REVERSED') THEN
2458: ARP_CASHBOOK.reverse(
2459: p_cr_id => ar_cash_receipt_id,
2460: p_reversal_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

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

2456: CE_AUTO_BANK_REC.G_nsf_handling = 'REVERSE' AND
2457: CE_AUTO_BANK_MATCH.trx_status <> 'REVERSED') THEN
2458: ARP_CASHBOOK.reverse(
2459: p_cr_id => ar_cash_receipt_id,
2460: p_reversal_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2461: p_reversal_date => sysdate,
2462: p_reversal_comments => NULL,
2463: p_reversal_reason_code => NULL,
2464: p_reversal_category => NULL,

Line 2465: p_module_name => 'CE_AUTO_BANK_REC',

2461: p_reversal_date => sysdate,
2462: p_reversal_comments => NULL,
2463: p_reversal_reason_code => NULL,
2464: p_reversal_category => NULL,
2465: p_module_name => 'CE_AUTO_BANK_REC',
2466: p_module_version => '1.0',
2467: p_crh_id => cleared_trx_id);
2468: cleared_trx_type := CE_AUTO_BANK_MATCH.csl_match_type;
2469: ELSIF (passin_mode = 'AUTO' AND

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

2467: p_crh_id => cleared_trx_id);
2468: cleared_trx_type := CE_AUTO_BANK_MATCH.csl_match_type;
2469: ELSIF (passin_mode = 'AUTO' AND
2470: CE_AUTO_BANK_MATCH.csl_trx_type IN ('NSF','REJECTED') AND
2471: CE_AUTO_BANK_REC.G_nsf_handling = 'DM REVERSE' AND
2472: CE_AUTO_BANK_MATCH.trx_status <> 'REVERSED') THEN
2473:
2474: IF (CE_AUTO_BANK_MATCH.csl_match_type = 'CASH' AND
2475: CE_AUTO_BANK_MATCH.trx_customer_id is not null) THEN

Line 2501: CE_AUTO_BANK_REC.G_set_of_books_id,

2497:
2498: l_valid_seq := CE_AUTO_BANK_IMPORT.get_sequence_info(
2499: 222,
2500: cust_trx_type,
2501: CE_AUTO_BANK_REC.G_set_of_books_id,
2502: 'A',
2503: CE_AUTO_BANK_MATCH.csl_trx_date,
2504: l_dbseqname,
2505: l_doc_seq_id,

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

2511: p_cc_id => cc_id,
2512: p_dm_cust_trx_type_id => cust_trx_type_id,
2513: p_dm_cust_trx_type => cust_trx_type,
2514: p_reversal_gl_date =>
2515: to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2516: p_reversal_date =>
2517: to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2518: p_reversal_category => 'NSF',
2519: p_reversal_reason_code => 'NSF',

Line 2525: p_module_name => 'CE_AUTO_BANK_REC',

2521: p_dm_number => out_trx_number,
2522: p_dm_doc_sequence_value => l_doc_seq_value,
2523: p_dm_doc_sequence_id => l_doc_seq_id,
2524: p_tw_status => out_status,
2525: p_module_name => 'CE_AUTO_BANK_REC',
2526: p_module_version => '1.0');
2527:
2528: if (out_status = 'OK') then
2529: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;

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

2577: ELSE
2578: IF l_DEBUG in ('Y', 'C') THEN
2579: cep_standard.debug('reconcile_trx: ' || ' ar_cash_receipt_id= '|| ar_cash_receipt_id ||
2580: ' CE_AUTO_BANK_MATCH.csl_trx_date = '|| CE_AUTO_BANK_MATCH.csl_trx_date ||
2581: ' CE_AUTO_BANK_REC.G_gl_date= '|| CE_AUTO_BANK_REC.G_gl_date);
2582: cep_standard.debug(' CE_AUTO_BANK_MATCH.csl_effective_date= '|| CE_AUTO_BANK_MATCH.csl_effective_date ||
2583: ' CE_AUTO_BANK_CLEAR.G_exchange_date= '|| CE_AUTO_BANK_CLEAR.G_exchange_date ||
2584: ' CE_AUTO_BANK_CLEAR.G_exchange_rate_type= '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
2585: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate= '|| CE_AUTO_BANK_CLEAR.G_exchange_rate ||

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

2592:
2593: ARP_CASHBOOK.clear(
2594: p_cr_id => to_number(ar_cash_receipt_id),
2595: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2596: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2597: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2598: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2599: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
2600: p_exchange_rate => CE_AUTO_BANK_CLEAR.G_exchange_rate,

Line 2604: p_module_name => 'CE_AUTO_BANK_REC',

2600: p_exchange_rate => CE_AUTO_BANK_CLEAR.G_exchange_rate,
2601: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
2602: p_amount_cleared => amount_cleared,
2603: p_amount_factored => charges_amount,
2604: p_module_name => 'CE_AUTO_BANK_REC',
2605: p_module_version => '1.0',
2606: p_crh_id => cleared_trx_id );
2607: cep_standard.debug('end call ARP_CASHBOOK.clear ');
2608: END IF;

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

2699: cep_standard.debug('X_EXCHANGE_RATE: '||to_char(xrate)||
2700: ', X_ACTUAL_VALUE_DATE: '||fnd_date.date_to_charDT(value_date));
2701: END IF;
2702:
2703: --CE_AUTO_BANK_REC.G_org_id := org_id;
2704: --CE_AUTO_BANK_REC.G_legal_entity_id := legal_entity_id;
2705: CE_AUTO_BANK_CLEAR.G_org_id := org_id;
2706: CE_AUTO_BANK_CLEAR.G_legal_entity_id := legal_entity_id;
2707:

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

2700: ', X_ACTUAL_VALUE_DATE: '||fnd_date.date_to_charDT(value_date));
2701: END IF;
2702:
2703: --CE_AUTO_BANK_REC.G_org_id := org_id;
2704: --CE_AUTO_BANK_REC.G_legal_entity_id := legal_entity_id;
2705: CE_AUTO_BANK_CLEAR.G_org_id := org_id;
2706: CE_AUTO_BANK_CLEAR.G_legal_entity_id := legal_entity_id;
2707:
2708: IF (org_id is not null) THEN

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

2806: END IF;
2807: ELSIF (clearing_trx_type = 'ROI_LINE' ) THEN
2808: CE_999_PKG.unclear( X_trx_id => trx_id,
2809: X_trx_type => tx_type,
2810: X_status => nvl(CE_AUTO_BANK_REC.G_open_interface_float_status, status),
2811: X_trx_date => trx_date,
2812: X_gl_date => gl_date);
2813: -- after unreconcile, update the reconciled_status of this trx in the GT table to 'N'
2814: CE_AUTO_BANK_MATCH.update_gt_reconciled_status(999, trx_id, 'N');