APPS.AR_AUTOREM_API dependencies on DBMS_SQL

Line 1360: ins_rec := dbms_sql.open_cursor();

1356: and gtt.CASH_RECEIPT_HISTORY_ID = CRH.CASH_RECEIPT_HISTORY_ID ';
1357:
1358: commit;
1359: execute immediate 'alter session enable parallel dml';
1360: ins_rec := dbms_sql.open_cursor();
1361: dbms_sql.parse (ins_rec, l_ins_stmt, dbms_sql.v7);
1362: dbms_sql.bind_variable( ins_rec, ':b_total_workers', p_total_workers);
1363: dbms_sql.bind_variable( ins_rec, ':b_batch_id', o_batch_id);
1364: ignore := dbms_sql.execute(ins_rec);

Line 1361: dbms_sql.parse (ins_rec, l_ins_stmt, dbms_sql.v7);

1357:
1358: commit;
1359: execute immediate 'alter session enable parallel dml';
1360: ins_rec := dbms_sql.open_cursor();
1361: dbms_sql.parse (ins_rec, l_ins_stmt, dbms_sql.v7);
1362: dbms_sql.bind_variable( ins_rec, ':b_total_workers', p_total_workers);
1363: dbms_sql.bind_variable( ins_rec, ':b_batch_id', o_batch_id);
1364: ignore := dbms_sql.execute(ins_rec);
1365: commit;

Line 1362: dbms_sql.bind_variable( ins_rec, ':b_total_workers', p_total_workers);

1358: commit;
1359: execute immediate 'alter session enable parallel dml';
1360: ins_rec := dbms_sql.open_cursor();
1361: dbms_sql.parse (ins_rec, l_ins_stmt, dbms_sql.v7);
1362: dbms_sql.bind_variable( ins_rec, ':b_total_workers', p_total_workers);
1363: dbms_sql.bind_variable( ins_rec, ':b_batch_id', o_batch_id);
1364: ignore := dbms_sql.execute(ins_rec);
1365: commit;
1366: execute immediate 'alter session disable parallel dml';

Line 1363: dbms_sql.bind_variable( ins_rec, ':b_batch_id', o_batch_id);

1359: execute immediate 'alter session enable parallel dml';
1360: ins_rec := dbms_sql.open_cursor();
1361: dbms_sql.parse (ins_rec, l_ins_stmt, dbms_sql.v7);
1362: dbms_sql.bind_variable( ins_rec, ':b_total_workers', p_total_workers);
1363: dbms_sql.bind_variable( ins_rec, ':b_batch_id', o_batch_id);
1364: ignore := dbms_sql.execute(ins_rec);
1365: commit;
1366: execute immediate 'alter session disable parallel dml';
1367:

Line 1364: ignore := dbms_sql.execute(ins_rec);

1360: ins_rec := dbms_sql.open_cursor();
1361: dbms_sql.parse (ins_rec, l_ins_stmt, dbms_sql.v7);
1362: dbms_sql.bind_variable( ins_rec, ':b_total_workers', p_total_workers);
1363: dbms_sql.bind_variable( ins_rec, ':b_batch_id', o_batch_id);
1364: ignore := dbms_sql.execute(ins_rec);
1365: commit;
1366: execute immediate 'alter session disable parallel dml';
1367:
1368: --Invoke the child programs

Line 1845: cash_receipt_id_array dbms_sql.Number_Table;

1841: /* declare the insert array elements */
1842: i NUMBER;
1843: dummy NUMBER;
1844: inst_stmt varchar2(2000);
1845: cash_receipt_id_array dbms_sql.Number_Table;
1846: payment_type_CODE_array dbms_sql.varchar2_Table;
1847: merchant_ref_array dbms_sql.varchar2_Table;
1848: currency_code_array dbms_sql.varchar2_Table;
1849: pay_from_customer_array dbms_sql.varchar2_Table;

Line 1846: payment_type_CODE_array dbms_sql.varchar2_Table;

1842: i NUMBER;
1843: dummy NUMBER;
1844: inst_stmt varchar2(2000);
1845: cash_receipt_id_array dbms_sql.Number_Table;
1846: payment_type_CODE_array dbms_sql.varchar2_Table;
1847: merchant_ref_array dbms_sql.varchar2_Table;
1848: currency_code_array dbms_sql.varchar2_Table;
1849: pay_from_customer_array dbms_sql.varchar2_Table;
1850: customer_site_use_id_array dbms_sql.Number_Table;

Line 1847: merchant_ref_array dbms_sql.varchar2_Table;

1843: dummy NUMBER;
1844: inst_stmt varchar2(2000);
1845: cash_receipt_id_array dbms_sql.Number_Table;
1846: payment_type_CODE_array dbms_sql.varchar2_Table;
1847: merchant_ref_array dbms_sql.varchar2_Table;
1848: currency_code_array dbms_sql.varchar2_Table;
1849: pay_from_customer_array dbms_sql.varchar2_Table;
1850: customer_site_use_id_array dbms_sql.Number_Table;
1851: prv_cash_receipt_hist_id_array dbms_sql.Number_Table;

Line 1848: currency_code_array dbms_sql.varchar2_Table;

1844: inst_stmt varchar2(2000);
1845: cash_receipt_id_array dbms_sql.Number_Table;
1846: payment_type_CODE_array dbms_sql.varchar2_Table;
1847: merchant_ref_array dbms_sql.varchar2_Table;
1848: currency_code_array dbms_sql.varchar2_Table;
1849: pay_from_customer_array dbms_sql.varchar2_Table;
1850: customer_site_use_id_array dbms_sql.Number_Table;
1851: prv_cash_receipt_hist_id_array dbms_sql.Number_Table;
1852: exchange_date_array dbms_sql.date_Table;

Line 1849: pay_from_customer_array dbms_sql.varchar2_Table;

1845: cash_receipt_id_array dbms_sql.Number_Table;
1846: payment_type_CODE_array dbms_sql.varchar2_Table;
1847: merchant_ref_array dbms_sql.varchar2_Table;
1848: currency_code_array dbms_sql.varchar2_Table;
1849: pay_from_customer_array dbms_sql.varchar2_Table;
1850: customer_site_use_id_array dbms_sql.Number_Table;
1851: prv_cash_receipt_hist_id_array dbms_sql.Number_Table;
1852: exchange_date_array dbms_sql.date_Table;
1853: exchange_rate_array dbms_sql.Number_Table;

Line 1850: customer_site_use_id_array dbms_sql.Number_Table;

1846: payment_type_CODE_array dbms_sql.varchar2_Table;
1847: merchant_ref_array dbms_sql.varchar2_Table;
1848: currency_code_array dbms_sql.varchar2_Table;
1849: pay_from_customer_array dbms_sql.varchar2_Table;
1850: customer_site_use_id_array dbms_sql.Number_Table;
1851: prv_cash_receipt_hist_id_array dbms_sql.Number_Table;
1852: exchange_date_array dbms_sql.date_Table;
1853: exchange_rate_array dbms_sql.Number_Table;
1854: exchange_type_array dbms_sql.varchar2_Table;

Line 1851: prv_cash_receipt_hist_id_array dbms_sql.Number_Table;

1847: merchant_ref_array dbms_sql.varchar2_Table;
1848: currency_code_array dbms_sql.varchar2_Table;
1849: pay_from_customer_array dbms_sql.varchar2_Table;
1850: customer_site_use_id_array dbms_sql.Number_Table;
1851: prv_cash_receipt_hist_id_array dbms_sql.Number_Table;
1852: exchange_date_array dbms_sql.date_Table;
1853: exchange_rate_array dbms_sql.Number_Table;
1854: exchange_type_array dbms_sql.varchar2_Table;
1855: cr_amount_array dbms_sql.Number_Table;

Line 1852: exchange_date_array dbms_sql.date_Table;

1848: currency_code_array dbms_sql.varchar2_Table;
1849: pay_from_customer_array dbms_sql.varchar2_Table;
1850: customer_site_use_id_array dbms_sql.Number_Table;
1851: prv_cash_receipt_hist_id_array dbms_sql.Number_Table;
1852: exchange_date_array dbms_sql.date_Table;
1853: exchange_rate_array dbms_sql.Number_Table;
1854: exchange_type_array dbms_sql.varchar2_Table;
1855: cr_amount_array dbms_sql.Number_Table;
1856: cr_acctd_amount_array dbms_sql.Number_Table;

Line 1853: exchange_rate_array dbms_sql.Number_Table;

1849: pay_from_customer_array dbms_sql.varchar2_Table;
1850: customer_site_use_id_array dbms_sql.Number_Table;
1851: prv_cash_receipt_hist_id_array dbms_sql.Number_Table;
1852: exchange_date_array dbms_sql.date_Table;
1853: exchange_rate_array dbms_sql.Number_Table;
1854: exchange_type_array dbms_sql.varchar2_Table;
1855: cr_amount_array dbms_sql.Number_Table;
1856: cr_acctd_amount_array dbms_sql.Number_Table;
1857: cr_factor_discount_amt_array dbms_sql.Number_Table;

Line 1854: exchange_type_array dbms_sql.varchar2_Table;

1850: customer_site_use_id_array dbms_sql.Number_Table;
1851: prv_cash_receipt_hist_id_array dbms_sql.Number_Table;
1852: exchange_date_array dbms_sql.date_Table;
1853: exchange_rate_array dbms_sql.Number_Table;
1854: exchange_type_array dbms_sql.varchar2_Table;
1855: cr_amount_array dbms_sql.Number_Table;
1856: cr_acctd_amount_array dbms_sql.Number_Table;
1857: cr_factor_discount_amt_array dbms_sql.Number_Table;
1858: remmitance_ccid_array dbms_sql.Number_Table;

Line 1855: cr_amount_array dbms_sql.Number_Table;

1851: prv_cash_receipt_hist_id_array dbms_sql.Number_Table;
1852: exchange_date_array dbms_sql.date_Table;
1853: exchange_rate_array dbms_sql.Number_Table;
1854: exchange_type_array dbms_sql.varchar2_Table;
1855: cr_amount_array dbms_sql.Number_Table;
1856: cr_acctd_amount_array dbms_sql.Number_Table;
1857: cr_factor_discount_amt_array dbms_sql.Number_Table;
1858: remmitance_ccid_array dbms_sql.Number_Table;
1859: bank_charges_ccid_array dbms_sql.Number_Table;

Line 1856: cr_acctd_amount_array dbms_sql.Number_Table;

1852: exchange_date_array dbms_sql.date_Table;
1853: exchange_rate_array dbms_sql.Number_Table;
1854: exchange_type_array dbms_sql.varchar2_Table;
1855: cr_amount_array dbms_sql.Number_Table;
1856: cr_acctd_amount_array dbms_sql.Number_Table;
1857: cr_factor_discount_amt_array dbms_sql.Number_Table;
1858: remmitance_ccid_array dbms_sql.Number_Table;
1859: bank_charges_ccid_array dbms_sql.Number_Table;
1860: code_combination_id_array dbms_sql.Number_Table;

Line 1857: cr_factor_discount_amt_array dbms_sql.Number_Table;

1853: exchange_rate_array dbms_sql.Number_Table;
1854: exchange_type_array dbms_sql.varchar2_Table;
1855: cr_amount_array dbms_sql.Number_Table;
1856: cr_acctd_amount_array dbms_sql.Number_Table;
1857: cr_factor_discount_amt_array dbms_sql.Number_Table;
1858: remmitance_ccid_array dbms_sql.Number_Table;
1859: bank_charges_ccid_array dbms_sql.Number_Table;
1860: code_combination_id_array dbms_sql.Number_Table;
1861: cash_receipt_history_id_array dbms_sql.Number_Table;

Line 1858: remmitance_ccid_array dbms_sql.Number_Table;

1854: exchange_type_array dbms_sql.varchar2_Table;
1855: cr_amount_array dbms_sql.Number_Table;
1856: cr_acctd_amount_array dbms_sql.Number_Table;
1857: cr_factor_discount_amt_array dbms_sql.Number_Table;
1858: remmitance_ccid_array dbms_sql.Number_Table;
1859: bank_charges_ccid_array dbms_sql.Number_Table;
1860: code_combination_id_array dbms_sql.Number_Table;
1861: cash_receipt_history_id_array dbms_sql.Number_Table;
1862: crh_gl_date_array dbms_sql.date_Table;

Line 1859: bank_charges_ccid_array dbms_sql.Number_Table;

1855: cr_amount_array dbms_sql.Number_Table;
1856: cr_acctd_amount_array dbms_sql.Number_Table;
1857: cr_factor_discount_amt_array dbms_sql.Number_Table;
1858: remmitance_ccid_array dbms_sql.Number_Table;
1859: bank_charges_ccid_array dbms_sql.Number_Table;
1860: code_combination_id_array dbms_sql.Number_Table;
1861: cash_receipt_history_id_array dbms_sql.Number_Table;
1862: crh_gl_date_array dbms_sql.date_Table;
1863: crh_trx_date_array dbms_sql.date_Table;

Line 1860: code_combination_id_array dbms_sql.Number_Table;

1856: cr_acctd_amount_array dbms_sql.Number_Table;
1857: cr_factor_discount_amt_array dbms_sql.Number_Table;
1858: remmitance_ccid_array dbms_sql.Number_Table;
1859: bank_charges_ccid_array dbms_sql.Number_Table;
1860: code_combination_id_array dbms_sql.Number_Table;
1861: cash_receipt_history_id_array dbms_sql.Number_Table;
1862: crh_gl_date_array dbms_sql.date_Table;
1863: crh_trx_date_array dbms_sql.date_Table;
1864: payment_server_order_num_array dbms_sql.varchar2_Table;

Line 1861: cash_receipt_history_id_array dbms_sql.Number_Table;

1857: cr_factor_discount_amt_array dbms_sql.Number_Table;
1858: remmitance_ccid_array dbms_sql.Number_Table;
1859: bank_charges_ccid_array dbms_sql.Number_Table;
1860: code_combination_id_array dbms_sql.Number_Table;
1861: cash_receipt_history_id_array dbms_sql.Number_Table;
1862: crh_gl_date_array dbms_sql.date_Table;
1863: crh_trx_date_array dbms_sql.date_Table;
1864: payment_server_order_num_array dbms_sql.varchar2_Table;
1865: approval_code_array dbms_sql.varchar2_Table;

Line 1862: crh_gl_date_array dbms_sql.date_Table;

1858: remmitance_ccid_array dbms_sql.Number_Table;
1859: bank_charges_ccid_array dbms_sql.Number_Table;
1860: code_combination_id_array dbms_sql.Number_Table;
1861: cash_receipt_history_id_array dbms_sql.Number_Table;
1862: crh_gl_date_array dbms_sql.date_Table;
1863: crh_trx_date_array dbms_sql.date_Table;
1864: payment_server_order_num_array dbms_sql.varchar2_Table;
1865: approval_code_array dbms_sql.varchar2_Table;
1866: receipt_number_array dbms_sql.varchar2_Table;

Line 1863: crh_trx_date_array dbms_sql.date_Table;

1859: bank_charges_ccid_array dbms_sql.Number_Table;
1860: code_combination_id_array dbms_sql.Number_Table;
1861: cash_receipt_history_id_array dbms_sql.Number_Table;
1862: crh_gl_date_array dbms_sql.date_Table;
1863: crh_trx_date_array dbms_sql.date_Table;
1864: payment_server_order_num_array dbms_sql.varchar2_Table;
1865: approval_code_array dbms_sql.varchar2_Table;
1866: receipt_number_array dbms_sql.varchar2_Table;
1867: unique_ref_array dbms_sql.varchar2_Table;

Line 1864: payment_server_order_num_array dbms_sql.varchar2_Table;

1860: code_combination_id_array dbms_sql.Number_Table;
1861: cash_receipt_history_id_array dbms_sql.Number_Table;
1862: crh_gl_date_array dbms_sql.date_Table;
1863: crh_trx_date_array dbms_sql.date_Table;
1864: payment_server_order_num_array dbms_sql.varchar2_Table;
1865: approval_code_array dbms_sql.varchar2_Table;
1866: receipt_number_array dbms_sql.varchar2_Table;
1867: unique_ref_array dbms_sql.varchar2_Table;
1868: customer_bank_account_id_array dbms_sql.Number_Table;

Line 1865: approval_code_array dbms_sql.varchar2_Table;

1861: cash_receipt_history_id_array dbms_sql.Number_Table;
1862: crh_gl_date_array dbms_sql.date_Table;
1863: crh_trx_date_array dbms_sql.date_Table;
1864: payment_server_order_num_array dbms_sql.varchar2_Table;
1865: approval_code_array dbms_sql.varchar2_Table;
1866: receipt_number_array dbms_sql.varchar2_Table;
1867: unique_ref_array dbms_sql.varchar2_Table;
1868: customer_bank_account_id_array dbms_sql.Number_Table;
1869: payment_trxn_extn_id_array dbms_sql.Number_Table;

Line 1866: receipt_number_array dbms_sql.varchar2_Table;

1862: crh_gl_date_array dbms_sql.date_Table;
1863: crh_trx_date_array dbms_sql.date_Table;
1864: payment_server_order_num_array dbms_sql.varchar2_Table;
1865: approval_code_array dbms_sql.varchar2_Table;
1866: receipt_number_array dbms_sql.varchar2_Table;
1867: unique_ref_array dbms_sql.varchar2_Table;
1868: customer_bank_account_id_array dbms_sql.Number_Table;
1869: payment_trxn_extn_id_array dbms_sql.Number_Table;
1870: rem_t NUMBER;

Line 1867: unique_ref_array dbms_sql.varchar2_Table;

1863: crh_trx_date_array dbms_sql.date_Table;
1864: payment_server_order_num_array dbms_sql.varchar2_Table;
1865: approval_code_array dbms_sql.varchar2_Table;
1866: receipt_number_array dbms_sql.varchar2_Table;
1867: unique_ref_array dbms_sql.varchar2_Table;
1868: customer_bank_account_id_array dbms_sql.Number_Table;
1869: payment_trxn_extn_id_array dbms_sql.Number_Table;
1870: rem_t NUMBER;
1871: /* end declare */

Line 1868: customer_bank_account_id_array dbms_sql.Number_Table;

1864: payment_server_order_num_array dbms_sql.varchar2_Table;
1865: approval_code_array dbms_sql.varchar2_Table;
1866: receipt_number_array dbms_sql.varchar2_Table;
1867: unique_ref_array dbms_sql.varchar2_Table;
1868: customer_bank_account_id_array dbms_sql.Number_Table;
1869: payment_trxn_extn_id_array dbms_sql.Number_Table;
1870: rem_t NUMBER;
1871: /* end declare */
1872:

Line 1869: payment_trxn_extn_id_array dbms_sql.Number_Table;

1865: approval_code_array dbms_sql.varchar2_Table;
1866: receipt_number_array dbms_sql.varchar2_Table;
1867: unique_ref_array dbms_sql.varchar2_Table;
1868: customer_bank_account_id_array dbms_sql.Number_Table;
1869: payment_trxn_extn_id_array dbms_sql.Number_Table;
1870: rem_t NUMBER;
1871: /* end declare */
1872:
1873:

Line 1982: sel_receipts := dbms_sql.open_cursor;

1978: AND d.source_type = ''CONFIRMATION''
1979: AND d.source_table = ''CRH''
1980: ';
1981:
1982: sel_receipts := dbms_sql.open_cursor;
1983:
1984: dbms_sql.parse (sel_receipts,l_sel_stmt,dbms_sql.v7);
1985:
1986: dbms_sql.bind_variable (sel_receipts,':ab_batch_id',p_batch_id);

Line 1984: dbms_sql.parse (sel_receipts,l_sel_stmt,dbms_sql.v7);

1980: ';
1981:
1982: sel_receipts := dbms_sql.open_cursor;
1983:
1984: dbms_sql.parse (sel_receipts,l_sel_stmt,dbms_sql.v7);
1985:
1986: dbms_sql.bind_variable (sel_receipts,':ab_batch_id',p_batch_id);
1987:
1988: dbms_sql.define_column (sel_receipts, 1, p_cash_receipt_id);

Line 1986: dbms_sql.bind_variable (sel_receipts,':ab_batch_id',p_batch_id);

1982: sel_receipts := dbms_sql.open_cursor;
1983:
1984: dbms_sql.parse (sel_receipts,l_sel_stmt,dbms_sql.v7);
1985:
1986: dbms_sql.bind_variable (sel_receipts,':ab_batch_id',p_batch_id);
1987:
1988: dbms_sql.define_column (sel_receipts, 1, p_cash_receipt_id);
1989: dbms_sql.define_column (sel_receipts, 2, p_payment_type_code,30);
1990: dbms_sql.define_column (sel_receipts, 3, p_merchant_ref,80);

Line 1988: dbms_sql.define_column (sel_receipts, 1, p_cash_receipt_id);

1984: dbms_sql.parse (sel_receipts,l_sel_stmt,dbms_sql.v7);
1985:
1986: dbms_sql.bind_variable (sel_receipts,':ab_batch_id',p_batch_id);
1987:
1988: dbms_sql.define_column (sel_receipts, 1, p_cash_receipt_id);
1989: dbms_sql.define_column (sel_receipts, 2, p_payment_type_code,30);
1990: dbms_sql.define_column (sel_receipts, 3, p_merchant_ref,80);
1991: dbms_sql.define_column (sel_receipts, 4, p_currency_code,15);
1992: dbms_sql.define_column (sel_receipts, 5, p_pay_from_customer);

Line 1989: dbms_sql.define_column (sel_receipts, 2, p_payment_type_code,30);

1985:
1986: dbms_sql.bind_variable (sel_receipts,':ab_batch_id',p_batch_id);
1987:
1988: dbms_sql.define_column (sel_receipts, 1, p_cash_receipt_id);
1989: dbms_sql.define_column (sel_receipts, 2, p_payment_type_code,30);
1990: dbms_sql.define_column (sel_receipts, 3, p_merchant_ref,80);
1991: dbms_sql.define_column (sel_receipts, 4, p_currency_code,15);
1992: dbms_sql.define_column (sel_receipts, 5, p_pay_from_customer);
1993: dbms_sql.define_column (sel_receipts, 6, p_customer_site_use_id);

Line 1990: dbms_sql.define_column (sel_receipts, 3, p_merchant_ref,80);

1986: dbms_sql.bind_variable (sel_receipts,':ab_batch_id',p_batch_id);
1987:
1988: dbms_sql.define_column (sel_receipts, 1, p_cash_receipt_id);
1989: dbms_sql.define_column (sel_receipts, 2, p_payment_type_code,30);
1990: dbms_sql.define_column (sel_receipts, 3, p_merchant_ref,80);
1991: dbms_sql.define_column (sel_receipts, 4, p_currency_code,15);
1992: dbms_sql.define_column (sel_receipts, 5, p_pay_from_customer);
1993: dbms_sql.define_column (sel_receipts, 6, p_customer_site_use_id);
1994: dbms_sql.define_column (sel_receipts, 7, p_prv_cash_receipt_hist_id);

Line 1991: dbms_sql.define_column (sel_receipts, 4, p_currency_code,15);

1987:
1988: dbms_sql.define_column (sel_receipts, 1, p_cash_receipt_id);
1989: dbms_sql.define_column (sel_receipts, 2, p_payment_type_code,30);
1990: dbms_sql.define_column (sel_receipts, 3, p_merchant_ref,80);
1991: dbms_sql.define_column (sel_receipts, 4, p_currency_code,15);
1992: dbms_sql.define_column (sel_receipts, 5, p_pay_from_customer);
1993: dbms_sql.define_column (sel_receipts, 6, p_customer_site_use_id);
1994: dbms_sql.define_column (sel_receipts, 7, p_prv_cash_receipt_hist_id);
1995: dbms_sql.define_column (sel_receipts, 8, p_exchange_date);

Line 1992: dbms_sql.define_column (sel_receipts, 5, p_pay_from_customer);

1988: dbms_sql.define_column (sel_receipts, 1, p_cash_receipt_id);
1989: dbms_sql.define_column (sel_receipts, 2, p_payment_type_code,30);
1990: dbms_sql.define_column (sel_receipts, 3, p_merchant_ref,80);
1991: dbms_sql.define_column (sel_receipts, 4, p_currency_code,15);
1992: dbms_sql.define_column (sel_receipts, 5, p_pay_from_customer);
1993: dbms_sql.define_column (sel_receipts, 6, p_customer_site_use_id);
1994: dbms_sql.define_column (sel_receipts, 7, p_prv_cash_receipt_hist_id);
1995: dbms_sql.define_column (sel_receipts, 8, p_exchange_date);
1996: dbms_sql.define_column (sel_receipts, 9, p_exchange_rate);

Line 1993: dbms_sql.define_column (sel_receipts, 6, p_customer_site_use_id);

1989: dbms_sql.define_column (sel_receipts, 2, p_payment_type_code,30);
1990: dbms_sql.define_column (sel_receipts, 3, p_merchant_ref,80);
1991: dbms_sql.define_column (sel_receipts, 4, p_currency_code,15);
1992: dbms_sql.define_column (sel_receipts, 5, p_pay_from_customer);
1993: dbms_sql.define_column (sel_receipts, 6, p_customer_site_use_id);
1994: dbms_sql.define_column (sel_receipts, 7, p_prv_cash_receipt_hist_id);
1995: dbms_sql.define_column (sel_receipts, 8, p_exchange_date);
1996: dbms_sql.define_column (sel_receipts, 9, p_exchange_rate);
1997: dbms_sql.define_column (sel_receipts, 10, p_exchange_type,30);

Line 1994: dbms_sql.define_column (sel_receipts, 7, p_prv_cash_receipt_hist_id);

1990: dbms_sql.define_column (sel_receipts, 3, p_merchant_ref,80);
1991: dbms_sql.define_column (sel_receipts, 4, p_currency_code,15);
1992: dbms_sql.define_column (sel_receipts, 5, p_pay_from_customer);
1993: dbms_sql.define_column (sel_receipts, 6, p_customer_site_use_id);
1994: dbms_sql.define_column (sel_receipts, 7, p_prv_cash_receipt_hist_id);
1995: dbms_sql.define_column (sel_receipts, 8, p_exchange_date);
1996: dbms_sql.define_column (sel_receipts, 9, p_exchange_rate);
1997: dbms_sql.define_column (sel_receipts, 10, p_exchange_type,30);
1998: dbms_sql.define_column (sel_receipts, 11, p_cr_amount);

Line 1995: dbms_sql.define_column (sel_receipts, 8, p_exchange_date);

1991: dbms_sql.define_column (sel_receipts, 4, p_currency_code,15);
1992: dbms_sql.define_column (sel_receipts, 5, p_pay_from_customer);
1993: dbms_sql.define_column (sel_receipts, 6, p_customer_site_use_id);
1994: dbms_sql.define_column (sel_receipts, 7, p_prv_cash_receipt_hist_id);
1995: dbms_sql.define_column (sel_receipts, 8, p_exchange_date);
1996: dbms_sql.define_column (sel_receipts, 9, p_exchange_rate);
1997: dbms_sql.define_column (sel_receipts, 10, p_exchange_type,30);
1998: dbms_sql.define_column (sel_receipts, 11, p_cr_amount);
1999: dbms_sql.define_column (sel_receipts, 12, p_cr_acctd_amount);

Line 1996: dbms_sql.define_column (sel_receipts, 9, p_exchange_rate);

1992: dbms_sql.define_column (sel_receipts, 5, p_pay_from_customer);
1993: dbms_sql.define_column (sel_receipts, 6, p_customer_site_use_id);
1994: dbms_sql.define_column (sel_receipts, 7, p_prv_cash_receipt_hist_id);
1995: dbms_sql.define_column (sel_receipts, 8, p_exchange_date);
1996: dbms_sql.define_column (sel_receipts, 9, p_exchange_rate);
1997: dbms_sql.define_column (sel_receipts, 10, p_exchange_type,30);
1998: dbms_sql.define_column (sel_receipts, 11, p_cr_amount);
1999: dbms_sql.define_column (sel_receipts, 12, p_cr_acctd_amount);
2000: dbms_sql.define_column (sel_receipts, 13, p_cr_factor_discount_amount);

Line 1997: dbms_sql.define_column (sel_receipts, 10, p_exchange_type,30);

1993: dbms_sql.define_column (sel_receipts, 6, p_customer_site_use_id);
1994: dbms_sql.define_column (sel_receipts, 7, p_prv_cash_receipt_hist_id);
1995: dbms_sql.define_column (sel_receipts, 8, p_exchange_date);
1996: dbms_sql.define_column (sel_receipts, 9, p_exchange_rate);
1997: dbms_sql.define_column (sel_receipts, 10, p_exchange_type,30);
1998: dbms_sql.define_column (sel_receipts, 11, p_cr_amount);
1999: dbms_sql.define_column (sel_receipts, 12, p_cr_acctd_amount);
2000: dbms_sql.define_column (sel_receipts, 13, p_cr_factor_discount_amount);
2001: dbms_sql.define_column (sel_receipts, 14, p_remmitance_ccid );

Line 1998: dbms_sql.define_column (sel_receipts, 11, p_cr_amount);

1994: dbms_sql.define_column (sel_receipts, 7, p_prv_cash_receipt_hist_id);
1995: dbms_sql.define_column (sel_receipts, 8, p_exchange_date);
1996: dbms_sql.define_column (sel_receipts, 9, p_exchange_rate);
1997: dbms_sql.define_column (sel_receipts, 10, p_exchange_type,30);
1998: dbms_sql.define_column (sel_receipts, 11, p_cr_amount);
1999: dbms_sql.define_column (sel_receipts, 12, p_cr_acctd_amount);
2000: dbms_sql.define_column (sel_receipts, 13, p_cr_factor_discount_amount);
2001: dbms_sql.define_column (sel_receipts, 14, p_remmitance_ccid );
2002: dbms_sql.define_column (sel_receipts, 15, p_bank_charges_ccid);

Line 1999: dbms_sql.define_column (sel_receipts, 12, p_cr_acctd_amount);

1995: dbms_sql.define_column (sel_receipts, 8, p_exchange_date);
1996: dbms_sql.define_column (sel_receipts, 9, p_exchange_rate);
1997: dbms_sql.define_column (sel_receipts, 10, p_exchange_type,30);
1998: dbms_sql.define_column (sel_receipts, 11, p_cr_amount);
1999: dbms_sql.define_column (sel_receipts, 12, p_cr_acctd_amount);
2000: dbms_sql.define_column (sel_receipts, 13, p_cr_factor_discount_amount);
2001: dbms_sql.define_column (sel_receipts, 14, p_remmitance_ccid );
2002: dbms_sql.define_column (sel_receipts, 15, p_bank_charges_ccid);
2003: dbms_sql.define_column (sel_receipts, 16, p_code_combination_id);

Line 2000: dbms_sql.define_column (sel_receipts, 13, p_cr_factor_discount_amount);

1996: dbms_sql.define_column (sel_receipts, 9, p_exchange_rate);
1997: dbms_sql.define_column (sel_receipts, 10, p_exchange_type,30);
1998: dbms_sql.define_column (sel_receipts, 11, p_cr_amount);
1999: dbms_sql.define_column (sel_receipts, 12, p_cr_acctd_amount);
2000: dbms_sql.define_column (sel_receipts, 13, p_cr_factor_discount_amount);
2001: dbms_sql.define_column (sel_receipts, 14, p_remmitance_ccid );
2002: dbms_sql.define_column (sel_receipts, 15, p_bank_charges_ccid);
2003: dbms_sql.define_column (sel_receipts, 16, p_code_combination_id);
2004: dbms_sql.define_column (sel_receipts, 17, p_cash_receipt_history_id);

Line 2001: dbms_sql.define_column (sel_receipts, 14, p_remmitance_ccid );

1997: dbms_sql.define_column (sel_receipts, 10, p_exchange_type,30);
1998: dbms_sql.define_column (sel_receipts, 11, p_cr_amount);
1999: dbms_sql.define_column (sel_receipts, 12, p_cr_acctd_amount);
2000: dbms_sql.define_column (sel_receipts, 13, p_cr_factor_discount_amount);
2001: dbms_sql.define_column (sel_receipts, 14, p_remmitance_ccid );
2002: dbms_sql.define_column (sel_receipts, 15, p_bank_charges_ccid);
2003: dbms_sql.define_column (sel_receipts, 16, p_code_combination_id);
2004: dbms_sql.define_column (sel_receipts, 17, p_cash_receipt_history_id);
2005: dbms_sql.define_column (sel_receipts, 18, p_crh_gl_date);

Line 2002: dbms_sql.define_column (sel_receipts, 15, p_bank_charges_ccid);

1998: dbms_sql.define_column (sel_receipts, 11, p_cr_amount);
1999: dbms_sql.define_column (sel_receipts, 12, p_cr_acctd_amount);
2000: dbms_sql.define_column (sel_receipts, 13, p_cr_factor_discount_amount);
2001: dbms_sql.define_column (sel_receipts, 14, p_remmitance_ccid );
2002: dbms_sql.define_column (sel_receipts, 15, p_bank_charges_ccid);
2003: dbms_sql.define_column (sel_receipts, 16, p_code_combination_id);
2004: dbms_sql.define_column (sel_receipts, 17, p_cash_receipt_history_id);
2005: dbms_sql.define_column (sel_receipts, 18, p_crh_gl_date);
2006: dbms_sql.define_column (sel_receipts, 19, p_crh_trx_date);

Line 2003: dbms_sql.define_column (sel_receipts, 16, p_code_combination_id);

1999: dbms_sql.define_column (sel_receipts, 12, p_cr_acctd_amount);
2000: dbms_sql.define_column (sel_receipts, 13, p_cr_factor_discount_amount);
2001: dbms_sql.define_column (sel_receipts, 14, p_remmitance_ccid );
2002: dbms_sql.define_column (sel_receipts, 15, p_bank_charges_ccid);
2003: dbms_sql.define_column (sel_receipts, 16, p_code_combination_id);
2004: dbms_sql.define_column (sel_receipts, 17, p_cash_receipt_history_id);
2005: dbms_sql.define_column (sel_receipts, 18, p_crh_gl_date);
2006: dbms_sql.define_column (sel_receipts, 19, p_crh_trx_date);
2007: dbms_sql.define_column (sel_receipts, 20, p_payment_server_order_num,80);

Line 2004: dbms_sql.define_column (sel_receipts, 17, p_cash_receipt_history_id);

2000: dbms_sql.define_column (sel_receipts, 13, p_cr_factor_discount_amount);
2001: dbms_sql.define_column (sel_receipts, 14, p_remmitance_ccid );
2002: dbms_sql.define_column (sel_receipts, 15, p_bank_charges_ccid);
2003: dbms_sql.define_column (sel_receipts, 16, p_code_combination_id);
2004: dbms_sql.define_column (sel_receipts, 17, p_cash_receipt_history_id);
2005: dbms_sql.define_column (sel_receipts, 18, p_crh_gl_date);
2006: dbms_sql.define_column (sel_receipts, 19, p_crh_trx_date);
2007: dbms_sql.define_column (sel_receipts, 20, p_payment_server_order_num,80);
2008: dbms_sql.define_column (sel_receipts, 21, p_approval_code,80);

Line 2005: dbms_sql.define_column (sel_receipts, 18, p_crh_gl_date);

2001: dbms_sql.define_column (sel_receipts, 14, p_remmitance_ccid );
2002: dbms_sql.define_column (sel_receipts, 15, p_bank_charges_ccid);
2003: dbms_sql.define_column (sel_receipts, 16, p_code_combination_id);
2004: dbms_sql.define_column (sel_receipts, 17, p_cash_receipt_history_id);
2005: dbms_sql.define_column (sel_receipts, 18, p_crh_gl_date);
2006: dbms_sql.define_column (sel_receipts, 19, p_crh_trx_date);
2007: dbms_sql.define_column (sel_receipts, 20, p_payment_server_order_num,80);
2008: dbms_sql.define_column (sel_receipts, 21, p_approval_code,80);
2009: dbms_sql.define_column (sel_receipts, 22, p_receipt_number,30);

Line 2006: dbms_sql.define_column (sel_receipts, 19, p_crh_trx_date);

2002: dbms_sql.define_column (sel_receipts, 15, p_bank_charges_ccid);
2003: dbms_sql.define_column (sel_receipts, 16, p_code_combination_id);
2004: dbms_sql.define_column (sel_receipts, 17, p_cash_receipt_history_id);
2005: dbms_sql.define_column (sel_receipts, 18, p_crh_gl_date);
2006: dbms_sql.define_column (sel_receipts, 19, p_crh_trx_date);
2007: dbms_sql.define_column (sel_receipts, 20, p_payment_server_order_num,80);
2008: dbms_sql.define_column (sel_receipts, 21, p_approval_code,80);
2009: dbms_sql.define_column (sel_receipts, 22, p_receipt_number,30);
2010: dbms_sql.define_column (sel_receipts, 23, p_unique_ref,32);

Line 2007: dbms_sql.define_column (sel_receipts, 20, p_payment_server_order_num,80);

2003: dbms_sql.define_column (sel_receipts, 16, p_code_combination_id);
2004: dbms_sql.define_column (sel_receipts, 17, p_cash_receipt_history_id);
2005: dbms_sql.define_column (sel_receipts, 18, p_crh_gl_date);
2006: dbms_sql.define_column (sel_receipts, 19, p_crh_trx_date);
2007: dbms_sql.define_column (sel_receipts, 20, p_payment_server_order_num,80);
2008: dbms_sql.define_column (sel_receipts, 21, p_approval_code,80);
2009: dbms_sql.define_column (sel_receipts, 22, p_receipt_number,30);
2010: dbms_sql.define_column (sel_receipts, 23, p_unique_ref,32);
2011: dbms_sql.define_column (sel_receipts, 24, p_customer_bank_account_id);

Line 2008: dbms_sql.define_column (sel_receipts, 21, p_approval_code,80);

2004: dbms_sql.define_column (sel_receipts, 17, p_cash_receipt_history_id);
2005: dbms_sql.define_column (sel_receipts, 18, p_crh_gl_date);
2006: dbms_sql.define_column (sel_receipts, 19, p_crh_trx_date);
2007: dbms_sql.define_column (sel_receipts, 20, p_payment_server_order_num,80);
2008: dbms_sql.define_column (sel_receipts, 21, p_approval_code,80);
2009: dbms_sql.define_column (sel_receipts, 22, p_receipt_number,30);
2010: dbms_sql.define_column (sel_receipts, 23, p_unique_ref,32);
2011: dbms_sql.define_column (sel_receipts, 24, p_customer_bank_account_id);
2012: dbms_sql.define_column (sel_receipts, 25, p_payment_trxn_extension_id);

Line 2009: dbms_sql.define_column (sel_receipts, 22, p_receipt_number,30);

2005: dbms_sql.define_column (sel_receipts, 18, p_crh_gl_date);
2006: dbms_sql.define_column (sel_receipts, 19, p_crh_trx_date);
2007: dbms_sql.define_column (sel_receipts, 20, p_payment_server_order_num,80);
2008: dbms_sql.define_column (sel_receipts, 21, p_approval_code,80);
2009: dbms_sql.define_column (sel_receipts, 22, p_receipt_number,30);
2010: dbms_sql.define_column (sel_receipts, 23, p_unique_ref,32);
2011: dbms_sql.define_column (sel_receipts, 24, p_customer_bank_account_id);
2012: dbms_sql.define_column (sel_receipts, 25, p_payment_trxn_extension_id);
2013:

Line 2010: dbms_sql.define_column (sel_receipts, 23, p_unique_ref,32);

2006: dbms_sql.define_column (sel_receipts, 19, p_crh_trx_date);
2007: dbms_sql.define_column (sel_receipts, 20, p_payment_server_order_num,80);
2008: dbms_sql.define_column (sel_receipts, 21, p_approval_code,80);
2009: dbms_sql.define_column (sel_receipts, 22, p_receipt_number,30);
2010: dbms_sql.define_column (sel_receipts, 23, p_unique_ref,32);
2011: dbms_sql.define_column (sel_receipts, 24, p_customer_bank_account_id);
2012: dbms_sql.define_column (sel_receipts, 25, p_payment_trxn_extension_id);
2013:
2014: IF PG_DEBUG in ('Y', 'C') THEN

Line 2011: dbms_sql.define_column (sel_receipts, 24, p_customer_bank_account_id);

2007: dbms_sql.define_column (sel_receipts, 20, p_payment_server_order_num,80);
2008: dbms_sql.define_column (sel_receipts, 21, p_approval_code,80);
2009: dbms_sql.define_column (sel_receipts, 22, p_receipt_number,30);
2010: dbms_sql.define_column (sel_receipts, 23, p_unique_ref,32);
2011: dbms_sql.define_column (sel_receipts, 24, p_customer_bank_account_id);
2012: dbms_sql.define_column (sel_receipts, 25, p_payment_trxn_extension_id);
2013:
2014: IF PG_DEBUG in ('Y', 'C') THEN
2015: fnd_file.put_line(FND_FILE.LOG, 'the select statemnt' || l_sel_stmt);

Line 2012: dbms_sql.define_column (sel_receipts, 25, p_payment_trxn_extension_id);

2008: dbms_sql.define_column (sel_receipts, 21, p_approval_code,80);
2009: dbms_sql.define_column (sel_receipts, 22, p_receipt_number,30);
2010: dbms_sql.define_column (sel_receipts, 23, p_unique_ref,32);
2011: dbms_sql.define_column (sel_receipts, 24, p_customer_bank_account_id);
2012: dbms_sql.define_column (sel_receipts, 25, p_payment_trxn_extension_id);
2013:
2014: IF PG_DEBUG in ('Y', 'C') THEN
2015: fnd_file.put_line(FND_FILE.LOG, 'the select statemnt' || l_sel_stmt);
2016: END IF;

Line 2018: l_rows_processed := dbms_sql.execute( sel_receipts);

2014: IF PG_DEBUG in ('Y', 'C') THEN
2015: fnd_file.put_line(FND_FILE.LOG, 'the select statemnt' || l_sel_stmt);
2016: END IF;
2017:
2018: l_rows_processed := dbms_sql.execute( sel_receipts);
2019:
2020: i:= 0;
2021:
2022: WHILE dbms_sql.fetch_rows( sel_receipts) > 0 LOOP

Line 2022: WHILE dbms_sql.fetch_rows( sel_receipts) > 0 LOOP

2018: l_rows_processed := dbms_sql.execute( sel_receipts);
2019:
2020: i:= 0;
2021:
2022: WHILE dbms_sql.fetch_rows( sel_receipts) > 0 LOOP
2023: fnd_file.put_line(FND_FILE.LOG,'the value of i- ent ' || to_char(i));
2024:
2025: dbms_sql.column_value (sel_receipts, 1, p_cash_receipt_id);
2026: dbms_sql.column_value (sel_receipts, 2, p_payment_type_code);

Line 2025: dbms_sql.column_value (sel_receipts, 1, p_cash_receipt_id);

2021:
2022: WHILE dbms_sql.fetch_rows( sel_receipts) > 0 LOOP
2023: fnd_file.put_line(FND_FILE.LOG,'the value of i- ent ' || to_char(i));
2024:
2025: dbms_sql.column_value (sel_receipts, 1, p_cash_receipt_id);
2026: dbms_sql.column_value (sel_receipts, 2, p_payment_type_code);
2027: dbms_sql.column_value (sel_receipts, 3, p_merchant_ref);
2028: dbms_sql.column_value (sel_receipts, 4, p_currency_code);
2029: dbms_sql.column_value (sel_receipts, 5, p_pay_from_customer);

Line 2026: dbms_sql.column_value (sel_receipts, 2, p_payment_type_code);

2022: WHILE dbms_sql.fetch_rows( sel_receipts) > 0 LOOP
2023: fnd_file.put_line(FND_FILE.LOG,'the value of i- ent ' || to_char(i));
2024:
2025: dbms_sql.column_value (sel_receipts, 1, p_cash_receipt_id);
2026: dbms_sql.column_value (sel_receipts, 2, p_payment_type_code);
2027: dbms_sql.column_value (sel_receipts, 3, p_merchant_ref);
2028: dbms_sql.column_value (sel_receipts, 4, p_currency_code);
2029: dbms_sql.column_value (sel_receipts, 5, p_pay_from_customer);
2030: dbms_sql.column_value (sel_receipts, 6, p_customer_site_use_id);

Line 2027: dbms_sql.column_value (sel_receipts, 3, p_merchant_ref);

2023: fnd_file.put_line(FND_FILE.LOG,'the value of i- ent ' || to_char(i));
2024:
2025: dbms_sql.column_value (sel_receipts, 1, p_cash_receipt_id);
2026: dbms_sql.column_value (sel_receipts, 2, p_payment_type_code);
2027: dbms_sql.column_value (sel_receipts, 3, p_merchant_ref);
2028: dbms_sql.column_value (sel_receipts, 4, p_currency_code);
2029: dbms_sql.column_value (sel_receipts, 5, p_pay_from_customer);
2030: dbms_sql.column_value (sel_receipts, 6, p_customer_site_use_id);
2031: dbms_sql.column_value (sel_receipts, 7, p_prv_cash_receipt_hist_id);

Line 2028: dbms_sql.column_value (sel_receipts, 4, p_currency_code);

2024:
2025: dbms_sql.column_value (sel_receipts, 1, p_cash_receipt_id);
2026: dbms_sql.column_value (sel_receipts, 2, p_payment_type_code);
2027: dbms_sql.column_value (sel_receipts, 3, p_merchant_ref);
2028: dbms_sql.column_value (sel_receipts, 4, p_currency_code);
2029: dbms_sql.column_value (sel_receipts, 5, p_pay_from_customer);
2030: dbms_sql.column_value (sel_receipts, 6, p_customer_site_use_id);
2031: dbms_sql.column_value (sel_receipts, 7, p_prv_cash_receipt_hist_id);
2032: dbms_sql.column_value (sel_receipts, 8, p_exchange_date);

Line 2029: dbms_sql.column_value (sel_receipts, 5, p_pay_from_customer);

2025: dbms_sql.column_value (sel_receipts, 1, p_cash_receipt_id);
2026: dbms_sql.column_value (sel_receipts, 2, p_payment_type_code);
2027: dbms_sql.column_value (sel_receipts, 3, p_merchant_ref);
2028: dbms_sql.column_value (sel_receipts, 4, p_currency_code);
2029: dbms_sql.column_value (sel_receipts, 5, p_pay_from_customer);
2030: dbms_sql.column_value (sel_receipts, 6, p_customer_site_use_id);
2031: dbms_sql.column_value (sel_receipts, 7, p_prv_cash_receipt_hist_id);
2032: dbms_sql.column_value (sel_receipts, 8, p_exchange_date);
2033: dbms_sql.column_value (sel_receipts, 9, p_exchange_rate);

Line 2030: dbms_sql.column_value (sel_receipts, 6, p_customer_site_use_id);

2026: dbms_sql.column_value (sel_receipts, 2, p_payment_type_code);
2027: dbms_sql.column_value (sel_receipts, 3, p_merchant_ref);
2028: dbms_sql.column_value (sel_receipts, 4, p_currency_code);
2029: dbms_sql.column_value (sel_receipts, 5, p_pay_from_customer);
2030: dbms_sql.column_value (sel_receipts, 6, p_customer_site_use_id);
2031: dbms_sql.column_value (sel_receipts, 7, p_prv_cash_receipt_hist_id);
2032: dbms_sql.column_value (sel_receipts, 8, p_exchange_date);
2033: dbms_sql.column_value (sel_receipts, 9, p_exchange_rate);
2034: dbms_sql.column_value (sel_receipts, 10, p_exchange_type);

Line 2031: dbms_sql.column_value (sel_receipts, 7, p_prv_cash_receipt_hist_id);

2027: dbms_sql.column_value (sel_receipts, 3, p_merchant_ref);
2028: dbms_sql.column_value (sel_receipts, 4, p_currency_code);
2029: dbms_sql.column_value (sel_receipts, 5, p_pay_from_customer);
2030: dbms_sql.column_value (sel_receipts, 6, p_customer_site_use_id);
2031: dbms_sql.column_value (sel_receipts, 7, p_prv_cash_receipt_hist_id);
2032: dbms_sql.column_value (sel_receipts, 8, p_exchange_date);
2033: dbms_sql.column_value (sel_receipts, 9, p_exchange_rate);
2034: dbms_sql.column_value (sel_receipts, 10, p_exchange_type);
2035: dbms_sql.column_value (sel_receipts, 11, p_cr_amount);

Line 2032: dbms_sql.column_value (sel_receipts, 8, p_exchange_date);

2028: dbms_sql.column_value (sel_receipts, 4, p_currency_code);
2029: dbms_sql.column_value (sel_receipts, 5, p_pay_from_customer);
2030: dbms_sql.column_value (sel_receipts, 6, p_customer_site_use_id);
2031: dbms_sql.column_value (sel_receipts, 7, p_prv_cash_receipt_hist_id);
2032: dbms_sql.column_value (sel_receipts, 8, p_exchange_date);
2033: dbms_sql.column_value (sel_receipts, 9, p_exchange_rate);
2034: dbms_sql.column_value (sel_receipts, 10, p_exchange_type);
2035: dbms_sql.column_value (sel_receipts, 11, p_cr_amount);
2036: dbms_sql.column_value (sel_receipts, 12, p_cr_acctd_amount);

Line 2033: dbms_sql.column_value (sel_receipts, 9, p_exchange_rate);

2029: dbms_sql.column_value (sel_receipts, 5, p_pay_from_customer);
2030: dbms_sql.column_value (sel_receipts, 6, p_customer_site_use_id);
2031: dbms_sql.column_value (sel_receipts, 7, p_prv_cash_receipt_hist_id);
2032: dbms_sql.column_value (sel_receipts, 8, p_exchange_date);
2033: dbms_sql.column_value (sel_receipts, 9, p_exchange_rate);
2034: dbms_sql.column_value (sel_receipts, 10, p_exchange_type);
2035: dbms_sql.column_value (sel_receipts, 11, p_cr_amount);
2036: dbms_sql.column_value (sel_receipts, 12, p_cr_acctd_amount);
2037: dbms_sql.column_value (sel_receipts, 13, p_cr_factor_discount_amount);

Line 2034: dbms_sql.column_value (sel_receipts, 10, p_exchange_type);

2030: dbms_sql.column_value (sel_receipts, 6, p_customer_site_use_id);
2031: dbms_sql.column_value (sel_receipts, 7, p_prv_cash_receipt_hist_id);
2032: dbms_sql.column_value (sel_receipts, 8, p_exchange_date);
2033: dbms_sql.column_value (sel_receipts, 9, p_exchange_rate);
2034: dbms_sql.column_value (sel_receipts, 10, p_exchange_type);
2035: dbms_sql.column_value (sel_receipts, 11, p_cr_amount);
2036: dbms_sql.column_value (sel_receipts, 12, p_cr_acctd_amount);
2037: dbms_sql.column_value (sel_receipts, 13, p_cr_factor_discount_amount);
2038: dbms_sql.column_value (sel_receipts, 14, p_remmitance_ccid );

Line 2035: dbms_sql.column_value (sel_receipts, 11, p_cr_amount);

2031: dbms_sql.column_value (sel_receipts, 7, p_prv_cash_receipt_hist_id);
2032: dbms_sql.column_value (sel_receipts, 8, p_exchange_date);
2033: dbms_sql.column_value (sel_receipts, 9, p_exchange_rate);
2034: dbms_sql.column_value (sel_receipts, 10, p_exchange_type);
2035: dbms_sql.column_value (sel_receipts, 11, p_cr_amount);
2036: dbms_sql.column_value (sel_receipts, 12, p_cr_acctd_amount);
2037: dbms_sql.column_value (sel_receipts, 13, p_cr_factor_discount_amount);
2038: dbms_sql.column_value (sel_receipts, 14, p_remmitance_ccid );
2039: dbms_sql.column_value (sel_receipts, 15, p_bank_charges_ccid);

Line 2036: dbms_sql.column_value (sel_receipts, 12, p_cr_acctd_amount);

2032: dbms_sql.column_value (sel_receipts, 8, p_exchange_date);
2033: dbms_sql.column_value (sel_receipts, 9, p_exchange_rate);
2034: dbms_sql.column_value (sel_receipts, 10, p_exchange_type);
2035: dbms_sql.column_value (sel_receipts, 11, p_cr_amount);
2036: dbms_sql.column_value (sel_receipts, 12, p_cr_acctd_amount);
2037: dbms_sql.column_value (sel_receipts, 13, p_cr_factor_discount_amount);
2038: dbms_sql.column_value (sel_receipts, 14, p_remmitance_ccid );
2039: dbms_sql.column_value (sel_receipts, 15, p_bank_charges_ccid);
2040: dbms_sql.column_value (sel_receipts, 16, p_code_combination_id);

Line 2037: dbms_sql.column_value (sel_receipts, 13, p_cr_factor_discount_amount);

2033: dbms_sql.column_value (sel_receipts, 9, p_exchange_rate);
2034: dbms_sql.column_value (sel_receipts, 10, p_exchange_type);
2035: dbms_sql.column_value (sel_receipts, 11, p_cr_amount);
2036: dbms_sql.column_value (sel_receipts, 12, p_cr_acctd_amount);
2037: dbms_sql.column_value (sel_receipts, 13, p_cr_factor_discount_amount);
2038: dbms_sql.column_value (sel_receipts, 14, p_remmitance_ccid );
2039: dbms_sql.column_value (sel_receipts, 15, p_bank_charges_ccid);
2040: dbms_sql.column_value (sel_receipts, 16, p_code_combination_id);
2041: dbms_sql.column_value (sel_receipts, 17, p_cash_receipt_history_id);

Line 2038: dbms_sql.column_value (sel_receipts, 14, p_remmitance_ccid );

2034: dbms_sql.column_value (sel_receipts, 10, p_exchange_type);
2035: dbms_sql.column_value (sel_receipts, 11, p_cr_amount);
2036: dbms_sql.column_value (sel_receipts, 12, p_cr_acctd_amount);
2037: dbms_sql.column_value (sel_receipts, 13, p_cr_factor_discount_amount);
2038: dbms_sql.column_value (sel_receipts, 14, p_remmitance_ccid );
2039: dbms_sql.column_value (sel_receipts, 15, p_bank_charges_ccid);
2040: dbms_sql.column_value (sel_receipts, 16, p_code_combination_id);
2041: dbms_sql.column_value (sel_receipts, 17, p_cash_receipt_history_id);
2042: dbms_sql.column_value (sel_receipts, 18, p_crh_gl_date);

Line 2039: dbms_sql.column_value (sel_receipts, 15, p_bank_charges_ccid);

2035: dbms_sql.column_value (sel_receipts, 11, p_cr_amount);
2036: dbms_sql.column_value (sel_receipts, 12, p_cr_acctd_amount);
2037: dbms_sql.column_value (sel_receipts, 13, p_cr_factor_discount_amount);
2038: dbms_sql.column_value (sel_receipts, 14, p_remmitance_ccid );
2039: dbms_sql.column_value (sel_receipts, 15, p_bank_charges_ccid);
2040: dbms_sql.column_value (sel_receipts, 16, p_code_combination_id);
2041: dbms_sql.column_value (sel_receipts, 17, p_cash_receipt_history_id);
2042: dbms_sql.column_value (sel_receipts, 18, p_crh_gl_date);
2043: dbms_sql.column_value (sel_receipts, 19, p_crh_trx_date);

Line 2040: dbms_sql.column_value (sel_receipts, 16, p_code_combination_id);

2036: dbms_sql.column_value (sel_receipts, 12, p_cr_acctd_amount);
2037: dbms_sql.column_value (sel_receipts, 13, p_cr_factor_discount_amount);
2038: dbms_sql.column_value (sel_receipts, 14, p_remmitance_ccid );
2039: dbms_sql.column_value (sel_receipts, 15, p_bank_charges_ccid);
2040: dbms_sql.column_value (sel_receipts, 16, p_code_combination_id);
2041: dbms_sql.column_value (sel_receipts, 17, p_cash_receipt_history_id);
2042: dbms_sql.column_value (sel_receipts, 18, p_crh_gl_date);
2043: dbms_sql.column_value (sel_receipts, 19, p_crh_trx_date);
2044: dbms_sql.column_value (sel_receipts, 20, p_payment_server_order_num);

Line 2041: dbms_sql.column_value (sel_receipts, 17, p_cash_receipt_history_id);

2037: dbms_sql.column_value (sel_receipts, 13, p_cr_factor_discount_amount);
2038: dbms_sql.column_value (sel_receipts, 14, p_remmitance_ccid );
2039: dbms_sql.column_value (sel_receipts, 15, p_bank_charges_ccid);
2040: dbms_sql.column_value (sel_receipts, 16, p_code_combination_id);
2041: dbms_sql.column_value (sel_receipts, 17, p_cash_receipt_history_id);
2042: dbms_sql.column_value (sel_receipts, 18, p_crh_gl_date);
2043: dbms_sql.column_value (sel_receipts, 19, p_crh_trx_date);
2044: dbms_sql.column_value (sel_receipts, 20, p_payment_server_order_num);
2045: dbms_sql.column_value (sel_receipts, 21, p_approval_code);

Line 2042: dbms_sql.column_value (sel_receipts, 18, p_crh_gl_date);

2038: dbms_sql.column_value (sel_receipts, 14, p_remmitance_ccid );
2039: dbms_sql.column_value (sel_receipts, 15, p_bank_charges_ccid);
2040: dbms_sql.column_value (sel_receipts, 16, p_code_combination_id);
2041: dbms_sql.column_value (sel_receipts, 17, p_cash_receipt_history_id);
2042: dbms_sql.column_value (sel_receipts, 18, p_crh_gl_date);
2043: dbms_sql.column_value (sel_receipts, 19, p_crh_trx_date);
2044: dbms_sql.column_value (sel_receipts, 20, p_payment_server_order_num);
2045: dbms_sql.column_value (sel_receipts, 21, p_approval_code);
2046: dbms_sql.column_value (sel_receipts, 22, p_receipt_number);

Line 2043: dbms_sql.column_value (sel_receipts, 19, p_crh_trx_date);

2039: dbms_sql.column_value (sel_receipts, 15, p_bank_charges_ccid);
2040: dbms_sql.column_value (sel_receipts, 16, p_code_combination_id);
2041: dbms_sql.column_value (sel_receipts, 17, p_cash_receipt_history_id);
2042: dbms_sql.column_value (sel_receipts, 18, p_crh_gl_date);
2043: dbms_sql.column_value (sel_receipts, 19, p_crh_trx_date);
2044: dbms_sql.column_value (sel_receipts, 20, p_payment_server_order_num);
2045: dbms_sql.column_value (sel_receipts, 21, p_approval_code);
2046: dbms_sql.column_value (sel_receipts, 22, p_receipt_number);
2047: dbms_sql.column_value (sel_receipts, 23, p_unique_ref);

Line 2044: dbms_sql.column_value (sel_receipts, 20, p_payment_server_order_num);

2040: dbms_sql.column_value (sel_receipts, 16, p_code_combination_id);
2041: dbms_sql.column_value (sel_receipts, 17, p_cash_receipt_history_id);
2042: dbms_sql.column_value (sel_receipts, 18, p_crh_gl_date);
2043: dbms_sql.column_value (sel_receipts, 19, p_crh_trx_date);
2044: dbms_sql.column_value (sel_receipts, 20, p_payment_server_order_num);
2045: dbms_sql.column_value (sel_receipts, 21, p_approval_code);
2046: dbms_sql.column_value (sel_receipts, 22, p_receipt_number);
2047: dbms_sql.column_value (sel_receipts, 23, p_unique_ref);
2048: dbms_sql.column_value (sel_receipts, 24, p_customer_bank_account_id);

Line 2045: dbms_sql.column_value (sel_receipts, 21, p_approval_code);

2041: dbms_sql.column_value (sel_receipts, 17, p_cash_receipt_history_id);
2042: dbms_sql.column_value (sel_receipts, 18, p_crh_gl_date);
2043: dbms_sql.column_value (sel_receipts, 19, p_crh_trx_date);
2044: dbms_sql.column_value (sel_receipts, 20, p_payment_server_order_num);
2045: dbms_sql.column_value (sel_receipts, 21, p_approval_code);
2046: dbms_sql.column_value (sel_receipts, 22, p_receipt_number);
2047: dbms_sql.column_value (sel_receipts, 23, p_unique_ref);
2048: dbms_sql.column_value (sel_receipts, 24, p_customer_bank_account_id);
2049: dbms_sql.column_value (sel_receipts, 25, p_payment_trxn_extension_id);

Line 2046: dbms_sql.column_value (sel_receipts, 22, p_receipt_number);

2042: dbms_sql.column_value (sel_receipts, 18, p_crh_gl_date);
2043: dbms_sql.column_value (sel_receipts, 19, p_crh_trx_date);
2044: dbms_sql.column_value (sel_receipts, 20, p_payment_server_order_num);
2045: dbms_sql.column_value (sel_receipts, 21, p_approval_code);
2046: dbms_sql.column_value (sel_receipts, 22, p_receipt_number);
2047: dbms_sql.column_value (sel_receipts, 23, p_unique_ref);
2048: dbms_sql.column_value (sel_receipts, 24, p_customer_bank_account_id);
2049: dbms_sql.column_value (sel_receipts, 25, p_payment_trxn_extension_id);
2050:

Line 2047: dbms_sql.column_value (sel_receipts, 23, p_unique_ref);

2043: dbms_sql.column_value (sel_receipts, 19, p_crh_trx_date);
2044: dbms_sql.column_value (sel_receipts, 20, p_payment_server_order_num);
2045: dbms_sql.column_value (sel_receipts, 21, p_approval_code);
2046: dbms_sql.column_value (sel_receipts, 22, p_receipt_number);
2047: dbms_sql.column_value (sel_receipts, 23, p_unique_ref);
2048: dbms_sql.column_value (sel_receipts, 24, p_customer_bank_account_id);
2049: dbms_sql.column_value (sel_receipts, 25, p_payment_trxn_extension_id);
2050:
2051:

Line 2048: dbms_sql.column_value (sel_receipts, 24, p_customer_bank_account_id);

2044: dbms_sql.column_value (sel_receipts, 20, p_payment_server_order_num);
2045: dbms_sql.column_value (sel_receipts, 21, p_approval_code);
2046: dbms_sql.column_value (sel_receipts, 22, p_receipt_number);
2047: dbms_sql.column_value (sel_receipts, 23, p_unique_ref);
2048: dbms_sql.column_value (sel_receipts, 24, p_customer_bank_account_id);
2049: dbms_sql.column_value (sel_receipts, 25, p_payment_trxn_extension_id);
2050:
2051:
2052:

Line 2049: dbms_sql.column_value (sel_receipts, 25, p_payment_trxn_extension_id);

2045: dbms_sql.column_value (sel_receipts, 21, p_approval_code);
2046: dbms_sql.column_value (sel_receipts, 22, p_receipt_number);
2047: dbms_sql.column_value (sel_receipts, 23, p_unique_ref);
2048: dbms_sql.column_value (sel_receipts, 24, p_customer_bank_account_id);
2049: dbms_sql.column_value (sel_receipts, 25, p_payment_trxn_extension_id);
2050:
2051:
2052:
2053: IF PG_DEBUG in ( 'Y','C') THEN

Line 2093: l_rows_fetched := dbms_sql.last_row_count ;

2089: END IF;
2090:
2091: END LOOP;
2092:
2093: l_rows_fetched := dbms_sql.last_row_count ;
2094:
2095: IF PG_DEBUG in ('Y', 'C') THEN
2096: fnd_file.put_line(FND_FILE.LOG,'the no of rows fetched ' || l_rows_fetched);
2097: END IF;

Line 2099: dbms_sql.close_cursor( sel_receipts);

2095: IF PG_DEBUG in ('Y', 'C') THEN
2096: fnd_file.put_line(FND_FILE.LOG,'the no of rows fetched ' || l_rows_fetched);
2097: END IF;
2098:
2099: dbms_sql.close_cursor( sel_receipts);
2100:
2101: IF PG_DEBUG in ('Y', 'C') THEN
2102: fnd_file.put_line(FND_FILE.LOG,'selrem and create and upd 1()-');
2103: END IF;

Line 2116: rem_t := dbms_sql.open_cursor;

2112: :c6_array,:c7_array,:c8_array,:c9_array,:c10_array,:c11_array,:c12_array,
2113: :c13_array,:c14_array,:c15_array,:c16_array,:c17_array,:c18_array,
2114: :c19_array,:c20_array,:c21_array,:c22_array,:c23_array,:c24_array,:c25_array)';
2115:
2116: rem_t := dbms_sql.open_cursor;
2117:
2118: dbms_sql.parse (rem_t,inst_stmt,dbms_sql.v7);
2119:
2120: dbms_sql.bind_array (rem_t,':c1_array',cash_receipt_id_array);

Line 2118: dbms_sql.parse (rem_t,inst_stmt,dbms_sql.v7);

2114: :c19_array,:c20_array,:c21_array,:c22_array,:c23_array,:c24_array,:c25_array)';
2115:
2116: rem_t := dbms_sql.open_cursor;
2117:
2118: dbms_sql.parse (rem_t,inst_stmt,dbms_sql.v7);
2119:
2120: dbms_sql.bind_array (rem_t,':c1_array',cash_receipt_id_array);
2121: dbms_sql.bind_array (rem_t,':c2_array',payment_type_CODE_array);
2122: dbms_sql.bind_array (rem_t,':c3_array',merchant_ref_array);

Line 2120: dbms_sql.bind_array (rem_t,':c1_array',cash_receipt_id_array);

2116: rem_t := dbms_sql.open_cursor;
2117:
2118: dbms_sql.parse (rem_t,inst_stmt,dbms_sql.v7);
2119:
2120: dbms_sql.bind_array (rem_t,':c1_array',cash_receipt_id_array);
2121: dbms_sql.bind_array (rem_t,':c2_array',payment_type_CODE_array);
2122: dbms_sql.bind_array (rem_t,':c3_array',merchant_ref_array);
2123: dbms_sql.bind_array (rem_t,':c4_array',currency_code_array);
2124: dbms_sql.bind_array (rem_t,':c5_array',pay_from_customer_array);

Line 2121: dbms_sql.bind_array (rem_t,':c2_array',payment_type_CODE_array);

2117:
2118: dbms_sql.parse (rem_t,inst_stmt,dbms_sql.v7);
2119:
2120: dbms_sql.bind_array (rem_t,':c1_array',cash_receipt_id_array);
2121: dbms_sql.bind_array (rem_t,':c2_array',payment_type_CODE_array);
2122: dbms_sql.bind_array (rem_t,':c3_array',merchant_ref_array);
2123: dbms_sql.bind_array (rem_t,':c4_array',currency_code_array);
2124: dbms_sql.bind_array (rem_t,':c5_array',pay_from_customer_array);
2125: dbms_sql.bind_array (rem_t,':c6_array',customer_site_use_id_array);

Line 2122: dbms_sql.bind_array (rem_t,':c3_array',merchant_ref_array);

2118: dbms_sql.parse (rem_t,inst_stmt,dbms_sql.v7);
2119:
2120: dbms_sql.bind_array (rem_t,':c1_array',cash_receipt_id_array);
2121: dbms_sql.bind_array (rem_t,':c2_array',payment_type_CODE_array);
2122: dbms_sql.bind_array (rem_t,':c3_array',merchant_ref_array);
2123: dbms_sql.bind_array (rem_t,':c4_array',currency_code_array);
2124: dbms_sql.bind_array (rem_t,':c5_array',pay_from_customer_array);
2125: dbms_sql.bind_array (rem_t,':c6_array',customer_site_use_id_array);
2126: dbms_sql.bind_array (rem_t,':c7_array',prv_cash_receipt_hist_id_array);

Line 2123: dbms_sql.bind_array (rem_t,':c4_array',currency_code_array);

2119:
2120: dbms_sql.bind_array (rem_t,':c1_array',cash_receipt_id_array);
2121: dbms_sql.bind_array (rem_t,':c2_array',payment_type_CODE_array);
2122: dbms_sql.bind_array (rem_t,':c3_array',merchant_ref_array);
2123: dbms_sql.bind_array (rem_t,':c4_array',currency_code_array);
2124: dbms_sql.bind_array (rem_t,':c5_array',pay_from_customer_array);
2125: dbms_sql.bind_array (rem_t,':c6_array',customer_site_use_id_array);
2126: dbms_sql.bind_array (rem_t,':c7_array',prv_cash_receipt_hist_id_array);
2127: dbms_sql.bind_array (rem_t,':c8_array',exchange_date_array);

Line 2124: dbms_sql.bind_array (rem_t,':c5_array',pay_from_customer_array);

2120: dbms_sql.bind_array (rem_t,':c1_array',cash_receipt_id_array);
2121: dbms_sql.bind_array (rem_t,':c2_array',payment_type_CODE_array);
2122: dbms_sql.bind_array (rem_t,':c3_array',merchant_ref_array);
2123: dbms_sql.bind_array (rem_t,':c4_array',currency_code_array);
2124: dbms_sql.bind_array (rem_t,':c5_array',pay_from_customer_array);
2125: dbms_sql.bind_array (rem_t,':c6_array',customer_site_use_id_array);
2126: dbms_sql.bind_array (rem_t,':c7_array',prv_cash_receipt_hist_id_array);
2127: dbms_sql.bind_array (rem_t,':c8_array',exchange_date_array);
2128: dbms_sql.bind_array (rem_t,':c9_array',exchange_rate_array);

Line 2125: dbms_sql.bind_array (rem_t,':c6_array',customer_site_use_id_array);

2121: dbms_sql.bind_array (rem_t,':c2_array',payment_type_CODE_array);
2122: dbms_sql.bind_array (rem_t,':c3_array',merchant_ref_array);
2123: dbms_sql.bind_array (rem_t,':c4_array',currency_code_array);
2124: dbms_sql.bind_array (rem_t,':c5_array',pay_from_customer_array);
2125: dbms_sql.bind_array (rem_t,':c6_array',customer_site_use_id_array);
2126: dbms_sql.bind_array (rem_t,':c7_array',prv_cash_receipt_hist_id_array);
2127: dbms_sql.bind_array (rem_t,':c8_array',exchange_date_array);
2128: dbms_sql.bind_array (rem_t,':c9_array',exchange_rate_array);
2129: dbms_sql.bind_array (rem_t,':c10_array',exchange_type_array);

Line 2126: dbms_sql.bind_array (rem_t,':c7_array',prv_cash_receipt_hist_id_array);

2122: dbms_sql.bind_array (rem_t,':c3_array',merchant_ref_array);
2123: dbms_sql.bind_array (rem_t,':c4_array',currency_code_array);
2124: dbms_sql.bind_array (rem_t,':c5_array',pay_from_customer_array);
2125: dbms_sql.bind_array (rem_t,':c6_array',customer_site_use_id_array);
2126: dbms_sql.bind_array (rem_t,':c7_array',prv_cash_receipt_hist_id_array);
2127: dbms_sql.bind_array (rem_t,':c8_array',exchange_date_array);
2128: dbms_sql.bind_array (rem_t,':c9_array',exchange_rate_array);
2129: dbms_sql.bind_array (rem_t,':c10_array',exchange_type_array);
2130: dbms_sql.bind_array (rem_t,':c11_array',cr_amount_array);

Line 2127: dbms_sql.bind_array (rem_t,':c8_array',exchange_date_array);

2123: dbms_sql.bind_array (rem_t,':c4_array',currency_code_array);
2124: dbms_sql.bind_array (rem_t,':c5_array',pay_from_customer_array);
2125: dbms_sql.bind_array (rem_t,':c6_array',customer_site_use_id_array);
2126: dbms_sql.bind_array (rem_t,':c7_array',prv_cash_receipt_hist_id_array);
2127: dbms_sql.bind_array (rem_t,':c8_array',exchange_date_array);
2128: dbms_sql.bind_array (rem_t,':c9_array',exchange_rate_array);
2129: dbms_sql.bind_array (rem_t,':c10_array',exchange_type_array);
2130: dbms_sql.bind_array (rem_t,':c11_array',cr_amount_array);
2131: dbms_sql.bind_array (rem_t,':c12_array',cr_acctd_amount_array);

Line 2128: dbms_sql.bind_array (rem_t,':c9_array',exchange_rate_array);

2124: dbms_sql.bind_array (rem_t,':c5_array',pay_from_customer_array);
2125: dbms_sql.bind_array (rem_t,':c6_array',customer_site_use_id_array);
2126: dbms_sql.bind_array (rem_t,':c7_array',prv_cash_receipt_hist_id_array);
2127: dbms_sql.bind_array (rem_t,':c8_array',exchange_date_array);
2128: dbms_sql.bind_array (rem_t,':c9_array',exchange_rate_array);
2129: dbms_sql.bind_array (rem_t,':c10_array',exchange_type_array);
2130: dbms_sql.bind_array (rem_t,':c11_array',cr_amount_array);
2131: dbms_sql.bind_array (rem_t,':c12_array',cr_acctd_amount_array);
2132: dbms_sql.bind_array (rem_t,':c13_array',cr_factor_discount_amt_array);

Line 2129: dbms_sql.bind_array (rem_t,':c10_array',exchange_type_array);

2125: dbms_sql.bind_array (rem_t,':c6_array',customer_site_use_id_array);
2126: dbms_sql.bind_array (rem_t,':c7_array',prv_cash_receipt_hist_id_array);
2127: dbms_sql.bind_array (rem_t,':c8_array',exchange_date_array);
2128: dbms_sql.bind_array (rem_t,':c9_array',exchange_rate_array);
2129: dbms_sql.bind_array (rem_t,':c10_array',exchange_type_array);
2130: dbms_sql.bind_array (rem_t,':c11_array',cr_amount_array);
2131: dbms_sql.bind_array (rem_t,':c12_array',cr_acctd_amount_array);
2132: dbms_sql.bind_array (rem_t,':c13_array',cr_factor_discount_amt_array);
2133: dbms_sql.bind_array (rem_t,':c14_array',remmitance_ccid_array);

Line 2130: dbms_sql.bind_array (rem_t,':c11_array',cr_amount_array);

2126: dbms_sql.bind_array (rem_t,':c7_array',prv_cash_receipt_hist_id_array);
2127: dbms_sql.bind_array (rem_t,':c8_array',exchange_date_array);
2128: dbms_sql.bind_array (rem_t,':c9_array',exchange_rate_array);
2129: dbms_sql.bind_array (rem_t,':c10_array',exchange_type_array);
2130: dbms_sql.bind_array (rem_t,':c11_array',cr_amount_array);
2131: dbms_sql.bind_array (rem_t,':c12_array',cr_acctd_amount_array);
2132: dbms_sql.bind_array (rem_t,':c13_array',cr_factor_discount_amt_array);
2133: dbms_sql.bind_array (rem_t,':c14_array',remmitance_ccid_array);
2134: dbms_sql.bind_array (rem_t,':c15_array',bank_charges_ccid_array);

Line 2131: dbms_sql.bind_array (rem_t,':c12_array',cr_acctd_amount_array);

2127: dbms_sql.bind_array (rem_t,':c8_array',exchange_date_array);
2128: dbms_sql.bind_array (rem_t,':c9_array',exchange_rate_array);
2129: dbms_sql.bind_array (rem_t,':c10_array',exchange_type_array);
2130: dbms_sql.bind_array (rem_t,':c11_array',cr_amount_array);
2131: dbms_sql.bind_array (rem_t,':c12_array',cr_acctd_amount_array);
2132: dbms_sql.bind_array (rem_t,':c13_array',cr_factor_discount_amt_array);
2133: dbms_sql.bind_array (rem_t,':c14_array',remmitance_ccid_array);
2134: dbms_sql.bind_array (rem_t,':c15_array',bank_charges_ccid_array);
2135: dbms_sql.bind_array (rem_t,':c16_array',code_combination_id_array);

Line 2132: dbms_sql.bind_array (rem_t,':c13_array',cr_factor_discount_amt_array);

2128: dbms_sql.bind_array (rem_t,':c9_array',exchange_rate_array);
2129: dbms_sql.bind_array (rem_t,':c10_array',exchange_type_array);
2130: dbms_sql.bind_array (rem_t,':c11_array',cr_amount_array);
2131: dbms_sql.bind_array (rem_t,':c12_array',cr_acctd_amount_array);
2132: dbms_sql.bind_array (rem_t,':c13_array',cr_factor_discount_amt_array);
2133: dbms_sql.bind_array (rem_t,':c14_array',remmitance_ccid_array);
2134: dbms_sql.bind_array (rem_t,':c15_array',bank_charges_ccid_array);
2135: dbms_sql.bind_array (rem_t,':c16_array',code_combination_id_array);
2136: dbms_sql.bind_array (rem_t,':c17_array',cash_receipt_history_id_array);

Line 2133: dbms_sql.bind_array (rem_t,':c14_array',remmitance_ccid_array);

2129: dbms_sql.bind_array (rem_t,':c10_array',exchange_type_array);
2130: dbms_sql.bind_array (rem_t,':c11_array',cr_amount_array);
2131: dbms_sql.bind_array (rem_t,':c12_array',cr_acctd_amount_array);
2132: dbms_sql.bind_array (rem_t,':c13_array',cr_factor_discount_amt_array);
2133: dbms_sql.bind_array (rem_t,':c14_array',remmitance_ccid_array);
2134: dbms_sql.bind_array (rem_t,':c15_array',bank_charges_ccid_array);
2135: dbms_sql.bind_array (rem_t,':c16_array',code_combination_id_array);
2136: dbms_sql.bind_array (rem_t,':c17_array',cash_receipt_history_id_array);
2137: dbms_sql.bind_array (rem_t,':c18_array',crh_gl_date_array);

Line 2134: dbms_sql.bind_array (rem_t,':c15_array',bank_charges_ccid_array);

2130: dbms_sql.bind_array (rem_t,':c11_array',cr_amount_array);
2131: dbms_sql.bind_array (rem_t,':c12_array',cr_acctd_amount_array);
2132: dbms_sql.bind_array (rem_t,':c13_array',cr_factor_discount_amt_array);
2133: dbms_sql.bind_array (rem_t,':c14_array',remmitance_ccid_array);
2134: dbms_sql.bind_array (rem_t,':c15_array',bank_charges_ccid_array);
2135: dbms_sql.bind_array (rem_t,':c16_array',code_combination_id_array);
2136: dbms_sql.bind_array (rem_t,':c17_array',cash_receipt_history_id_array);
2137: dbms_sql.bind_array (rem_t,':c18_array',crh_gl_date_array);
2138: dbms_sql.bind_array (rem_t,':c19_array',crh_trx_date_array);

Line 2135: dbms_sql.bind_array (rem_t,':c16_array',code_combination_id_array);

2131: dbms_sql.bind_array (rem_t,':c12_array',cr_acctd_amount_array);
2132: dbms_sql.bind_array (rem_t,':c13_array',cr_factor_discount_amt_array);
2133: dbms_sql.bind_array (rem_t,':c14_array',remmitance_ccid_array);
2134: dbms_sql.bind_array (rem_t,':c15_array',bank_charges_ccid_array);
2135: dbms_sql.bind_array (rem_t,':c16_array',code_combination_id_array);
2136: dbms_sql.bind_array (rem_t,':c17_array',cash_receipt_history_id_array);
2137: dbms_sql.bind_array (rem_t,':c18_array',crh_gl_date_array);
2138: dbms_sql.bind_array (rem_t,':c19_array',crh_trx_date_array);
2139: dbms_sql.bind_array (rem_t,':c20_array',payment_server_order_num_array);

Line 2136: dbms_sql.bind_array (rem_t,':c17_array',cash_receipt_history_id_array);

2132: dbms_sql.bind_array (rem_t,':c13_array',cr_factor_discount_amt_array);
2133: dbms_sql.bind_array (rem_t,':c14_array',remmitance_ccid_array);
2134: dbms_sql.bind_array (rem_t,':c15_array',bank_charges_ccid_array);
2135: dbms_sql.bind_array (rem_t,':c16_array',code_combination_id_array);
2136: dbms_sql.bind_array (rem_t,':c17_array',cash_receipt_history_id_array);
2137: dbms_sql.bind_array (rem_t,':c18_array',crh_gl_date_array);
2138: dbms_sql.bind_array (rem_t,':c19_array',crh_trx_date_array);
2139: dbms_sql.bind_array (rem_t,':c20_array',payment_server_order_num_array);
2140: dbms_sql.bind_array (rem_t,':c21_array',approval_code_array);

Line 2137: dbms_sql.bind_array (rem_t,':c18_array',crh_gl_date_array);

2133: dbms_sql.bind_array (rem_t,':c14_array',remmitance_ccid_array);
2134: dbms_sql.bind_array (rem_t,':c15_array',bank_charges_ccid_array);
2135: dbms_sql.bind_array (rem_t,':c16_array',code_combination_id_array);
2136: dbms_sql.bind_array (rem_t,':c17_array',cash_receipt_history_id_array);
2137: dbms_sql.bind_array (rem_t,':c18_array',crh_gl_date_array);
2138: dbms_sql.bind_array (rem_t,':c19_array',crh_trx_date_array);
2139: dbms_sql.bind_array (rem_t,':c20_array',payment_server_order_num_array);
2140: dbms_sql.bind_array (rem_t,':c21_array',approval_code_array);
2141: dbms_sql.bind_array (rem_t,':c22_array',receipt_number_array);

Line 2138: dbms_sql.bind_array (rem_t,':c19_array',crh_trx_date_array);

2134: dbms_sql.bind_array (rem_t,':c15_array',bank_charges_ccid_array);
2135: dbms_sql.bind_array (rem_t,':c16_array',code_combination_id_array);
2136: dbms_sql.bind_array (rem_t,':c17_array',cash_receipt_history_id_array);
2137: dbms_sql.bind_array (rem_t,':c18_array',crh_gl_date_array);
2138: dbms_sql.bind_array (rem_t,':c19_array',crh_trx_date_array);
2139: dbms_sql.bind_array (rem_t,':c20_array',payment_server_order_num_array);
2140: dbms_sql.bind_array (rem_t,':c21_array',approval_code_array);
2141: dbms_sql.bind_array (rem_t,':c22_array',receipt_number_array);
2142: dbms_sql.bind_array (rem_t,':c23_array',unique_ref_array);

Line 2139: dbms_sql.bind_array (rem_t,':c20_array',payment_server_order_num_array);

2135: dbms_sql.bind_array (rem_t,':c16_array',code_combination_id_array);
2136: dbms_sql.bind_array (rem_t,':c17_array',cash_receipt_history_id_array);
2137: dbms_sql.bind_array (rem_t,':c18_array',crh_gl_date_array);
2138: dbms_sql.bind_array (rem_t,':c19_array',crh_trx_date_array);
2139: dbms_sql.bind_array (rem_t,':c20_array',payment_server_order_num_array);
2140: dbms_sql.bind_array (rem_t,':c21_array',approval_code_array);
2141: dbms_sql.bind_array (rem_t,':c22_array',receipt_number_array);
2142: dbms_sql.bind_array (rem_t,':c23_array',unique_ref_array);
2143: dbms_sql.bind_array (rem_t,':c24_array',customer_bank_account_id_array);

Line 2140: dbms_sql.bind_array (rem_t,':c21_array',approval_code_array);

2136: dbms_sql.bind_array (rem_t,':c17_array',cash_receipt_history_id_array);
2137: dbms_sql.bind_array (rem_t,':c18_array',crh_gl_date_array);
2138: dbms_sql.bind_array (rem_t,':c19_array',crh_trx_date_array);
2139: dbms_sql.bind_array (rem_t,':c20_array',payment_server_order_num_array);
2140: dbms_sql.bind_array (rem_t,':c21_array',approval_code_array);
2141: dbms_sql.bind_array (rem_t,':c22_array',receipt_number_array);
2142: dbms_sql.bind_array (rem_t,':c23_array',unique_ref_array);
2143: dbms_sql.bind_array (rem_t,':c24_array',customer_bank_account_id_array);
2144: dbms_sql.bind_array (rem_t,':c25_array',payment_trxn_extn_id_array);

Line 2141: dbms_sql.bind_array (rem_t,':c22_array',receipt_number_array);

2137: dbms_sql.bind_array (rem_t,':c18_array',crh_gl_date_array);
2138: dbms_sql.bind_array (rem_t,':c19_array',crh_trx_date_array);
2139: dbms_sql.bind_array (rem_t,':c20_array',payment_server_order_num_array);
2140: dbms_sql.bind_array (rem_t,':c21_array',approval_code_array);
2141: dbms_sql.bind_array (rem_t,':c22_array',receipt_number_array);
2142: dbms_sql.bind_array (rem_t,':c23_array',unique_ref_array);
2143: dbms_sql.bind_array (rem_t,':c24_array',customer_bank_account_id_array);
2144: dbms_sql.bind_array (rem_t,':c25_array',payment_trxn_extn_id_array);
2145:

Line 2142: dbms_sql.bind_array (rem_t,':c23_array',unique_ref_array);

2138: dbms_sql.bind_array (rem_t,':c19_array',crh_trx_date_array);
2139: dbms_sql.bind_array (rem_t,':c20_array',payment_server_order_num_array);
2140: dbms_sql.bind_array (rem_t,':c21_array',approval_code_array);
2141: dbms_sql.bind_array (rem_t,':c22_array',receipt_number_array);
2142: dbms_sql.bind_array (rem_t,':c23_array',unique_ref_array);
2143: dbms_sql.bind_array (rem_t,':c24_array',customer_bank_account_id_array);
2144: dbms_sql.bind_array (rem_t,':c25_array',payment_trxn_extn_id_array);
2145:
2146:

Line 2143: dbms_sql.bind_array (rem_t,':c24_array',customer_bank_account_id_array);

2139: dbms_sql.bind_array (rem_t,':c20_array',payment_server_order_num_array);
2140: dbms_sql.bind_array (rem_t,':c21_array',approval_code_array);
2141: dbms_sql.bind_array (rem_t,':c22_array',receipt_number_array);
2142: dbms_sql.bind_array (rem_t,':c23_array',unique_ref_array);
2143: dbms_sql.bind_array (rem_t,':c24_array',customer_bank_account_id_array);
2144: dbms_sql.bind_array (rem_t,':c25_array',payment_trxn_extn_id_array);
2145:
2146:
2147: dummy := dbms_sql.execute(rem_t);

Line 2144: dbms_sql.bind_array (rem_t,':c25_array',payment_trxn_extn_id_array);

2140: dbms_sql.bind_array (rem_t,':c21_array',approval_code_array);
2141: dbms_sql.bind_array (rem_t,':c22_array',receipt_number_array);
2142: dbms_sql.bind_array (rem_t,':c23_array',unique_ref_array);
2143: dbms_sql.bind_array (rem_t,':c24_array',customer_bank_account_id_array);
2144: dbms_sql.bind_array (rem_t,':c25_array',payment_trxn_extn_id_array);
2145:
2146:
2147: dummy := dbms_sql.execute(rem_t);
2148:

Line 2147: dummy := dbms_sql.execute(rem_t);

2143: dbms_sql.bind_array (rem_t,':c24_array',customer_bank_account_id_array);
2144: dbms_sql.bind_array (rem_t,':c25_array',payment_trxn_extn_id_array);
2145:
2146:
2147: dummy := dbms_sql.execute(rem_t);
2148:
2149: dbms_sql.close_cursor(rem_t);
2150:
2151: EXCEPTION WHEN OTHERS THEN

Line 2149: dbms_sql.close_cursor(rem_t);

2145:
2146:
2147: dummy := dbms_sql.execute(rem_t);
2148:
2149: dbms_sql.close_cursor(rem_t);
2150:
2151: EXCEPTION WHEN OTHERS THEN
2152: if dbms_sql.is_open(rem_t) then
2153: dbms_sql.close_cursor(rem_t);

Line 2152: if dbms_sql.is_open(rem_t) then

2148:
2149: dbms_sql.close_cursor(rem_t);
2150:
2151: EXCEPTION WHEN OTHERS THEN
2152: if dbms_sql.is_open(rem_t) then
2153: dbms_sql.close_cursor(rem_t);
2154: end if;
2155: fnd_file.put_line(FND_FILE.LOG,'error code() '|| to_char(SQLCODE));
2156: raise;

Line 2153: dbms_sql.close_cursor(rem_t);

2149: dbms_sql.close_cursor(rem_t);
2150:
2151: EXCEPTION WHEN OTHERS THEN
2152: if dbms_sql.is_open(rem_t) then
2153: dbms_sql.close_cursor(rem_t);
2154: end if;
2155: fnd_file.put_line(FND_FILE.LOG,'error code() '|| to_char(SQLCODE));
2156: raise;
2157:

Line 2190: rem_t1 := dbms_sql.open_cursor;

2186: AND status = ''CONFIRMED''
2187: ';
2188:
2189:
2190: rem_t1 := dbms_sql.open_cursor;
2191:
2192: dbms_sql.parse (rem_t1,upd_stmt1,dbms_sql.v7);
2193:
2194: dbms_sql.bind_array (rem_t1,':ucrh_id_array', cash_receipt_history_id_array);

Line 2192: dbms_sql.parse (rem_t1,upd_stmt1,dbms_sql.v7);

2188:
2189:
2190: rem_t1 := dbms_sql.open_cursor;
2191:
2192: dbms_sql.parse (rem_t1,upd_stmt1,dbms_sql.v7);
2193:
2194: dbms_sql.bind_array (rem_t1,':ucrh_id_array', cash_receipt_history_id_array);
2195: dbms_sql.bind_array (rem_t1,':ucrh_gl_date_array',crh_gl_date_array );
2196: dbms_sql.bind_array (rem_t1,':cr_id_array', cash_receipt_id_array);

Line 2194: dbms_sql.bind_array (rem_t1,':ucrh_id_array', cash_receipt_history_id_array);

2190: rem_t1 := dbms_sql.open_cursor;
2191:
2192: dbms_sql.parse (rem_t1,upd_stmt1,dbms_sql.v7);
2193:
2194: dbms_sql.bind_array (rem_t1,':ucrh_id_array', cash_receipt_history_id_array);
2195: dbms_sql.bind_array (rem_t1,':ucrh_gl_date_array',crh_gl_date_array );
2196: dbms_sql.bind_array (rem_t1,':cr_id_array', cash_receipt_id_array);
2197: /* who cols*/
2198:

Line 2195: dbms_sql.bind_array (rem_t1,':ucrh_gl_date_array',crh_gl_date_array );

2191:
2192: dbms_sql.parse (rem_t1,upd_stmt1,dbms_sql.v7);
2193:
2194: dbms_sql.bind_array (rem_t1,':ucrh_id_array', cash_receipt_history_id_array);
2195: dbms_sql.bind_array (rem_t1,':ucrh_gl_date_array',crh_gl_date_array );
2196: dbms_sql.bind_array (rem_t1,':cr_id_array', cash_receipt_id_array);
2197: /* who cols*/
2198:
2199: dbms_sql.bind_variable (rem_t1,':i_last_updated_by',l_last_updated_by);

Line 2196: dbms_sql.bind_array (rem_t1,':cr_id_array', cash_receipt_id_array);

2192: dbms_sql.parse (rem_t1,upd_stmt1,dbms_sql.v7);
2193:
2194: dbms_sql.bind_array (rem_t1,':ucrh_id_array', cash_receipt_history_id_array);
2195: dbms_sql.bind_array (rem_t1,':ucrh_gl_date_array',crh_gl_date_array );
2196: dbms_sql.bind_array (rem_t1,':cr_id_array', cash_receipt_id_array);
2197: /* who cols*/
2198:
2199: dbms_sql.bind_variable (rem_t1,':i_last_updated_by',l_last_updated_by);
2200: dbms_sql.bind_variable (rem_t1,':i_last_update_login',l_last_update_login);

Line 2199: dbms_sql.bind_variable (rem_t1,':i_last_updated_by',l_last_updated_by);

2195: dbms_sql.bind_array (rem_t1,':ucrh_gl_date_array',crh_gl_date_array );
2196: dbms_sql.bind_array (rem_t1,':cr_id_array', cash_receipt_id_array);
2197: /* who cols*/
2198:
2199: dbms_sql.bind_variable (rem_t1,':i_last_updated_by',l_last_updated_by);
2200: dbms_sql.bind_variable (rem_t1,':i_last_update_login',l_last_update_login);
2201: dbms_sql.bind_variable (rem_t1,':i_request_id',l_request_id);
2202: dbms_sql.bind_variable (rem_t1,':i_program_application_id',l_program_application_id);
2203: dbms_sql.bind_variable (rem_t1,':i_program_id',l_program_id);

Line 2200: dbms_sql.bind_variable (rem_t1,':i_last_update_login',l_last_update_login);

2196: dbms_sql.bind_array (rem_t1,':cr_id_array', cash_receipt_id_array);
2197: /* who cols*/
2198:
2199: dbms_sql.bind_variable (rem_t1,':i_last_updated_by',l_last_updated_by);
2200: dbms_sql.bind_variable (rem_t1,':i_last_update_login',l_last_update_login);
2201: dbms_sql.bind_variable (rem_t1,':i_request_id',l_request_id);
2202: dbms_sql.bind_variable (rem_t1,':i_program_application_id',l_program_application_id);
2203: dbms_sql.bind_variable (rem_t1,':i_program_id',l_program_id);
2204:

Line 2201: dbms_sql.bind_variable (rem_t1,':i_request_id',l_request_id);

2197: /* who cols*/
2198:
2199: dbms_sql.bind_variable (rem_t1,':i_last_updated_by',l_last_updated_by);
2200: dbms_sql.bind_variable (rem_t1,':i_last_update_login',l_last_update_login);
2201: dbms_sql.bind_variable (rem_t1,':i_request_id',l_request_id);
2202: dbms_sql.bind_variable (rem_t1,':i_program_application_id',l_program_application_id);
2203: dbms_sql.bind_variable (rem_t1,':i_program_id',l_program_id);
2204:
2205: dummy := dbms_sql.execute(rem_t1);

Line 2202: dbms_sql.bind_variable (rem_t1,':i_program_application_id',l_program_application_id);

2198:
2199: dbms_sql.bind_variable (rem_t1,':i_last_updated_by',l_last_updated_by);
2200: dbms_sql.bind_variable (rem_t1,':i_last_update_login',l_last_update_login);
2201: dbms_sql.bind_variable (rem_t1,':i_request_id',l_request_id);
2202: dbms_sql.bind_variable (rem_t1,':i_program_application_id',l_program_application_id);
2203: dbms_sql.bind_variable (rem_t1,':i_program_id',l_program_id);
2204:
2205: dummy := dbms_sql.execute(rem_t1);
2206:

Line 2203: dbms_sql.bind_variable (rem_t1,':i_program_id',l_program_id);

2199: dbms_sql.bind_variable (rem_t1,':i_last_updated_by',l_last_updated_by);
2200: dbms_sql.bind_variable (rem_t1,':i_last_update_login',l_last_update_login);
2201: dbms_sql.bind_variable (rem_t1,':i_request_id',l_request_id);
2202: dbms_sql.bind_variable (rem_t1,':i_program_application_id',l_program_application_id);
2203: dbms_sql.bind_variable (rem_t1,':i_program_id',l_program_id);
2204:
2205: dummy := dbms_sql.execute(rem_t1);
2206:
2207: dbms_sql.close_cursor(rem_t1);

Line 2205: dummy := dbms_sql.execute(rem_t1);

2201: dbms_sql.bind_variable (rem_t1,':i_request_id',l_request_id);
2202: dbms_sql.bind_variable (rem_t1,':i_program_application_id',l_program_application_id);
2203: dbms_sql.bind_variable (rem_t1,':i_program_id',l_program_id);
2204:
2205: dummy := dbms_sql.execute(rem_t1);
2206:
2207: dbms_sql.close_cursor(rem_t1);
2208:
2209: IF PG_DEBUG in ('Y', 'C') THEN

Line 2207: dbms_sql.close_cursor(rem_t1);

2203: dbms_sql.bind_variable (rem_t1,':i_program_id',l_program_id);
2204:
2205: dummy := dbms_sql.execute(rem_t1);
2206:
2207: dbms_sql.close_cursor(rem_t1);
2208:
2209: IF PG_DEBUG in ('Y', 'C') THEN
2210: arp_standard.debug (to_char(SQL%ROWCOUNT) || ' row(s) updated.');
2211: fnd_file.put_line(FND_FILE.LOG,'upd-crh1 ()-');

Line 2215: if dbms_sql.is_open(rem_t1) then

2211: fnd_file.put_line(FND_FILE.LOG,'upd-crh1 ()-');
2212: END IF;
2213:
2214: EXCEPTION WHEN OTHERS THEN
2215: if dbms_sql.is_open(rem_t1) then
2216: dbms_sql.close_cursor(rem_t1);
2217: end if;
2218: IF PG_DEBUG in ('Y', 'C') THEN
2219: fnd_file.put_line(FND_FILE.LOG,'failed to update() '|| to_char(SQLCODE));

Line 2216: dbms_sql.close_cursor(rem_t1);

2212: END IF;
2213:
2214: EXCEPTION WHEN OTHERS THEN
2215: if dbms_sql.is_open(rem_t1) then
2216: dbms_sql.close_cursor(rem_t1);
2217: end if;
2218: IF PG_DEBUG in ('Y', 'C') THEN
2219: fnd_file.put_line(FND_FILE.LOG,'failed to update() '|| to_char(SQLCODE));
2220: END IF;

Line 2342: rem_t3 := dbms_sql.open_cursor;

2338: sysdate
2339: FROM AR_REMIT_GT r
2340: WHERE r.cash_receipt_history_id is not null';
2341:
2342: rem_t3 := dbms_sql.open_cursor;
2343:
2344: dbms_sql.parse (rem_t3,ins_crh1,dbms_sql.v7);
2345:
2346: IF PG_DEBUG in ('Y', 'C') THEN

Line 2344: dbms_sql.parse (rem_t3,ins_crh1,dbms_sql.v7);

2340: WHERE r.cash_receipt_history_id is not null';
2341:
2342: rem_t3 := dbms_sql.open_cursor;
2343:
2344: dbms_sql.parse (rem_t3,ins_crh1,dbms_sql.v7);
2345:
2346: IF PG_DEBUG in ('Y', 'C') THEN
2347: fnd_file.put_line(FND_FILE.LOG, 'the batch_id ' || p_batch_id);
2348: END IF;

Line 2351: dbms_sql.bind_variable (rem_t3,':i_batch_id',p_batch_id); -- NOTE THIS ONE

2347: fnd_file.put_line(FND_FILE.LOG, 'the batch_id ' || p_batch_id);
2348: END IF;
2349:
2350:
2351: dbms_sql.bind_variable (rem_t3,':i_batch_id',p_batch_id); -- NOTE THIS ONE
2352: dbms_sql.bind_variable (rem_t3,':factor_flag',l_factor_flag); -- NOTE THIS ONE
2353: /* who cols */
2354: dbms_sql.bind_variable (rem_t3,':i_created_by',l_created_by);
2355: dbms_sql.bind_variable (rem_t3,':i_last_updated_by',l_last_updated_by);

Line 2352: dbms_sql.bind_variable (rem_t3,':factor_flag',l_factor_flag); -- NOTE THIS ONE

2348: END IF;
2349:
2350:
2351: dbms_sql.bind_variable (rem_t3,':i_batch_id',p_batch_id); -- NOTE THIS ONE
2352: dbms_sql.bind_variable (rem_t3,':factor_flag',l_factor_flag); -- NOTE THIS ONE
2353: /* who cols */
2354: dbms_sql.bind_variable (rem_t3,':i_created_by',l_created_by);
2355: dbms_sql.bind_variable (rem_t3,':i_last_updated_by',l_last_updated_by);
2356: dbms_sql.bind_variable (rem_t3,':i_last_update_login',l_last_update_login);

Line 2354: dbms_sql.bind_variable (rem_t3,':i_created_by',l_created_by);

2350:
2351: dbms_sql.bind_variable (rem_t3,':i_batch_id',p_batch_id); -- NOTE THIS ONE
2352: dbms_sql.bind_variable (rem_t3,':factor_flag',l_factor_flag); -- NOTE THIS ONE
2353: /* who cols */
2354: dbms_sql.bind_variable (rem_t3,':i_created_by',l_created_by);
2355: dbms_sql.bind_variable (rem_t3,':i_last_updated_by',l_last_updated_by);
2356: dbms_sql.bind_variable (rem_t3,':i_last_update_login',l_last_update_login);
2357: dbms_sql.bind_variable (rem_t3,':i_request_id',l_request_id);
2358: dbms_sql.bind_variable (rem_t3,':i_org_id',l_org_id);

Line 2355: dbms_sql.bind_variable (rem_t3,':i_last_updated_by',l_last_updated_by);

2351: dbms_sql.bind_variable (rem_t3,':i_batch_id',p_batch_id); -- NOTE THIS ONE
2352: dbms_sql.bind_variable (rem_t3,':factor_flag',l_factor_flag); -- NOTE THIS ONE
2353: /* who cols */
2354: dbms_sql.bind_variable (rem_t3,':i_created_by',l_created_by);
2355: dbms_sql.bind_variable (rem_t3,':i_last_updated_by',l_last_updated_by);
2356: dbms_sql.bind_variable (rem_t3,':i_last_update_login',l_last_update_login);
2357: dbms_sql.bind_variable (rem_t3,':i_request_id',l_request_id);
2358: dbms_sql.bind_variable (rem_t3,':i_org_id',l_org_id);
2359: dbms_sql.bind_variable (rem_t3,':i_program_application_id',l_program_application_id);

Line 2356: dbms_sql.bind_variable (rem_t3,':i_last_update_login',l_last_update_login);

2352: dbms_sql.bind_variable (rem_t3,':factor_flag',l_factor_flag); -- NOTE THIS ONE
2353: /* who cols */
2354: dbms_sql.bind_variable (rem_t3,':i_created_by',l_created_by);
2355: dbms_sql.bind_variable (rem_t3,':i_last_updated_by',l_last_updated_by);
2356: dbms_sql.bind_variable (rem_t3,':i_last_update_login',l_last_update_login);
2357: dbms_sql.bind_variable (rem_t3,':i_request_id',l_request_id);
2358: dbms_sql.bind_variable (rem_t3,':i_org_id',l_org_id);
2359: dbms_sql.bind_variable (rem_t3,':i_program_application_id',l_program_application_id);
2360: dbms_sql.bind_variable (rem_t3,':i_program_id',l_program_id);

Line 2357: dbms_sql.bind_variable (rem_t3,':i_request_id',l_request_id);

2353: /* who cols */
2354: dbms_sql.bind_variable (rem_t3,':i_created_by',l_created_by);
2355: dbms_sql.bind_variable (rem_t3,':i_last_updated_by',l_last_updated_by);
2356: dbms_sql.bind_variable (rem_t3,':i_last_update_login',l_last_update_login);
2357: dbms_sql.bind_variable (rem_t3,':i_request_id',l_request_id);
2358: dbms_sql.bind_variable (rem_t3,':i_org_id',l_org_id);
2359: dbms_sql.bind_variable (rem_t3,':i_program_application_id',l_program_application_id);
2360: dbms_sql.bind_variable (rem_t3,':i_program_id',l_program_id);
2361:

Line 2358: dbms_sql.bind_variable (rem_t3,':i_org_id',l_org_id);

2354: dbms_sql.bind_variable (rem_t3,':i_created_by',l_created_by);
2355: dbms_sql.bind_variable (rem_t3,':i_last_updated_by',l_last_updated_by);
2356: dbms_sql.bind_variable (rem_t3,':i_last_update_login',l_last_update_login);
2357: dbms_sql.bind_variable (rem_t3,':i_request_id',l_request_id);
2358: dbms_sql.bind_variable (rem_t3,':i_org_id',l_org_id);
2359: dbms_sql.bind_variable (rem_t3,':i_program_application_id',l_program_application_id);
2360: dbms_sql.bind_variable (rem_t3,':i_program_id',l_program_id);
2361:
2362:

Line 2359: dbms_sql.bind_variable (rem_t3,':i_program_application_id',l_program_application_id);

2355: dbms_sql.bind_variable (rem_t3,':i_last_updated_by',l_last_updated_by);
2356: dbms_sql.bind_variable (rem_t3,':i_last_update_login',l_last_update_login);
2357: dbms_sql.bind_variable (rem_t3,':i_request_id',l_request_id);
2358: dbms_sql.bind_variable (rem_t3,':i_org_id',l_org_id);
2359: dbms_sql.bind_variable (rem_t3,':i_program_application_id',l_program_application_id);
2360: dbms_sql.bind_variable (rem_t3,':i_program_id',l_program_id);
2361:
2362:
2363: IF PG_DEBUG in ('Y', 'C') THEN

Line 2360: dbms_sql.bind_variable (rem_t3,':i_program_id',l_program_id);

2356: dbms_sql.bind_variable (rem_t3,':i_last_update_login',l_last_update_login);
2357: dbms_sql.bind_variable (rem_t3,':i_request_id',l_request_id);
2358: dbms_sql.bind_variable (rem_t3,':i_org_id',l_org_id);
2359: dbms_sql.bind_variable (rem_t3,':i_program_application_id',l_program_application_id);
2360: dbms_sql.bind_variable (rem_t3,':i_program_id',l_program_id);
2361:
2362:
2363: IF PG_DEBUG in ('Y', 'C') THEN
2364: fnd_file.put_line(FND_FILE.LOG, 'the insert statemnt' || ins_crh1);

Line 2367: dummy := dbms_sql.execute(rem_t3);

2363: IF PG_DEBUG in ('Y', 'C') THEN
2364: fnd_file.put_line(FND_FILE.LOG, 'the insert statemnt' || ins_crh1);
2365: END IF;
2366:
2367: dummy := dbms_sql.execute(rem_t3);
2368:
2369: dbms_sql.close_cursor(rem_t3);
2370:
2371:

Line 2369: dbms_sql.close_cursor(rem_t3);

2365: END IF;
2366:
2367: dummy := dbms_sql.execute(rem_t3);
2368:
2369: dbms_sql.close_cursor(rem_t3);
2370:
2371:
2372: /* BICHATTE after the insert into crh we have to fire the XLA event */
2373:

Line 2405: if dbms_sql.is_open(rem_t3) then

2401:
2402:
2403: EXCEPTION WHEN OTHERS THEN
2404: fnd_file.put_line(FND_FILE.LOG, 'the insert statemnt' || ins_crh1);
2405: if dbms_sql.is_open(rem_t3) then
2406: dbms_sql.close_cursor(rem_t3);
2407: end if;
2408: IF PG_DEBUG in ('Y', 'C') THEN
2409: fnd_file.put_line(FND_FILE.LOG,'failed to insert() '|| to_char(SQLCODE));

Line 2406: dbms_sql.close_cursor(rem_t3);

2402:
2403: EXCEPTION WHEN OTHERS THEN
2404: fnd_file.put_line(FND_FILE.LOG, 'the insert statemnt' || ins_crh1);
2405: if dbms_sql.is_open(rem_t3) then
2406: dbms_sql.close_cursor(rem_t3);
2407: end if;
2408: IF PG_DEBUG in ('Y', 'C') THEN
2409: fnd_file.put_line(FND_FILE.LOG,'failed to insert() '|| to_char(SQLCODE));
2410: fnd_file.put_line(FND_FILE.LOG, 'the insert statemnt' || ins_crh1);

Line 2512: rem_t4 := dbms_sql.open_cursor;

2508: WHERE crh.cash_receipt_history_id = r.cash_receipt_history_id
2509: AND l.lookup_type = ''AR_CARTESIAN_JOIN''
2510: AND l.lookup_code IN (''1'',''2'')';
2511:
2512: rem_t4 := dbms_sql.open_cursor;
2513:
2514: dbms_sql.parse (rem_t4,ins_dist1,dbms_sql.v7);
2515:
2516: IF PG_DEBUG in ('Y', 'C') THEN

Line 2514: dbms_sql.parse (rem_t4,ins_dist1,dbms_sql.v7);

2510: AND l.lookup_code IN (''1'',''2'')';
2511:
2512: rem_t4 := dbms_sql.open_cursor;
2513:
2514: dbms_sql.parse (rem_t4,ins_dist1,dbms_sql.v7);
2515:
2516: IF PG_DEBUG in ('Y', 'C') THEN
2517: fnd_file.put_line(FND_FILE.LOG, 'the insert dist statement is ' || ins_dist1);
2518: END IF;

Line 2520: dbms_sql.bind_variable (rem_t4,':factor_flag',l_factor_flag); -- NOTE THIS ONE

2516: IF PG_DEBUG in ('Y', 'C') THEN
2517: fnd_file.put_line(FND_FILE.LOG, 'the insert dist statement is ' || ins_dist1);
2518: END IF;
2519:
2520: dbms_sql.bind_variable (rem_t4,':factor_flag',l_factor_flag); -- NOTE THIS ONE
2521: /* who cols */
2522: dbms_sql.bind_variable (rem_t4,':i_created_by',l_created_by);
2523: dbms_sql.bind_variable (rem_t4,':i_last_updated_by',l_last_updated_by);
2524: dbms_sql.bind_variable (rem_t4,':i_org_id',l_org_id);

Line 2522: dbms_sql.bind_variable (rem_t4,':i_created_by',l_created_by);

2518: END IF;
2519:
2520: dbms_sql.bind_variable (rem_t4,':factor_flag',l_factor_flag); -- NOTE THIS ONE
2521: /* who cols */
2522: dbms_sql.bind_variable (rem_t4,':i_created_by',l_created_by);
2523: dbms_sql.bind_variable (rem_t4,':i_last_updated_by',l_last_updated_by);
2524: dbms_sql.bind_variable (rem_t4,':i_org_id',l_org_id);
2525: dbms_sql.bind_variable (rem_t4,':i_last_update_login',l_last_update_login);
2526:

Line 2523: dbms_sql.bind_variable (rem_t4,':i_last_updated_by',l_last_updated_by);

2519:
2520: dbms_sql.bind_variable (rem_t4,':factor_flag',l_factor_flag); -- NOTE THIS ONE
2521: /* who cols */
2522: dbms_sql.bind_variable (rem_t4,':i_created_by',l_created_by);
2523: dbms_sql.bind_variable (rem_t4,':i_last_updated_by',l_last_updated_by);
2524: dbms_sql.bind_variable (rem_t4,':i_org_id',l_org_id);
2525: dbms_sql.bind_variable (rem_t4,':i_last_update_login',l_last_update_login);
2526:
2527:

Line 2524: dbms_sql.bind_variable (rem_t4,':i_org_id',l_org_id);

2520: dbms_sql.bind_variable (rem_t4,':factor_flag',l_factor_flag); -- NOTE THIS ONE
2521: /* who cols */
2522: dbms_sql.bind_variable (rem_t4,':i_created_by',l_created_by);
2523: dbms_sql.bind_variable (rem_t4,':i_last_updated_by',l_last_updated_by);
2524: dbms_sql.bind_variable (rem_t4,':i_org_id',l_org_id);
2525: dbms_sql.bind_variable (rem_t4,':i_last_update_login',l_last_update_login);
2526:
2527:
2528: d2 := dbms_sql.execute(rem_t4);

Line 2525: dbms_sql.bind_variable (rem_t4,':i_last_update_login',l_last_update_login);

2521: /* who cols */
2522: dbms_sql.bind_variable (rem_t4,':i_created_by',l_created_by);
2523: dbms_sql.bind_variable (rem_t4,':i_last_updated_by',l_last_updated_by);
2524: dbms_sql.bind_variable (rem_t4,':i_org_id',l_org_id);
2525: dbms_sql.bind_variable (rem_t4,':i_last_update_login',l_last_update_login);
2526:
2527:
2528: d2 := dbms_sql.execute(rem_t4);
2529:

Line 2528: d2 := dbms_sql.execute(rem_t4);

2524: dbms_sql.bind_variable (rem_t4,':i_org_id',l_org_id);
2525: dbms_sql.bind_variable (rem_t4,':i_last_update_login',l_last_update_login);
2526:
2527:
2528: d2 := dbms_sql.execute(rem_t4);
2529:
2530: dbms_sql.close_cursor(rem_t4);
2531:
2532: IF PG_DEBUG in ('Y', 'C') THEN

Line 2530: dbms_sql.close_cursor(rem_t4);

2526:
2527:
2528: d2 := dbms_sql.execute(rem_t4);
2529:
2530: dbms_sql.close_cursor(rem_t4);
2531:
2532: IF PG_DEBUG in ('Y', 'C') THEN
2533: fnd_file.put_line(FND_FILE.LOG,'ins_dist1 ()-');
2534: END IF;

Line 2537: if dbms_sql.is_open(rem_t4) then

2533: fnd_file.put_line(FND_FILE.LOG,'ins_dist1 ()-');
2534: END IF;
2535:
2536: EXCEPTION WHEN OTHERS THEN
2537: if dbms_sql.is_open(rem_t4) then
2538: dbms_sql.close_cursor(rem_t4);
2539: end if;
2540: IF PG_DEBUG in ('Y', 'C') THEN
2541: fnd_file.put_line(FND_FILE.LOG, 'the insert dist statement is ' || ins_dist1);

Line 2538: dbms_sql.close_cursor(rem_t4);

2534: END IF;
2535:
2536: EXCEPTION WHEN OTHERS THEN
2537: if dbms_sql.is_open(rem_t4) then
2538: dbms_sql.close_cursor(rem_t4);
2539: end if;
2540: IF PG_DEBUG in ('Y', 'C') THEN
2541: fnd_file.put_line(FND_FILE.LOG, 'the insert dist statement is ' || ins_dist1);
2542: fnd_file.put_line(FND_FILE.LOG,'DIST failed to insert() '|| to_char(SQLCODE));

Line 2626: cash_receipt_id_array dbms_sql.Number_Table;

2622: /* declare the insert array elements */
2623: i NUMBER;
2624: dummy NUMBER;
2625: inst_stmt varchar2(2000);
2626: cash_receipt_id_array dbms_sql.Number_Table;
2627: payment_type_CODE_array dbms_sql.varchar2_Table;
2628: merchant_ref_array dbms_sql.varchar2_Table;
2629: currency_code_array dbms_sql.varchar2_Table;
2630: pay_from_customer_array dbms_sql.varchar2_Table;

Line 2627: payment_type_CODE_array dbms_sql.varchar2_Table;

2623: i NUMBER;
2624: dummy NUMBER;
2625: inst_stmt varchar2(2000);
2626: cash_receipt_id_array dbms_sql.Number_Table;
2627: payment_type_CODE_array dbms_sql.varchar2_Table;
2628: merchant_ref_array dbms_sql.varchar2_Table;
2629: currency_code_array dbms_sql.varchar2_Table;
2630: pay_from_customer_array dbms_sql.varchar2_Table;
2631: customer_site_use_id_array dbms_sql.Number_Table;

Line 2628: merchant_ref_array dbms_sql.varchar2_Table;

2624: dummy NUMBER;
2625: inst_stmt varchar2(2000);
2626: cash_receipt_id_array dbms_sql.Number_Table;
2627: payment_type_CODE_array dbms_sql.varchar2_Table;
2628: merchant_ref_array dbms_sql.varchar2_Table;
2629: currency_code_array dbms_sql.varchar2_Table;
2630: pay_from_customer_array dbms_sql.varchar2_Table;
2631: customer_site_use_id_array dbms_sql.Number_Table;
2632: prv_cash_receipt_hist_id_array dbms_sql.Number_Table;

Line 2629: currency_code_array dbms_sql.varchar2_Table;

2625: inst_stmt varchar2(2000);
2626: cash_receipt_id_array dbms_sql.Number_Table;
2627: payment_type_CODE_array dbms_sql.varchar2_Table;
2628: merchant_ref_array dbms_sql.varchar2_Table;
2629: currency_code_array dbms_sql.varchar2_Table;
2630: pay_from_customer_array dbms_sql.varchar2_Table;
2631: customer_site_use_id_array dbms_sql.Number_Table;
2632: prv_cash_receipt_hist_id_array dbms_sql.Number_Table;
2633: exchange_date_array dbms_sql.date_Table;

Line 2630: pay_from_customer_array dbms_sql.varchar2_Table;

2626: cash_receipt_id_array dbms_sql.Number_Table;
2627: payment_type_CODE_array dbms_sql.varchar2_Table;
2628: merchant_ref_array dbms_sql.varchar2_Table;
2629: currency_code_array dbms_sql.varchar2_Table;
2630: pay_from_customer_array dbms_sql.varchar2_Table;
2631: customer_site_use_id_array dbms_sql.Number_Table;
2632: prv_cash_receipt_hist_id_array dbms_sql.Number_Table;
2633: exchange_date_array dbms_sql.date_Table;
2634: exchange_rate_array dbms_sql.Number_Table;

Line 2631: customer_site_use_id_array dbms_sql.Number_Table;

2627: payment_type_CODE_array dbms_sql.varchar2_Table;
2628: merchant_ref_array dbms_sql.varchar2_Table;
2629: currency_code_array dbms_sql.varchar2_Table;
2630: pay_from_customer_array dbms_sql.varchar2_Table;
2631: customer_site_use_id_array dbms_sql.Number_Table;
2632: prv_cash_receipt_hist_id_array dbms_sql.Number_Table;
2633: exchange_date_array dbms_sql.date_Table;
2634: exchange_rate_array dbms_sql.Number_Table;
2635: exchange_type_array dbms_sql.varchar2_Table;

Line 2632: prv_cash_receipt_hist_id_array dbms_sql.Number_Table;

2628: merchant_ref_array dbms_sql.varchar2_Table;
2629: currency_code_array dbms_sql.varchar2_Table;
2630: pay_from_customer_array dbms_sql.varchar2_Table;
2631: customer_site_use_id_array dbms_sql.Number_Table;
2632: prv_cash_receipt_hist_id_array dbms_sql.Number_Table;
2633: exchange_date_array dbms_sql.date_Table;
2634: exchange_rate_array dbms_sql.Number_Table;
2635: exchange_type_array dbms_sql.varchar2_Table;
2636: cr_amount_array dbms_sql.Number_Table;

Line 2633: exchange_date_array dbms_sql.date_Table;

2629: currency_code_array dbms_sql.varchar2_Table;
2630: pay_from_customer_array dbms_sql.varchar2_Table;
2631: customer_site_use_id_array dbms_sql.Number_Table;
2632: prv_cash_receipt_hist_id_array dbms_sql.Number_Table;
2633: exchange_date_array dbms_sql.date_Table;
2634: exchange_rate_array dbms_sql.Number_Table;
2635: exchange_type_array dbms_sql.varchar2_Table;
2636: cr_amount_array dbms_sql.Number_Table;
2637: cr_acctd_amount_array dbms_sql.Number_Table;

Line 2634: exchange_rate_array dbms_sql.Number_Table;

2630: pay_from_customer_array dbms_sql.varchar2_Table;
2631: customer_site_use_id_array dbms_sql.Number_Table;
2632: prv_cash_receipt_hist_id_array dbms_sql.Number_Table;
2633: exchange_date_array dbms_sql.date_Table;
2634: exchange_rate_array dbms_sql.Number_Table;
2635: exchange_type_array dbms_sql.varchar2_Table;
2636: cr_amount_array dbms_sql.Number_Table;
2637: cr_acctd_amount_array dbms_sql.Number_Table;
2638: cr_factor_discount_amt_array dbms_sql.Number_Table;

Line 2635: exchange_type_array dbms_sql.varchar2_Table;

2631: customer_site_use_id_array dbms_sql.Number_Table;
2632: prv_cash_receipt_hist_id_array dbms_sql.Number_Table;
2633: exchange_date_array dbms_sql.date_Table;
2634: exchange_rate_array dbms_sql.Number_Table;
2635: exchange_type_array dbms_sql.varchar2_Table;
2636: cr_amount_array dbms_sql.Number_Table;
2637: cr_acctd_amount_array dbms_sql.Number_Table;
2638: cr_factor_discount_amt_array dbms_sql.Number_Table;
2639: remmitance_ccid_array dbms_sql.Number_Table;

Line 2636: cr_amount_array dbms_sql.Number_Table;

2632: prv_cash_receipt_hist_id_array dbms_sql.Number_Table;
2633: exchange_date_array dbms_sql.date_Table;
2634: exchange_rate_array dbms_sql.Number_Table;
2635: exchange_type_array dbms_sql.varchar2_Table;
2636: cr_amount_array dbms_sql.Number_Table;
2637: cr_acctd_amount_array dbms_sql.Number_Table;
2638: cr_factor_discount_amt_array dbms_sql.Number_Table;
2639: remmitance_ccid_array dbms_sql.Number_Table;
2640: bank_charges_ccid_array dbms_sql.Number_Table;

Line 2637: cr_acctd_amount_array dbms_sql.Number_Table;

2633: exchange_date_array dbms_sql.date_Table;
2634: exchange_rate_array dbms_sql.Number_Table;
2635: exchange_type_array dbms_sql.varchar2_Table;
2636: cr_amount_array dbms_sql.Number_Table;
2637: cr_acctd_amount_array dbms_sql.Number_Table;
2638: cr_factor_discount_amt_array dbms_sql.Number_Table;
2639: remmitance_ccid_array dbms_sql.Number_Table;
2640: bank_charges_ccid_array dbms_sql.Number_Table;
2641: code_combination_id_array dbms_sql.Number_Table;

Line 2638: cr_factor_discount_amt_array dbms_sql.Number_Table;

2634: exchange_rate_array dbms_sql.Number_Table;
2635: exchange_type_array dbms_sql.varchar2_Table;
2636: cr_amount_array dbms_sql.Number_Table;
2637: cr_acctd_amount_array dbms_sql.Number_Table;
2638: cr_factor_discount_amt_array dbms_sql.Number_Table;
2639: remmitance_ccid_array dbms_sql.Number_Table;
2640: bank_charges_ccid_array dbms_sql.Number_Table;
2641: code_combination_id_array dbms_sql.Number_Table;
2642: cash_receipt_history_id_array dbms_sql.Number_Table;

Line 2639: remmitance_ccid_array dbms_sql.Number_Table;

2635: exchange_type_array dbms_sql.varchar2_Table;
2636: cr_amount_array dbms_sql.Number_Table;
2637: cr_acctd_amount_array dbms_sql.Number_Table;
2638: cr_factor_discount_amt_array dbms_sql.Number_Table;
2639: remmitance_ccid_array dbms_sql.Number_Table;
2640: bank_charges_ccid_array dbms_sql.Number_Table;
2641: code_combination_id_array dbms_sql.Number_Table;
2642: cash_receipt_history_id_array dbms_sql.Number_Table;
2643: crh_gl_date_array dbms_sql.date_Table;

Line 2640: bank_charges_ccid_array dbms_sql.Number_Table;

2636: cr_amount_array dbms_sql.Number_Table;
2637: cr_acctd_amount_array dbms_sql.Number_Table;
2638: cr_factor_discount_amt_array dbms_sql.Number_Table;
2639: remmitance_ccid_array dbms_sql.Number_Table;
2640: bank_charges_ccid_array dbms_sql.Number_Table;
2641: code_combination_id_array dbms_sql.Number_Table;
2642: cash_receipt_history_id_array dbms_sql.Number_Table;
2643: crh_gl_date_array dbms_sql.date_Table;
2644: crh_trx_date_array dbms_sql.date_Table;

Line 2641: code_combination_id_array dbms_sql.Number_Table;

2637: cr_acctd_amount_array dbms_sql.Number_Table;
2638: cr_factor_discount_amt_array dbms_sql.Number_Table;
2639: remmitance_ccid_array dbms_sql.Number_Table;
2640: bank_charges_ccid_array dbms_sql.Number_Table;
2641: code_combination_id_array dbms_sql.Number_Table;
2642: cash_receipt_history_id_array dbms_sql.Number_Table;
2643: crh_gl_date_array dbms_sql.date_Table;
2644: crh_trx_date_array dbms_sql.date_Table;
2645: payment_server_order_num_array dbms_sql.varchar2_Table;

Line 2642: cash_receipt_history_id_array dbms_sql.Number_Table;

2638: cr_factor_discount_amt_array dbms_sql.Number_Table;
2639: remmitance_ccid_array dbms_sql.Number_Table;
2640: bank_charges_ccid_array dbms_sql.Number_Table;
2641: code_combination_id_array dbms_sql.Number_Table;
2642: cash_receipt_history_id_array dbms_sql.Number_Table;
2643: crh_gl_date_array dbms_sql.date_Table;
2644: crh_trx_date_array dbms_sql.date_Table;
2645: payment_server_order_num_array dbms_sql.varchar2_Table;
2646: approval_code_array dbms_sql.varchar2_Table;

Line 2643: crh_gl_date_array dbms_sql.date_Table;

2639: remmitance_ccid_array dbms_sql.Number_Table;
2640: bank_charges_ccid_array dbms_sql.Number_Table;
2641: code_combination_id_array dbms_sql.Number_Table;
2642: cash_receipt_history_id_array dbms_sql.Number_Table;
2643: crh_gl_date_array dbms_sql.date_Table;
2644: crh_trx_date_array dbms_sql.date_Table;
2645: payment_server_order_num_array dbms_sql.varchar2_Table;
2646: approval_code_array dbms_sql.varchar2_Table;
2647: receipt_number_array dbms_sql.varchar2_Table;

Line 2644: crh_trx_date_array dbms_sql.date_Table;

2640: bank_charges_ccid_array dbms_sql.Number_Table;
2641: code_combination_id_array dbms_sql.Number_Table;
2642: cash_receipt_history_id_array dbms_sql.Number_Table;
2643: crh_gl_date_array dbms_sql.date_Table;
2644: crh_trx_date_array dbms_sql.date_Table;
2645: payment_server_order_num_array dbms_sql.varchar2_Table;
2646: approval_code_array dbms_sql.varchar2_Table;
2647: receipt_number_array dbms_sql.varchar2_Table;
2648: unique_ref_array dbms_sql.varchar2_Table;

Line 2645: payment_server_order_num_array dbms_sql.varchar2_Table;

2641: code_combination_id_array dbms_sql.Number_Table;
2642: cash_receipt_history_id_array dbms_sql.Number_Table;
2643: crh_gl_date_array dbms_sql.date_Table;
2644: crh_trx_date_array dbms_sql.date_Table;
2645: payment_server_order_num_array dbms_sql.varchar2_Table;
2646: approval_code_array dbms_sql.varchar2_Table;
2647: receipt_number_array dbms_sql.varchar2_Table;
2648: unique_ref_array dbms_sql.varchar2_Table;
2649: customer_bank_account_id_array dbms_sql.Number_Table;

Line 2646: approval_code_array dbms_sql.varchar2_Table;

2642: cash_receipt_history_id_array dbms_sql.Number_Table;
2643: crh_gl_date_array dbms_sql.date_Table;
2644: crh_trx_date_array dbms_sql.date_Table;
2645: payment_server_order_num_array dbms_sql.varchar2_Table;
2646: approval_code_array dbms_sql.varchar2_Table;
2647: receipt_number_array dbms_sql.varchar2_Table;
2648: unique_ref_array dbms_sql.varchar2_Table;
2649: customer_bank_account_id_array dbms_sql.Number_Table;
2650: payment_trxn_extn_id_array dbms_sql.Number_Table;

Line 2647: receipt_number_array dbms_sql.varchar2_Table;

2643: crh_gl_date_array dbms_sql.date_Table;
2644: crh_trx_date_array dbms_sql.date_Table;
2645: payment_server_order_num_array dbms_sql.varchar2_Table;
2646: approval_code_array dbms_sql.varchar2_Table;
2647: receipt_number_array dbms_sql.varchar2_Table;
2648: unique_ref_array dbms_sql.varchar2_Table;
2649: customer_bank_account_id_array dbms_sql.Number_Table;
2650: payment_trxn_extn_id_array dbms_sql.Number_Table;
2651: rem_t NUMBER;

Line 2648: unique_ref_array dbms_sql.varchar2_Table;

2644: crh_trx_date_array dbms_sql.date_Table;
2645: payment_server_order_num_array dbms_sql.varchar2_Table;
2646: approval_code_array dbms_sql.varchar2_Table;
2647: receipt_number_array dbms_sql.varchar2_Table;
2648: unique_ref_array dbms_sql.varchar2_Table;
2649: customer_bank_account_id_array dbms_sql.Number_Table;
2650: payment_trxn_extn_id_array dbms_sql.Number_Table;
2651: rem_t NUMBER;
2652: /* end declare */

Line 2649: customer_bank_account_id_array dbms_sql.Number_Table;

2645: payment_server_order_num_array dbms_sql.varchar2_Table;
2646: approval_code_array dbms_sql.varchar2_Table;
2647: receipt_number_array dbms_sql.varchar2_Table;
2648: unique_ref_array dbms_sql.varchar2_Table;
2649: customer_bank_account_id_array dbms_sql.Number_Table;
2650: payment_trxn_extn_id_array dbms_sql.Number_Table;
2651: rem_t NUMBER;
2652: /* end declare */
2653:

Line 2650: payment_trxn_extn_id_array dbms_sql.Number_Table;

2646: approval_code_array dbms_sql.varchar2_Table;
2647: receipt_number_array dbms_sql.varchar2_Table;
2648: unique_ref_array dbms_sql.varchar2_Table;
2649: customer_bank_account_id_array dbms_sql.Number_Table;
2650: payment_trxn_extn_id_array dbms_sql.Number_Table;
2651: rem_t NUMBER;
2652: /* end declare */
2653:
2654:

Line 2743: sel_receipts := dbms_sql.open_cursor;

2739: WHERE batch_id = :ab_batch_id
2740: AND current_worker = :h_worker_number
2741: ';
2742:
2743: sel_receipts := dbms_sql.open_cursor;
2744:
2745: dbms_sql.parse (sel_receipts,l_sel_stmt,dbms_sql.v7);
2746:
2747: dbms_sql.bind_variable (sel_receipts,':ab_batch_id',p_batch_id);

Line 2745: dbms_sql.parse (sel_receipts,l_sel_stmt,dbms_sql.v7);

2741: ';
2742:
2743: sel_receipts := dbms_sql.open_cursor;
2744:
2745: dbms_sql.parse (sel_receipts,l_sel_stmt,dbms_sql.v7);
2746:
2747: dbms_sql.bind_variable (sel_receipts,':ab_batch_id',p_batch_id);
2748: dbms_sql.bind_variable (sel_receipts,':h_worker_number', WORKER_NUMBER);
2749:

Line 2747: dbms_sql.bind_variable (sel_receipts,':ab_batch_id',p_batch_id);

2743: sel_receipts := dbms_sql.open_cursor;
2744:
2745: dbms_sql.parse (sel_receipts,l_sel_stmt,dbms_sql.v7);
2746:
2747: dbms_sql.bind_variable (sel_receipts,':ab_batch_id',p_batch_id);
2748: dbms_sql.bind_variable (sel_receipts,':h_worker_number', WORKER_NUMBER);
2749:
2750:
2751: dbms_sql.define_column (sel_receipts, 1, p_cash_receipt_id);

Line 2748: dbms_sql.bind_variable (sel_receipts,':h_worker_number', WORKER_NUMBER);

2744:
2745: dbms_sql.parse (sel_receipts,l_sel_stmt,dbms_sql.v7);
2746:
2747: dbms_sql.bind_variable (sel_receipts,':ab_batch_id',p_batch_id);
2748: dbms_sql.bind_variable (sel_receipts,':h_worker_number', WORKER_NUMBER);
2749:
2750:
2751: dbms_sql.define_column (sel_receipts, 1, p_cash_receipt_id);
2752: dbms_sql.define_column (sel_receipts, 2, p_payment_type_code,30);

Line 2751: dbms_sql.define_column (sel_receipts, 1, p_cash_receipt_id);

2747: dbms_sql.bind_variable (sel_receipts,':ab_batch_id',p_batch_id);
2748: dbms_sql.bind_variable (sel_receipts,':h_worker_number', WORKER_NUMBER);
2749:
2750:
2751: dbms_sql.define_column (sel_receipts, 1, p_cash_receipt_id);
2752: dbms_sql.define_column (sel_receipts, 2, p_payment_type_code,30);
2753: dbms_sql.define_column (sel_receipts, 3, p_merchant_ref,80);
2754: dbms_sql.define_column (sel_receipts, 4, p_currency_code,15);
2755: dbms_sql.define_column (sel_receipts, 5, p_pay_from_customer);

Line 2752: dbms_sql.define_column (sel_receipts, 2, p_payment_type_code,30);

2748: dbms_sql.bind_variable (sel_receipts,':h_worker_number', WORKER_NUMBER);
2749:
2750:
2751: dbms_sql.define_column (sel_receipts, 1, p_cash_receipt_id);
2752: dbms_sql.define_column (sel_receipts, 2, p_payment_type_code,30);
2753: dbms_sql.define_column (sel_receipts, 3, p_merchant_ref,80);
2754: dbms_sql.define_column (sel_receipts, 4, p_currency_code,15);
2755: dbms_sql.define_column (sel_receipts, 5, p_pay_from_customer);
2756: dbms_sql.define_column (sel_receipts, 6, p_customer_site_use_id);

Line 2753: dbms_sql.define_column (sel_receipts, 3, p_merchant_ref,80);

2749:
2750:
2751: dbms_sql.define_column (sel_receipts, 1, p_cash_receipt_id);
2752: dbms_sql.define_column (sel_receipts, 2, p_payment_type_code,30);
2753: dbms_sql.define_column (sel_receipts, 3, p_merchant_ref,80);
2754: dbms_sql.define_column (sel_receipts, 4, p_currency_code,15);
2755: dbms_sql.define_column (sel_receipts, 5, p_pay_from_customer);
2756: dbms_sql.define_column (sel_receipts, 6, p_customer_site_use_id);
2757: dbms_sql.define_column (sel_receipts, 7, p_prv_cash_receipt_hist_id);

Line 2754: dbms_sql.define_column (sel_receipts, 4, p_currency_code,15);

2750:
2751: dbms_sql.define_column (sel_receipts, 1, p_cash_receipt_id);
2752: dbms_sql.define_column (sel_receipts, 2, p_payment_type_code,30);
2753: dbms_sql.define_column (sel_receipts, 3, p_merchant_ref,80);
2754: dbms_sql.define_column (sel_receipts, 4, p_currency_code,15);
2755: dbms_sql.define_column (sel_receipts, 5, p_pay_from_customer);
2756: dbms_sql.define_column (sel_receipts, 6, p_customer_site_use_id);
2757: dbms_sql.define_column (sel_receipts, 7, p_prv_cash_receipt_hist_id);
2758: dbms_sql.define_column (sel_receipts, 8, p_exchange_date);

Line 2755: dbms_sql.define_column (sel_receipts, 5, p_pay_from_customer);

2751: dbms_sql.define_column (sel_receipts, 1, p_cash_receipt_id);
2752: dbms_sql.define_column (sel_receipts, 2, p_payment_type_code,30);
2753: dbms_sql.define_column (sel_receipts, 3, p_merchant_ref,80);
2754: dbms_sql.define_column (sel_receipts, 4, p_currency_code,15);
2755: dbms_sql.define_column (sel_receipts, 5, p_pay_from_customer);
2756: dbms_sql.define_column (sel_receipts, 6, p_customer_site_use_id);
2757: dbms_sql.define_column (sel_receipts, 7, p_prv_cash_receipt_hist_id);
2758: dbms_sql.define_column (sel_receipts, 8, p_exchange_date);
2759: dbms_sql.define_column (sel_receipts, 9, p_exchange_rate);

Line 2756: dbms_sql.define_column (sel_receipts, 6, p_customer_site_use_id);

2752: dbms_sql.define_column (sel_receipts, 2, p_payment_type_code,30);
2753: dbms_sql.define_column (sel_receipts, 3, p_merchant_ref,80);
2754: dbms_sql.define_column (sel_receipts, 4, p_currency_code,15);
2755: dbms_sql.define_column (sel_receipts, 5, p_pay_from_customer);
2756: dbms_sql.define_column (sel_receipts, 6, p_customer_site_use_id);
2757: dbms_sql.define_column (sel_receipts, 7, p_prv_cash_receipt_hist_id);
2758: dbms_sql.define_column (sel_receipts, 8, p_exchange_date);
2759: dbms_sql.define_column (sel_receipts, 9, p_exchange_rate);
2760: dbms_sql.define_column (sel_receipts, 10, p_exchange_type,30);

Line 2757: dbms_sql.define_column (sel_receipts, 7, p_prv_cash_receipt_hist_id);

2753: dbms_sql.define_column (sel_receipts, 3, p_merchant_ref,80);
2754: dbms_sql.define_column (sel_receipts, 4, p_currency_code,15);
2755: dbms_sql.define_column (sel_receipts, 5, p_pay_from_customer);
2756: dbms_sql.define_column (sel_receipts, 6, p_customer_site_use_id);
2757: dbms_sql.define_column (sel_receipts, 7, p_prv_cash_receipt_hist_id);
2758: dbms_sql.define_column (sel_receipts, 8, p_exchange_date);
2759: dbms_sql.define_column (sel_receipts, 9, p_exchange_rate);
2760: dbms_sql.define_column (sel_receipts, 10, p_exchange_type,30);
2761: dbms_sql.define_column (sel_receipts, 11, p_cr_amount);

Line 2758: dbms_sql.define_column (sel_receipts, 8, p_exchange_date);

2754: dbms_sql.define_column (sel_receipts, 4, p_currency_code,15);
2755: dbms_sql.define_column (sel_receipts, 5, p_pay_from_customer);
2756: dbms_sql.define_column (sel_receipts, 6, p_customer_site_use_id);
2757: dbms_sql.define_column (sel_receipts, 7, p_prv_cash_receipt_hist_id);
2758: dbms_sql.define_column (sel_receipts, 8, p_exchange_date);
2759: dbms_sql.define_column (sel_receipts, 9, p_exchange_rate);
2760: dbms_sql.define_column (sel_receipts, 10, p_exchange_type,30);
2761: dbms_sql.define_column (sel_receipts, 11, p_cr_amount);
2762: dbms_sql.define_column (sel_receipts, 12, p_cr_acctd_amount);

Line 2759: dbms_sql.define_column (sel_receipts, 9, p_exchange_rate);

2755: dbms_sql.define_column (sel_receipts, 5, p_pay_from_customer);
2756: dbms_sql.define_column (sel_receipts, 6, p_customer_site_use_id);
2757: dbms_sql.define_column (sel_receipts, 7, p_prv_cash_receipt_hist_id);
2758: dbms_sql.define_column (sel_receipts, 8, p_exchange_date);
2759: dbms_sql.define_column (sel_receipts, 9, p_exchange_rate);
2760: dbms_sql.define_column (sel_receipts, 10, p_exchange_type,30);
2761: dbms_sql.define_column (sel_receipts, 11, p_cr_amount);
2762: dbms_sql.define_column (sel_receipts, 12, p_cr_acctd_amount);
2763: dbms_sql.define_column (sel_receipts, 13, p_cr_factor_discount_amount);

Line 2760: dbms_sql.define_column (sel_receipts, 10, p_exchange_type,30);

2756: dbms_sql.define_column (sel_receipts, 6, p_customer_site_use_id);
2757: dbms_sql.define_column (sel_receipts, 7, p_prv_cash_receipt_hist_id);
2758: dbms_sql.define_column (sel_receipts, 8, p_exchange_date);
2759: dbms_sql.define_column (sel_receipts, 9, p_exchange_rate);
2760: dbms_sql.define_column (sel_receipts, 10, p_exchange_type,30);
2761: dbms_sql.define_column (sel_receipts, 11, p_cr_amount);
2762: dbms_sql.define_column (sel_receipts, 12, p_cr_acctd_amount);
2763: dbms_sql.define_column (sel_receipts, 13, p_cr_factor_discount_amount);
2764: dbms_sql.define_column (sel_receipts, 14, p_remmitance_ccid );

Line 2761: dbms_sql.define_column (sel_receipts, 11, p_cr_amount);

2757: dbms_sql.define_column (sel_receipts, 7, p_prv_cash_receipt_hist_id);
2758: dbms_sql.define_column (sel_receipts, 8, p_exchange_date);
2759: dbms_sql.define_column (sel_receipts, 9, p_exchange_rate);
2760: dbms_sql.define_column (sel_receipts, 10, p_exchange_type,30);
2761: dbms_sql.define_column (sel_receipts, 11, p_cr_amount);
2762: dbms_sql.define_column (sel_receipts, 12, p_cr_acctd_amount);
2763: dbms_sql.define_column (sel_receipts, 13, p_cr_factor_discount_amount);
2764: dbms_sql.define_column (sel_receipts, 14, p_remmitance_ccid );
2765: dbms_sql.define_column (sel_receipts, 15, p_bank_charges_ccid);

Line 2762: dbms_sql.define_column (sel_receipts, 12, p_cr_acctd_amount);

2758: dbms_sql.define_column (sel_receipts, 8, p_exchange_date);
2759: dbms_sql.define_column (sel_receipts, 9, p_exchange_rate);
2760: dbms_sql.define_column (sel_receipts, 10, p_exchange_type,30);
2761: dbms_sql.define_column (sel_receipts, 11, p_cr_amount);
2762: dbms_sql.define_column (sel_receipts, 12, p_cr_acctd_amount);
2763: dbms_sql.define_column (sel_receipts, 13, p_cr_factor_discount_amount);
2764: dbms_sql.define_column (sel_receipts, 14, p_remmitance_ccid );
2765: dbms_sql.define_column (sel_receipts, 15, p_bank_charges_ccid);
2766: dbms_sql.define_column (sel_receipts, 16, p_code_combination_id);

Line 2763: dbms_sql.define_column (sel_receipts, 13, p_cr_factor_discount_amount);

2759: dbms_sql.define_column (sel_receipts, 9, p_exchange_rate);
2760: dbms_sql.define_column (sel_receipts, 10, p_exchange_type,30);
2761: dbms_sql.define_column (sel_receipts, 11, p_cr_amount);
2762: dbms_sql.define_column (sel_receipts, 12, p_cr_acctd_amount);
2763: dbms_sql.define_column (sel_receipts, 13, p_cr_factor_discount_amount);
2764: dbms_sql.define_column (sel_receipts, 14, p_remmitance_ccid );
2765: dbms_sql.define_column (sel_receipts, 15, p_bank_charges_ccid);
2766: dbms_sql.define_column (sel_receipts, 16, p_code_combination_id);
2767: dbms_sql.define_column (sel_receipts, 17, p_cash_receipt_history_id);

Line 2764: dbms_sql.define_column (sel_receipts, 14, p_remmitance_ccid );

2760: dbms_sql.define_column (sel_receipts, 10, p_exchange_type,30);
2761: dbms_sql.define_column (sel_receipts, 11, p_cr_amount);
2762: dbms_sql.define_column (sel_receipts, 12, p_cr_acctd_amount);
2763: dbms_sql.define_column (sel_receipts, 13, p_cr_factor_discount_amount);
2764: dbms_sql.define_column (sel_receipts, 14, p_remmitance_ccid );
2765: dbms_sql.define_column (sel_receipts, 15, p_bank_charges_ccid);
2766: dbms_sql.define_column (sel_receipts, 16, p_code_combination_id);
2767: dbms_sql.define_column (sel_receipts, 17, p_cash_receipt_history_id);
2768: dbms_sql.define_column (sel_receipts, 18, p_crh_gl_date);

Line 2765: dbms_sql.define_column (sel_receipts, 15, p_bank_charges_ccid);

2761: dbms_sql.define_column (sel_receipts, 11, p_cr_amount);
2762: dbms_sql.define_column (sel_receipts, 12, p_cr_acctd_amount);
2763: dbms_sql.define_column (sel_receipts, 13, p_cr_factor_discount_amount);
2764: dbms_sql.define_column (sel_receipts, 14, p_remmitance_ccid );
2765: dbms_sql.define_column (sel_receipts, 15, p_bank_charges_ccid);
2766: dbms_sql.define_column (sel_receipts, 16, p_code_combination_id);
2767: dbms_sql.define_column (sel_receipts, 17, p_cash_receipt_history_id);
2768: dbms_sql.define_column (sel_receipts, 18, p_crh_gl_date);
2769: dbms_sql.define_column (sel_receipts, 19, p_crh_trx_date);

Line 2766: dbms_sql.define_column (sel_receipts, 16, p_code_combination_id);

2762: dbms_sql.define_column (sel_receipts, 12, p_cr_acctd_amount);
2763: dbms_sql.define_column (sel_receipts, 13, p_cr_factor_discount_amount);
2764: dbms_sql.define_column (sel_receipts, 14, p_remmitance_ccid );
2765: dbms_sql.define_column (sel_receipts, 15, p_bank_charges_ccid);
2766: dbms_sql.define_column (sel_receipts, 16, p_code_combination_id);
2767: dbms_sql.define_column (sel_receipts, 17, p_cash_receipt_history_id);
2768: dbms_sql.define_column (sel_receipts, 18, p_crh_gl_date);
2769: dbms_sql.define_column (sel_receipts, 19, p_crh_trx_date);
2770: dbms_sql.define_column (sel_receipts, 20, p_payment_server_order_num,80);

Line 2767: dbms_sql.define_column (sel_receipts, 17, p_cash_receipt_history_id);

2763: dbms_sql.define_column (sel_receipts, 13, p_cr_factor_discount_amount);
2764: dbms_sql.define_column (sel_receipts, 14, p_remmitance_ccid );
2765: dbms_sql.define_column (sel_receipts, 15, p_bank_charges_ccid);
2766: dbms_sql.define_column (sel_receipts, 16, p_code_combination_id);
2767: dbms_sql.define_column (sel_receipts, 17, p_cash_receipt_history_id);
2768: dbms_sql.define_column (sel_receipts, 18, p_crh_gl_date);
2769: dbms_sql.define_column (sel_receipts, 19, p_crh_trx_date);
2770: dbms_sql.define_column (sel_receipts, 20, p_payment_server_order_num,80);
2771: dbms_sql.define_column (sel_receipts, 21, p_approval_code,80);

Line 2768: dbms_sql.define_column (sel_receipts, 18, p_crh_gl_date);

2764: dbms_sql.define_column (sel_receipts, 14, p_remmitance_ccid );
2765: dbms_sql.define_column (sel_receipts, 15, p_bank_charges_ccid);
2766: dbms_sql.define_column (sel_receipts, 16, p_code_combination_id);
2767: dbms_sql.define_column (sel_receipts, 17, p_cash_receipt_history_id);
2768: dbms_sql.define_column (sel_receipts, 18, p_crh_gl_date);
2769: dbms_sql.define_column (sel_receipts, 19, p_crh_trx_date);
2770: dbms_sql.define_column (sel_receipts, 20, p_payment_server_order_num,80);
2771: dbms_sql.define_column (sel_receipts, 21, p_approval_code,80);
2772: dbms_sql.define_column (sel_receipts, 22, p_receipt_number,30);

Line 2769: dbms_sql.define_column (sel_receipts, 19, p_crh_trx_date);

2765: dbms_sql.define_column (sel_receipts, 15, p_bank_charges_ccid);
2766: dbms_sql.define_column (sel_receipts, 16, p_code_combination_id);
2767: dbms_sql.define_column (sel_receipts, 17, p_cash_receipt_history_id);
2768: dbms_sql.define_column (sel_receipts, 18, p_crh_gl_date);
2769: dbms_sql.define_column (sel_receipts, 19, p_crh_trx_date);
2770: dbms_sql.define_column (sel_receipts, 20, p_payment_server_order_num,80);
2771: dbms_sql.define_column (sel_receipts, 21, p_approval_code,80);
2772: dbms_sql.define_column (sel_receipts, 22, p_receipt_number,30);
2773: dbms_sql.define_column (sel_receipts, 23, p_unique_ref,32);

Line 2770: dbms_sql.define_column (sel_receipts, 20, p_payment_server_order_num,80);

2766: dbms_sql.define_column (sel_receipts, 16, p_code_combination_id);
2767: dbms_sql.define_column (sel_receipts, 17, p_cash_receipt_history_id);
2768: dbms_sql.define_column (sel_receipts, 18, p_crh_gl_date);
2769: dbms_sql.define_column (sel_receipts, 19, p_crh_trx_date);
2770: dbms_sql.define_column (sel_receipts, 20, p_payment_server_order_num,80);
2771: dbms_sql.define_column (sel_receipts, 21, p_approval_code,80);
2772: dbms_sql.define_column (sel_receipts, 22, p_receipt_number,30);
2773: dbms_sql.define_column (sel_receipts, 23, p_unique_ref,32);
2774: dbms_sql.define_column (sel_receipts, 24, p_customer_bank_account_id);

Line 2771: dbms_sql.define_column (sel_receipts, 21, p_approval_code,80);

2767: dbms_sql.define_column (sel_receipts, 17, p_cash_receipt_history_id);
2768: dbms_sql.define_column (sel_receipts, 18, p_crh_gl_date);
2769: dbms_sql.define_column (sel_receipts, 19, p_crh_trx_date);
2770: dbms_sql.define_column (sel_receipts, 20, p_payment_server_order_num,80);
2771: dbms_sql.define_column (sel_receipts, 21, p_approval_code,80);
2772: dbms_sql.define_column (sel_receipts, 22, p_receipt_number,30);
2773: dbms_sql.define_column (sel_receipts, 23, p_unique_ref,32);
2774: dbms_sql.define_column (sel_receipts, 24, p_customer_bank_account_id);
2775: dbms_sql.define_column (sel_receipts, 25, p_payment_trxn_extension_id);

Line 2772: dbms_sql.define_column (sel_receipts, 22, p_receipt_number,30);

2768: dbms_sql.define_column (sel_receipts, 18, p_crh_gl_date);
2769: dbms_sql.define_column (sel_receipts, 19, p_crh_trx_date);
2770: dbms_sql.define_column (sel_receipts, 20, p_payment_server_order_num,80);
2771: dbms_sql.define_column (sel_receipts, 21, p_approval_code,80);
2772: dbms_sql.define_column (sel_receipts, 22, p_receipt_number,30);
2773: dbms_sql.define_column (sel_receipts, 23, p_unique_ref,32);
2774: dbms_sql.define_column (sel_receipts, 24, p_customer_bank_account_id);
2775: dbms_sql.define_column (sel_receipts, 25, p_payment_trxn_extension_id);
2776:

Line 2773: dbms_sql.define_column (sel_receipts, 23, p_unique_ref,32);

2769: dbms_sql.define_column (sel_receipts, 19, p_crh_trx_date);
2770: dbms_sql.define_column (sel_receipts, 20, p_payment_server_order_num,80);
2771: dbms_sql.define_column (sel_receipts, 21, p_approval_code,80);
2772: dbms_sql.define_column (sel_receipts, 22, p_receipt_number,30);
2773: dbms_sql.define_column (sel_receipts, 23, p_unique_ref,32);
2774: dbms_sql.define_column (sel_receipts, 24, p_customer_bank_account_id);
2775: dbms_sql.define_column (sel_receipts, 25, p_payment_trxn_extension_id);
2776:
2777: IF PG_DEBUG in ('Y', 'C') THEN

Line 2774: dbms_sql.define_column (sel_receipts, 24, p_customer_bank_account_id);

2770: dbms_sql.define_column (sel_receipts, 20, p_payment_server_order_num,80);
2771: dbms_sql.define_column (sel_receipts, 21, p_approval_code,80);
2772: dbms_sql.define_column (sel_receipts, 22, p_receipt_number,30);
2773: dbms_sql.define_column (sel_receipts, 23, p_unique_ref,32);
2774: dbms_sql.define_column (sel_receipts, 24, p_customer_bank_account_id);
2775: dbms_sql.define_column (sel_receipts, 25, p_payment_trxn_extension_id);
2776:
2777: IF PG_DEBUG in ('Y', 'C') THEN
2778: fnd_file.put_line(FND_FILE.LOG, 'the select statemnt' || l_sel_stmt);

Line 2775: dbms_sql.define_column (sel_receipts, 25, p_payment_trxn_extension_id);

2771: dbms_sql.define_column (sel_receipts, 21, p_approval_code,80);
2772: dbms_sql.define_column (sel_receipts, 22, p_receipt_number,30);
2773: dbms_sql.define_column (sel_receipts, 23, p_unique_ref,32);
2774: dbms_sql.define_column (sel_receipts, 24, p_customer_bank_account_id);
2775: dbms_sql.define_column (sel_receipts, 25, p_payment_trxn_extension_id);
2776:
2777: IF PG_DEBUG in ('Y', 'C') THEN
2778: fnd_file.put_line(FND_FILE.LOG, 'the select statemnt' || l_sel_stmt);
2779: END IF;

Line 2781: l_rows_processed := dbms_sql.execute( sel_receipts);

2777: IF PG_DEBUG in ('Y', 'C') THEN
2778: fnd_file.put_line(FND_FILE.LOG, 'the select statemnt' || l_sel_stmt);
2779: END IF;
2780:
2781: l_rows_processed := dbms_sql.execute( sel_receipts);
2782:
2783: i:= 0;
2784:
2785: WHILE dbms_sql.fetch_rows( sel_receipts) > 0 LOOP

Line 2785: WHILE dbms_sql.fetch_rows( sel_receipts) > 0 LOOP

2781: l_rows_processed := dbms_sql.execute( sel_receipts);
2782:
2783: i:= 0;
2784:
2785: WHILE dbms_sql.fetch_rows( sel_receipts) > 0 LOOP
2786: dbms_sql.column_value (sel_receipts, 1, p_cash_receipt_id);
2787: dbms_sql.column_value (sel_receipts, 2, p_payment_type_code);
2788: dbms_sql.column_value (sel_receipts, 3, p_merchant_ref);
2789: dbms_sql.column_value (sel_receipts, 4, p_currency_code);

Line 2786: dbms_sql.column_value (sel_receipts, 1, p_cash_receipt_id);

2782:
2783: i:= 0;
2784:
2785: WHILE dbms_sql.fetch_rows( sel_receipts) > 0 LOOP
2786: dbms_sql.column_value (sel_receipts, 1, p_cash_receipt_id);
2787: dbms_sql.column_value (sel_receipts, 2, p_payment_type_code);
2788: dbms_sql.column_value (sel_receipts, 3, p_merchant_ref);
2789: dbms_sql.column_value (sel_receipts, 4, p_currency_code);
2790: dbms_sql.column_value (sel_receipts, 5, p_pay_from_customer);

Line 2787: dbms_sql.column_value (sel_receipts, 2, p_payment_type_code);

2783: i:= 0;
2784:
2785: WHILE dbms_sql.fetch_rows( sel_receipts) > 0 LOOP
2786: dbms_sql.column_value (sel_receipts, 1, p_cash_receipt_id);
2787: dbms_sql.column_value (sel_receipts, 2, p_payment_type_code);
2788: dbms_sql.column_value (sel_receipts, 3, p_merchant_ref);
2789: dbms_sql.column_value (sel_receipts, 4, p_currency_code);
2790: dbms_sql.column_value (sel_receipts, 5, p_pay_from_customer);
2791: dbms_sql.column_value (sel_receipts, 6, p_customer_site_use_id);

Line 2788: dbms_sql.column_value (sel_receipts, 3, p_merchant_ref);

2784:
2785: WHILE dbms_sql.fetch_rows( sel_receipts) > 0 LOOP
2786: dbms_sql.column_value (sel_receipts, 1, p_cash_receipt_id);
2787: dbms_sql.column_value (sel_receipts, 2, p_payment_type_code);
2788: dbms_sql.column_value (sel_receipts, 3, p_merchant_ref);
2789: dbms_sql.column_value (sel_receipts, 4, p_currency_code);
2790: dbms_sql.column_value (sel_receipts, 5, p_pay_from_customer);
2791: dbms_sql.column_value (sel_receipts, 6, p_customer_site_use_id);
2792: dbms_sql.column_value (sel_receipts, 7, p_prv_cash_receipt_hist_id);

Line 2789: dbms_sql.column_value (sel_receipts, 4, p_currency_code);

2785: WHILE dbms_sql.fetch_rows( sel_receipts) > 0 LOOP
2786: dbms_sql.column_value (sel_receipts, 1, p_cash_receipt_id);
2787: dbms_sql.column_value (sel_receipts, 2, p_payment_type_code);
2788: dbms_sql.column_value (sel_receipts, 3, p_merchant_ref);
2789: dbms_sql.column_value (sel_receipts, 4, p_currency_code);
2790: dbms_sql.column_value (sel_receipts, 5, p_pay_from_customer);
2791: dbms_sql.column_value (sel_receipts, 6, p_customer_site_use_id);
2792: dbms_sql.column_value (sel_receipts, 7, p_prv_cash_receipt_hist_id);
2793: dbms_sql.column_value (sel_receipts, 8, p_exchange_date);

Line 2790: dbms_sql.column_value (sel_receipts, 5, p_pay_from_customer);

2786: dbms_sql.column_value (sel_receipts, 1, p_cash_receipt_id);
2787: dbms_sql.column_value (sel_receipts, 2, p_payment_type_code);
2788: dbms_sql.column_value (sel_receipts, 3, p_merchant_ref);
2789: dbms_sql.column_value (sel_receipts, 4, p_currency_code);
2790: dbms_sql.column_value (sel_receipts, 5, p_pay_from_customer);
2791: dbms_sql.column_value (sel_receipts, 6, p_customer_site_use_id);
2792: dbms_sql.column_value (sel_receipts, 7, p_prv_cash_receipt_hist_id);
2793: dbms_sql.column_value (sel_receipts, 8, p_exchange_date);
2794: dbms_sql.column_value (sel_receipts, 9, p_exchange_rate);

Line 2791: dbms_sql.column_value (sel_receipts, 6, p_customer_site_use_id);

2787: dbms_sql.column_value (sel_receipts, 2, p_payment_type_code);
2788: dbms_sql.column_value (sel_receipts, 3, p_merchant_ref);
2789: dbms_sql.column_value (sel_receipts, 4, p_currency_code);
2790: dbms_sql.column_value (sel_receipts, 5, p_pay_from_customer);
2791: dbms_sql.column_value (sel_receipts, 6, p_customer_site_use_id);
2792: dbms_sql.column_value (sel_receipts, 7, p_prv_cash_receipt_hist_id);
2793: dbms_sql.column_value (sel_receipts, 8, p_exchange_date);
2794: dbms_sql.column_value (sel_receipts, 9, p_exchange_rate);
2795: dbms_sql.column_value (sel_receipts, 10, p_exchange_type);

Line 2792: dbms_sql.column_value (sel_receipts, 7, p_prv_cash_receipt_hist_id);

2788: dbms_sql.column_value (sel_receipts, 3, p_merchant_ref);
2789: dbms_sql.column_value (sel_receipts, 4, p_currency_code);
2790: dbms_sql.column_value (sel_receipts, 5, p_pay_from_customer);
2791: dbms_sql.column_value (sel_receipts, 6, p_customer_site_use_id);
2792: dbms_sql.column_value (sel_receipts, 7, p_prv_cash_receipt_hist_id);
2793: dbms_sql.column_value (sel_receipts, 8, p_exchange_date);
2794: dbms_sql.column_value (sel_receipts, 9, p_exchange_rate);
2795: dbms_sql.column_value (sel_receipts, 10, p_exchange_type);
2796: dbms_sql.column_value (sel_receipts, 11, p_cr_amount);

Line 2793: dbms_sql.column_value (sel_receipts, 8, p_exchange_date);

2789: dbms_sql.column_value (sel_receipts, 4, p_currency_code);
2790: dbms_sql.column_value (sel_receipts, 5, p_pay_from_customer);
2791: dbms_sql.column_value (sel_receipts, 6, p_customer_site_use_id);
2792: dbms_sql.column_value (sel_receipts, 7, p_prv_cash_receipt_hist_id);
2793: dbms_sql.column_value (sel_receipts, 8, p_exchange_date);
2794: dbms_sql.column_value (sel_receipts, 9, p_exchange_rate);
2795: dbms_sql.column_value (sel_receipts, 10, p_exchange_type);
2796: dbms_sql.column_value (sel_receipts, 11, p_cr_amount);
2797: dbms_sql.column_value (sel_receipts, 12, p_cr_acctd_amount);

Line 2794: dbms_sql.column_value (sel_receipts, 9, p_exchange_rate);

2790: dbms_sql.column_value (sel_receipts, 5, p_pay_from_customer);
2791: dbms_sql.column_value (sel_receipts, 6, p_customer_site_use_id);
2792: dbms_sql.column_value (sel_receipts, 7, p_prv_cash_receipt_hist_id);
2793: dbms_sql.column_value (sel_receipts, 8, p_exchange_date);
2794: dbms_sql.column_value (sel_receipts, 9, p_exchange_rate);
2795: dbms_sql.column_value (sel_receipts, 10, p_exchange_type);
2796: dbms_sql.column_value (sel_receipts, 11, p_cr_amount);
2797: dbms_sql.column_value (sel_receipts, 12, p_cr_acctd_amount);
2798: dbms_sql.column_value (sel_receipts, 13, p_cr_factor_discount_amount);

Line 2795: dbms_sql.column_value (sel_receipts, 10, p_exchange_type);

2791: dbms_sql.column_value (sel_receipts, 6, p_customer_site_use_id);
2792: dbms_sql.column_value (sel_receipts, 7, p_prv_cash_receipt_hist_id);
2793: dbms_sql.column_value (sel_receipts, 8, p_exchange_date);
2794: dbms_sql.column_value (sel_receipts, 9, p_exchange_rate);
2795: dbms_sql.column_value (sel_receipts, 10, p_exchange_type);
2796: dbms_sql.column_value (sel_receipts, 11, p_cr_amount);
2797: dbms_sql.column_value (sel_receipts, 12, p_cr_acctd_amount);
2798: dbms_sql.column_value (sel_receipts, 13, p_cr_factor_discount_amount);
2799: dbms_sql.column_value (sel_receipts, 14, p_remmitance_ccid );

Line 2796: dbms_sql.column_value (sel_receipts, 11, p_cr_amount);

2792: dbms_sql.column_value (sel_receipts, 7, p_prv_cash_receipt_hist_id);
2793: dbms_sql.column_value (sel_receipts, 8, p_exchange_date);
2794: dbms_sql.column_value (sel_receipts, 9, p_exchange_rate);
2795: dbms_sql.column_value (sel_receipts, 10, p_exchange_type);
2796: dbms_sql.column_value (sel_receipts, 11, p_cr_amount);
2797: dbms_sql.column_value (sel_receipts, 12, p_cr_acctd_amount);
2798: dbms_sql.column_value (sel_receipts, 13, p_cr_factor_discount_amount);
2799: dbms_sql.column_value (sel_receipts, 14, p_remmitance_ccid );
2800: dbms_sql.column_value (sel_receipts, 15, p_bank_charges_ccid);

Line 2797: dbms_sql.column_value (sel_receipts, 12, p_cr_acctd_amount);

2793: dbms_sql.column_value (sel_receipts, 8, p_exchange_date);
2794: dbms_sql.column_value (sel_receipts, 9, p_exchange_rate);
2795: dbms_sql.column_value (sel_receipts, 10, p_exchange_type);
2796: dbms_sql.column_value (sel_receipts, 11, p_cr_amount);
2797: dbms_sql.column_value (sel_receipts, 12, p_cr_acctd_amount);
2798: dbms_sql.column_value (sel_receipts, 13, p_cr_factor_discount_amount);
2799: dbms_sql.column_value (sel_receipts, 14, p_remmitance_ccid );
2800: dbms_sql.column_value (sel_receipts, 15, p_bank_charges_ccid);
2801: dbms_sql.column_value (sel_receipts, 16, p_code_combination_id);

Line 2798: dbms_sql.column_value (sel_receipts, 13, p_cr_factor_discount_amount);

2794: dbms_sql.column_value (sel_receipts, 9, p_exchange_rate);
2795: dbms_sql.column_value (sel_receipts, 10, p_exchange_type);
2796: dbms_sql.column_value (sel_receipts, 11, p_cr_amount);
2797: dbms_sql.column_value (sel_receipts, 12, p_cr_acctd_amount);
2798: dbms_sql.column_value (sel_receipts, 13, p_cr_factor_discount_amount);
2799: dbms_sql.column_value (sel_receipts, 14, p_remmitance_ccid );
2800: dbms_sql.column_value (sel_receipts, 15, p_bank_charges_ccid);
2801: dbms_sql.column_value (sel_receipts, 16, p_code_combination_id);
2802: dbms_sql.column_value (sel_receipts, 17, p_cash_receipt_history_id);

Line 2799: dbms_sql.column_value (sel_receipts, 14, p_remmitance_ccid );

2795: dbms_sql.column_value (sel_receipts, 10, p_exchange_type);
2796: dbms_sql.column_value (sel_receipts, 11, p_cr_amount);
2797: dbms_sql.column_value (sel_receipts, 12, p_cr_acctd_amount);
2798: dbms_sql.column_value (sel_receipts, 13, p_cr_factor_discount_amount);
2799: dbms_sql.column_value (sel_receipts, 14, p_remmitance_ccid );
2800: dbms_sql.column_value (sel_receipts, 15, p_bank_charges_ccid);
2801: dbms_sql.column_value (sel_receipts, 16, p_code_combination_id);
2802: dbms_sql.column_value (sel_receipts, 17, p_cash_receipt_history_id);
2803: dbms_sql.column_value (sel_receipts, 18, p_crh_gl_date);

Line 2800: dbms_sql.column_value (sel_receipts, 15, p_bank_charges_ccid);

2796: dbms_sql.column_value (sel_receipts, 11, p_cr_amount);
2797: dbms_sql.column_value (sel_receipts, 12, p_cr_acctd_amount);
2798: dbms_sql.column_value (sel_receipts, 13, p_cr_factor_discount_amount);
2799: dbms_sql.column_value (sel_receipts, 14, p_remmitance_ccid );
2800: dbms_sql.column_value (sel_receipts, 15, p_bank_charges_ccid);
2801: dbms_sql.column_value (sel_receipts, 16, p_code_combination_id);
2802: dbms_sql.column_value (sel_receipts, 17, p_cash_receipt_history_id);
2803: dbms_sql.column_value (sel_receipts, 18, p_crh_gl_date);
2804: dbms_sql.column_value (sel_receipts, 19, p_crh_trx_date);

Line 2801: dbms_sql.column_value (sel_receipts, 16, p_code_combination_id);

2797: dbms_sql.column_value (sel_receipts, 12, p_cr_acctd_amount);
2798: dbms_sql.column_value (sel_receipts, 13, p_cr_factor_discount_amount);
2799: dbms_sql.column_value (sel_receipts, 14, p_remmitance_ccid );
2800: dbms_sql.column_value (sel_receipts, 15, p_bank_charges_ccid);
2801: dbms_sql.column_value (sel_receipts, 16, p_code_combination_id);
2802: dbms_sql.column_value (sel_receipts, 17, p_cash_receipt_history_id);
2803: dbms_sql.column_value (sel_receipts, 18, p_crh_gl_date);
2804: dbms_sql.column_value (sel_receipts, 19, p_crh_trx_date);
2805: dbms_sql.column_value (sel_receipts, 20, p_payment_server_order_num);

Line 2802: dbms_sql.column_value (sel_receipts, 17, p_cash_receipt_history_id);

2798: dbms_sql.column_value (sel_receipts, 13, p_cr_factor_discount_amount);
2799: dbms_sql.column_value (sel_receipts, 14, p_remmitance_ccid );
2800: dbms_sql.column_value (sel_receipts, 15, p_bank_charges_ccid);
2801: dbms_sql.column_value (sel_receipts, 16, p_code_combination_id);
2802: dbms_sql.column_value (sel_receipts, 17, p_cash_receipt_history_id);
2803: dbms_sql.column_value (sel_receipts, 18, p_crh_gl_date);
2804: dbms_sql.column_value (sel_receipts, 19, p_crh_trx_date);
2805: dbms_sql.column_value (sel_receipts, 20, p_payment_server_order_num);
2806: dbms_sql.column_value (sel_receipts, 21, p_approval_code);

Line 2803: dbms_sql.column_value (sel_receipts, 18, p_crh_gl_date);

2799: dbms_sql.column_value (sel_receipts, 14, p_remmitance_ccid );
2800: dbms_sql.column_value (sel_receipts, 15, p_bank_charges_ccid);
2801: dbms_sql.column_value (sel_receipts, 16, p_code_combination_id);
2802: dbms_sql.column_value (sel_receipts, 17, p_cash_receipt_history_id);
2803: dbms_sql.column_value (sel_receipts, 18, p_crh_gl_date);
2804: dbms_sql.column_value (sel_receipts, 19, p_crh_trx_date);
2805: dbms_sql.column_value (sel_receipts, 20, p_payment_server_order_num);
2806: dbms_sql.column_value (sel_receipts, 21, p_approval_code);
2807: dbms_sql.column_value (sel_receipts, 22, p_receipt_number);

Line 2804: dbms_sql.column_value (sel_receipts, 19, p_crh_trx_date);

2800: dbms_sql.column_value (sel_receipts, 15, p_bank_charges_ccid);
2801: dbms_sql.column_value (sel_receipts, 16, p_code_combination_id);
2802: dbms_sql.column_value (sel_receipts, 17, p_cash_receipt_history_id);
2803: dbms_sql.column_value (sel_receipts, 18, p_crh_gl_date);
2804: dbms_sql.column_value (sel_receipts, 19, p_crh_trx_date);
2805: dbms_sql.column_value (sel_receipts, 20, p_payment_server_order_num);
2806: dbms_sql.column_value (sel_receipts, 21, p_approval_code);
2807: dbms_sql.column_value (sel_receipts, 22, p_receipt_number);
2808: dbms_sql.column_value (sel_receipts, 23, p_unique_ref);

Line 2805: dbms_sql.column_value (sel_receipts, 20, p_payment_server_order_num);

2801: dbms_sql.column_value (sel_receipts, 16, p_code_combination_id);
2802: dbms_sql.column_value (sel_receipts, 17, p_cash_receipt_history_id);
2803: dbms_sql.column_value (sel_receipts, 18, p_crh_gl_date);
2804: dbms_sql.column_value (sel_receipts, 19, p_crh_trx_date);
2805: dbms_sql.column_value (sel_receipts, 20, p_payment_server_order_num);
2806: dbms_sql.column_value (sel_receipts, 21, p_approval_code);
2807: dbms_sql.column_value (sel_receipts, 22, p_receipt_number);
2808: dbms_sql.column_value (sel_receipts, 23, p_unique_ref);
2809: dbms_sql.column_value (sel_receipts, 24, p_customer_bank_account_id);

Line 2806: dbms_sql.column_value (sel_receipts, 21, p_approval_code);

2802: dbms_sql.column_value (sel_receipts, 17, p_cash_receipt_history_id);
2803: dbms_sql.column_value (sel_receipts, 18, p_crh_gl_date);
2804: dbms_sql.column_value (sel_receipts, 19, p_crh_trx_date);
2805: dbms_sql.column_value (sel_receipts, 20, p_payment_server_order_num);
2806: dbms_sql.column_value (sel_receipts, 21, p_approval_code);
2807: dbms_sql.column_value (sel_receipts, 22, p_receipt_number);
2808: dbms_sql.column_value (sel_receipts, 23, p_unique_ref);
2809: dbms_sql.column_value (sel_receipts, 24, p_customer_bank_account_id);
2810: dbms_sql.column_value (sel_receipts, 25, p_payment_trxn_extension_id);

Line 2807: dbms_sql.column_value (sel_receipts, 22, p_receipt_number);

2803: dbms_sql.column_value (sel_receipts, 18, p_crh_gl_date);
2804: dbms_sql.column_value (sel_receipts, 19, p_crh_trx_date);
2805: dbms_sql.column_value (sel_receipts, 20, p_payment_server_order_num);
2806: dbms_sql.column_value (sel_receipts, 21, p_approval_code);
2807: dbms_sql.column_value (sel_receipts, 22, p_receipt_number);
2808: dbms_sql.column_value (sel_receipts, 23, p_unique_ref);
2809: dbms_sql.column_value (sel_receipts, 24, p_customer_bank_account_id);
2810: dbms_sql.column_value (sel_receipts, 25, p_payment_trxn_extension_id);
2811:

Line 2808: dbms_sql.column_value (sel_receipts, 23, p_unique_ref);

2804: dbms_sql.column_value (sel_receipts, 19, p_crh_trx_date);
2805: dbms_sql.column_value (sel_receipts, 20, p_payment_server_order_num);
2806: dbms_sql.column_value (sel_receipts, 21, p_approval_code);
2807: dbms_sql.column_value (sel_receipts, 22, p_receipt_number);
2808: dbms_sql.column_value (sel_receipts, 23, p_unique_ref);
2809: dbms_sql.column_value (sel_receipts, 24, p_customer_bank_account_id);
2810: dbms_sql.column_value (sel_receipts, 25, p_payment_trxn_extension_id);
2811:
2812: IF PG_DEBUG in ( 'Y','C') THEN

Line 2809: dbms_sql.column_value (sel_receipts, 24, p_customer_bank_account_id);

2805: dbms_sql.column_value (sel_receipts, 20, p_payment_server_order_num);
2806: dbms_sql.column_value (sel_receipts, 21, p_approval_code);
2807: dbms_sql.column_value (sel_receipts, 22, p_receipt_number);
2808: dbms_sql.column_value (sel_receipts, 23, p_unique_ref);
2809: dbms_sql.column_value (sel_receipts, 24, p_customer_bank_account_id);
2810: dbms_sql.column_value (sel_receipts, 25, p_payment_trxn_extension_id);
2811:
2812: IF PG_DEBUG in ( 'Y','C') THEN
2813: fnd_file.put_line(FND_FILE.LOG,

Line 2810: dbms_sql.column_value (sel_receipts, 25, p_payment_trxn_extension_id);

2806: dbms_sql.column_value (sel_receipts, 21, p_approval_code);
2807: dbms_sql.column_value (sel_receipts, 22, p_receipt_number);
2808: dbms_sql.column_value (sel_receipts, 23, p_unique_ref);
2809: dbms_sql.column_value (sel_receipts, 24, p_customer_bank_account_id);
2810: dbms_sql.column_value (sel_receipts, 25, p_payment_trxn_extension_id);
2811:
2812: IF PG_DEBUG in ( 'Y','C') THEN
2813: fnd_file.put_line(FND_FILE.LOG,
2814: 'the value of ps_id ' || p_cash_receipt_id);

Line 2853: l_rows_fetched := dbms_sql.last_row_count ;

2849: END IF;
2850:
2851: END LOOP;
2852:
2853: l_rows_fetched := dbms_sql.last_row_count ;
2854:
2855: IF PG_DEBUG in ('Y', 'C') THEN
2856: fnd_file.put_line(FND_FILE.LOG,'the no of rows fetched ' || l_rows_fetched);
2857: END IF;

Line 2859: dbms_sql.close_cursor( sel_receipts);

2855: IF PG_DEBUG in ('Y', 'C') THEN
2856: fnd_file.put_line(FND_FILE.LOG,'the no of rows fetched ' || l_rows_fetched);
2857: END IF;
2858:
2859: dbms_sql.close_cursor( sel_receipts);
2860:
2861: IF PG_DEBUG in ('Y', 'C') THEN
2862: fnd_file.put_line(FND_FILE.LOG,'selrem and create and upd 1()-');
2863: END IF;

Line 2888: rem_t := dbms_sql.open_cursor;

2884: :c6_array,:c7_array,:c8_array,:c9_array,:c10_array,:c11_array,:c12_array,
2885: :c13_array,:c14_array,:c15_array,:c16_array,:c17_array,:c18_array,
2886: :c19_array,:c20_array,:c21_array,:c22_array,:c23_array,:c24_array,:c25_array)';
2887:
2888: rem_t := dbms_sql.open_cursor;
2889:
2890: dbms_sql.parse (rem_t,inst_stmt,dbms_sql.v7);
2891:
2892: dbms_sql.bind_array (rem_t,':c1_array',cash_receipt_id_array);

Line 2890: dbms_sql.parse (rem_t,inst_stmt,dbms_sql.v7);

2886: :c19_array,:c20_array,:c21_array,:c22_array,:c23_array,:c24_array,:c25_array)';
2887:
2888: rem_t := dbms_sql.open_cursor;
2889:
2890: dbms_sql.parse (rem_t,inst_stmt,dbms_sql.v7);
2891:
2892: dbms_sql.bind_array (rem_t,':c1_array',cash_receipt_id_array);
2893: dbms_sql.bind_array (rem_t,':c2_array',payment_type_CODE_array);
2894: dbms_sql.bind_array (rem_t,':c3_array',merchant_ref_array);

Line 2892: dbms_sql.bind_array (rem_t,':c1_array',cash_receipt_id_array);

2888: rem_t := dbms_sql.open_cursor;
2889:
2890: dbms_sql.parse (rem_t,inst_stmt,dbms_sql.v7);
2891:
2892: dbms_sql.bind_array (rem_t,':c1_array',cash_receipt_id_array);
2893: dbms_sql.bind_array (rem_t,':c2_array',payment_type_CODE_array);
2894: dbms_sql.bind_array (rem_t,':c3_array',merchant_ref_array);
2895: dbms_sql.bind_array (rem_t,':c4_array',currency_code_array);
2896: dbms_sql.bind_array (rem_t,':c5_array',pay_from_customer_array);

Line 2893: dbms_sql.bind_array (rem_t,':c2_array',payment_type_CODE_array);

2889:
2890: dbms_sql.parse (rem_t,inst_stmt,dbms_sql.v7);
2891:
2892: dbms_sql.bind_array (rem_t,':c1_array',cash_receipt_id_array);
2893: dbms_sql.bind_array (rem_t,':c2_array',payment_type_CODE_array);
2894: dbms_sql.bind_array (rem_t,':c3_array',merchant_ref_array);
2895: dbms_sql.bind_array (rem_t,':c4_array',currency_code_array);
2896: dbms_sql.bind_array (rem_t,':c5_array',pay_from_customer_array);
2897: dbms_sql.bind_array (rem_t,':c6_array',customer_site_use_id_array);

Line 2894: dbms_sql.bind_array (rem_t,':c3_array',merchant_ref_array);

2890: dbms_sql.parse (rem_t,inst_stmt,dbms_sql.v7);
2891:
2892: dbms_sql.bind_array (rem_t,':c1_array',cash_receipt_id_array);
2893: dbms_sql.bind_array (rem_t,':c2_array',payment_type_CODE_array);
2894: dbms_sql.bind_array (rem_t,':c3_array',merchant_ref_array);
2895: dbms_sql.bind_array (rem_t,':c4_array',currency_code_array);
2896: dbms_sql.bind_array (rem_t,':c5_array',pay_from_customer_array);
2897: dbms_sql.bind_array (rem_t,':c6_array',customer_site_use_id_array);
2898: dbms_sql.bind_array (rem_t,':c7_array',prv_cash_receipt_hist_id_array);

Line 2895: dbms_sql.bind_array (rem_t,':c4_array',currency_code_array);

2891:
2892: dbms_sql.bind_array (rem_t,':c1_array',cash_receipt_id_array);
2893: dbms_sql.bind_array (rem_t,':c2_array',payment_type_CODE_array);
2894: dbms_sql.bind_array (rem_t,':c3_array',merchant_ref_array);
2895: dbms_sql.bind_array (rem_t,':c4_array',currency_code_array);
2896: dbms_sql.bind_array (rem_t,':c5_array',pay_from_customer_array);
2897: dbms_sql.bind_array (rem_t,':c6_array',customer_site_use_id_array);
2898: dbms_sql.bind_array (rem_t,':c7_array',prv_cash_receipt_hist_id_array);
2899: dbms_sql.bind_array (rem_t,':c8_array',exchange_date_array);

Line 2896: dbms_sql.bind_array (rem_t,':c5_array',pay_from_customer_array);

2892: dbms_sql.bind_array (rem_t,':c1_array',cash_receipt_id_array);
2893: dbms_sql.bind_array (rem_t,':c2_array',payment_type_CODE_array);
2894: dbms_sql.bind_array (rem_t,':c3_array',merchant_ref_array);
2895: dbms_sql.bind_array (rem_t,':c4_array',currency_code_array);
2896: dbms_sql.bind_array (rem_t,':c5_array',pay_from_customer_array);
2897: dbms_sql.bind_array (rem_t,':c6_array',customer_site_use_id_array);
2898: dbms_sql.bind_array (rem_t,':c7_array',prv_cash_receipt_hist_id_array);
2899: dbms_sql.bind_array (rem_t,':c8_array',exchange_date_array);
2900: dbms_sql.bind_array (rem_t,':c9_array',exchange_rate_array);

Line 2897: dbms_sql.bind_array (rem_t,':c6_array',customer_site_use_id_array);

2893: dbms_sql.bind_array (rem_t,':c2_array',payment_type_CODE_array);
2894: dbms_sql.bind_array (rem_t,':c3_array',merchant_ref_array);
2895: dbms_sql.bind_array (rem_t,':c4_array',currency_code_array);
2896: dbms_sql.bind_array (rem_t,':c5_array',pay_from_customer_array);
2897: dbms_sql.bind_array (rem_t,':c6_array',customer_site_use_id_array);
2898: dbms_sql.bind_array (rem_t,':c7_array',prv_cash_receipt_hist_id_array);
2899: dbms_sql.bind_array (rem_t,':c8_array',exchange_date_array);
2900: dbms_sql.bind_array (rem_t,':c9_array',exchange_rate_array);
2901: dbms_sql.bind_array (rem_t,':c10_array',exchange_type_array);

Line 2898: dbms_sql.bind_array (rem_t,':c7_array',prv_cash_receipt_hist_id_array);

2894: dbms_sql.bind_array (rem_t,':c3_array',merchant_ref_array);
2895: dbms_sql.bind_array (rem_t,':c4_array',currency_code_array);
2896: dbms_sql.bind_array (rem_t,':c5_array',pay_from_customer_array);
2897: dbms_sql.bind_array (rem_t,':c6_array',customer_site_use_id_array);
2898: dbms_sql.bind_array (rem_t,':c7_array',prv_cash_receipt_hist_id_array);
2899: dbms_sql.bind_array (rem_t,':c8_array',exchange_date_array);
2900: dbms_sql.bind_array (rem_t,':c9_array',exchange_rate_array);
2901: dbms_sql.bind_array (rem_t,':c10_array',exchange_type_array);
2902: dbms_sql.bind_array (rem_t,':c11_array',cr_amount_array);

Line 2899: dbms_sql.bind_array (rem_t,':c8_array',exchange_date_array);

2895: dbms_sql.bind_array (rem_t,':c4_array',currency_code_array);
2896: dbms_sql.bind_array (rem_t,':c5_array',pay_from_customer_array);
2897: dbms_sql.bind_array (rem_t,':c6_array',customer_site_use_id_array);
2898: dbms_sql.bind_array (rem_t,':c7_array',prv_cash_receipt_hist_id_array);
2899: dbms_sql.bind_array (rem_t,':c8_array',exchange_date_array);
2900: dbms_sql.bind_array (rem_t,':c9_array',exchange_rate_array);
2901: dbms_sql.bind_array (rem_t,':c10_array',exchange_type_array);
2902: dbms_sql.bind_array (rem_t,':c11_array',cr_amount_array);
2903: dbms_sql.bind_array (rem_t,':c12_array',cr_acctd_amount_array);

Line 2900: dbms_sql.bind_array (rem_t,':c9_array',exchange_rate_array);

2896: dbms_sql.bind_array (rem_t,':c5_array',pay_from_customer_array);
2897: dbms_sql.bind_array (rem_t,':c6_array',customer_site_use_id_array);
2898: dbms_sql.bind_array (rem_t,':c7_array',prv_cash_receipt_hist_id_array);
2899: dbms_sql.bind_array (rem_t,':c8_array',exchange_date_array);
2900: dbms_sql.bind_array (rem_t,':c9_array',exchange_rate_array);
2901: dbms_sql.bind_array (rem_t,':c10_array',exchange_type_array);
2902: dbms_sql.bind_array (rem_t,':c11_array',cr_amount_array);
2903: dbms_sql.bind_array (rem_t,':c12_array',cr_acctd_amount_array);
2904: dbms_sql.bind_array (rem_t,':c13_array',cr_factor_discount_amt_array);

Line 2901: dbms_sql.bind_array (rem_t,':c10_array',exchange_type_array);

2897: dbms_sql.bind_array (rem_t,':c6_array',customer_site_use_id_array);
2898: dbms_sql.bind_array (rem_t,':c7_array',prv_cash_receipt_hist_id_array);
2899: dbms_sql.bind_array (rem_t,':c8_array',exchange_date_array);
2900: dbms_sql.bind_array (rem_t,':c9_array',exchange_rate_array);
2901: dbms_sql.bind_array (rem_t,':c10_array',exchange_type_array);
2902: dbms_sql.bind_array (rem_t,':c11_array',cr_amount_array);
2903: dbms_sql.bind_array (rem_t,':c12_array',cr_acctd_amount_array);
2904: dbms_sql.bind_array (rem_t,':c13_array',cr_factor_discount_amt_array);
2905: dbms_sql.bind_array (rem_t,':c14_array',remmitance_ccid_array);

Line 2902: dbms_sql.bind_array (rem_t,':c11_array',cr_amount_array);

2898: dbms_sql.bind_array (rem_t,':c7_array',prv_cash_receipt_hist_id_array);
2899: dbms_sql.bind_array (rem_t,':c8_array',exchange_date_array);
2900: dbms_sql.bind_array (rem_t,':c9_array',exchange_rate_array);
2901: dbms_sql.bind_array (rem_t,':c10_array',exchange_type_array);
2902: dbms_sql.bind_array (rem_t,':c11_array',cr_amount_array);
2903: dbms_sql.bind_array (rem_t,':c12_array',cr_acctd_amount_array);
2904: dbms_sql.bind_array (rem_t,':c13_array',cr_factor_discount_amt_array);
2905: dbms_sql.bind_array (rem_t,':c14_array',remmitance_ccid_array);
2906: dbms_sql.bind_array (rem_t,':c15_array',bank_charges_ccid_array);

Line 2903: dbms_sql.bind_array (rem_t,':c12_array',cr_acctd_amount_array);

2899: dbms_sql.bind_array (rem_t,':c8_array',exchange_date_array);
2900: dbms_sql.bind_array (rem_t,':c9_array',exchange_rate_array);
2901: dbms_sql.bind_array (rem_t,':c10_array',exchange_type_array);
2902: dbms_sql.bind_array (rem_t,':c11_array',cr_amount_array);
2903: dbms_sql.bind_array (rem_t,':c12_array',cr_acctd_amount_array);
2904: dbms_sql.bind_array (rem_t,':c13_array',cr_factor_discount_amt_array);
2905: dbms_sql.bind_array (rem_t,':c14_array',remmitance_ccid_array);
2906: dbms_sql.bind_array (rem_t,':c15_array',bank_charges_ccid_array);
2907: dbms_sql.bind_array (rem_t,':c16_array',code_combination_id_array);

Line 2904: dbms_sql.bind_array (rem_t,':c13_array',cr_factor_discount_amt_array);

2900: dbms_sql.bind_array (rem_t,':c9_array',exchange_rate_array);
2901: dbms_sql.bind_array (rem_t,':c10_array',exchange_type_array);
2902: dbms_sql.bind_array (rem_t,':c11_array',cr_amount_array);
2903: dbms_sql.bind_array (rem_t,':c12_array',cr_acctd_amount_array);
2904: dbms_sql.bind_array (rem_t,':c13_array',cr_factor_discount_amt_array);
2905: dbms_sql.bind_array (rem_t,':c14_array',remmitance_ccid_array);
2906: dbms_sql.bind_array (rem_t,':c15_array',bank_charges_ccid_array);
2907: dbms_sql.bind_array (rem_t,':c16_array',code_combination_id_array);
2908: dbms_sql.bind_array (rem_t,':c17_array',cash_receipt_history_id_array);

Line 2905: dbms_sql.bind_array (rem_t,':c14_array',remmitance_ccid_array);

2901: dbms_sql.bind_array (rem_t,':c10_array',exchange_type_array);
2902: dbms_sql.bind_array (rem_t,':c11_array',cr_amount_array);
2903: dbms_sql.bind_array (rem_t,':c12_array',cr_acctd_amount_array);
2904: dbms_sql.bind_array (rem_t,':c13_array',cr_factor_discount_amt_array);
2905: dbms_sql.bind_array (rem_t,':c14_array',remmitance_ccid_array);
2906: dbms_sql.bind_array (rem_t,':c15_array',bank_charges_ccid_array);
2907: dbms_sql.bind_array (rem_t,':c16_array',code_combination_id_array);
2908: dbms_sql.bind_array (rem_t,':c17_array',cash_receipt_history_id_array);
2909: dbms_sql.bind_array (rem_t,':c18_array',crh_gl_date_array);

Line 2906: dbms_sql.bind_array (rem_t,':c15_array',bank_charges_ccid_array);

2902: dbms_sql.bind_array (rem_t,':c11_array',cr_amount_array);
2903: dbms_sql.bind_array (rem_t,':c12_array',cr_acctd_amount_array);
2904: dbms_sql.bind_array (rem_t,':c13_array',cr_factor_discount_amt_array);
2905: dbms_sql.bind_array (rem_t,':c14_array',remmitance_ccid_array);
2906: dbms_sql.bind_array (rem_t,':c15_array',bank_charges_ccid_array);
2907: dbms_sql.bind_array (rem_t,':c16_array',code_combination_id_array);
2908: dbms_sql.bind_array (rem_t,':c17_array',cash_receipt_history_id_array);
2909: dbms_sql.bind_array (rem_t,':c18_array',crh_gl_date_array);
2910: dbms_sql.bind_array (rem_t,':c19_array',crh_trx_date_array);

Line 2907: dbms_sql.bind_array (rem_t,':c16_array',code_combination_id_array);

2903: dbms_sql.bind_array (rem_t,':c12_array',cr_acctd_amount_array);
2904: dbms_sql.bind_array (rem_t,':c13_array',cr_factor_discount_amt_array);
2905: dbms_sql.bind_array (rem_t,':c14_array',remmitance_ccid_array);
2906: dbms_sql.bind_array (rem_t,':c15_array',bank_charges_ccid_array);
2907: dbms_sql.bind_array (rem_t,':c16_array',code_combination_id_array);
2908: dbms_sql.bind_array (rem_t,':c17_array',cash_receipt_history_id_array);
2909: dbms_sql.bind_array (rem_t,':c18_array',crh_gl_date_array);
2910: dbms_sql.bind_array (rem_t,':c19_array',crh_trx_date_array);
2911: dbms_sql.bind_array (rem_t,':c20_array',payment_server_order_num_array);

Line 2908: dbms_sql.bind_array (rem_t,':c17_array',cash_receipt_history_id_array);

2904: dbms_sql.bind_array (rem_t,':c13_array',cr_factor_discount_amt_array);
2905: dbms_sql.bind_array (rem_t,':c14_array',remmitance_ccid_array);
2906: dbms_sql.bind_array (rem_t,':c15_array',bank_charges_ccid_array);
2907: dbms_sql.bind_array (rem_t,':c16_array',code_combination_id_array);
2908: dbms_sql.bind_array (rem_t,':c17_array',cash_receipt_history_id_array);
2909: dbms_sql.bind_array (rem_t,':c18_array',crh_gl_date_array);
2910: dbms_sql.bind_array (rem_t,':c19_array',crh_trx_date_array);
2911: dbms_sql.bind_array (rem_t,':c20_array',payment_server_order_num_array);
2912: dbms_sql.bind_array (rem_t,':c21_array',approval_code_array);

Line 2909: dbms_sql.bind_array (rem_t,':c18_array',crh_gl_date_array);

2905: dbms_sql.bind_array (rem_t,':c14_array',remmitance_ccid_array);
2906: dbms_sql.bind_array (rem_t,':c15_array',bank_charges_ccid_array);
2907: dbms_sql.bind_array (rem_t,':c16_array',code_combination_id_array);
2908: dbms_sql.bind_array (rem_t,':c17_array',cash_receipt_history_id_array);
2909: dbms_sql.bind_array (rem_t,':c18_array',crh_gl_date_array);
2910: dbms_sql.bind_array (rem_t,':c19_array',crh_trx_date_array);
2911: dbms_sql.bind_array (rem_t,':c20_array',payment_server_order_num_array);
2912: dbms_sql.bind_array (rem_t,':c21_array',approval_code_array);
2913: dbms_sql.bind_array (rem_t,':c22_array',receipt_number_array);

Line 2910: dbms_sql.bind_array (rem_t,':c19_array',crh_trx_date_array);

2906: dbms_sql.bind_array (rem_t,':c15_array',bank_charges_ccid_array);
2907: dbms_sql.bind_array (rem_t,':c16_array',code_combination_id_array);
2908: dbms_sql.bind_array (rem_t,':c17_array',cash_receipt_history_id_array);
2909: dbms_sql.bind_array (rem_t,':c18_array',crh_gl_date_array);
2910: dbms_sql.bind_array (rem_t,':c19_array',crh_trx_date_array);
2911: dbms_sql.bind_array (rem_t,':c20_array',payment_server_order_num_array);
2912: dbms_sql.bind_array (rem_t,':c21_array',approval_code_array);
2913: dbms_sql.bind_array (rem_t,':c22_array',receipt_number_array);
2914: dbms_sql.bind_array (rem_t,':c23_array',unique_ref_array);

Line 2911: dbms_sql.bind_array (rem_t,':c20_array',payment_server_order_num_array);

2907: dbms_sql.bind_array (rem_t,':c16_array',code_combination_id_array);
2908: dbms_sql.bind_array (rem_t,':c17_array',cash_receipt_history_id_array);
2909: dbms_sql.bind_array (rem_t,':c18_array',crh_gl_date_array);
2910: dbms_sql.bind_array (rem_t,':c19_array',crh_trx_date_array);
2911: dbms_sql.bind_array (rem_t,':c20_array',payment_server_order_num_array);
2912: dbms_sql.bind_array (rem_t,':c21_array',approval_code_array);
2913: dbms_sql.bind_array (rem_t,':c22_array',receipt_number_array);
2914: dbms_sql.bind_array (rem_t,':c23_array',unique_ref_array);
2915: dbms_sql.bind_array (rem_t,':c24_array',customer_bank_account_id_array);

Line 2912: dbms_sql.bind_array (rem_t,':c21_array',approval_code_array);

2908: dbms_sql.bind_array (rem_t,':c17_array',cash_receipt_history_id_array);
2909: dbms_sql.bind_array (rem_t,':c18_array',crh_gl_date_array);
2910: dbms_sql.bind_array (rem_t,':c19_array',crh_trx_date_array);
2911: dbms_sql.bind_array (rem_t,':c20_array',payment_server_order_num_array);
2912: dbms_sql.bind_array (rem_t,':c21_array',approval_code_array);
2913: dbms_sql.bind_array (rem_t,':c22_array',receipt_number_array);
2914: dbms_sql.bind_array (rem_t,':c23_array',unique_ref_array);
2915: dbms_sql.bind_array (rem_t,':c24_array',customer_bank_account_id_array);
2916: dbms_sql.bind_array (rem_t,':c25_array',payment_trxn_extn_id_array);

Line 2913: dbms_sql.bind_array (rem_t,':c22_array',receipt_number_array);

2909: dbms_sql.bind_array (rem_t,':c18_array',crh_gl_date_array);
2910: dbms_sql.bind_array (rem_t,':c19_array',crh_trx_date_array);
2911: dbms_sql.bind_array (rem_t,':c20_array',payment_server_order_num_array);
2912: dbms_sql.bind_array (rem_t,':c21_array',approval_code_array);
2913: dbms_sql.bind_array (rem_t,':c22_array',receipt_number_array);
2914: dbms_sql.bind_array (rem_t,':c23_array',unique_ref_array);
2915: dbms_sql.bind_array (rem_t,':c24_array',customer_bank_account_id_array);
2916: dbms_sql.bind_array (rem_t,':c25_array',payment_trxn_extn_id_array);
2917:

Line 2914: dbms_sql.bind_array (rem_t,':c23_array',unique_ref_array);

2910: dbms_sql.bind_array (rem_t,':c19_array',crh_trx_date_array);
2911: dbms_sql.bind_array (rem_t,':c20_array',payment_server_order_num_array);
2912: dbms_sql.bind_array (rem_t,':c21_array',approval_code_array);
2913: dbms_sql.bind_array (rem_t,':c22_array',receipt_number_array);
2914: dbms_sql.bind_array (rem_t,':c23_array',unique_ref_array);
2915: dbms_sql.bind_array (rem_t,':c24_array',customer_bank_account_id_array);
2916: dbms_sql.bind_array (rem_t,':c25_array',payment_trxn_extn_id_array);
2917:
2918:

Line 2915: dbms_sql.bind_array (rem_t,':c24_array',customer_bank_account_id_array);

2911: dbms_sql.bind_array (rem_t,':c20_array',payment_server_order_num_array);
2912: dbms_sql.bind_array (rem_t,':c21_array',approval_code_array);
2913: dbms_sql.bind_array (rem_t,':c22_array',receipt_number_array);
2914: dbms_sql.bind_array (rem_t,':c23_array',unique_ref_array);
2915: dbms_sql.bind_array (rem_t,':c24_array',customer_bank_account_id_array);
2916: dbms_sql.bind_array (rem_t,':c25_array',payment_trxn_extn_id_array);
2917:
2918:
2919: dummy := dbms_sql.execute(rem_t);

Line 2916: dbms_sql.bind_array (rem_t,':c25_array',payment_trxn_extn_id_array);

2912: dbms_sql.bind_array (rem_t,':c21_array',approval_code_array);
2913: dbms_sql.bind_array (rem_t,':c22_array',receipt_number_array);
2914: dbms_sql.bind_array (rem_t,':c23_array',unique_ref_array);
2915: dbms_sql.bind_array (rem_t,':c24_array',customer_bank_account_id_array);
2916: dbms_sql.bind_array (rem_t,':c25_array',payment_trxn_extn_id_array);
2917:
2918:
2919: dummy := dbms_sql.execute(rem_t);
2920:

Line 2919: dummy := dbms_sql.execute(rem_t);

2915: dbms_sql.bind_array (rem_t,':c24_array',customer_bank_account_id_array);
2916: dbms_sql.bind_array (rem_t,':c25_array',payment_trxn_extn_id_array);
2917:
2918:
2919: dummy := dbms_sql.execute(rem_t);
2920:
2921: dbms_sql.close_cursor(rem_t);
2922:
2923: EXCEPTION WHEN OTHERS THEN

Line 2921: dbms_sql.close_cursor(rem_t);

2917:
2918:
2919: dummy := dbms_sql.execute(rem_t);
2920:
2921: dbms_sql.close_cursor(rem_t);
2922:
2923: EXCEPTION WHEN OTHERS THEN
2924: if dbms_sql.is_open(rem_t) then
2925: dbms_sql.close_cursor(rem_t);

Line 2924: if dbms_sql.is_open(rem_t) then

2920:
2921: dbms_sql.close_cursor(rem_t);
2922:
2923: EXCEPTION WHEN OTHERS THEN
2924: if dbms_sql.is_open(rem_t) then
2925: dbms_sql.close_cursor(rem_t);
2926: end if;
2927: fnd_file.put_line(FND_FILE.LOG,'error code() '|| to_char(SQLCODE));
2928: raise;

Line 2925: dbms_sql.close_cursor(rem_t);

2921: dbms_sql.close_cursor(rem_t);
2922:
2923: EXCEPTION WHEN OTHERS THEN
2924: if dbms_sql.is_open(rem_t) then
2925: dbms_sql.close_cursor(rem_t);
2926: end if;
2927: fnd_file.put_line(FND_FILE.LOG,'error code() '|| to_char(SQLCODE));
2928: raise;
2929:

Line 2962: rem_t1 := dbms_sql.open_cursor;

2958: AND status = ''CONFIRMED''
2959: ';
2960:
2961:
2962: rem_t1 := dbms_sql.open_cursor;
2963:
2964: dbms_sql.parse (rem_t1,upd_stmt1,dbms_sql.v7);
2965:
2966: dbms_sql.bind_array (rem_t1,':ucrh_id_array', cash_receipt_history_id_array);

Line 2964: dbms_sql.parse (rem_t1,upd_stmt1,dbms_sql.v7);

2960:
2961:
2962: rem_t1 := dbms_sql.open_cursor;
2963:
2964: dbms_sql.parse (rem_t1,upd_stmt1,dbms_sql.v7);
2965:
2966: dbms_sql.bind_array (rem_t1,':ucrh_id_array', cash_receipt_history_id_array);
2967: dbms_sql.bind_array (rem_t1,':ucrh_gl_date_array',crh_gl_date_array );
2968: dbms_sql.bind_array (rem_t1,':cr_id_array', cash_receipt_id_array);

Line 2966: dbms_sql.bind_array (rem_t1,':ucrh_id_array', cash_receipt_history_id_array);

2962: rem_t1 := dbms_sql.open_cursor;
2963:
2964: dbms_sql.parse (rem_t1,upd_stmt1,dbms_sql.v7);
2965:
2966: dbms_sql.bind_array (rem_t1,':ucrh_id_array', cash_receipt_history_id_array);
2967: dbms_sql.bind_array (rem_t1,':ucrh_gl_date_array',crh_gl_date_array );
2968: dbms_sql.bind_array (rem_t1,':cr_id_array', cash_receipt_id_array);
2969: /* who cols*/
2970:

Line 2967: dbms_sql.bind_array (rem_t1,':ucrh_gl_date_array',crh_gl_date_array );

2963:
2964: dbms_sql.parse (rem_t1,upd_stmt1,dbms_sql.v7);
2965:
2966: dbms_sql.bind_array (rem_t1,':ucrh_id_array', cash_receipt_history_id_array);
2967: dbms_sql.bind_array (rem_t1,':ucrh_gl_date_array',crh_gl_date_array );
2968: dbms_sql.bind_array (rem_t1,':cr_id_array', cash_receipt_id_array);
2969: /* who cols*/
2970:
2971: dbms_sql.bind_variable (rem_t1,':i_last_updated_by',l_last_updated_by);

Line 2968: dbms_sql.bind_array (rem_t1,':cr_id_array', cash_receipt_id_array);

2964: dbms_sql.parse (rem_t1,upd_stmt1,dbms_sql.v7);
2965:
2966: dbms_sql.bind_array (rem_t1,':ucrh_id_array', cash_receipt_history_id_array);
2967: dbms_sql.bind_array (rem_t1,':ucrh_gl_date_array',crh_gl_date_array );
2968: dbms_sql.bind_array (rem_t1,':cr_id_array', cash_receipt_id_array);
2969: /* who cols*/
2970:
2971: dbms_sql.bind_variable (rem_t1,':i_last_updated_by',l_last_updated_by);
2972: dbms_sql.bind_variable (rem_t1,':i_last_update_login',l_last_update_login);

Line 2971: dbms_sql.bind_variable (rem_t1,':i_last_updated_by',l_last_updated_by);

2967: dbms_sql.bind_array (rem_t1,':ucrh_gl_date_array',crh_gl_date_array );
2968: dbms_sql.bind_array (rem_t1,':cr_id_array', cash_receipt_id_array);
2969: /* who cols*/
2970:
2971: dbms_sql.bind_variable (rem_t1,':i_last_updated_by',l_last_updated_by);
2972: dbms_sql.bind_variable (rem_t1,':i_last_update_login',l_last_update_login);
2973: dbms_sql.bind_variable (rem_t1,':i_request_id',l_request_id);
2974: dbms_sql.bind_variable (rem_t1,':i_program_application_id',l_program_application_id);
2975: dbms_sql.bind_variable (rem_t1,':i_program_id',l_program_id);

Line 2972: dbms_sql.bind_variable (rem_t1,':i_last_update_login',l_last_update_login);

2968: dbms_sql.bind_array (rem_t1,':cr_id_array', cash_receipt_id_array);
2969: /* who cols*/
2970:
2971: dbms_sql.bind_variable (rem_t1,':i_last_updated_by',l_last_updated_by);
2972: dbms_sql.bind_variable (rem_t1,':i_last_update_login',l_last_update_login);
2973: dbms_sql.bind_variable (rem_t1,':i_request_id',l_request_id);
2974: dbms_sql.bind_variable (rem_t1,':i_program_application_id',l_program_application_id);
2975: dbms_sql.bind_variable (rem_t1,':i_program_id',l_program_id);
2976:

Line 2973: dbms_sql.bind_variable (rem_t1,':i_request_id',l_request_id);

2969: /* who cols*/
2970:
2971: dbms_sql.bind_variable (rem_t1,':i_last_updated_by',l_last_updated_by);
2972: dbms_sql.bind_variable (rem_t1,':i_last_update_login',l_last_update_login);
2973: dbms_sql.bind_variable (rem_t1,':i_request_id',l_request_id);
2974: dbms_sql.bind_variable (rem_t1,':i_program_application_id',l_program_application_id);
2975: dbms_sql.bind_variable (rem_t1,':i_program_id',l_program_id);
2976:
2977: dummy := dbms_sql.execute(rem_t1);

Line 2974: dbms_sql.bind_variable (rem_t1,':i_program_application_id',l_program_application_id);

2970:
2971: dbms_sql.bind_variable (rem_t1,':i_last_updated_by',l_last_updated_by);
2972: dbms_sql.bind_variable (rem_t1,':i_last_update_login',l_last_update_login);
2973: dbms_sql.bind_variable (rem_t1,':i_request_id',l_request_id);
2974: dbms_sql.bind_variable (rem_t1,':i_program_application_id',l_program_application_id);
2975: dbms_sql.bind_variable (rem_t1,':i_program_id',l_program_id);
2976:
2977: dummy := dbms_sql.execute(rem_t1);
2978:

Line 2975: dbms_sql.bind_variable (rem_t1,':i_program_id',l_program_id);

2971: dbms_sql.bind_variable (rem_t1,':i_last_updated_by',l_last_updated_by);
2972: dbms_sql.bind_variable (rem_t1,':i_last_update_login',l_last_update_login);
2973: dbms_sql.bind_variable (rem_t1,':i_request_id',l_request_id);
2974: dbms_sql.bind_variable (rem_t1,':i_program_application_id',l_program_application_id);
2975: dbms_sql.bind_variable (rem_t1,':i_program_id',l_program_id);
2976:
2977: dummy := dbms_sql.execute(rem_t1);
2978:
2979: dbms_sql.close_cursor(rem_t1);

Line 2977: dummy := dbms_sql.execute(rem_t1);

2973: dbms_sql.bind_variable (rem_t1,':i_request_id',l_request_id);
2974: dbms_sql.bind_variable (rem_t1,':i_program_application_id',l_program_application_id);
2975: dbms_sql.bind_variable (rem_t1,':i_program_id',l_program_id);
2976:
2977: dummy := dbms_sql.execute(rem_t1);
2978:
2979: dbms_sql.close_cursor(rem_t1);
2980:
2981: IF PG_DEBUG in ('Y', 'C') THEN

Line 2979: dbms_sql.close_cursor(rem_t1);

2975: dbms_sql.bind_variable (rem_t1,':i_program_id',l_program_id);
2976:
2977: dummy := dbms_sql.execute(rem_t1);
2978:
2979: dbms_sql.close_cursor(rem_t1);
2980:
2981: IF PG_DEBUG in ('Y', 'C') THEN
2982: arp_standard.debug (to_char(SQL%ROWCOUNT) || ' row(s) updated.');
2983: fnd_file.put_line(FND_FILE.LOG,'upd-crh1 ()-');

Line 2987: if dbms_sql.is_open(rem_t1) then

2983: fnd_file.put_line(FND_FILE.LOG,'upd-crh1 ()-');
2984: END IF;
2985:
2986: EXCEPTION WHEN OTHERS THEN
2987: if dbms_sql.is_open(rem_t1) then
2988: dbms_sql.close_cursor(rem_t1);
2989: end if;
2990: IF PG_DEBUG in ('Y', 'C') THEN
2991: fnd_file.put_line(FND_FILE.LOG,'failed to update() '|| to_char(SQLCODE));

Line 2988: dbms_sql.close_cursor(rem_t1);

2984: END IF;
2985:
2986: EXCEPTION WHEN OTHERS THEN
2987: if dbms_sql.is_open(rem_t1) then
2988: dbms_sql.close_cursor(rem_t1);
2989: end if;
2990: IF PG_DEBUG in ('Y', 'C') THEN
2991: fnd_file.put_line(FND_FILE.LOG,'failed to update() '|| to_char(SQLCODE));
2992: END IF;

Line 3114: rem_t3 := dbms_sql.open_cursor;

3110: sysdate
3111: FROM AR_REMIT_GT r
3112: WHERE r.cash_receipt_history_id is not null';
3113:
3114: rem_t3 := dbms_sql.open_cursor;
3115:
3116: dbms_sql.parse (rem_t3,ins_crh1,dbms_sql.v7);
3117:
3118: IF PG_DEBUG in ('Y', 'C') THEN

Line 3116: dbms_sql.parse (rem_t3,ins_crh1,dbms_sql.v7);

3112: WHERE r.cash_receipt_history_id is not null';
3113:
3114: rem_t3 := dbms_sql.open_cursor;
3115:
3116: dbms_sql.parse (rem_t3,ins_crh1,dbms_sql.v7);
3117:
3118: IF PG_DEBUG in ('Y', 'C') THEN
3119: fnd_file.put_line(FND_FILE.LOG, 'the batch_id ' || p_batch_id);
3120: END IF;

Line 3123: dbms_sql.bind_variable (rem_t3,':i_batch_id',p_batch_id);

3119: fnd_file.put_line(FND_FILE.LOG, 'the batch_id ' || p_batch_id);
3120: END IF;
3121:
3122:
3123: dbms_sql.bind_variable (rem_t3,':i_batch_id',p_batch_id);
3124: dbms_sql.bind_variable (rem_t3,':factor_flag',l_factor_flag);
3125: /* who cols */
3126: dbms_sql.bind_variable (rem_t3,':i_created_by',l_created_by);
3127: dbms_sql.bind_variable (rem_t3,':i_last_updated_by',l_last_updated_by);

Line 3124: dbms_sql.bind_variable (rem_t3,':factor_flag',l_factor_flag);

3120: END IF;
3121:
3122:
3123: dbms_sql.bind_variable (rem_t3,':i_batch_id',p_batch_id);
3124: dbms_sql.bind_variable (rem_t3,':factor_flag',l_factor_flag);
3125: /* who cols */
3126: dbms_sql.bind_variable (rem_t3,':i_created_by',l_created_by);
3127: dbms_sql.bind_variable (rem_t3,':i_last_updated_by',l_last_updated_by);
3128: dbms_sql.bind_variable (rem_t3,':i_last_update_login',l_last_update_login);

Line 3126: dbms_sql.bind_variable (rem_t3,':i_created_by',l_created_by);

3122:
3123: dbms_sql.bind_variable (rem_t3,':i_batch_id',p_batch_id);
3124: dbms_sql.bind_variable (rem_t3,':factor_flag',l_factor_flag);
3125: /* who cols */
3126: dbms_sql.bind_variable (rem_t3,':i_created_by',l_created_by);
3127: dbms_sql.bind_variable (rem_t3,':i_last_updated_by',l_last_updated_by);
3128: dbms_sql.bind_variable (rem_t3,':i_last_update_login',l_last_update_login);
3129: dbms_sql.bind_variable (rem_t3,':i_request_id',l_request_id);
3130: dbms_sql.bind_variable (rem_t3,':i_org_id',l_org_id);

Line 3127: dbms_sql.bind_variable (rem_t3,':i_last_updated_by',l_last_updated_by);

3123: dbms_sql.bind_variable (rem_t3,':i_batch_id',p_batch_id);
3124: dbms_sql.bind_variable (rem_t3,':factor_flag',l_factor_flag);
3125: /* who cols */
3126: dbms_sql.bind_variable (rem_t3,':i_created_by',l_created_by);
3127: dbms_sql.bind_variable (rem_t3,':i_last_updated_by',l_last_updated_by);
3128: dbms_sql.bind_variable (rem_t3,':i_last_update_login',l_last_update_login);
3129: dbms_sql.bind_variable (rem_t3,':i_request_id',l_request_id);
3130: dbms_sql.bind_variable (rem_t3,':i_org_id',l_org_id);
3131: dbms_sql.bind_variable (rem_t3,':i_program_application_id',l_program_application_id);

Line 3128: dbms_sql.bind_variable (rem_t3,':i_last_update_login',l_last_update_login);

3124: dbms_sql.bind_variable (rem_t3,':factor_flag',l_factor_flag);
3125: /* who cols */
3126: dbms_sql.bind_variable (rem_t3,':i_created_by',l_created_by);
3127: dbms_sql.bind_variable (rem_t3,':i_last_updated_by',l_last_updated_by);
3128: dbms_sql.bind_variable (rem_t3,':i_last_update_login',l_last_update_login);
3129: dbms_sql.bind_variable (rem_t3,':i_request_id',l_request_id);
3130: dbms_sql.bind_variable (rem_t3,':i_org_id',l_org_id);
3131: dbms_sql.bind_variable (rem_t3,':i_program_application_id',l_program_application_id);
3132: dbms_sql.bind_variable (rem_t3,':i_program_id',l_program_id);

Line 3129: dbms_sql.bind_variable (rem_t3,':i_request_id',l_request_id);

3125: /* who cols */
3126: dbms_sql.bind_variable (rem_t3,':i_created_by',l_created_by);
3127: dbms_sql.bind_variable (rem_t3,':i_last_updated_by',l_last_updated_by);
3128: dbms_sql.bind_variable (rem_t3,':i_last_update_login',l_last_update_login);
3129: dbms_sql.bind_variable (rem_t3,':i_request_id',l_request_id);
3130: dbms_sql.bind_variable (rem_t3,':i_org_id',l_org_id);
3131: dbms_sql.bind_variable (rem_t3,':i_program_application_id',l_program_application_id);
3132: dbms_sql.bind_variable (rem_t3,':i_program_id',l_program_id);
3133:

Line 3130: dbms_sql.bind_variable (rem_t3,':i_org_id',l_org_id);

3126: dbms_sql.bind_variable (rem_t3,':i_created_by',l_created_by);
3127: dbms_sql.bind_variable (rem_t3,':i_last_updated_by',l_last_updated_by);
3128: dbms_sql.bind_variable (rem_t3,':i_last_update_login',l_last_update_login);
3129: dbms_sql.bind_variable (rem_t3,':i_request_id',l_request_id);
3130: dbms_sql.bind_variable (rem_t3,':i_org_id',l_org_id);
3131: dbms_sql.bind_variable (rem_t3,':i_program_application_id',l_program_application_id);
3132: dbms_sql.bind_variable (rem_t3,':i_program_id',l_program_id);
3133:
3134:

Line 3131: dbms_sql.bind_variable (rem_t3,':i_program_application_id',l_program_application_id);

3127: dbms_sql.bind_variable (rem_t3,':i_last_updated_by',l_last_updated_by);
3128: dbms_sql.bind_variable (rem_t3,':i_last_update_login',l_last_update_login);
3129: dbms_sql.bind_variable (rem_t3,':i_request_id',l_request_id);
3130: dbms_sql.bind_variable (rem_t3,':i_org_id',l_org_id);
3131: dbms_sql.bind_variable (rem_t3,':i_program_application_id',l_program_application_id);
3132: dbms_sql.bind_variable (rem_t3,':i_program_id',l_program_id);
3133:
3134:
3135: IF PG_DEBUG in ('Y', 'C') THEN

Line 3132: dbms_sql.bind_variable (rem_t3,':i_program_id',l_program_id);

3128: dbms_sql.bind_variable (rem_t3,':i_last_update_login',l_last_update_login);
3129: dbms_sql.bind_variable (rem_t3,':i_request_id',l_request_id);
3130: dbms_sql.bind_variable (rem_t3,':i_org_id',l_org_id);
3131: dbms_sql.bind_variable (rem_t3,':i_program_application_id',l_program_application_id);
3132: dbms_sql.bind_variable (rem_t3,':i_program_id',l_program_id);
3133:
3134:
3135: IF PG_DEBUG in ('Y', 'C') THEN
3136: fnd_file.put_line(FND_FILE.LOG, 'the insert statemnt' || ins_crh1);

Line 3139: dummy := dbms_sql.execute(rem_t3);

3135: IF PG_DEBUG in ('Y', 'C') THEN
3136: fnd_file.put_line(FND_FILE.LOG, 'the insert statemnt' || ins_crh1);
3137: END IF;
3138:
3139: dummy := dbms_sql.execute(rem_t3);
3140:
3141: dbms_sql.close_cursor(rem_t3);
3142:
3143:

Line 3141: dbms_sql.close_cursor(rem_t3);

3137: END IF;
3138:
3139: dummy := dbms_sql.execute(rem_t3);
3140:
3141: dbms_sql.close_cursor(rem_t3);
3142:
3143:
3144: /* BICHATTE after the insert into crh we have to fire the XLA event */
3145:

Line 3177: if dbms_sql.is_open(rem_t3) then

3173:
3174:
3175: EXCEPTION WHEN OTHERS THEN
3176: fnd_file.put_line(FND_FILE.LOG, 'the insert statemnt' || ins_crh1);
3177: if dbms_sql.is_open(rem_t3) then
3178: dbms_sql.close_cursor(rem_t3);
3179: end if;
3180: IF PG_DEBUG in ('Y', 'C') THEN
3181: fnd_file.put_line(FND_FILE.LOG,'failed to insert() '|| to_char(SQLCODE));

Line 3178: dbms_sql.close_cursor(rem_t3);

3174:
3175: EXCEPTION WHEN OTHERS THEN
3176: fnd_file.put_line(FND_FILE.LOG, 'the insert statemnt' || ins_crh1);
3177: if dbms_sql.is_open(rem_t3) then
3178: dbms_sql.close_cursor(rem_t3);
3179: end if;
3180: IF PG_DEBUG in ('Y', 'C') THEN
3181: fnd_file.put_line(FND_FILE.LOG,'failed to insert() '|| to_char(SQLCODE));
3182: fnd_file.put_line(FND_FILE.LOG, 'the insert statemnt' || ins_crh1);

Line 3284: rem_t4 := dbms_sql.open_cursor;

3280: WHERE crh.cash_receipt_history_id = r.cash_receipt_history_id
3281: AND l.lookup_type = ''AR_CARTESIAN_JOIN''
3282: AND l.lookup_code IN (''1'',''2'')';
3283:
3284: rem_t4 := dbms_sql.open_cursor;
3285:
3286: dbms_sql.parse (rem_t4,ins_dist1,dbms_sql.v7);
3287:
3288: IF PG_DEBUG in ('Y', 'C') THEN

Line 3286: dbms_sql.parse (rem_t4,ins_dist1,dbms_sql.v7);

3282: AND l.lookup_code IN (''1'',''2'')';
3283:
3284: rem_t4 := dbms_sql.open_cursor;
3285:
3286: dbms_sql.parse (rem_t4,ins_dist1,dbms_sql.v7);
3287:
3288: IF PG_DEBUG in ('Y', 'C') THEN
3289: fnd_file.put_line(FND_FILE.LOG, 'the insert dist statement is ' || ins_dist1);
3290: END IF;

Line 3292: dbms_sql.bind_variable (rem_t4,':factor_flag',l_factor_flag);

3288: IF PG_DEBUG in ('Y', 'C') THEN
3289: fnd_file.put_line(FND_FILE.LOG, 'the insert dist statement is ' || ins_dist1);
3290: END IF;
3291:
3292: dbms_sql.bind_variable (rem_t4,':factor_flag',l_factor_flag);
3293: /* who cols */
3294: dbms_sql.bind_variable (rem_t4,':i_created_by',l_created_by);
3295: dbms_sql.bind_variable (rem_t4,':i_last_updated_by',l_last_updated_by);
3296: dbms_sql.bind_variable (rem_t4,':i_org_id',l_org_id);

Line 3294: dbms_sql.bind_variable (rem_t4,':i_created_by',l_created_by);

3290: END IF;
3291:
3292: dbms_sql.bind_variable (rem_t4,':factor_flag',l_factor_flag);
3293: /* who cols */
3294: dbms_sql.bind_variable (rem_t4,':i_created_by',l_created_by);
3295: dbms_sql.bind_variable (rem_t4,':i_last_updated_by',l_last_updated_by);
3296: dbms_sql.bind_variable (rem_t4,':i_org_id',l_org_id);
3297: dbms_sql.bind_variable (rem_t4,':i_last_update_login',l_last_update_login);
3298:

Line 3295: dbms_sql.bind_variable (rem_t4,':i_last_updated_by',l_last_updated_by);

3291:
3292: dbms_sql.bind_variable (rem_t4,':factor_flag',l_factor_flag);
3293: /* who cols */
3294: dbms_sql.bind_variable (rem_t4,':i_created_by',l_created_by);
3295: dbms_sql.bind_variable (rem_t4,':i_last_updated_by',l_last_updated_by);
3296: dbms_sql.bind_variable (rem_t4,':i_org_id',l_org_id);
3297: dbms_sql.bind_variable (rem_t4,':i_last_update_login',l_last_update_login);
3298:
3299:

Line 3296: dbms_sql.bind_variable (rem_t4,':i_org_id',l_org_id);

3292: dbms_sql.bind_variable (rem_t4,':factor_flag',l_factor_flag);
3293: /* who cols */
3294: dbms_sql.bind_variable (rem_t4,':i_created_by',l_created_by);
3295: dbms_sql.bind_variable (rem_t4,':i_last_updated_by',l_last_updated_by);
3296: dbms_sql.bind_variable (rem_t4,':i_org_id',l_org_id);
3297: dbms_sql.bind_variable (rem_t4,':i_last_update_login',l_last_update_login);
3298:
3299:
3300: d2 := dbms_sql.execute(rem_t4);

Line 3297: dbms_sql.bind_variable (rem_t4,':i_last_update_login',l_last_update_login);

3293: /* who cols */
3294: dbms_sql.bind_variable (rem_t4,':i_created_by',l_created_by);
3295: dbms_sql.bind_variable (rem_t4,':i_last_updated_by',l_last_updated_by);
3296: dbms_sql.bind_variable (rem_t4,':i_org_id',l_org_id);
3297: dbms_sql.bind_variable (rem_t4,':i_last_update_login',l_last_update_login);
3298:
3299:
3300: d2 := dbms_sql.execute(rem_t4);
3301:

Line 3300: d2 := dbms_sql.execute(rem_t4);

3296: dbms_sql.bind_variable (rem_t4,':i_org_id',l_org_id);
3297: dbms_sql.bind_variable (rem_t4,':i_last_update_login',l_last_update_login);
3298:
3299:
3300: d2 := dbms_sql.execute(rem_t4);
3301:
3302: dbms_sql.close_cursor(rem_t4);
3303:
3304: IF PG_DEBUG in ('Y', 'C') THEN

Line 3302: dbms_sql.close_cursor(rem_t4);

3298:
3299:
3300: d2 := dbms_sql.execute(rem_t4);
3301:
3302: dbms_sql.close_cursor(rem_t4);
3303:
3304: IF PG_DEBUG in ('Y', 'C') THEN
3305: fnd_file.put_line(FND_FILE.LOG,'ins_dist1 ()-');
3306: END IF;

Line 3309: if dbms_sql.is_open(rem_t4) then

3305: fnd_file.put_line(FND_FILE.LOG,'ins_dist1 ()-');
3306: END IF;
3307:
3308: EXCEPTION WHEN OTHERS THEN
3309: if dbms_sql.is_open(rem_t4) then
3310: dbms_sql.close_cursor(rem_t4);
3311: end if;
3312: IF PG_DEBUG in ('Y', 'C') THEN
3313: fnd_file.put_line(FND_FILE.LOG, 'the insert dist statement is ' || ins_dist1);

Line 3310: dbms_sql.close_cursor(rem_t4);

3306: END IF;
3307:
3308: EXCEPTION WHEN OTHERS THEN
3309: if dbms_sql.is_open(rem_t4) then
3310: dbms_sql.close_cursor(rem_t4);
3311: end if;
3312: IF PG_DEBUG in ('Y', 'C') THEN
3313: fnd_file.put_line(FND_FILE.LOG, 'the insert dist statement is ' || ins_dist1);
3314: fnd_file.put_line(FND_FILE.LOG,'DIST failed to insert() '|| to_char(SQLCODE));

Line 3390: cash_receipt_id_array dbms_sql.Number_Table;

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;
3393: ins_recs INTEGER;
3394: upd_recs INTEGER; --14798599

Line 3391: cr_id_array dbms_sql.Number_Table;

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;
3393: ins_recs INTEGER;
3394: upd_recs INTEGER; --14798599
3395:

Line 3392: amt_array dbms_sql.Number_Table;

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;
3393: ins_recs INTEGER;
3394: upd_recs INTEGER; --14798599
3395:
3396: i number;

Line 3461: ins_recs := dbms_sql.open_cursor;

3457: execute immediate 'alter session enable parallel dml';
3458:
3459:
3460: --move all the receipts in confirmed status to GT table
3461: ins_recs := dbms_sql.open_cursor;
3462: dbms_sql.parse (ins_recs, ins_stmt, dbms_sql.v7);
3463: ignore := dbms_sql.execute(ins_recs);
3464: commit;
3465:

Line 3462: dbms_sql.parse (ins_recs, ins_stmt, dbms_sql.v7);

3458:
3459:
3460: --move all the receipts in confirmed status to GT table
3461: ins_recs := dbms_sql.open_cursor;
3462: dbms_sql.parse (ins_recs, ins_stmt, dbms_sql.v7);
3463: ignore := dbms_sql.execute(ins_recs);
3464: commit;
3465:
3466: execute immediate 'alter session disable parallel dml';

Line 3463: ignore := dbms_sql.execute(ins_recs);

3459:
3460: --move all the receipts in confirmed status to GT table
3461: ins_recs := dbms_sql.open_cursor;
3462: dbms_sql.parse (ins_recs, ins_stmt, dbms_sql.v7);
3463: ignore := dbms_sql.execute(ins_recs);
3464: commit;
3465:
3466: execute immediate 'alter session disable parallel dml';
3467:

Line 3468: dbms_sql.close_cursor( ins_recs );

3464: commit;
3465:
3466: execute immediate 'alter session disable parallel dml';
3467:
3468: dbms_sql.close_cursor( ins_recs );
3469:
3470: IF PG_PARALLEL IN ('Y', 'C') THEN
3471: l_sel_stmt := ' SELECT /*+ unnest LEADING(crh,crh1,cr) parallel(crh) parallel(crh1) parallel(cr) parallel(ps) swap_join_inputs(rm) swap_join_inputs(rclass) use_hash(rm,rclass) use_nl(crh1,cr,ps,rma1,rma2) cardinality(crh,10000) */';
3472: ELSE

Line 3671: remit_recs := dbms_sql.open_cursor;

3667: WHERE selected_remittance_batch_id is null ';
3668:
3669: l_sel_stmt := upd_stmt2 ||' AND cash_receipt_id IN ( '|| l_sel_stmt || ')';
3670:
3671: remit_recs := dbms_sql.open_cursor;
3672:
3673: dbms_sql.parse (remit_recs,l_sel_stmt,dbms_sql.v7);
3674:
3675: /* bind the variables used in update statement */

Line 3673: dbms_sql.parse (remit_recs,l_sel_stmt,dbms_sql.v7);

3669: l_sel_stmt := upd_stmt2 ||' AND cash_receipt_id IN ( '|| l_sel_stmt || ')';
3670:
3671: remit_recs := dbms_sql.open_cursor;
3672:
3673: dbms_sql.parse (remit_recs,l_sel_stmt,dbms_sql.v7);
3674:
3675: /* bind the variables used in update statement */
3676: dbms_sql.bind_variable (remit_recs,':u_batch_id',p_batch_id);
3677: dbms_sql.bind_variable (remit_recs,':u_remit_bank_account_id',p_remit_bank_account_id);

Line 3676: dbms_sql.bind_variable (remit_recs,':u_batch_id',p_batch_id);

3672:
3673: dbms_sql.parse (remit_recs,l_sel_stmt,dbms_sql.v7);
3674:
3675: /* bind the variables used in update statement */
3676: dbms_sql.bind_variable (remit_recs,':u_batch_id',p_batch_id);
3677: dbms_sql.bind_variable (remit_recs,':u_remit_bank_account_id',p_remit_bank_account_id);
3678:
3679: /* who cols */
3680: dbms_sql.bind_variable (remit_recs,':i_last_updated_by',l_last_updated_by);

Line 3677: dbms_sql.bind_variable (remit_recs,':u_remit_bank_account_id',p_remit_bank_account_id);

3673: dbms_sql.parse (remit_recs,l_sel_stmt,dbms_sql.v7);
3674:
3675: /* bind the variables used in update statement */
3676: dbms_sql.bind_variable (remit_recs,':u_batch_id',p_batch_id);
3677: dbms_sql.bind_variable (remit_recs,':u_remit_bank_account_id',p_remit_bank_account_id);
3678:
3679: /* who cols */
3680: dbms_sql.bind_variable (remit_recs,':i_last_updated_by',l_last_updated_by);
3681: dbms_sql.bind_variable (remit_recs,':i_last_update_login',l_last_update_login);

Line 3680: dbms_sql.bind_variable (remit_recs,':i_last_updated_by',l_last_updated_by);

3676: dbms_sql.bind_variable (remit_recs,':u_batch_id',p_batch_id);
3677: dbms_sql.bind_variable (remit_recs,':u_remit_bank_account_id',p_remit_bank_account_id);
3678:
3679: /* who cols */
3680: dbms_sql.bind_variable (remit_recs,':i_last_updated_by',l_last_updated_by);
3681: dbms_sql.bind_variable (remit_recs,':i_last_update_login',l_last_update_login);
3682: dbms_sql.bind_variable (remit_recs,':i_request_id',l_request_id);
3683: dbms_sql.bind_variable (remit_recs,':i_program_application_id',l_program_application_id);
3684: dbms_sql.bind_variable (remit_recs,':i_program_id',l_program_id);

Line 3681: dbms_sql.bind_variable (remit_recs,':i_last_update_login',l_last_update_login);

3677: dbms_sql.bind_variable (remit_recs,':u_remit_bank_account_id',p_remit_bank_account_id);
3678:
3679: /* who cols */
3680: dbms_sql.bind_variable (remit_recs,':i_last_updated_by',l_last_updated_by);
3681: dbms_sql.bind_variable (remit_recs,':i_last_update_login',l_last_update_login);
3682: dbms_sql.bind_variable (remit_recs,':i_request_id',l_request_id);
3683: dbms_sql.bind_variable (remit_recs,':i_program_application_id',l_program_application_id);
3684: dbms_sql.bind_variable (remit_recs,':i_program_id',l_program_id);
3685: ELSE

Line 3682: dbms_sql.bind_variable (remit_recs,':i_request_id',l_request_id);

3678:
3679: /* who cols */
3680: dbms_sql.bind_variable (remit_recs,':i_last_updated_by',l_last_updated_by);
3681: dbms_sql.bind_variable (remit_recs,':i_last_update_login',l_last_update_login);
3682: dbms_sql.bind_variable (remit_recs,':i_request_id',l_request_id);
3683: dbms_sql.bind_variable (remit_recs,':i_program_application_id',l_program_application_id);
3684: dbms_sql.bind_variable (remit_recs,':i_program_id',l_program_id);
3685: ELSE
3686: IF p_remittance_total_from IS NOT NULL OR p_remittance_total_to IS NOT NULL THEN

Line 3683: dbms_sql.bind_variable (remit_recs,':i_program_application_id',l_program_application_id);

3679: /* who cols */
3680: dbms_sql.bind_variable (remit_recs,':i_last_updated_by',l_last_updated_by);
3681: dbms_sql.bind_variable (remit_recs,':i_last_update_login',l_last_update_login);
3682: dbms_sql.bind_variable (remit_recs,':i_request_id',l_request_id);
3683: dbms_sql.bind_variable (remit_recs,':i_program_application_id',l_program_application_id);
3684: dbms_sql.bind_variable (remit_recs,':i_program_id',l_program_id);
3685: ELSE
3686: IF p_remittance_total_from IS NOT NULL OR p_remittance_total_to IS NOT NULL THEN
3687: l_sel_stmt := l_sel_stmt || ' ORDER BY DECODE(cr.type,''CASH'',ps.due_date,''MISC'',cr.deposit_date), cr.amount'; --14798599

Line 3684: dbms_sql.bind_variable (remit_recs,':i_program_id',l_program_id);

3680: dbms_sql.bind_variable (remit_recs,':i_last_updated_by',l_last_updated_by);
3681: dbms_sql.bind_variable (remit_recs,':i_last_update_login',l_last_update_login);
3682: dbms_sql.bind_variable (remit_recs,':i_request_id',l_request_id);
3683: dbms_sql.bind_variable (remit_recs,':i_program_application_id',l_program_application_id);
3684: dbms_sql.bind_variable (remit_recs,':i_program_id',l_program_id);
3685: ELSE
3686: IF p_remittance_total_from IS NOT NULL OR p_remittance_total_to IS NOT NULL THEN
3687: l_sel_stmt := l_sel_stmt || ' ORDER BY DECODE(cr.type,''CASH'',ps.due_date,''MISC'',cr.deposit_date), cr.amount'; --14798599
3688:

Line 3689: remit_recs := dbms_sql.open_cursor;

3685: ELSE
3686: IF p_remittance_total_from IS NOT NULL OR p_remittance_total_to IS NOT NULL THEN
3687: l_sel_stmt := l_sel_stmt || ' ORDER BY DECODE(cr.type,''CASH'',ps.due_date,''MISC'',cr.deposit_date), cr.amount'; --14798599
3688:
3689: remit_recs := dbms_sql.open_cursor;
3690:
3691: dbms_sql.parse (remit_recs,l_sel_stmt,dbms_sql.v7);
3692: END IF;
3693:

Line 3691: dbms_sql.parse (remit_recs,l_sel_stmt,dbms_sql.v7);

3687: l_sel_stmt := l_sel_stmt || ' ORDER BY DECODE(cr.type,''CASH'',ps.due_date,''MISC'',cr.deposit_date), cr.amount'; --14798599
3688:
3689: remit_recs := dbms_sql.open_cursor;
3690:
3691: dbms_sql.parse (remit_recs,l_sel_stmt,dbms_sql.v7);
3692: END IF;
3693:
3694: END IF;
3695: /* bind the variables */

Line 3696: dbms_sql.bind_variable (remit_recs,':bs_receipt_method_id',p_receipt_method_id);

3692: END IF;
3693:
3694: END IF;
3695: /* bind the variables */
3696: dbms_sql.bind_variable (remit_recs,':bs_receipt_method_id',p_receipt_method_id);
3697: dbms_sql.bind_variable (remit_recs,':bs_currency',p_currency_code);
3698:
3699: IF p_receipt_method_id IS NOT NULL THEN
3700: dbms_sql.bind_variable (remit_recs,':bs_payment_type_code', p_payment_type_code);

Line 3697: dbms_sql.bind_variable (remit_recs,':bs_currency',p_currency_code);

3693:
3694: END IF;
3695: /* bind the variables */
3696: dbms_sql.bind_variable (remit_recs,':bs_receipt_method_id',p_receipt_method_id);
3697: dbms_sql.bind_variable (remit_recs,':bs_currency',p_currency_code);
3698:
3699: IF p_receipt_method_id IS NOT NULL THEN
3700: dbms_sql.bind_variable (remit_recs,':bs_payment_type_code', p_payment_type_code);
3701: END IF;

Line 3700: dbms_sql.bind_variable (remit_recs,':bs_payment_type_code', p_payment_type_code);

3696: dbms_sql.bind_variable (remit_recs,':bs_receipt_method_id',p_receipt_method_id);
3697: dbms_sql.bind_variable (remit_recs,':bs_currency',p_currency_code);
3698:
3699: IF p_receipt_method_id IS NOT NULL THEN
3700: dbms_sql.bind_variable (remit_recs,':bs_payment_type_code', p_payment_type_code);
3701: END IF;
3702:
3703: dbms_sql.bind_variable (remit_recs,':bs_sob_id', p_sob_id);
3704: dbms_sql.bind_variable (remit_recs,':bs_remit_method_code',p_remit_method_code);

Line 3703: dbms_sql.bind_variable (remit_recs,':bs_sob_id', p_sob_id);

3699: IF p_receipt_method_id IS NOT NULL THEN
3700: dbms_sql.bind_variable (remit_recs,':bs_payment_type_code', p_payment_type_code);
3701: END IF;
3702:
3703: dbms_sql.bind_variable (remit_recs,':bs_sob_id', p_sob_id);
3704: dbms_sql.bind_variable (remit_recs,':bs_remit_method_code',p_remit_method_code);
3705: dbms_sql.bind_variable (remit_recs,':bs_remit_account_id', p_remit_bank_account_id);
3706:
3707: IF p_customer_number_l IS NOT NULL THEN

Line 3704: dbms_sql.bind_variable (remit_recs,':bs_remit_method_code',p_remit_method_code);

3700: dbms_sql.bind_variable (remit_recs,':bs_payment_type_code', p_payment_type_code);
3701: END IF;
3702:
3703: dbms_sql.bind_variable (remit_recs,':bs_sob_id', p_sob_id);
3704: dbms_sql.bind_variable (remit_recs,':bs_remit_method_code',p_remit_method_code);
3705: dbms_sql.bind_variable (remit_recs,':bs_remit_account_id', p_remit_bank_account_id);
3706:
3707: IF p_customer_number_l IS NOT NULL THEN
3708: dbms_sql.bind_variable (remit_recs,':customer_number_l',p_customer_number_l);

Line 3705: dbms_sql.bind_variable (remit_recs,':bs_remit_account_id', p_remit_bank_account_id);

3701: END IF;
3702:
3703: dbms_sql.bind_variable (remit_recs,':bs_sob_id', p_sob_id);
3704: dbms_sql.bind_variable (remit_recs,':bs_remit_method_code',p_remit_method_code);
3705: dbms_sql.bind_variable (remit_recs,':bs_remit_account_id', p_remit_bank_account_id);
3706:
3707: IF p_customer_number_l IS NOT NULL THEN
3708: dbms_sql.bind_variable (remit_recs,':customer_number_l',p_customer_number_l);
3709: END IF;

Line 3708: dbms_sql.bind_variable (remit_recs,':customer_number_l',p_customer_number_l);

3704: dbms_sql.bind_variable (remit_recs,':bs_remit_method_code',p_remit_method_code);
3705: dbms_sql.bind_variable (remit_recs,':bs_remit_account_id', p_remit_bank_account_id);
3706:
3707: IF p_customer_number_l IS NOT NULL THEN
3708: dbms_sql.bind_variable (remit_recs,':customer_number_l',p_customer_number_l);
3709: END IF;
3710:
3711: IF p_customer_number_h IS NOT NULL THEN
3712: dbms_sql.bind_variable (remit_recs,':customer_number_h',p_customer_number_h);

Line 3712: dbms_sql.bind_variable (remit_recs,':customer_number_h',p_customer_number_h);

3708: dbms_sql.bind_variable (remit_recs,':customer_number_l',p_customer_number_l);
3709: END IF;
3710:
3711: IF p_customer_number_h IS NOT NULL THEN
3712: dbms_sql.bind_variable (remit_recs,':customer_number_h',p_customer_number_h);
3713: END IF;
3714:
3715: /*Bug 8473259 binding variables for name */
3716: IF p_customer_name_l IS NOT NULL THEN

Line 3717: dbms_sql.bind_variable (remit_recs,':customer_name_l',p_customer_name_l);

3713: END IF;
3714:
3715: /*Bug 8473259 binding variables for name */
3716: IF p_customer_name_l IS NOT NULL THEN
3717: dbms_sql.bind_variable (remit_recs,':customer_name_l',p_customer_name_l);
3718: END IF;
3719:
3720: IF p_customer_name_h IS NOT NULL THEN
3721: dbms_sql.bind_variable (remit_recs,':customer_name_h',p_customer_name_h);

Line 3721: dbms_sql.bind_variable (remit_recs,':customer_name_h',p_customer_name_h);

3717: dbms_sql.bind_variable (remit_recs,':customer_name_l',p_customer_name_l);
3718: END IF;
3719:
3720: IF p_customer_name_h IS NOT NULL THEN
3721: dbms_sql.bind_variable (remit_recs,':customer_name_h',p_customer_name_h);
3722: END IF;
3723:
3724: IF p_due_date_l IS NOT NULL THEN
3725: dbms_sql.bind_variable (remit_recs,':due_date_l',p_due_date_l);

Line 3725: dbms_sql.bind_variable (remit_recs,':due_date_l',p_due_date_l);

3721: dbms_sql.bind_variable (remit_recs,':customer_name_h',p_customer_name_h);
3722: END IF;
3723:
3724: IF p_due_date_l IS NOT NULL THEN
3725: dbms_sql.bind_variable (remit_recs,':due_date_l',p_due_date_l);
3726: END IF;
3727:
3728: IF p_due_date_h IS NOT NULL THEN
3729: dbms_sql.bind_variable (remit_recs,':due_date_h',p_due_date_h);

Line 3729: dbms_sql.bind_variable (remit_recs,':due_date_h',p_due_date_h);

3725: dbms_sql.bind_variable (remit_recs,':due_date_l',p_due_date_l);
3726: END IF;
3727:
3728: IF p_due_date_h IS NOT NULL THEN
3729: dbms_sql.bind_variable (remit_recs,':due_date_h',p_due_date_h);
3730: END IF;
3731:
3732: IF p_trx_date_l IS NOT NULL THEN
3733: dbms_sql.bind_variable (remit_recs,':trx_date_l',p_trx_date_l);

Line 3733: dbms_sql.bind_variable (remit_recs,':trx_date_l',p_trx_date_l);

3729: dbms_sql.bind_variable (remit_recs,':due_date_h',p_due_date_h);
3730: END IF;
3731:
3732: IF p_trx_date_l IS NOT NULL THEN
3733: dbms_sql.bind_variable (remit_recs,':trx_date_l',p_trx_date_l);
3734: END IF;
3735:
3736: IF p_trx_date_h IS NOT NULL THEN
3737: dbms_sql.bind_variable (remit_recs,':trx_date_h',p_trx_date_h);

Line 3737: dbms_sql.bind_variable (remit_recs,':trx_date_h',p_trx_date_h);

3733: dbms_sql.bind_variable (remit_recs,':trx_date_l',p_trx_date_l);
3734: END IF;
3735:
3736: IF p_trx_date_h IS NOT NULL THEN
3737: dbms_sql.bind_variable (remit_recs,':trx_date_h',p_trx_date_h);
3738: END IF;
3739:
3740: IF p_trx_num_l IS NOT NULL THEN
3741: dbms_sql.bind_variable (remit_recs,':rcpt_number_l',p_trx_num_l);

Line 3741: dbms_sql.bind_variable (remit_recs,':rcpt_number_l',p_trx_num_l);

3737: dbms_sql.bind_variable (remit_recs,':trx_date_h',p_trx_date_h);
3738: END IF;
3739:
3740: IF p_trx_num_l IS NOT NULL THEN
3741: dbms_sql.bind_variable (remit_recs,':rcpt_number_l',p_trx_num_l);
3742: END IF;
3743:
3744: IF p_trx_num_h IS NOT NULL THEN
3745: dbms_sql.bind_variable (remit_recs,':rcpt_number_h',p_trx_num_h);

Line 3745: dbms_sql.bind_variable (remit_recs,':rcpt_number_h',p_trx_num_h);

3741: dbms_sql.bind_variable (remit_recs,':rcpt_number_l',p_trx_num_l);
3742: END IF;
3743:
3744: IF p_trx_num_h IS NOT NULL THEN
3745: dbms_sql.bind_variable (remit_recs,':rcpt_number_h',p_trx_num_h);
3746: END IF;
3747:
3748: /*bug 8473259 binding variable for document number*/
3749: IF p_doc_num_l IS NOT NULL THEN

Line 3750: dbms_sql.bind_variable (remit_recs,':doc_num_l',p_doc_num_l);

3746: END IF;
3747:
3748: /*bug 8473259 binding variable for document number*/
3749: IF p_doc_num_l IS NOT NULL THEN
3750: dbms_sql.bind_variable (remit_recs,':doc_num_l',p_doc_num_l);
3751: END IF;
3752:
3753: IF p_doc_num_h IS NOT NULL AND nvl(p_doc_num_l,-1) <> p_doc_num_h THEN
3754: dbms_sql.bind_variable (remit_recs,':doc_num_h',p_doc_num_h);

Line 3754: dbms_sql.bind_variable (remit_recs,':doc_num_h',p_doc_num_h);

3750: dbms_sql.bind_variable (remit_recs,':doc_num_l',p_doc_num_l);
3751: END IF;
3752:
3753: IF p_doc_num_h IS NOT NULL AND nvl(p_doc_num_l,-1) <> p_doc_num_h THEN
3754: dbms_sql.bind_variable (remit_recs,':doc_num_h',p_doc_num_h);
3755: END IF;
3756:
3757: IF p_remittance_total_to IS NOT NULL THEN
3758: dbms_sql.bind_variable (remit_recs,':remittance_total_to',p_remittance_total_to );

Line 3758: dbms_sql.bind_variable (remit_recs,':remittance_total_to',p_remittance_total_to );

3754: dbms_sql.bind_variable (remit_recs,':doc_num_h',p_doc_num_h);
3755: END IF;
3756:
3757: IF p_remittance_total_to IS NOT NULL THEN
3758: dbms_sql.bind_variable (remit_recs,':remittance_total_to',p_remittance_total_to );
3759: END IF;
3760: /* 14798599
3761: IF p_remittance_total_from IS NOT NULL THEN
3762: dbms_sql.bind_variable (remit_recs,':remittance_total_from',p_remittance_total_from );

Line 3762: dbms_sql.bind_variable (remit_recs,':remittance_total_from',p_remittance_total_from );

3758: dbms_sql.bind_variable (remit_recs,':remittance_total_to',p_remittance_total_to );
3759: END IF;
3760: /* 14798599
3761: IF p_remittance_total_from IS NOT NULL THEN
3762: dbms_sql.bind_variable (remit_recs,':remittance_total_from',p_remittance_total_from );
3763: END IF;
3764: */
3765: IF PG_DEBUG in ('Y', 'C') THEN
3766: fnd_file.put_line(FND_FILE.LOG, 'the select statemnt' || l_sel_stmt);

Line 3770: dbms_sql.define_array( remit_recs, 1, cr_id_array, 1000, 1 ); --14798599

3766: fnd_file.put_line(FND_FILE.LOG, 'the select statemnt' || l_sel_stmt);
3767: END IF;
3768:
3769: IF p_remittance_total_from IS NOT NULL OR p_remittance_total_to IS NOT NULL THEN
3770: dbms_sql.define_array( remit_recs, 1, cr_id_array, 1000, 1 ); --14798599
3771: dbms_sql.define_array( remit_recs, 2, amt_array, 1000, 1 ); --14798599
3772: END IF;
3773: commit;
3774: execute immediate 'alter session enable parallel dml';

Line 3771: dbms_sql.define_array( remit_recs, 2, amt_array, 1000, 1 ); --14798599

3767: END IF;
3768:
3769: IF p_remittance_total_from IS NOT NULL OR p_remittance_total_to IS NOT NULL THEN
3770: dbms_sql.define_array( remit_recs, 1, cr_id_array, 1000, 1 ); --14798599
3771: dbms_sql.define_array( remit_recs, 2, amt_array, 1000, 1 ); --14798599
3772: END IF;
3773: commit;
3774: execute immediate 'alter session enable parallel dml';
3775: l_rows_processed := dbms_sql.execute( remit_recs );

Line 3775: l_rows_processed := dbms_sql.execute( remit_recs );

3771: dbms_sql.define_array( remit_recs, 2, amt_array, 1000, 1 ); --14798599
3772: END IF;
3773: commit;
3774: execute immediate 'alter session enable parallel dml';
3775: l_rows_processed := dbms_sql.execute( remit_recs );
3776:
3777: commit;
3778:
3779: execute immediate 'alter session disable parallel dml';

Line 3786: dum := dbms_sql.fetch_rows( remit_recs );

3782: i := 1;
3783: IF p_remittance_total_from IS NOT NULL OR p_remittance_total_to IS NOT NULL THEN
3784: LOOP
3785:
3786: dum := dbms_sql.fetch_rows( remit_recs );
3787:
3788: dbms_sql.column_value( remit_recs, 1, cr_id_array );
3789: dbms_sql.column_value( remit_recs, 2, amt_array );
3790:

Line 3788: dbms_sql.column_value( remit_recs, 1, cr_id_array );

3784: LOOP
3785:
3786: dum := dbms_sql.fetch_rows( remit_recs );
3787:
3788: dbms_sql.column_value( remit_recs, 1, cr_id_array );
3789: dbms_sql.column_value( remit_recs, 2, amt_array );
3790:
3791: FOR idx IN 1..dum
3792: LOOP

Line 3789: dbms_sql.column_value( remit_recs, 2, amt_array );

3785:
3786: dum := dbms_sql.fetch_rows( remit_recs );
3787:
3788: dbms_sql.column_value( remit_recs, 1, cr_id_array );
3789: dbms_sql.column_value( remit_recs, 2, amt_array );
3790:
3791: FOR idx IN 1..dum
3792: LOOP
3793: l_amount := l_amount + amt_array(idx);

Line 3831: upd_recs := dbms_sql.open_cursor;

3827:
3828: --14798599 l_sel_stmt := upd_stmt2 ||' AND cash_receipt_id IN ( '|| l_sel_stmt || ')';
3829: upd_stmt2 := upd_stmt2 ||' AND cash_receipt_id IN ( :cash_receipt_id_array )'; --14798599
3830:
3831: upd_recs := dbms_sql.open_cursor;
3832:
3833: dbms_sql.parse (upd_recs,upd_stmt2,dbms_sql.v7);
3834:
3835: /* bind the variables used in update statement */

Line 3833: dbms_sql.parse (upd_recs,upd_stmt2,dbms_sql.v7);

3829: upd_stmt2 := upd_stmt2 ||' AND cash_receipt_id IN ( :cash_receipt_id_array )'; --14798599
3830:
3831: upd_recs := dbms_sql.open_cursor;
3832:
3833: dbms_sql.parse (upd_recs,upd_stmt2,dbms_sql.v7);
3834:
3835: /* bind the variables used in update statement */
3836: dbms_sql.bind_variable (upd_recs,':u_batch_id',p_batch_id);
3837: dbms_sql.bind_variable (upd_recs,':u_remit_bank_account_id',p_remit_bank_account_id);

Line 3836: dbms_sql.bind_variable (upd_recs,':u_batch_id',p_batch_id);

3832:
3833: dbms_sql.parse (upd_recs,upd_stmt2,dbms_sql.v7);
3834:
3835: /* bind the variables used in update statement */
3836: dbms_sql.bind_variable (upd_recs,':u_batch_id',p_batch_id);
3837: dbms_sql.bind_variable (upd_recs,':u_remit_bank_account_id',p_remit_bank_account_id);
3838:
3839: /* who cols */
3840: dbms_sql.bind_variable (upd_recs,':i_last_updated_by',l_last_updated_by);

Line 3837: dbms_sql.bind_variable (upd_recs,':u_remit_bank_account_id',p_remit_bank_account_id);

3833: dbms_sql.parse (upd_recs,upd_stmt2,dbms_sql.v7);
3834:
3835: /* bind the variables used in update statement */
3836: dbms_sql.bind_variable (upd_recs,':u_batch_id',p_batch_id);
3837: dbms_sql.bind_variable (upd_recs,':u_remit_bank_account_id',p_remit_bank_account_id);
3838:
3839: /* who cols */
3840: dbms_sql.bind_variable (upd_recs,':i_last_updated_by',l_last_updated_by);
3841: dbms_sql.bind_variable (upd_recs,':i_last_update_login',l_last_update_login);

Line 3840: dbms_sql.bind_variable (upd_recs,':i_last_updated_by',l_last_updated_by);

3836: dbms_sql.bind_variable (upd_recs,':u_batch_id',p_batch_id);
3837: dbms_sql.bind_variable (upd_recs,':u_remit_bank_account_id',p_remit_bank_account_id);
3838:
3839: /* who cols */
3840: dbms_sql.bind_variable (upd_recs,':i_last_updated_by',l_last_updated_by);
3841: dbms_sql.bind_variable (upd_recs,':i_last_update_login',l_last_update_login);
3842: dbms_sql.bind_variable (upd_recs,':i_request_id',l_request_id);
3843: dbms_sql.bind_variable (upd_recs,':i_program_application_id',l_program_application_id);
3844: dbms_sql.bind_variable (upd_recs,':i_program_id',l_program_id);

Line 3841: dbms_sql.bind_variable (upd_recs,':i_last_update_login',l_last_update_login);

3837: dbms_sql.bind_variable (upd_recs,':u_remit_bank_account_id',p_remit_bank_account_id);
3838:
3839: /* who cols */
3840: dbms_sql.bind_variable (upd_recs,':i_last_updated_by',l_last_updated_by);
3841: dbms_sql.bind_variable (upd_recs,':i_last_update_login',l_last_update_login);
3842: dbms_sql.bind_variable (upd_recs,':i_request_id',l_request_id);
3843: dbms_sql.bind_variable (upd_recs,':i_program_application_id',l_program_application_id);
3844: dbms_sql.bind_variable (upd_recs,':i_program_id',l_program_id);
3845:

Line 3842: dbms_sql.bind_variable (upd_recs,':i_request_id',l_request_id);

3838:
3839: /* who cols */
3840: dbms_sql.bind_variable (upd_recs,':i_last_updated_by',l_last_updated_by);
3841: dbms_sql.bind_variable (upd_recs,':i_last_update_login',l_last_update_login);
3842: dbms_sql.bind_variable (upd_recs,':i_request_id',l_request_id);
3843: dbms_sql.bind_variable (upd_recs,':i_program_application_id',l_program_application_id);
3844: dbms_sql.bind_variable (upd_recs,':i_program_id',l_program_id);
3845:
3846: dbms_sql.bind_array(upd_recs,':cash_receipt_id_array',cash_receipt_id_array);

Line 3843: dbms_sql.bind_variable (upd_recs,':i_program_application_id',l_program_application_id);

3839: /* who cols */
3840: dbms_sql.bind_variable (upd_recs,':i_last_updated_by',l_last_updated_by);
3841: dbms_sql.bind_variable (upd_recs,':i_last_update_login',l_last_update_login);
3842: dbms_sql.bind_variable (upd_recs,':i_request_id',l_request_id);
3843: dbms_sql.bind_variable (upd_recs,':i_program_application_id',l_program_application_id);
3844: dbms_sql.bind_variable (upd_recs,':i_program_id',l_program_id);
3845:
3846: dbms_sql.bind_array(upd_recs,':cash_receipt_id_array',cash_receipt_id_array);
3847:

Line 3844: dbms_sql.bind_variable (upd_recs,':i_program_id',l_program_id);

3840: dbms_sql.bind_variable (upd_recs,':i_last_updated_by',l_last_updated_by);
3841: dbms_sql.bind_variable (upd_recs,':i_last_update_login',l_last_update_login);
3842: dbms_sql.bind_variable (upd_recs,':i_request_id',l_request_id);
3843: dbms_sql.bind_variable (upd_recs,':i_program_application_id',l_program_application_id);
3844: dbms_sql.bind_variable (upd_recs,':i_program_id',l_program_id);
3845:
3846: dbms_sql.bind_array(upd_recs,':cash_receipt_id_array',cash_receipt_id_array);
3847:
3848: commit;

Line 3846: dbms_sql.bind_array(upd_recs,':cash_receipt_id_array',cash_receipt_id_array);

3842: dbms_sql.bind_variable (upd_recs,':i_request_id',l_request_id);
3843: dbms_sql.bind_variable (upd_recs,':i_program_application_id',l_program_application_id);
3844: dbms_sql.bind_variable (upd_recs,':i_program_id',l_program_id);
3845:
3846: dbms_sql.bind_array(upd_recs,':cash_receipt_id_array',cash_receipt_id_array);
3847:
3848: commit;
3849: execute immediate 'alter session enable parallel dml';
3850: l_rows_processed := dbms_sql.execute( upd_recs );

Line 3850: l_rows_processed := dbms_sql.execute( upd_recs );

3846: dbms_sql.bind_array(upd_recs,':cash_receipt_id_array',cash_receipt_id_array);
3847:
3848: commit;
3849: execute immediate 'alter session enable parallel dml';
3850: l_rows_processed := dbms_sql.execute( upd_recs );
3851: commit;
3852: execute immediate 'alter session disable parallel dml';
3853:
3854: END IF;

Line 3855: l_rows_fetched := dbms_sql.last_row_count ;

3851: commit;
3852: execute immediate 'alter session disable parallel dml';
3853:
3854: END IF;
3855: l_rows_fetched := dbms_sql.last_row_count ;
3856:
3857: IF PG_DEBUG in ('Y', 'C') THEN
3858: fnd_file.put_line(FND_FILE.LOG,'the no of rows fetched ' || l_rows_fetched);
3859: END IF;

Line 3861: if dbms_sql.is_open(upd_recs) THEN

3857: IF PG_DEBUG in ('Y', 'C') THEN
3858: fnd_file.put_line(FND_FILE.LOG,'the no of rows fetched ' || l_rows_fetched);
3859: END IF;
3860:
3861: if dbms_sql.is_open(upd_recs) THEN
3862: dbms_sql.close_cursor( upd_recs );
3863: end if;
3864:
3865: END IF;

Line 3862: dbms_sql.close_cursor( upd_recs );

3858: fnd_file.put_line(FND_FILE.LOG,'the no of rows fetched ' || l_rows_fetched);
3859: END IF;
3860:
3861: if dbms_sql.is_open(upd_recs) THEN
3862: dbms_sql.close_cursor( upd_recs );
3863: end if;
3864:
3865: END IF;
3866:

Line 3868: dbms_sql.close_cursor( remit_recs );

3864:
3865: END IF;
3866:
3867:
3868: dbms_sql.close_cursor( remit_recs );
3869:
3870: IF PG_DEBUG in ('Y', 'C') THEN
3871: fnd_file.put_line(FND_FILE.LOG,'sel_and_update recs ()-');
3872: END IF;