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.AR_AUTOREM_API dependencies on AR_CASH_RECEIPTS

Line 13: pg_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;

9:
10: G_ERROR varchar2(1) := 'N';
11: TOTAL_WORKERS NUMBER := 0;
12: WORKER_NUMBER NUMBER := 0;
13: pg_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;
14: pg_format_flag ar_cash_receipts.confirmed_flag%TYPE ;
15: pg_create_flag ar_cash_receipts.confirmed_flag%TYPE ;
16:
17: pg_execution_from varchar2(20) := 'MANUAL';

Line 14: pg_format_flag ar_cash_receipts.confirmed_flag%TYPE ;

10: G_ERROR varchar2(1) := 'N';
11: TOTAL_WORKERS NUMBER := 0;
12: WORKER_NUMBER NUMBER := 0;
13: pg_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;
14: pg_format_flag ar_cash_receipts.confirmed_flag%TYPE ;
15: pg_create_flag ar_cash_receipts.confirmed_flag%TYPE ;
16:
17: pg_execution_from varchar2(20) := 'MANUAL';
18:

Line 15: pg_create_flag ar_cash_receipts.confirmed_flag%TYPE ;

11: TOTAL_WORKERS NUMBER := 0;
12: WORKER_NUMBER NUMBER := 0;
13: pg_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;
14: pg_format_flag ar_cash_receipts.confirmed_flag%TYPE ;
15: pg_create_flag ar_cash_receipts.confirmed_flag%TYPE ;
16:
17: pg_execution_from varchar2(20) := 'MANUAL';
18:
19:

Line 94: l_request_id ar_cash_receipts.request_id%TYPE;

90: p_worker_number IN NUMBER DEFAULT 0,
91: p_total_workers IN NUMBER DEFAULT 0
92: ) IS
93:
94: l_request_id ar_cash_receipts.request_id%TYPE;
95: l_batch_date ar_cash_receipts.receipt_date%TYPE ;
96: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
97: l_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;
98: l_format_flag ar_cash_receipts.confirmed_flag%TYPE ;

Line 95: l_batch_date ar_cash_receipts.receipt_date%TYPE ;

91: p_total_workers IN NUMBER DEFAULT 0
92: ) IS
93:
94: l_request_id ar_cash_receipts.request_id%TYPE;
95: l_batch_date ar_cash_receipts.receipt_date%TYPE ;
96: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
97: l_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;
98: l_format_flag ar_cash_receipts.confirmed_flag%TYPE ;
99: l_create_flag ar_cash_receipts.confirmed_flag%TYPE ;

Line 97: l_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;

93:
94: l_request_id ar_cash_receipts.request_id%TYPE;
95: l_batch_date ar_cash_receipts.receipt_date%TYPE ;
96: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
97: l_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;
98: l_format_flag ar_cash_receipts.confirmed_flag%TYPE ;
99: l_create_flag ar_cash_receipts.confirmed_flag%TYPE ;
100: l_currency_code ar_cash_receipts.currency_code%TYPE;
101: l_remittance_method ar_receipt_classes.remit_method_code%TYPE;

Line 98: l_format_flag ar_cash_receipts.confirmed_flag%TYPE ;

94: l_request_id ar_cash_receipts.request_id%TYPE;
95: l_batch_date ar_cash_receipts.receipt_date%TYPE ;
96: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
97: l_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;
98: l_format_flag ar_cash_receipts.confirmed_flag%TYPE ;
99: l_create_flag ar_cash_receipts.confirmed_flag%TYPE ;
100: l_currency_code ar_cash_receipts.currency_code%TYPE;
101: l_remittance_method ar_receipt_classes.remit_method_code%TYPE;
102: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;

Line 99: l_create_flag ar_cash_receipts.confirmed_flag%TYPE ;

95: l_batch_date ar_cash_receipts.receipt_date%TYPE ;
96: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
97: l_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;
98: l_format_flag ar_cash_receipts.confirmed_flag%TYPE ;
99: l_create_flag ar_cash_receipts.confirmed_flag%TYPE ;
100: l_currency_code ar_cash_receipts.currency_code%TYPE;
101: l_remittance_method ar_receipt_classes.remit_method_code%TYPE;
102: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;
103: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;

Line 100: l_currency_code ar_cash_receipts.currency_code%TYPE;

96: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
97: l_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;
98: l_format_flag ar_cash_receipts.confirmed_flag%TYPE ;
99: l_create_flag ar_cash_receipts.confirmed_flag%TYPE ;
100: l_currency_code ar_cash_receipts.currency_code%TYPE;
101: l_remittance_method ar_receipt_classes.remit_method_code%TYPE;
102: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;
103: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;
104: l_remittance_bank_branch_id ap_bank_accounts.bank_branch_id%TYPE DEFAULT NULL;

Line 103: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;

99: l_create_flag ar_cash_receipts.confirmed_flag%TYPE ;
100: l_currency_code ar_cash_receipts.currency_code%TYPE;
101: l_remittance_method ar_receipt_classes.remit_method_code%TYPE;
102: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;
103: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;
104: l_remittance_bank_branch_id ap_bank_accounts.bank_branch_id%TYPE DEFAULT NULL;
105: l_remittance_bank_account_id ar_receipt_method_accounts.REMIT_BANK_ACCT_USE_ID%TYPE DEFAULT NULL;
106: o_batch_id NUMBER;
107:

Line 282: from AR_CASH_RECEIPTS

278: ELSE
279: BEGIN
280: select count(*)
281: INTO l_count
282: from AR_CASH_RECEIPTS
283: where selected_remittance_batch_id = p_batch_id;
284:
285: EXCEPTION
286: when no_data_found THEN

Line 727: update ar_cash_receipts

723: control_check ( p_batch_id =>o_batch_id);
724:
725: fnd_file.put_line(FND_FILE.LOG,'reset selected_remittance_batch_id for all receipts after approval');
726:
727: update ar_cash_receipts
728: set selected_remittance_batch_id = null
729: where selected_remittance_batch_id = o_batch_id
730: and cash_receipt_id in (select cash_receipt_id from
731: ar_cash_receipt_history

Line 768: FROM ar_cash_receipts cr

764: nvl(sum(cr.amount),0),
765: count(*) into
766: l_control_amount,
767: l_control_count
768: FROM ar_cash_receipts cr
769: WHERE cr.selected_remittance_batch_id = o_batch_id;
770:
771: update ar_batches
772: SET batch_applied_status = l_batch_applied_status,

Line 983: l_request_id ar_cash_receipts.request_id%TYPE;

979:
980: l_worker_number NUMBER ;
981: l_complete BOOLEAN := FALSE;
982: l_count NUMBER;
983: l_request_id ar_cash_receipts.request_id%TYPE;
984: l_batch_date ar_cash_receipts.receipt_date%TYPE ;
985: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
986: l_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;
987: l_format_flag ar_cash_receipts.confirmed_flag%TYPE ;

Line 984: l_batch_date ar_cash_receipts.receipt_date%TYPE ;

980: l_worker_number NUMBER ;
981: l_complete BOOLEAN := FALSE;
982: l_count NUMBER;
983: l_request_id ar_cash_receipts.request_id%TYPE;
984: l_batch_date ar_cash_receipts.receipt_date%TYPE ;
985: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
986: l_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;
987: l_format_flag ar_cash_receipts.confirmed_flag%TYPE ;
988: l_create_flag ar_cash_receipts.confirmed_flag%TYPE ;

Line 986: l_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;

982: l_count NUMBER;
983: l_request_id ar_cash_receipts.request_id%TYPE;
984: l_batch_date ar_cash_receipts.receipt_date%TYPE ;
985: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
986: l_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;
987: l_format_flag ar_cash_receipts.confirmed_flag%TYPE ;
988: l_create_flag ar_cash_receipts.confirmed_flag%TYPE ;
989: l_currency_code ar_cash_receipts.currency_code%TYPE;
990: l_remittance_method ar_receipt_classes.remit_method_code%TYPE;

Line 987: l_format_flag ar_cash_receipts.confirmed_flag%TYPE ;

983: l_request_id ar_cash_receipts.request_id%TYPE;
984: l_batch_date ar_cash_receipts.receipt_date%TYPE ;
985: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
986: l_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;
987: l_format_flag ar_cash_receipts.confirmed_flag%TYPE ;
988: l_create_flag ar_cash_receipts.confirmed_flag%TYPE ;
989: l_currency_code ar_cash_receipts.currency_code%TYPE;
990: l_remittance_method ar_receipt_classes.remit_method_code%TYPE;
991: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;

Line 988: l_create_flag ar_cash_receipts.confirmed_flag%TYPE ;

984: l_batch_date ar_cash_receipts.receipt_date%TYPE ;
985: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
986: l_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;
987: l_format_flag ar_cash_receipts.confirmed_flag%TYPE ;
988: l_create_flag ar_cash_receipts.confirmed_flag%TYPE ;
989: l_currency_code ar_cash_receipts.currency_code%TYPE;
990: l_remittance_method ar_receipt_classes.remit_method_code%TYPE;
991: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;
992: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;

Line 989: l_currency_code ar_cash_receipts.currency_code%TYPE;

985: l_gl_date ar_cash_receipt_history.gl_date%TYPE;
986: l_approve_flag ar_cash_receipts.confirmed_flag%TYPE ;
987: l_format_flag ar_cash_receipts.confirmed_flag%TYPE ;
988: l_create_flag ar_cash_receipts.confirmed_flag%TYPE ;
989: l_currency_code ar_cash_receipts.currency_code%TYPE;
990: l_remittance_method ar_receipt_classes.remit_method_code%TYPE;
991: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;
992: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;
993: l_remittance_bank_branch_id ap_bank_accounts.bank_branch_id%TYPE DEFAULT NULL;

Line 992: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;

988: l_create_flag ar_cash_receipts.confirmed_flag%TYPE ;
989: l_currency_code ar_cash_receipts.currency_code%TYPE;
990: l_remittance_method ar_receipt_classes.remit_method_code%TYPE;
991: l_receipt_class_id ar_receipt_classes.receipt_class_id%TYPE ;
992: l_receipt_method_id ar_cash_receipts.receipt_method_id%TYPE ;
993: l_remittance_bank_branch_id ap_bank_accounts.bank_branch_id%TYPE DEFAULT NULL;
994: l_remittance_bank_account_id ar_receipt_method_accounts.REMIT_BANK_ACCT_USE_ID%TYPE DEFAULT NULL;
995: l_batch_applied_status ar_batches.batch_applied_status%TYPE;
996: l_return_status VARCHAR2(1);

Line 1236: from AR_CASH_RECEIPTS

1232: BEGIN
1233: l_count := 0;
1234: select count(*)
1235: INTO l_count
1236: from AR_CASH_RECEIPTS
1237: where selected_remittance_batch_id = o_batch_id;
1238: EXCEPTION
1239: when no_data_found THEN
1240: l_count :=0;

Line 1288: /+ leading(gtt,crh) cardinality(gtt 1000) swap_join_inputs(bat) use_hash(bat) parallel(gtt) parallel(crh) use_nl(crh,cr,hca,party,ps,d) index(cr AR_CASH_RECEIPTS_U1) /';

1284: ) ';
1285: IF PG_PARALLEL IN ('Y', 'C') THEN
1286: l_ins_stmt := l_ins_stmt ||
1287: 'SELECT
1288: /*+ leading(gtt,crh) cardinality(gtt 1000) swap_join_inputs(bat) use_hash(bat) parallel(gtt) parallel(crh) use_nl(crh,cr,hca,party,ps,d) index(cr AR_CASH_RECEIPTS_U1) */';
1289: ELSE
1290: l_ins_stmt := l_ins_stmt ||
1291: 'SELECT
1292: /*+ leading(gtt,crh) cardinality(gtt 1000) swap_join_inputs(bat) use_hash(bat) use_nl(crh,cr,hca,party,ps,d) */';

Line 1331: ar_cash_receipts cr,

1327: --MOD(cr.cash_receipt_id, p_total_workers) + 1
1328: --MOD(CEIL(cr.cash_receipt_id/10000), p_total_workers) + 1
1329: MOD(CEIL((DENSE_RANK() over(order by crh.cash_receipt_id))/5000), :b_total_workers) + 1
1330: FROM ar_rem_cr_id_gtt gtt,
1331: ar_cash_receipts cr,
1332: ar_receipt_methods rm,
1333: ar_receipt_classes rc,
1334: hz_cust_accounts hca,
1335: hz_parties party,

Line 1423: FROM ar_cash_receipts cr

1419: nvl(sum(cr.amount),0),
1420: count(*) into
1421: l_control_amount,
1422: l_control_count
1423: FROM ar_cash_receipts cr
1424: WHERE cr.selected_remittance_batch_id = o_batch_id;
1425:
1426: UPDATE ar_batches
1427: SET batch_applied_status = l_batch_applied_status,

Line 1502: p_batch_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,

1498: | 16-JUL-2005 bichatte Created |
1499: *=========================================================================*/
1500:
1501: PROCEDURE insert_batch(
1502: p_batch_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
1503: p_batch_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
1504: p_approve_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
1505: p_format_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
1506: p_currency_code IN ar_batches.currency_code%TYPE,

Line 1504: p_approve_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,

1500:
1501: PROCEDURE insert_batch(
1502: p_batch_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
1503: p_batch_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
1504: p_approve_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
1505: p_format_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
1506: p_currency_code IN ar_batches.currency_code%TYPE,
1507: p_remmitance_method IN ar_batches.remit_method_code%TYPE,
1508: p_receipt_class_id IN ar_receipt_classes.receipt_class_id%TYPE,

Line 1505: p_format_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,

1501: PROCEDURE insert_batch(
1502: p_batch_date IN ar_cash_receipts.receipt_date%TYPE DEFAULT NULL,
1503: p_batch_gl_date IN ar_cash_receipt_history.gl_date%TYPE DEFAULT NULL,
1504: p_approve_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
1505: p_format_flag IN ar_cash_receipts.override_remit_account_flag%TYPE DEFAULT NULL,
1506: p_currency_code IN ar_batches.currency_code%TYPE,
1507: p_remmitance_method IN ar_batches.remit_method_code%TYPE,
1508: p_receipt_class_id IN ar_receipt_classes.receipt_class_id%TYPE,
1509: p_payment_method_id IN ar_receipt_methods.receipt_method_id%TYPE,

Line 1813: p_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;

1809: l_sel_stmt long;
1810: sel_receipts INTEGER;
1811: /* declare the cursor variables */
1812:
1813: p_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
1814: p_payment_type_code ar_receipt_methods.payment_type_code%TYPE;
1815: p_merchant_ref ar_receipt_methods.merchant_ref%TYPE;
1816: p_currency_code ar_cash_receipts.currency_code%TYPE;
1817: p_pay_from_customer ar_cash_receipts.pay_from_customer%TYPE;

Line 1816: p_currency_code ar_cash_receipts.currency_code%TYPE;

1812:
1813: p_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
1814: p_payment_type_code ar_receipt_methods.payment_type_code%TYPE;
1815: p_merchant_ref ar_receipt_methods.merchant_ref%TYPE;
1816: p_currency_code ar_cash_receipts.currency_code%TYPE;
1817: p_pay_from_customer ar_cash_receipts.pay_from_customer%TYPE;
1818: p_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
1819: p_prv_cash_receipt_hist_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1820: p_exchange_date ar_cash_receipt_history.exchange_date%TYPE;

Line 1817: p_pay_from_customer ar_cash_receipts.pay_from_customer%TYPE;

1813: p_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
1814: p_payment_type_code ar_receipt_methods.payment_type_code%TYPE;
1815: p_merchant_ref ar_receipt_methods.merchant_ref%TYPE;
1816: p_currency_code ar_cash_receipts.currency_code%TYPE;
1817: p_pay_from_customer ar_cash_receipts.pay_from_customer%TYPE;
1818: p_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
1819: p_prv_cash_receipt_hist_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1820: p_exchange_date ar_cash_receipt_history.exchange_date%TYPE;
1821: p_exchange_rate ar_cash_receipt_history.exchange_rate%TYPE;

Line 1818: p_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;

1814: p_payment_type_code ar_receipt_methods.payment_type_code%TYPE;
1815: p_merchant_ref ar_receipt_methods.merchant_ref%TYPE;
1816: p_currency_code ar_cash_receipts.currency_code%TYPE;
1817: p_pay_from_customer ar_cash_receipts.pay_from_customer%TYPE;
1818: p_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
1819: p_prv_cash_receipt_hist_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1820: p_exchange_date ar_cash_receipt_history.exchange_date%TYPE;
1821: p_exchange_rate ar_cash_receipt_history.exchange_rate%TYPE;
1822: p_exchange_type ar_cash_receipt_history.exchange_rate_type%TYPE;

Line 1823: p_cr_amount ar_cash_receipts.amount%TYPE;

1819: p_prv_cash_receipt_hist_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1820: p_exchange_date ar_cash_receipt_history.exchange_date%TYPE;
1821: p_exchange_rate ar_cash_receipt_history.exchange_rate%TYPE;
1822: p_exchange_type ar_cash_receipt_history.exchange_rate_type%TYPE;
1823: p_cr_amount ar_cash_receipts.amount%TYPE;
1824: p_cr_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;
1825: p_cr_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
1826: p_remmitance_ccid ar_receipt_method_accounts.remittance_ccid%TYPE;
1827: p_bank_charges_ccid ar_receipt_method_accounts.bank_charges_ccid%TYPE;

Line 1825: p_cr_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;

1821: p_exchange_rate ar_cash_receipt_history.exchange_rate%TYPE;
1822: p_exchange_type ar_cash_receipt_history.exchange_rate_type%TYPE;
1823: p_cr_amount ar_cash_receipts.amount%TYPE;
1824: p_cr_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;
1825: p_cr_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
1826: p_remmitance_ccid ar_receipt_method_accounts.remittance_ccid%TYPE;
1827: p_bank_charges_ccid ar_receipt_method_accounts.bank_charges_ccid%TYPE;
1828: p_code_combination_id ar_distributions.code_combination_id%TYPE;
1829: p_cash_receipt_history_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;

Line 1832: p_payment_server_order_num ar_cash_receipts.payment_server_order_num%TYPE;

1828: p_code_combination_id ar_distributions.code_combination_id%TYPE;
1829: p_cash_receipt_history_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1830: p_crh_gl_date ar_cash_receipt_history.gl_date%TYPE;
1831: p_crh_trx_date ar_cash_receipt_history.trx_date%TYPE;
1832: p_payment_server_order_num ar_cash_receipts.payment_server_order_num%TYPE;
1833: p_approval_code ar_cash_receipts.approval_code%TYPE;
1834: p_receipt_number ar_cash_receipts.receipt_number%TYPE;
1835: p_unique_ref ar_cash_receipts.unique_reference%TYPE;
1836: p_customer_bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE;

Line 1833: p_approval_code ar_cash_receipts.approval_code%TYPE;

1829: p_cash_receipt_history_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1830: p_crh_gl_date ar_cash_receipt_history.gl_date%TYPE;
1831: p_crh_trx_date ar_cash_receipt_history.trx_date%TYPE;
1832: p_payment_server_order_num ar_cash_receipts.payment_server_order_num%TYPE;
1833: p_approval_code ar_cash_receipts.approval_code%TYPE;
1834: p_receipt_number ar_cash_receipts.receipt_number%TYPE;
1835: p_unique_ref ar_cash_receipts.unique_reference%TYPE;
1836: p_customer_bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE;
1837: p_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;

Line 1834: p_receipt_number ar_cash_receipts.receipt_number%TYPE;

1830: p_crh_gl_date ar_cash_receipt_history.gl_date%TYPE;
1831: p_crh_trx_date ar_cash_receipt_history.trx_date%TYPE;
1832: p_payment_server_order_num ar_cash_receipts.payment_server_order_num%TYPE;
1833: p_approval_code ar_cash_receipts.approval_code%TYPE;
1834: p_receipt_number ar_cash_receipts.receipt_number%TYPE;
1835: p_unique_ref ar_cash_receipts.unique_reference%TYPE;
1836: p_customer_bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE;
1837: p_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;
1838:

Line 1835: p_unique_ref ar_cash_receipts.unique_reference%TYPE;

1831: p_crh_trx_date ar_cash_receipt_history.trx_date%TYPE;
1832: p_payment_server_order_num ar_cash_receipts.payment_server_order_num%TYPE;
1833: p_approval_code ar_cash_receipts.approval_code%TYPE;
1834: p_receipt_number ar_cash_receipts.receipt_number%TYPE;
1835: p_unique_ref ar_cash_receipts.unique_reference%TYPE;
1836: p_customer_bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE;
1837: p_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;
1838:
1839: /* end declare */

Line 1836: p_customer_bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE;

1832: p_payment_server_order_num ar_cash_receipts.payment_server_order_num%TYPE;
1833: p_approval_code ar_cash_receipts.approval_code%TYPE;
1834: p_receipt_number ar_cash_receipts.receipt_number%TYPE;
1835: p_unique_ref ar_cash_receipts.unique_reference%TYPE;
1836: p_customer_bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE;
1837: p_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;
1838:
1839: /* end declare */
1840:

Line 1837: p_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;

1833: p_approval_code ar_cash_receipts.approval_code%TYPE;
1834: p_receipt_number ar_cash_receipts.receipt_number%TYPE;
1835: p_unique_ref ar_cash_receipts.unique_reference%TYPE;
1836: p_customer_bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE;
1837: p_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;
1838:
1839: /* end declare */
1840:
1841: /* declare the insert array elements */

Line 1962: FROM ar_cash_receipts cr, ar_cash_receipt_history crh,

1958: NULL,SYS_GUID(),
1959: cr.unique_reference ),
1960: cr.customer_bank_account_id,
1961: cr.payment_trxn_extension_id
1962: FROM ar_cash_receipts cr, ar_cash_receipt_history crh,
1963: ar_receipt_methods rm,
1964: ar_batches bat,
1965: ar_receipt_method_accounts rma,
1966: ar_payment_schedules ps,

Line 2594: p_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;

2590: l_sel_stmt long;
2591: sel_receipts INTEGER;
2592: /* declare the cursor variables */
2593:
2594: p_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
2595: p_payment_type_code ar_receipt_methods.payment_type_code%TYPE;
2596: p_merchant_ref ar_receipt_methods.merchant_ref%TYPE;
2597: p_currency_code ar_cash_receipts.currency_code%TYPE;
2598: p_pay_from_customer ar_cash_receipts.pay_from_customer%TYPE;

Line 2597: p_currency_code ar_cash_receipts.currency_code%TYPE;

2593:
2594: p_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
2595: p_payment_type_code ar_receipt_methods.payment_type_code%TYPE;
2596: p_merchant_ref ar_receipt_methods.merchant_ref%TYPE;
2597: p_currency_code ar_cash_receipts.currency_code%TYPE;
2598: p_pay_from_customer ar_cash_receipts.pay_from_customer%TYPE;
2599: p_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
2600: p_prv_cash_receipt_hist_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
2601: p_exchange_date ar_cash_receipt_history.exchange_date%TYPE;

Line 2598: p_pay_from_customer ar_cash_receipts.pay_from_customer%TYPE;

2594: p_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
2595: p_payment_type_code ar_receipt_methods.payment_type_code%TYPE;
2596: p_merchant_ref ar_receipt_methods.merchant_ref%TYPE;
2597: p_currency_code ar_cash_receipts.currency_code%TYPE;
2598: p_pay_from_customer ar_cash_receipts.pay_from_customer%TYPE;
2599: p_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
2600: p_prv_cash_receipt_hist_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
2601: p_exchange_date ar_cash_receipt_history.exchange_date%TYPE;
2602: p_exchange_rate ar_cash_receipt_history.exchange_rate%TYPE;

Line 2599: p_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;

2595: p_payment_type_code ar_receipt_methods.payment_type_code%TYPE;
2596: p_merchant_ref ar_receipt_methods.merchant_ref%TYPE;
2597: p_currency_code ar_cash_receipts.currency_code%TYPE;
2598: p_pay_from_customer ar_cash_receipts.pay_from_customer%TYPE;
2599: p_customer_site_use_id ar_cash_receipts.customer_site_use_id%TYPE;
2600: p_prv_cash_receipt_hist_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
2601: p_exchange_date ar_cash_receipt_history.exchange_date%TYPE;
2602: p_exchange_rate ar_cash_receipt_history.exchange_rate%TYPE;
2603: p_exchange_type ar_cash_receipt_history.exchange_rate_type%TYPE;

Line 2604: p_cr_amount ar_cash_receipts.amount%TYPE;

2600: p_prv_cash_receipt_hist_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
2601: p_exchange_date ar_cash_receipt_history.exchange_date%TYPE;
2602: p_exchange_rate ar_cash_receipt_history.exchange_rate%TYPE;
2603: p_exchange_type ar_cash_receipt_history.exchange_rate_type%TYPE;
2604: p_cr_amount ar_cash_receipts.amount%TYPE;
2605: p_cr_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;
2606: p_cr_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
2607: p_remmitance_ccid ar_receipt_method_accounts.remittance_ccid%TYPE;
2608: p_bank_charges_ccid ar_receipt_method_accounts.bank_charges_ccid%TYPE;

Line 2606: p_cr_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;

2602: p_exchange_rate ar_cash_receipt_history.exchange_rate%TYPE;
2603: p_exchange_type ar_cash_receipt_history.exchange_rate_type%TYPE;
2604: p_cr_amount ar_cash_receipts.amount%TYPE;
2605: p_cr_acctd_amount ar_cash_receipt_history.acctd_amount%TYPE;
2606: p_cr_factor_discount_amount ar_cash_receipts.factor_discount_amount%TYPE;
2607: p_remmitance_ccid ar_receipt_method_accounts.remittance_ccid%TYPE;
2608: p_bank_charges_ccid ar_receipt_method_accounts.bank_charges_ccid%TYPE;
2609: p_code_combination_id ar_distributions.code_combination_id%TYPE;
2610: p_cash_receipt_history_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;

Line 2613: p_payment_server_order_num ar_cash_receipts.payment_server_order_num%TYPE;

2609: p_code_combination_id ar_distributions.code_combination_id%TYPE;
2610: p_cash_receipt_history_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
2611: p_crh_gl_date ar_cash_receipt_history.gl_date%TYPE;
2612: p_crh_trx_date ar_cash_receipt_history.trx_date%TYPE;
2613: p_payment_server_order_num ar_cash_receipts.payment_server_order_num%TYPE;
2614: p_approval_code ar_cash_receipts.approval_code%TYPE;
2615: p_receipt_number ar_cash_receipts.receipt_number%TYPE;
2616: p_unique_ref ar_cash_receipts.unique_reference%TYPE;
2617: p_customer_bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE;

Line 2614: p_approval_code ar_cash_receipts.approval_code%TYPE;

2610: p_cash_receipt_history_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
2611: p_crh_gl_date ar_cash_receipt_history.gl_date%TYPE;
2612: p_crh_trx_date ar_cash_receipt_history.trx_date%TYPE;
2613: p_payment_server_order_num ar_cash_receipts.payment_server_order_num%TYPE;
2614: p_approval_code ar_cash_receipts.approval_code%TYPE;
2615: p_receipt_number ar_cash_receipts.receipt_number%TYPE;
2616: p_unique_ref ar_cash_receipts.unique_reference%TYPE;
2617: p_customer_bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE;
2618: p_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;

Line 2615: p_receipt_number ar_cash_receipts.receipt_number%TYPE;

2611: p_crh_gl_date ar_cash_receipt_history.gl_date%TYPE;
2612: p_crh_trx_date ar_cash_receipt_history.trx_date%TYPE;
2613: p_payment_server_order_num ar_cash_receipts.payment_server_order_num%TYPE;
2614: p_approval_code ar_cash_receipts.approval_code%TYPE;
2615: p_receipt_number ar_cash_receipts.receipt_number%TYPE;
2616: p_unique_ref ar_cash_receipts.unique_reference%TYPE;
2617: p_customer_bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE;
2618: p_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;
2619:

Line 2616: p_unique_ref ar_cash_receipts.unique_reference%TYPE;

2612: p_crh_trx_date ar_cash_receipt_history.trx_date%TYPE;
2613: p_payment_server_order_num ar_cash_receipts.payment_server_order_num%TYPE;
2614: p_approval_code ar_cash_receipts.approval_code%TYPE;
2615: p_receipt_number ar_cash_receipts.receipt_number%TYPE;
2616: p_unique_ref ar_cash_receipts.unique_reference%TYPE;
2617: p_customer_bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE;
2618: p_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;
2619:
2620: /* end declare */

Line 2617: p_customer_bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE;

2613: p_payment_server_order_num ar_cash_receipts.payment_server_order_num%TYPE;
2614: p_approval_code ar_cash_receipts.approval_code%TYPE;
2615: p_receipt_number ar_cash_receipts.receipt_number%TYPE;
2616: p_unique_ref ar_cash_receipts.unique_reference%TYPE;
2617: p_customer_bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE;
2618: p_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;
2619:
2620: /* end declare */
2621:

Line 2618: p_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;

2614: p_approval_code ar_cash_receipts.approval_code%TYPE;
2615: p_receipt_number ar_cash_receipts.receipt_number%TYPE;
2616: p_unique_ref ar_cash_receipts.unique_reference%TYPE;
2617: p_customer_bank_account_id ar_cash_receipts.customer_bank_account_id%TYPE;
2618: p_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;
2619:
2620: /* end declare */
2621:
2622: /* declare the insert array elements */

Line 3362: p_doc_num_l IN ar_cash_receipts.doc_sequence_value%type,

3358: p_customer_number_l IN hz_cust_accounts.account_number%TYPE,
3359: p_customer_number_h IN hz_cust_accounts.account_number%TYPE,
3360: p_customer_name_l IN hz_parties.party_name%type,
3361: p_customer_name_h IN hz_parties.party_name%type,
3362: p_doc_num_l IN ar_cash_receipts.doc_sequence_value%type,
3363: p_doc_num_h IN ar_cash_receipts.doc_sequence_value%type,
3364: p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,
3365: p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,
3366: p_due_date_l IN ar_payment_schedules.due_date%TYPE,

Line 3363: p_doc_num_h IN ar_cash_receipts.doc_sequence_value%type,

3359: p_customer_number_h IN hz_cust_accounts.account_number%TYPE,
3360: p_customer_name_l IN hz_parties.party_name%type,
3361: p_customer_name_h IN hz_parties.party_name%type,
3362: p_doc_num_l IN ar_cash_receipts.doc_sequence_value%type,
3363: p_doc_num_h IN ar_cash_receipts.doc_sequence_value%type,
3364: p_trx_date_l IN ar_payment_schedules.trx_date%TYPE,
3365: p_trx_date_h IN ar_payment_schedules.trx_date%TYPE,
3366: p_due_date_l IN ar_payment_schedules.due_date%TYPE,
3367: p_due_date_h IN ar_payment_schedules.due_date%TYPE,

Line 3370: p_remittance_total_to IN ar_cash_receipts.amount%TYPE,

3366: p_due_date_l IN ar_payment_schedules.due_date%TYPE,
3367: p_due_date_h IN ar_payment_schedules.due_date%TYPE,
3368: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,
3369: p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,
3370: p_remittance_total_to IN ar_cash_receipts.amount%TYPE,
3371: p_remittance_total_from IN ar_cash_receipts.amount%TYPE,
3372: p_batch_id IN ar_batches.batch_id%TYPE,
3373: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
3374: p_currency_code IN ar_cash_receipts.currency_code%TYPE,

Line 3371: p_remittance_total_from IN ar_cash_receipts.amount%TYPE,

3367: p_due_date_h IN ar_payment_schedules.due_date%TYPE,
3368: p_trx_num_l IN ar_payment_schedules.trx_number%TYPE,
3369: p_trx_num_h IN ar_payment_schedules.trx_number%TYPE,
3370: p_remittance_total_to IN ar_cash_receipts.amount%TYPE,
3371: p_remittance_total_from IN ar_cash_receipts.amount%TYPE,
3372: p_batch_id IN ar_batches.batch_id%TYPE,
3373: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
3374: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
3375: p_payment_type_code IN ar_receipt_methods.payment_type_code%TYPE,

Line 3374: p_currency_code IN ar_cash_receipts.currency_code%TYPE,

3370: p_remittance_total_to IN ar_cash_receipts.amount%TYPE,
3371: p_remittance_total_from IN ar_cash_receipts.amount%TYPE,
3372: p_batch_id IN ar_batches.batch_id%TYPE,
3373: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
3374: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
3375: p_payment_type_code IN ar_receipt_methods.payment_type_code%TYPE,
3376: p_sob_id IN ar_cash_receipts.set_of_books_id%TYPE,
3377: p_remit_method_code IN ar_receipt_classes.remit_method_code%TYPE,
3378: p_remit_bank_account_id IN ar_cash_receipts.remittance_bank_account_id%TYPE,

Line 3376: p_sob_id IN ar_cash_receipts.set_of_books_id%TYPE,

3372: p_batch_id IN ar_batches.batch_id%TYPE,
3373: p_receipt_method_id IN ar_receipt_methods.receipt_method_id%TYPE,
3374: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
3375: p_payment_type_code IN ar_receipt_methods.payment_type_code%TYPE,
3376: p_sob_id IN ar_cash_receipts.set_of_books_id%TYPE,
3377: p_remit_method_code IN ar_receipt_classes.remit_method_code%TYPE,
3378: p_remit_bank_account_id IN ar_cash_receipts.remittance_bank_account_id%TYPE,
3379: p_return_status OUT NOCOPY VARCHAR2
3380: ) IS

Line 3378: p_remit_bank_account_id IN ar_cash_receipts.remittance_bank_account_id%TYPE,

3374: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
3375: p_payment_type_code IN ar_receipt_methods.payment_type_code%TYPE,
3376: p_sob_id IN ar_cash_receipts.set_of_books_id%TYPE,
3377: p_remit_method_code IN ar_receipt_classes.remit_method_code%TYPE,
3378: p_remit_bank_account_id IN ar_cash_receipts.remittance_bank_account_id%TYPE,
3379: p_return_status OUT NOCOPY VARCHAR2
3380: ) IS
3381:
3382: remit_recs INTEGER;

Line 3387: p_amount ar_cash_receipts.amount%TYPE;

3383: l_sel_stmt long;
3384: l_rows_processed INTEGER;
3385: l_rows_fetched INTEGER;
3386: p_cash_receipt_id NUMBER(15);
3387: p_amount ar_cash_receipts.amount%TYPE;
3388: l_amount ar_cash_receipts.amount%TYPE; --14798599
3389: p_payment_method_id ar_receipt_methods.receipt_method_id%TYPE;
3390: cash_receipt_id_array dbms_sql.Number_Table;
3391: cr_id_array dbms_sql.Number_Table;

Line 3388: l_amount ar_cash_receipts.amount%TYPE; --14798599

3384: l_rows_processed INTEGER;
3385: l_rows_fetched INTEGER;
3386: p_cash_receipt_id NUMBER(15);
3387: p_amount ar_cash_receipts.amount%TYPE;
3388: l_amount ar_cash_receipts.amount%TYPE; --14798599
3389: p_payment_method_id ar_receipt_methods.receipt_method_id%TYPE;
3390: cash_receipt_id_array dbms_sql.Number_Table;
3391: cr_id_array dbms_sql.Number_Table;
3392: amt_array dbms_sql.Number_Table;

Line 3491: ar_cash_receipts cr,

3487: l_sel_stmt := l_sel_stmt || ' ar_rem_cr_id_gtt crh, ';
3488: end if;
3489:
3490: l_sel_stmt := l_sel_stmt || ' ar_cash_receipt_history crh1,
3491: ar_cash_receipts cr,
3492: ar_payment_schedules ps,
3493: ar_receipt_classes rclass,
3494: ar_receipt_methods rm,
3495: ar_receipt_method_accounts rma1,

Line 3654: upd_stmt2 := ' UPDATE /+ parallel(R) index(R) / ar_cash_receipts R';

3650: END IF;*/
3651:
3652: IF p_remittance_total_from IS NULL AND p_remittance_total_to IS NULL THEN
3653: IF PG_PARALLEL IN ('Y', 'C') THEN
3654: upd_stmt2 := ' UPDATE /*+ parallel(R) index(R) */ ar_cash_receipts R';
3655: ELSE
3656: upd_stmt2 := ' UPDATE /*+ index(R) */ ar_cash_receipts R';
3657: END IF;
3658: upd_stmt2 := upd_stmt2 ||' SET selected_remittance_batch_id = :u_batch_id,

Line 3656: upd_stmt2 := ' UPDATE /+ index(R) / ar_cash_receipts R';

3652: IF p_remittance_total_from IS NULL AND p_remittance_total_to IS NULL THEN
3653: IF PG_PARALLEL IN ('Y', 'C') THEN
3654: upd_stmt2 := ' UPDATE /*+ parallel(R) index(R) */ ar_cash_receipts R';
3655: ELSE
3656: upd_stmt2 := ' UPDATE /*+ index(R) */ ar_cash_receipts R';
3657: END IF;
3658: upd_stmt2 := upd_stmt2 ||' SET selected_remittance_batch_id = :u_batch_id,
3659: REMIT_BANK_ACCT_USE_ID = :u_remit_bank_account_id,
3660: last_update_date = sysdate,

Line 3813: upd_stmt2 := ' UPDATE /+ parallel(R) index(R) / ar_cash_receipts R';

3809:
3810: IF (i > 1) AND (p_remittance_total_from IS NULL OR l_amount >= p_remittance_total_from) THEN
3811:
3812: IF PG_PARALLEL IN ('Y', 'C') THEN
3813: upd_stmt2 := ' UPDATE /*+ parallel(R) index(R) */ ar_cash_receipts R';
3814: ELSE
3815: upd_stmt2 := ' UPDATE /*+ index(R) */ ar_cash_receipts R';
3816: END IF;
3817: upd_stmt2 := upd_stmt2 ||' SET selected_remittance_batch_id = :u_batch_id,

Line 3815: upd_stmt2 := ' UPDATE /+ index(R) / ar_cash_receipts R';

3811:
3812: IF PG_PARALLEL IN ('Y', 'C') THEN
3813: upd_stmt2 := ' UPDATE /*+ parallel(R) index(R) */ ar_cash_receipts R';
3814: ELSE
3815: upd_stmt2 := ' UPDATE /*+ index(R) */ ar_cash_receipts R';
3816: END IF;
3817: upd_stmt2 := upd_stmt2 ||' SET selected_remittance_batch_id = :u_batch_id,
3818: REMIT_BANK_ACCT_USE_ID = :u_remit_bank_account_id,
3819: last_update_date = sysdate,

Line 3927: FROM ar_cash_receipts cr,

3923: cr.payment_trxn_extension_id,
3924: cr.selected_remittance_batch_id,
3925: cr.receipt_date,
3926: pr.home_country
3927: FROM ar_cash_receipts cr,
3928: ar_receipt_methods rm,
3929: ar_receipt_classes rc,
3930: hz_cust_accounts hca,
3931: hz_parties party,

Line 3951: l_cr_rec ar_cash_receipts_all%ROWTYPE;

3947: AND pr.party_id = bank.party_id
3948: AND sysdate between pr.effective_start_date and nvl(pr.effective_end_date,sysdate) ;
3949:
3950: -- rct_info rct_info_cur%ROWTYPE;
3951: l_cr_rec ar_cash_receipts_all%ROWTYPE;
3952: l_org_type HR_ALL_ORGANIZATION_UNITS.TYPE%TYPE;
3953: l_action VARCHAR2(80);
3954: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3955: l_msg_count NUMBER;

Line 3987: l_cr_id ar_cash_receipts.cash_receipt_id%type;

3983: ls_msg_count NUMBER;
3984: ls_msg_data VARCHAR2(2000);
3985: ls_response_rec_tab IBY_FNDCPT_TRXN_PUB.SettlementResult_tbl_type;
3986: ls_iby_msg_data VARCHAR2(2000);
3987: l_cr_id ar_cash_receipts.cash_receipt_id%type;
3988: l_paying_customer_id ar_cash_receipts.pay_from_customer%type;
3989: l_cust_site_id ar_cash_receipts.customer_site_use_id%type;
3990: l_count1 NUMBER;
3991:

Line 3988: l_paying_customer_id ar_cash_receipts.pay_from_customer%type;

3984: ls_msg_data VARCHAR2(2000);
3985: ls_response_rec_tab IBY_FNDCPT_TRXN_PUB.SettlementResult_tbl_type;
3986: ls_iby_msg_data VARCHAR2(2000);
3987: l_cr_id ar_cash_receipts.cash_receipt_id%type;
3988: l_paying_customer_id ar_cash_receipts.pay_from_customer%type;
3989: l_cust_site_id ar_cash_receipts.customer_site_use_id%type;
3990: l_count1 NUMBER;
3991:
3992: /* end declare varaibles for settlement */

Line 3989: l_cust_site_id ar_cash_receipts.customer_site_use_id%type;

3985: ls_response_rec_tab IBY_FNDCPT_TRXN_PUB.SettlementResult_tbl_type;
3986: ls_iby_msg_data VARCHAR2(2000);
3987: l_cr_id ar_cash_receipts.cash_receipt_id%type;
3988: l_paying_customer_id ar_cash_receipts.pay_from_customer%type;
3989: l_cust_site_id ar_cash_receipts.customer_site_use_id%type;
3990: l_count1 NUMBER;
3991:
3992: /* end declare varaibles for settlement */
3993:

Line 4213: UPDATE ar_cash_receipts

4209: l_response_rec.Result_Message , 1, 240);
4210:
4211: fnd_file.put_line(FND_FILE.LOG, 'l_iby_msg_data: ' || l_iby_msg_data);
4212: /*Bug 10282633 Fix for correcting error mesage w/ iby code*/
4213: UPDATE ar_cash_receipts
4214: SET cc_error_flag = 'Y',
4215: cc_error_code = l_response_rec.Result_Code,
4216: cc_error_text = nvl(l_iby_msg_data,pl_msg_data),
4217: last_updated_by = l_last_updated_by,

Line 4242: UPDATE ar_cash_receipts

4238:
4239: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
4240: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',l_vend_msg_data);
4241:
4242: UPDATE ar_cash_receipts
4243: SET cc_error_flag = 'Y',
4244: cc_error_code = l_authresult_rec.PaymentSys_Code,
4245: cc_error_text = substr(l_authresult_rec.PaymentSys_Msg,1,240),
4246: last_updated_by = l_last_updated_by,

Line 4287: UPDATE ar_cash_receipts

4283: p_exception_code => 'AR_CC_AUTH_FAILED',
4284: p_additional_message => l_iby_msg_data
4285: );
4286:
4287: UPDATE ar_cash_receipts
4288: SET cc_error_flag = 'Y',
4289: last_updated_by = l_last_updated_by,
4290: last_update_date = sysdate,
4291: last_update_login = l_last_update_login,

Line 4420: UPDATE ar_cash_receipts

4416: p_exception_code => 'AR_CC_AUTH_FAILED',
4417: p_additional_message => lc_iby_msg_data
4418: );
4419: /*Bug 10282633 Fixed for storing correct message*/
4420: UPDATE ar_cash_receipts
4421: SET cc_error_flag = 'Y',
4422: cc_error_code = lc_response_rec.Result_Code,
4423: cc_error_text = nvl(lc_iby_msg_data,pl_msg_data),
4424: last_updated_by = l_last_updated_by,

Line 4456: UPDATE ar_cash_receipts

4452: p_exception_code => 'AR_CC_AUTH_FAILED',
4453: p_additional_message => l_iby_msg_data
4454: );
4455:
4456: UPDATE ar_cash_receipts
4457: SET cc_error_flag = 'Y',
4458: last_updated_by = l_last_updated_by,
4459: last_update_date = sysdate,
4460: last_update_login = l_last_update_login,

Line 4572: select /+ INDEX(ar_cash_receipts ar_cash_receipts_n15) /

4568:
4569: fnd_file.put_line(FND_FILE.LOG, 'ls_iby_msg_data: ' || ls_iby_msg_data);
4570:
4571: Begin
4572: select /*+ INDEX(ar_cash_receipts ar_cash_receipts_n15) */
4573: cash_receipt_id,pay_from_customer,customer_site_use_id
4574: into l_cr_id,l_paying_customer_id,l_cust_site_id
4575: from ar_cash_receipts
4576: where selected_remittance_batch_id = p_batch_id and

Line 4575: from ar_cash_receipts

4571: Begin
4572: select /*+ INDEX(ar_cash_receipts ar_cash_receipts_n15) */
4573: cash_receipt_id,pay_from_customer,customer_site_use_id
4574: into l_cr_id,l_paying_customer_id,l_cust_site_id
4575: from ar_cash_receipts
4576: where selected_remittance_batch_id = p_batch_id and
4577: payment_trxn_extension_id = ls_response_rec_tab(i).Trxn_Extension_Id;
4578:
4579:

Line 4592: UPDATE ar_cash_receipts

4588: p_additional_message => ls_iby_msg_data
4589: );
4590:
4591:
4592: UPDATE ar_cash_receipts
4593: SET cc_error_flag = 'Y',
4594: cc_error_code = decode(ls_response_rec_tab(i).Result.Result_Code,'INVALID_AUTHORIZATION',cc_error_code,ls_response_rec_tab(i).Result.Result_Code),
4595: cc_error_text = decode(ls_response_rec_tab(i).Result.Result_Code,'INVALID_AUTHORIZATION',cc_error_text,substr(ls_response_rec_tab(i).Result.Result_Message,1,240)),
4596: last_updated_by = l_last_updated_by,

Line 4683: ar_cash_receipts_all cr,

4679: a.batch_id,
4680: pr.home_country
4681: FROM ar_autorem_interim a,
4682: /* Need to pass country code for SEPA specific receipts */
4683: ar_cash_receipts_all cr,
4684: ce_bank_acct_uses bau,
4685: ce_bank_accounts cba,
4686: hz_parties bank,
4687: hz_organization_profiles pr

Line 4699: CURSOR rct_date_cur (c_cash_receipt_id ar_cash_receipts_all.cash_receipt_id%TYPE)

4695: AND sysdate between pr.effective_start_date and nvl(pr.effective_end_date,sysdate) ;
4696:
4697:
4698: /*Bug 7666285*/
4699: CURSOR rct_date_cur (c_cash_receipt_id ar_cash_receipts_all.cash_receipt_id%TYPE)
4700: IS
4701: SELECT receipt_date
4702: FROM ar_cash_receipts
4703: WHERE cash_receipt_id = c_cash_receipt_id;

Line 4702: FROM ar_cash_receipts

4698: /*Bug 7666285*/
4699: CURSOR rct_date_cur (c_cash_receipt_id ar_cash_receipts_all.cash_receipt_id%TYPE)
4700: IS
4701: SELECT receipt_date
4702: FROM ar_cash_receipts
4703: WHERE cash_receipt_id = c_cash_receipt_id;
4704:
4705:
4706:

Line 4708: l_cr_rec ar_cash_receipts_all%ROWTYPE;

4704:
4705:
4706:
4707: -- rct_info rct_info_cur%ROWTYPE;
4708: l_cr_rec ar_cash_receipts_all%ROWTYPE;
4709: l_org_type HR_ALL_ORGANIZATION_UNITS.TYPE%TYPE;
4710: l_action VARCHAR2(80);
4711: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
4712: l_msg_count NUMBER;

Line 4723: l_receipt_date ar_cash_receipts_all.receipt_date%TYPE; /Bug7666285/

4719: l_amount_rec IBY_FNDCPT_TRXN_PUB.Amount_rec_type;
4720: l_payer_rec IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;
4721: l_response_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type; /* OUT RESPONSE STRUCTURE */
4722:
4723: l_receipt_date ar_cash_receipts_all.receipt_date%TYPE; /*Bug7666285*/
4724:
4725: /* DECLARE the variables required for the payment engine (AUTH) all the REC TYPES */
4726:
4727: l_payee_rec IBY_FNDCPT_TRXN_PUB.PayeeContext_rec_type;

Line 4745: l_cr_id ar_cash_receipts.cash_receipt_id%type;

4741: ls_msg_count NUMBER;
4742: ls_msg_data VARCHAR2(2000);
4743: ls_response_rec_tab IBY_FNDCPT_TRXN_PUB.SettlementResult_tbl_type;
4744: ls_iby_msg_data VARCHAR2(2000);
4745: l_cr_id ar_cash_receipts.cash_receipt_id%type;
4746: l_paying_customer_id ar_cash_receipts.pay_from_customer%type;
4747: l_cust_site_id ar_cash_receipts.customer_site_use_id%type;
4748: l_count1 NUMBER;
4749:

Line 4746: l_paying_customer_id ar_cash_receipts.pay_from_customer%type;

4742: ls_msg_data VARCHAR2(2000);
4743: ls_response_rec_tab IBY_FNDCPT_TRXN_PUB.SettlementResult_tbl_type;
4744: ls_iby_msg_data VARCHAR2(2000);
4745: l_cr_id ar_cash_receipts.cash_receipt_id%type;
4746: l_paying_customer_id ar_cash_receipts.pay_from_customer%type;
4747: l_cust_site_id ar_cash_receipts.customer_site_use_id%type;
4748: l_count1 NUMBER;
4749:
4750: /* end declare varaibles for settlement */

Line 4747: l_cust_site_id ar_cash_receipts.customer_site_use_id%type;

4743: ls_response_rec_tab IBY_FNDCPT_TRXN_PUB.SettlementResult_tbl_type;
4744: ls_iby_msg_data VARCHAR2(2000);
4745: l_cr_id ar_cash_receipts.cash_receipt_id%type;
4746: l_paying_customer_id ar_cash_receipts.pay_from_customer%type;
4747: l_cust_site_id ar_cash_receipts.customer_site_use_id%type;
4748: l_count1 NUMBER;
4749:
4750: /* end declare varaibles for settlement */
4751:

Line 4960: UPDATE ar_cash_receipts

4956: l_response_rec.Result_Message , 1, 240);
4957:
4958: fnd_file.put_line(FND_FILE.LOG, 'l_iby_msg_data: ' || l_iby_msg_data);
4959: /*Bug 10282633*/
4960: UPDATE ar_cash_receipts
4961: SET cc_error_flag = 'Y',
4962: cc_error_code = l_response_rec.Result_Code,
4963: cc_error_text = nvl(l_iby_msg_data,pl_msg_data),
4964: last_updated_by = l_last_updated_by,

Line 4987: UPDATE ar_cash_receipts

4983:
4984: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
4985: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',l_vend_msg_data);
4986:
4987: UPDATE ar_cash_receipts
4988: SET cc_error_flag = 'Y',
4989: cc_error_code = l_authresult_rec.PaymentSys_Code,
4990: cc_error_text = substr(l_authresult_rec.PaymentSys_Msg,1,240),
4991: last_updated_by = l_last_updated_by,

Line 5032: UPDATE ar_cash_receipts

5028: p_exception_code => 'AR_CC_AUTH_FAILED',
5029: p_additional_message => l_iby_msg_data
5030: );
5031:
5032: UPDATE ar_cash_receipts
5033: SET cc_error_flag = 'Y',
5034: last_updated_by = l_last_updated_by,
5035: last_update_date = sysdate,
5036: last_update_login = l_last_update_login,

Line 5184: UPDATE ar_cash_receipts

5180: p_exception_code => 'AR_CC_AUTH_FAILED',
5181: p_additional_message => lc_iby_msg_data
5182: );
5183: /*Bug 10282633*/
5184: UPDATE ar_cash_receipts
5185: SET cc_error_flag = 'Y',
5186: cc_error_code = lc_response_rec.Result_Code,
5187: cc_error_text = nvl(lc_iby_msg_data,pl_msg_data),
5188: last_updated_by = l_last_updated_by,

Line 5220: UPDATE ar_cash_receipts

5216: p_exception_code => 'AR_CC_AUTH_FAILED',
5217: p_additional_message => l_iby_msg_data
5218: );
5219:
5220: UPDATE ar_cash_receipts
5221: SET cc_error_flag = 'Y',
5222: last_updated_by = l_last_updated_by,
5223: last_update_date = sysdate,
5224: last_update_login = l_last_update_login,

Line 5344: select /+ INDEX(ar_cash_receipts ar_cash_receipts_n15) /

5340: fnd_file.put_line(FND_FILE.LOG, 'ls_iby_msg_data: ' || ls_iby_msg_data);
5341: END IF;
5342:
5343: Begin
5344: select /*+ INDEX(ar_cash_receipts ar_cash_receipts_n15) */
5345: cash_receipt_id,pay_from_customer,customer_site_use_id
5346: into l_cr_id,l_paying_customer_id,l_cust_site_id
5347: from ar_cash_receipts
5348: where selected_remittance_batch_id = p_batch_id and

Line 5347: from ar_cash_receipts

5343: Begin
5344: select /*+ INDEX(ar_cash_receipts ar_cash_receipts_n15) */
5345: cash_receipt_id,pay_from_customer,customer_site_use_id
5346: into l_cr_id,l_paying_customer_id,l_cust_site_id
5347: from ar_cash_receipts
5348: where selected_remittance_batch_id = p_batch_id and
5349: payment_trxn_extension_id = ls_response_rec_tab(i).Trxn_Extension_Id;
5350:
5351:

Line 5364: UPDATE ar_cash_receipts

5360: p_additional_message => ls_iby_msg_data
5361: );
5362:
5363:
5364: UPDATE ar_cash_receipts
5365: SET cc_error_flag = 'Y',
5366: cc_error_code = ls_response_rec_tab(i).Result.Result_Code,
5367: cc_error_text = ls_response_rec_tab(i).Result.Result_Message,
5368: last_updated_by = l_last_updated_by,

Line 5435: p_request_id IN ar_cash_receipts.request_id%TYPE DEFAULT NULL,

5431: | 16-JUL-2005 bichatte Created |
5432: *=========================================================================*/
5433: PROCEDURE insert_exceptions(
5434: p_batch_id IN ar_batches.batch_id%TYPE DEFAULT NULL,
5435: p_request_id IN ar_cash_receipts.request_id%TYPE DEFAULT NULL,
5436: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
5437: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
5438: p_paying_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
5439: p_paying_site_use_id IN ar_cash_receipts.customer_site_use_id%TYPE DEFAULT NULL,

Line 5436: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,

5432: *=========================================================================*/
5433: PROCEDURE insert_exceptions(
5434: p_batch_id IN ar_batches.batch_id%TYPE DEFAULT NULL,
5435: p_request_id IN ar_cash_receipts.request_id%TYPE DEFAULT NULL,
5436: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
5437: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
5438: p_paying_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
5439: p_paying_site_use_id IN ar_cash_receipts.customer_site_use_id%TYPE DEFAULT NULL,
5440: p_due_date IN ar_payment_schedules.due_date%TYPE DEFAULT NULL,

Line 5438: p_paying_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,

5434: p_batch_id IN ar_batches.batch_id%TYPE DEFAULT NULL,
5435: p_request_id IN ar_cash_receipts.request_id%TYPE DEFAULT NULL,
5436: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
5437: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
5438: p_paying_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
5439: p_paying_site_use_id IN ar_cash_receipts.customer_site_use_id%TYPE DEFAULT NULL,
5440: p_due_date IN ar_payment_schedules.due_date%TYPE DEFAULT NULL,
5441: p_cust_min_rec_amount IN NUMBER DEFAULT NULL,
5442: p_bank_min_rec_amount IN NUMBER DEFAULT NULL,

Line 5439: p_paying_site_use_id IN ar_cash_receipts.customer_site_use_id%TYPE DEFAULT NULL,

5435: p_request_id IN ar_cash_receipts.request_id%TYPE DEFAULT NULL,
5436: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE DEFAULT NULL,
5437: p_payment_schedule_id IN ar_payment_schedules.payment_schedule_id%TYPE DEFAULT NULL,
5438: p_paying_customer_id IN ar_cash_receipts.pay_from_customer%TYPE DEFAULT NULL,
5439: p_paying_site_use_id IN ar_cash_receipts.customer_site_use_id%TYPE DEFAULT NULL,
5440: p_due_date IN ar_payment_schedules.due_date%TYPE DEFAULT NULL,
5441: p_cust_min_rec_amount IN NUMBER DEFAULT NULL,
5442: p_bank_min_rec_amount IN NUMBER DEFAULT NULL,
5443: p_exception_code IN VARCHAR2,

Line 5585: p_request_id ar_cash_receipts.request_id%TYPE

5581: *=========================================================================*/
5582:
5583: PROCEDURE SUBMIT_REPORT (
5584: p_batch_id ar_batches.batch_id%TYPE,
5585: p_request_id ar_cash_receipts.request_id%TYPE
5586: ) IS
5587:
5588: l_reqid NUMBER(15);
5589: l_org_id NUMBEr;

Line 5757: UPDATE ar_cash_receipts

5753: l_last_update_login := arp_standard.profile.last_update_login ;
5754: l_program_application_id := arp_standard.application_id ;
5755: l_program_id := arp_standard.profile.program_id;
5756:
5757: UPDATE ar_cash_receipts
5758: SET cc_error_flag = 'Y',
5759: last_updated_by = l_last_updated_by,
5760: last_update_date = sysdate,
5761: last_update_login = l_last_update_login,

Line 5768: FROM ar_cash_receipts cr,

5764: program_id = l_program_id,
5765: program_update_date = sysdate
5766: WHERE cash_receipt_id in (
5767: SELECT cr.cash_receipt_id
5768: FROM ar_cash_receipts cr,
5769: ar_cash_receipt_history crh,
5770: iby_trxn_extensions_v trxn_ext
5771: WHERE crh.request_id = l_request_id
5772: AND crh.status = 'REMITTED'

Line 5820: FROM ar_cash_receipts cr,

5816: l_last_update_login,
5817: l_program_application_id,
5818: l_program_id,
5819: sysdate
5820: FROM ar_cash_receipts cr,
5821: ar_cash_receipt_history crh,
5822: iby_trxn_extensions_v trxn_ext
5823: WHERE crh.request_id = l_request_id
5824: AND crh.status = 'REMITTED'

Line 5838: UPDATE ar_cash_receipts

5834: AND summ.reqtype in ('ORAPMTCAPTURE','ORAPMTBATCHREQ')
5835: AND summ.status IN(0, 11, 100, 111));
5836: end if;
5837:
5838: UPDATE ar_cash_receipts
5839: SET cc_error_flag = 'Y',
5840: last_updated_by = l_last_updated_by,
5841: last_update_date = sysdate,
5842: last_update_login = l_last_update_login,

Line 5849: FROM ar_cash_receipts cr,

5845: program_id = l_program_id,
5846: program_update_date = sysdate
5847: WHERE cash_receipt_id in (
5848: SELECT cr.cash_receipt_id
5849: FROM ar_cash_receipts cr,
5850: ar_cash_receipt_history crh,
5851: iby_trxn_extensions_v trxn_ext
5852: WHERE crh.request_id = l_request_id
5853: AND crh.status = 'REMITTED'

Line 5901: FROM ar_cash_receipts cr,

5897: l_last_update_login,
5898: l_program_application_id,
5899: l_program_id,
5900: sysdate
5901: FROM ar_cash_receipts cr,
5902: ar_cash_receipt_history crh,
5903: iby_trxn_extensions_v trxn_ext
5904: WHERE crh.request_id = l_request_id
5905: AND crh.status = 'REMITTED'

Line 5944: UPDATE ar_cash_receipts

5940: END IF;
5941:
5942: IF G_ERROR = 'Y' THEN
5943:
5944: UPDATE ar_cash_receipts
5945: SET cc_error_flag = null
5946: WHERE cash_receipt_id in (
5947: SELECT cr.cash_receipt_id
5948: FROM ar_cash_receipts cr,

Line 5948: FROM ar_cash_receipts cr,

5944: UPDATE ar_cash_receipts
5945: SET cc_error_flag = null
5946: WHERE cash_receipt_id in (
5947: SELECT cr.cash_receipt_id
5948: FROM ar_cash_receipts cr,
5949: ar_cash_receipt_history crh,
5950: iby_trxn_extensions_v trxn_ext
5951: WHERE cr.request_id = p_request_id
5952: AND cr.cc_error_flag = 'Y'

Line 5971: UPDATE ar_cash_receipts

5967:
5968: fnd_file.put_line(FND_FILE.LOG,'CASH receipt rows updated : '||sql%rowcount);
5969:
5970:
5971: UPDATE ar_cash_receipts
5972: SET cc_error_flag = null
5973: WHERE cash_receipt_id in (
5974: SELECT cr.cash_receipt_id
5975: FROM ar_cash_receipts cr,

Line 5975: FROM ar_cash_receipts cr,

5971: UPDATE ar_cash_receipts
5972: SET cc_error_flag = null
5973: WHERE cash_receipt_id in (
5974: SELECT cr.cash_receipt_id
5975: FROM ar_cash_receipts cr,
5976: ar_cash_receipt_history crh,
5977: iby_trxn_extensions_v trxn_ext
5978: WHERE cr.request_id = p_request_id
5979: AND cr.cc_error_flag = 'Y'

Line 5999: update ar_cash_receipts

5995: fnd_file.put_line(FND_FILE.LOG,'MISC receipt rows updated : '||sql%rowcount);
5996:
5997: fnd_file.put_line(FND_FILE.LOG,'delete the bad receipts');
5998:
5999: update ar_cash_receipts
6000: set selected_remittance_batch_id = null
6001: where request_id = p_request_id
6002: and cc_error_flag = 'Y';
6003:

Line 6017: from ar_cash_receipts

6013: current_record_flag = 'Y'
6014: where request_id = p_request_id
6015: and status = 'CONFIRMED'
6016: and cash_receipt_id in ( select cash_receipt_id
6017: from ar_cash_receipts
6018: where request_id = p_request_id
6019: and cc_error_flag = 'Y');
6020:
6021: IF PG_DEBUG in ('Y','C') THEN

Line 6029: ar_cash_receipts cr

6025: delete from ar_distributions
6026: where source_table = 'CRH'
6027: and source_id in ( select crh.cash_receipt_history_id
6028: from ar_cash_receipt_history crh,
6029: ar_cash_receipts cr
6030: where crh.STATUS = 'REMITTED'
6031: and crh.request_id = p_request_id
6032: and cr.cash_receipt_id = crh.cash_receipt_id
6033: and cr.request_id = p_request_id

Line 6044: from ar_cash_receipts

6040: delete from ar_cash_receipt_history
6041: where STATUS = 'REMITTED'
6042: and request_id = p_request_id
6043: and cash_receipt_id in ( select cash_receipt_id
6044: from ar_cash_receipts
6045: where request_id = p_request_id
6046: and cc_error_flag = 'Y');
6047:
6048:

Line 6112: FROM ar_cash_receipts cr,

6108: reference_date_2,
6109: reference_date_3,
6110: reference_date_4,
6111: on_hold_flag
6112: FROM ar_cash_receipts cr,
6113: xla_transaction_entities_upg xte,
6114: xla_events xe
6115: WHERE cr.request_id = p_request_id
6116: AND cr.cc_error_flag = 'Y'