eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_AUTOREM_API dependencies on DBMS_SQL

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

1294: and gtt.CASH_RECEIPT_HISTORY_ID = CRH.CASH_RECEIPT_HISTORY_ID ';
1295:
1296: commit;
1297: execute immediate 'alter session enable parallel dml';
1298: ins_rec := dbms_sql.open_cursor();
1299: dbms_sql.parse (ins_rec, l_ins_stmt, dbms_sql.v7);
1300: dbms_sql.bind_variable( ins_rec, ':b_total_workers', p_total_workers);
1301: dbms_sql.bind_variable( ins_rec, ':b_batch_id', o_batch_id);
1302: ignore := dbms_sql.execute(ins_rec);

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

1295:
1296: commit;
1297: execute immediate 'alter session enable parallel dml';
1298: ins_rec := dbms_sql.open_cursor();
1299: dbms_sql.parse (ins_rec, l_ins_stmt, dbms_sql.v7);
1300: dbms_sql.bind_variable( ins_rec, ':b_total_workers', p_total_workers);
1301: dbms_sql.bind_variable( ins_rec, ':b_batch_id', o_batch_id);
1302: ignore := dbms_sql.execute(ins_rec);
1303: commit;

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

1296: commit;
1297: execute immediate 'alter session enable parallel dml';
1298: ins_rec := dbms_sql.open_cursor();
1299: dbms_sql.parse (ins_rec, l_ins_stmt, dbms_sql.v7);
1300: dbms_sql.bind_variable( ins_rec, ':b_total_workers', p_total_workers);
1301: dbms_sql.bind_variable( ins_rec, ':b_batch_id', o_batch_id);
1302: ignore := dbms_sql.execute(ins_rec);
1303: commit;
1304:

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

1297: execute immediate 'alter session enable parallel dml';
1298: ins_rec := dbms_sql.open_cursor();
1299: dbms_sql.parse (ins_rec, l_ins_stmt, dbms_sql.v7);
1300: dbms_sql.bind_variable( ins_rec, ':b_total_workers', p_total_workers);
1301: dbms_sql.bind_variable( ins_rec, ':b_batch_id', o_batch_id);
1302: ignore := dbms_sql.execute(ins_rec);
1303: commit;
1304:
1305: --Invoke the child programs

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

1298: ins_rec := dbms_sql.open_cursor();
1299: dbms_sql.parse (ins_rec, l_ins_stmt, dbms_sql.v7);
1300: dbms_sql.bind_variable( ins_rec, ':b_total_workers', p_total_workers);
1301: dbms_sql.bind_variable( ins_rec, ':b_batch_id', o_batch_id);
1302: ignore := dbms_sql.execute(ins_rec);
1303: commit;
1304:
1305: --Invoke the child programs
1306: FOR l_worker_number IN 1..p_total_workers LOOP

Line 1781: cash_receipt_id_array dbms_sql.Number_Table;

1777: /* declare the insert array elements */
1778: i NUMBER;
1779: dummy NUMBER;
1780: inst_stmt varchar2(2000);
1781: cash_receipt_id_array dbms_sql.Number_Table;
1782: payment_type_CODE_array dbms_sql.varchar2_Table;
1783: merchant_ref_array dbms_sql.varchar2_Table;
1784: currency_code_array dbms_sql.varchar2_Table;
1785: pay_from_customer_array dbms_sql.varchar2_Table;

Line 1782: payment_type_CODE_array dbms_sql.varchar2_Table;

1778: i NUMBER;
1779: dummy NUMBER;
1780: inst_stmt varchar2(2000);
1781: cash_receipt_id_array dbms_sql.Number_Table;
1782: payment_type_CODE_array dbms_sql.varchar2_Table;
1783: merchant_ref_array dbms_sql.varchar2_Table;
1784: currency_code_array dbms_sql.varchar2_Table;
1785: pay_from_customer_array dbms_sql.varchar2_Table;
1786: customer_site_use_id_array dbms_sql.Number_Table;

Line 1783: merchant_ref_array dbms_sql.varchar2_Table;

1779: dummy NUMBER;
1780: inst_stmt varchar2(2000);
1781: cash_receipt_id_array dbms_sql.Number_Table;
1782: payment_type_CODE_array dbms_sql.varchar2_Table;
1783: merchant_ref_array dbms_sql.varchar2_Table;
1784: currency_code_array dbms_sql.varchar2_Table;
1785: pay_from_customer_array dbms_sql.varchar2_Table;
1786: customer_site_use_id_array dbms_sql.Number_Table;
1787: prv_cash_receipt_hist_id_array dbms_sql.Number_Table;

Line 1784: currency_code_array dbms_sql.varchar2_Table;

1780: inst_stmt varchar2(2000);
1781: cash_receipt_id_array dbms_sql.Number_Table;
1782: payment_type_CODE_array dbms_sql.varchar2_Table;
1783: merchant_ref_array dbms_sql.varchar2_Table;
1784: currency_code_array dbms_sql.varchar2_Table;
1785: pay_from_customer_array dbms_sql.varchar2_Table;
1786: customer_site_use_id_array dbms_sql.Number_Table;
1787: prv_cash_receipt_hist_id_array dbms_sql.Number_Table;
1788: exchange_date_array dbms_sql.date_Table;

Line 1785: pay_from_customer_array dbms_sql.varchar2_Table;

1781: cash_receipt_id_array dbms_sql.Number_Table;
1782: payment_type_CODE_array dbms_sql.varchar2_Table;
1783: merchant_ref_array dbms_sql.varchar2_Table;
1784: currency_code_array dbms_sql.varchar2_Table;
1785: pay_from_customer_array dbms_sql.varchar2_Table;
1786: customer_site_use_id_array dbms_sql.Number_Table;
1787: prv_cash_receipt_hist_id_array dbms_sql.Number_Table;
1788: exchange_date_array dbms_sql.date_Table;
1789: exchange_rate_array dbms_sql.Number_Table;

Line 1786: customer_site_use_id_array dbms_sql.Number_Table;

1782: payment_type_CODE_array dbms_sql.varchar2_Table;
1783: merchant_ref_array dbms_sql.varchar2_Table;
1784: currency_code_array dbms_sql.varchar2_Table;
1785: pay_from_customer_array dbms_sql.varchar2_Table;
1786: customer_site_use_id_array dbms_sql.Number_Table;
1787: prv_cash_receipt_hist_id_array dbms_sql.Number_Table;
1788: exchange_date_array dbms_sql.date_Table;
1789: exchange_rate_array dbms_sql.Number_Table;
1790: exchange_type_array dbms_sql.varchar2_Table;

Line 1787: prv_cash_receipt_hist_id_array dbms_sql.Number_Table;

1783: merchant_ref_array dbms_sql.varchar2_Table;
1784: currency_code_array dbms_sql.varchar2_Table;
1785: pay_from_customer_array dbms_sql.varchar2_Table;
1786: customer_site_use_id_array dbms_sql.Number_Table;
1787: prv_cash_receipt_hist_id_array dbms_sql.Number_Table;
1788: exchange_date_array dbms_sql.date_Table;
1789: exchange_rate_array dbms_sql.Number_Table;
1790: exchange_type_array dbms_sql.varchar2_Table;
1791: cr_amount_array dbms_sql.Number_Table;

Line 1788: exchange_date_array dbms_sql.date_Table;

1784: currency_code_array dbms_sql.varchar2_Table;
1785: pay_from_customer_array dbms_sql.varchar2_Table;
1786: customer_site_use_id_array dbms_sql.Number_Table;
1787: prv_cash_receipt_hist_id_array dbms_sql.Number_Table;
1788: exchange_date_array dbms_sql.date_Table;
1789: exchange_rate_array dbms_sql.Number_Table;
1790: exchange_type_array dbms_sql.varchar2_Table;
1791: cr_amount_array dbms_sql.Number_Table;
1792: cr_acctd_amount_array dbms_sql.Number_Table;

Line 1789: exchange_rate_array dbms_sql.Number_Table;

1785: pay_from_customer_array dbms_sql.varchar2_Table;
1786: customer_site_use_id_array dbms_sql.Number_Table;
1787: prv_cash_receipt_hist_id_array dbms_sql.Number_Table;
1788: exchange_date_array dbms_sql.date_Table;
1789: exchange_rate_array dbms_sql.Number_Table;
1790: exchange_type_array dbms_sql.varchar2_Table;
1791: cr_amount_array dbms_sql.Number_Table;
1792: cr_acctd_amount_array dbms_sql.Number_Table;
1793: cr_factor_discount_amt_array dbms_sql.Number_Table;

Line 1790: exchange_type_array dbms_sql.varchar2_Table;

1786: customer_site_use_id_array dbms_sql.Number_Table;
1787: prv_cash_receipt_hist_id_array dbms_sql.Number_Table;
1788: exchange_date_array dbms_sql.date_Table;
1789: exchange_rate_array dbms_sql.Number_Table;
1790: exchange_type_array dbms_sql.varchar2_Table;
1791: cr_amount_array dbms_sql.Number_Table;
1792: cr_acctd_amount_array dbms_sql.Number_Table;
1793: cr_factor_discount_amt_array dbms_sql.Number_Table;
1794: remmitance_ccid_array dbms_sql.Number_Table;

Line 1791: cr_amount_array dbms_sql.Number_Table;

1787: prv_cash_receipt_hist_id_array dbms_sql.Number_Table;
1788: exchange_date_array dbms_sql.date_Table;
1789: exchange_rate_array dbms_sql.Number_Table;
1790: exchange_type_array dbms_sql.varchar2_Table;
1791: cr_amount_array dbms_sql.Number_Table;
1792: cr_acctd_amount_array dbms_sql.Number_Table;
1793: cr_factor_discount_amt_array dbms_sql.Number_Table;
1794: remmitance_ccid_array dbms_sql.Number_Table;
1795: bank_charges_ccid_array dbms_sql.Number_Table;

Line 1792: cr_acctd_amount_array dbms_sql.Number_Table;

1788: exchange_date_array dbms_sql.date_Table;
1789: exchange_rate_array dbms_sql.Number_Table;
1790: exchange_type_array dbms_sql.varchar2_Table;
1791: cr_amount_array dbms_sql.Number_Table;
1792: cr_acctd_amount_array dbms_sql.Number_Table;
1793: cr_factor_discount_amt_array dbms_sql.Number_Table;
1794: remmitance_ccid_array dbms_sql.Number_Table;
1795: bank_charges_ccid_array dbms_sql.Number_Table;
1796: code_combination_id_array dbms_sql.Number_Table;

Line 1793: cr_factor_discount_amt_array dbms_sql.Number_Table;

1789: exchange_rate_array dbms_sql.Number_Table;
1790: exchange_type_array dbms_sql.varchar2_Table;
1791: cr_amount_array dbms_sql.Number_Table;
1792: cr_acctd_amount_array dbms_sql.Number_Table;
1793: cr_factor_discount_amt_array dbms_sql.Number_Table;
1794: remmitance_ccid_array dbms_sql.Number_Table;
1795: bank_charges_ccid_array dbms_sql.Number_Table;
1796: code_combination_id_array dbms_sql.Number_Table;
1797: cash_receipt_history_id_array dbms_sql.Number_Table;

Line 1794: remmitance_ccid_array dbms_sql.Number_Table;

1790: exchange_type_array dbms_sql.varchar2_Table;
1791: cr_amount_array dbms_sql.Number_Table;
1792: cr_acctd_amount_array dbms_sql.Number_Table;
1793: cr_factor_discount_amt_array dbms_sql.Number_Table;
1794: remmitance_ccid_array dbms_sql.Number_Table;
1795: bank_charges_ccid_array dbms_sql.Number_Table;
1796: code_combination_id_array dbms_sql.Number_Table;
1797: cash_receipt_history_id_array dbms_sql.Number_Table;
1798: crh_gl_date_array dbms_sql.date_Table;

Line 1795: bank_charges_ccid_array dbms_sql.Number_Table;

1791: cr_amount_array dbms_sql.Number_Table;
1792: cr_acctd_amount_array dbms_sql.Number_Table;
1793: cr_factor_discount_amt_array dbms_sql.Number_Table;
1794: remmitance_ccid_array dbms_sql.Number_Table;
1795: bank_charges_ccid_array dbms_sql.Number_Table;
1796: code_combination_id_array dbms_sql.Number_Table;
1797: cash_receipt_history_id_array dbms_sql.Number_Table;
1798: crh_gl_date_array dbms_sql.date_Table;
1799: crh_trx_date_array dbms_sql.date_Table;

Line 1796: code_combination_id_array dbms_sql.Number_Table;

1792: cr_acctd_amount_array dbms_sql.Number_Table;
1793: cr_factor_discount_amt_array dbms_sql.Number_Table;
1794: remmitance_ccid_array dbms_sql.Number_Table;
1795: bank_charges_ccid_array dbms_sql.Number_Table;
1796: code_combination_id_array dbms_sql.Number_Table;
1797: cash_receipt_history_id_array dbms_sql.Number_Table;
1798: crh_gl_date_array dbms_sql.date_Table;
1799: crh_trx_date_array dbms_sql.date_Table;
1800: payment_server_order_num_array dbms_sql.varchar2_Table;

Line 1797: cash_receipt_history_id_array dbms_sql.Number_Table;

1793: cr_factor_discount_amt_array dbms_sql.Number_Table;
1794: remmitance_ccid_array dbms_sql.Number_Table;
1795: bank_charges_ccid_array dbms_sql.Number_Table;
1796: code_combination_id_array dbms_sql.Number_Table;
1797: cash_receipt_history_id_array dbms_sql.Number_Table;
1798: crh_gl_date_array dbms_sql.date_Table;
1799: crh_trx_date_array dbms_sql.date_Table;
1800: payment_server_order_num_array dbms_sql.varchar2_Table;
1801: approval_code_array dbms_sql.varchar2_Table;

Line 1798: crh_gl_date_array dbms_sql.date_Table;

1794: remmitance_ccid_array dbms_sql.Number_Table;
1795: bank_charges_ccid_array dbms_sql.Number_Table;
1796: code_combination_id_array dbms_sql.Number_Table;
1797: cash_receipt_history_id_array dbms_sql.Number_Table;
1798: crh_gl_date_array dbms_sql.date_Table;
1799: crh_trx_date_array dbms_sql.date_Table;
1800: payment_server_order_num_array dbms_sql.varchar2_Table;
1801: approval_code_array dbms_sql.varchar2_Table;
1802: receipt_number_array dbms_sql.varchar2_Table;

Line 1799: crh_trx_date_array dbms_sql.date_Table;

1795: bank_charges_ccid_array dbms_sql.Number_Table;
1796: code_combination_id_array dbms_sql.Number_Table;
1797: cash_receipt_history_id_array dbms_sql.Number_Table;
1798: crh_gl_date_array dbms_sql.date_Table;
1799: crh_trx_date_array dbms_sql.date_Table;
1800: payment_server_order_num_array dbms_sql.varchar2_Table;
1801: approval_code_array dbms_sql.varchar2_Table;
1802: receipt_number_array dbms_sql.varchar2_Table;
1803: unique_ref_array dbms_sql.varchar2_Table;

Line 1800: payment_server_order_num_array dbms_sql.varchar2_Table;

1796: code_combination_id_array dbms_sql.Number_Table;
1797: cash_receipt_history_id_array dbms_sql.Number_Table;
1798: crh_gl_date_array dbms_sql.date_Table;
1799: crh_trx_date_array dbms_sql.date_Table;
1800: payment_server_order_num_array dbms_sql.varchar2_Table;
1801: approval_code_array dbms_sql.varchar2_Table;
1802: receipt_number_array dbms_sql.varchar2_Table;
1803: unique_ref_array dbms_sql.varchar2_Table;
1804: customer_bank_account_id_array dbms_sql.Number_Table;

Line 1801: approval_code_array dbms_sql.varchar2_Table;

1797: cash_receipt_history_id_array dbms_sql.Number_Table;
1798: crh_gl_date_array dbms_sql.date_Table;
1799: crh_trx_date_array dbms_sql.date_Table;
1800: payment_server_order_num_array dbms_sql.varchar2_Table;
1801: approval_code_array dbms_sql.varchar2_Table;
1802: receipt_number_array dbms_sql.varchar2_Table;
1803: unique_ref_array dbms_sql.varchar2_Table;
1804: customer_bank_account_id_array dbms_sql.Number_Table;
1805: payment_trxn_extn_id_array dbms_sql.Number_Table;

Line 1802: receipt_number_array dbms_sql.varchar2_Table;

1798: crh_gl_date_array dbms_sql.date_Table;
1799: crh_trx_date_array dbms_sql.date_Table;
1800: payment_server_order_num_array dbms_sql.varchar2_Table;
1801: approval_code_array dbms_sql.varchar2_Table;
1802: receipt_number_array dbms_sql.varchar2_Table;
1803: unique_ref_array dbms_sql.varchar2_Table;
1804: customer_bank_account_id_array dbms_sql.Number_Table;
1805: payment_trxn_extn_id_array dbms_sql.Number_Table;
1806: rem_t NUMBER;

Line 1803: unique_ref_array dbms_sql.varchar2_Table;

1799: crh_trx_date_array dbms_sql.date_Table;
1800: payment_server_order_num_array dbms_sql.varchar2_Table;
1801: approval_code_array dbms_sql.varchar2_Table;
1802: receipt_number_array dbms_sql.varchar2_Table;
1803: unique_ref_array dbms_sql.varchar2_Table;
1804: customer_bank_account_id_array dbms_sql.Number_Table;
1805: payment_trxn_extn_id_array dbms_sql.Number_Table;
1806: rem_t NUMBER;
1807: /* end declare */

Line 1804: customer_bank_account_id_array dbms_sql.Number_Table;

1800: payment_server_order_num_array dbms_sql.varchar2_Table;
1801: approval_code_array dbms_sql.varchar2_Table;
1802: receipt_number_array dbms_sql.varchar2_Table;
1803: unique_ref_array dbms_sql.varchar2_Table;
1804: customer_bank_account_id_array dbms_sql.Number_Table;
1805: payment_trxn_extn_id_array dbms_sql.Number_Table;
1806: rem_t NUMBER;
1807: /* end declare */
1808:

Line 1805: payment_trxn_extn_id_array dbms_sql.Number_Table;

1801: approval_code_array dbms_sql.varchar2_Table;
1802: receipt_number_array dbms_sql.varchar2_Table;
1803: unique_ref_array dbms_sql.varchar2_Table;
1804: customer_bank_account_id_array dbms_sql.Number_Table;
1805: payment_trxn_extn_id_array dbms_sql.Number_Table;
1806: rem_t NUMBER;
1807: /* end declare */
1808:
1809:

Line 1918: sel_receipts := dbms_sql.open_cursor;

1914: AND d.source_type = ''CONFIRMATION''
1915: AND d.source_table = ''CRH''
1916: ';
1917:
1918: sel_receipts := dbms_sql.open_cursor;
1919:
1920: dbms_sql.parse (sel_receipts,l_sel_stmt,dbms_sql.v7);
1921:
1922: dbms_sql.bind_variable (sel_receipts,':ab_batch_id',p_batch_id);

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

1916: ';
1917:
1918: sel_receipts := dbms_sql.open_cursor;
1919:
1920: dbms_sql.parse (sel_receipts,l_sel_stmt,dbms_sql.v7);
1921:
1922: dbms_sql.bind_variable (sel_receipts,':ab_batch_id',p_batch_id);
1923:
1924: dbms_sql.define_column (sel_receipts, 1, p_cash_receipt_id);

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

1918: sel_receipts := dbms_sql.open_cursor;
1919:
1920: dbms_sql.parse (sel_receipts,l_sel_stmt,dbms_sql.v7);
1921:
1922: dbms_sql.bind_variable (sel_receipts,':ab_batch_id',p_batch_id);
1923:
1924: dbms_sql.define_column (sel_receipts, 1, p_cash_receipt_id);
1925: dbms_sql.define_column (sel_receipts, 2, p_payment_type_code,30);
1926: dbms_sql.define_column (sel_receipts, 3, p_merchant_ref,80);

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

1920: dbms_sql.parse (sel_receipts,l_sel_stmt,dbms_sql.v7);
1921:
1922: dbms_sql.bind_variable (sel_receipts,':ab_batch_id',p_batch_id);
1923:
1924: dbms_sql.define_column (sel_receipts, 1, p_cash_receipt_id);
1925: dbms_sql.define_column (sel_receipts, 2, p_payment_type_code,30);
1926: dbms_sql.define_column (sel_receipts, 3, p_merchant_ref,80);
1927: dbms_sql.define_column (sel_receipts, 4, p_currency_code,15);
1928: dbms_sql.define_column (sel_receipts, 5, p_pay_from_customer);

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

1921:
1922: dbms_sql.bind_variable (sel_receipts,':ab_batch_id',p_batch_id);
1923:
1924: dbms_sql.define_column (sel_receipts, 1, p_cash_receipt_id);
1925: dbms_sql.define_column (sel_receipts, 2, p_payment_type_code,30);
1926: dbms_sql.define_column (sel_receipts, 3, p_merchant_ref,80);
1927: dbms_sql.define_column (sel_receipts, 4, p_currency_code,15);
1928: dbms_sql.define_column (sel_receipts, 5, p_pay_from_customer);
1929: dbms_sql.define_column (sel_receipts, 6, p_customer_site_use_id);

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

1922: dbms_sql.bind_variable (sel_receipts,':ab_batch_id',p_batch_id);
1923:
1924: dbms_sql.define_column (sel_receipts, 1, p_cash_receipt_id);
1925: dbms_sql.define_column (sel_receipts, 2, p_payment_type_code,30);
1926: dbms_sql.define_column (sel_receipts, 3, p_merchant_ref,80);
1927: dbms_sql.define_column (sel_receipts, 4, p_currency_code,15);
1928: dbms_sql.define_column (sel_receipts, 5, p_pay_from_customer);
1929: dbms_sql.define_column (sel_receipts, 6, p_customer_site_use_id);
1930: dbms_sql.define_column (sel_receipts, 7, p_prv_cash_receipt_hist_id);

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

1923:
1924: dbms_sql.define_column (sel_receipts, 1, p_cash_receipt_id);
1925: dbms_sql.define_column (sel_receipts, 2, p_payment_type_code,30);
1926: dbms_sql.define_column (sel_receipts, 3, p_merchant_ref,80);
1927: dbms_sql.define_column (sel_receipts, 4, p_currency_code,15);
1928: dbms_sql.define_column (sel_receipts, 5, p_pay_from_customer);
1929: dbms_sql.define_column (sel_receipts, 6, p_customer_site_use_id);
1930: dbms_sql.define_column (sel_receipts, 7, p_prv_cash_receipt_hist_id);
1931: dbms_sql.define_column (sel_receipts, 8, p_exchange_date);

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

1924: dbms_sql.define_column (sel_receipts, 1, p_cash_receipt_id);
1925: dbms_sql.define_column (sel_receipts, 2, p_payment_type_code,30);
1926: dbms_sql.define_column (sel_receipts, 3, p_merchant_ref,80);
1927: dbms_sql.define_column (sel_receipts, 4, p_currency_code,15);
1928: dbms_sql.define_column (sel_receipts, 5, p_pay_from_customer);
1929: dbms_sql.define_column (sel_receipts, 6, p_customer_site_use_id);
1930: dbms_sql.define_column (sel_receipts, 7, p_prv_cash_receipt_hist_id);
1931: dbms_sql.define_column (sel_receipts, 8, p_exchange_date);
1932: dbms_sql.define_column (sel_receipts, 9, p_exchange_rate);

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

1925: dbms_sql.define_column (sel_receipts, 2, p_payment_type_code,30);
1926: dbms_sql.define_column (sel_receipts, 3, p_merchant_ref,80);
1927: dbms_sql.define_column (sel_receipts, 4, p_currency_code,15);
1928: dbms_sql.define_column (sel_receipts, 5, p_pay_from_customer);
1929: dbms_sql.define_column (sel_receipts, 6, p_customer_site_use_id);
1930: dbms_sql.define_column (sel_receipts, 7, p_prv_cash_receipt_hist_id);
1931: dbms_sql.define_column (sel_receipts, 8, p_exchange_date);
1932: dbms_sql.define_column (sel_receipts, 9, p_exchange_rate);
1933: dbms_sql.define_column (sel_receipts, 10, p_exchange_type,30);

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

1926: dbms_sql.define_column (sel_receipts, 3, p_merchant_ref,80);
1927: dbms_sql.define_column (sel_receipts, 4, p_currency_code,15);
1928: dbms_sql.define_column (sel_receipts, 5, p_pay_from_customer);
1929: dbms_sql.define_column (sel_receipts, 6, p_customer_site_use_id);
1930: dbms_sql.define_column (sel_receipts, 7, p_prv_cash_receipt_hist_id);
1931: dbms_sql.define_column (sel_receipts, 8, p_exchange_date);
1932: dbms_sql.define_column (sel_receipts, 9, p_exchange_rate);
1933: dbms_sql.define_column (sel_receipts, 10, p_exchange_type,30);
1934: dbms_sql.define_column (sel_receipts, 11, p_cr_amount);

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

1927: dbms_sql.define_column (sel_receipts, 4, p_currency_code,15);
1928: dbms_sql.define_column (sel_receipts, 5, p_pay_from_customer);
1929: dbms_sql.define_column (sel_receipts, 6, p_customer_site_use_id);
1930: dbms_sql.define_column (sel_receipts, 7, p_prv_cash_receipt_hist_id);
1931: dbms_sql.define_column (sel_receipts, 8, p_exchange_date);
1932: dbms_sql.define_column (sel_receipts, 9, p_exchange_rate);
1933: dbms_sql.define_column (sel_receipts, 10, p_exchange_type,30);
1934: dbms_sql.define_column (sel_receipts, 11, p_cr_amount);
1935: dbms_sql.define_column (sel_receipts, 12, p_cr_acctd_amount);

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

1928: dbms_sql.define_column (sel_receipts, 5, p_pay_from_customer);
1929: dbms_sql.define_column (sel_receipts, 6, p_customer_site_use_id);
1930: dbms_sql.define_column (sel_receipts, 7, p_prv_cash_receipt_hist_id);
1931: dbms_sql.define_column (sel_receipts, 8, p_exchange_date);
1932: dbms_sql.define_column (sel_receipts, 9, p_exchange_rate);
1933: dbms_sql.define_column (sel_receipts, 10, p_exchange_type,30);
1934: dbms_sql.define_column (sel_receipts, 11, p_cr_amount);
1935: dbms_sql.define_column (sel_receipts, 12, p_cr_acctd_amount);
1936: dbms_sql.define_column (sel_receipts, 13, p_cr_factor_discount_amount);

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

1929: dbms_sql.define_column (sel_receipts, 6, p_customer_site_use_id);
1930: dbms_sql.define_column (sel_receipts, 7, p_prv_cash_receipt_hist_id);
1931: dbms_sql.define_column (sel_receipts, 8, p_exchange_date);
1932: dbms_sql.define_column (sel_receipts, 9, p_exchange_rate);
1933: dbms_sql.define_column (sel_receipts, 10, p_exchange_type,30);
1934: dbms_sql.define_column (sel_receipts, 11, p_cr_amount);
1935: dbms_sql.define_column (sel_receipts, 12, p_cr_acctd_amount);
1936: dbms_sql.define_column (sel_receipts, 13, p_cr_factor_discount_amount);
1937: dbms_sql.define_column (sel_receipts, 14, p_remmitance_ccid );

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

1930: dbms_sql.define_column (sel_receipts, 7, p_prv_cash_receipt_hist_id);
1931: dbms_sql.define_column (sel_receipts, 8, p_exchange_date);
1932: dbms_sql.define_column (sel_receipts, 9, p_exchange_rate);
1933: dbms_sql.define_column (sel_receipts, 10, p_exchange_type,30);
1934: dbms_sql.define_column (sel_receipts, 11, p_cr_amount);
1935: dbms_sql.define_column (sel_receipts, 12, p_cr_acctd_amount);
1936: dbms_sql.define_column (sel_receipts, 13, p_cr_factor_discount_amount);
1937: dbms_sql.define_column (sel_receipts, 14, p_remmitance_ccid );
1938: dbms_sql.define_column (sel_receipts, 15, p_bank_charges_ccid);

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

1931: dbms_sql.define_column (sel_receipts, 8, p_exchange_date);
1932: dbms_sql.define_column (sel_receipts, 9, p_exchange_rate);
1933: dbms_sql.define_column (sel_receipts, 10, p_exchange_type,30);
1934: dbms_sql.define_column (sel_receipts, 11, p_cr_amount);
1935: dbms_sql.define_column (sel_receipts, 12, p_cr_acctd_amount);
1936: dbms_sql.define_column (sel_receipts, 13, p_cr_factor_discount_amount);
1937: dbms_sql.define_column (sel_receipts, 14, p_remmitance_ccid );
1938: dbms_sql.define_column (sel_receipts, 15, p_bank_charges_ccid);
1939: dbms_sql.define_column (sel_receipts, 16, p_code_combination_id);

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

1932: dbms_sql.define_column (sel_receipts, 9, p_exchange_rate);
1933: dbms_sql.define_column (sel_receipts, 10, p_exchange_type,30);
1934: dbms_sql.define_column (sel_receipts, 11, p_cr_amount);
1935: dbms_sql.define_column (sel_receipts, 12, p_cr_acctd_amount);
1936: dbms_sql.define_column (sel_receipts, 13, p_cr_factor_discount_amount);
1937: dbms_sql.define_column (sel_receipts, 14, p_remmitance_ccid );
1938: dbms_sql.define_column (sel_receipts, 15, p_bank_charges_ccid);
1939: dbms_sql.define_column (sel_receipts, 16, p_code_combination_id);
1940: dbms_sql.define_column (sel_receipts, 17, p_cash_receipt_history_id);

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

1933: dbms_sql.define_column (sel_receipts, 10, p_exchange_type,30);
1934: dbms_sql.define_column (sel_receipts, 11, p_cr_amount);
1935: dbms_sql.define_column (sel_receipts, 12, p_cr_acctd_amount);
1936: dbms_sql.define_column (sel_receipts, 13, p_cr_factor_discount_amount);
1937: dbms_sql.define_column (sel_receipts, 14, p_remmitance_ccid );
1938: dbms_sql.define_column (sel_receipts, 15, p_bank_charges_ccid);
1939: dbms_sql.define_column (sel_receipts, 16, p_code_combination_id);
1940: dbms_sql.define_column (sel_receipts, 17, p_cash_receipt_history_id);
1941: dbms_sql.define_column (sel_receipts, 18, p_crh_gl_date);

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

1934: dbms_sql.define_column (sel_receipts, 11, p_cr_amount);
1935: dbms_sql.define_column (sel_receipts, 12, p_cr_acctd_amount);
1936: dbms_sql.define_column (sel_receipts, 13, p_cr_factor_discount_amount);
1937: dbms_sql.define_column (sel_receipts, 14, p_remmitance_ccid );
1938: dbms_sql.define_column (sel_receipts, 15, p_bank_charges_ccid);
1939: dbms_sql.define_column (sel_receipts, 16, p_code_combination_id);
1940: dbms_sql.define_column (sel_receipts, 17, p_cash_receipt_history_id);
1941: dbms_sql.define_column (sel_receipts, 18, p_crh_gl_date);
1942: dbms_sql.define_column (sel_receipts, 19, p_crh_trx_date);

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

1935: dbms_sql.define_column (sel_receipts, 12, p_cr_acctd_amount);
1936: dbms_sql.define_column (sel_receipts, 13, p_cr_factor_discount_amount);
1937: dbms_sql.define_column (sel_receipts, 14, p_remmitance_ccid );
1938: dbms_sql.define_column (sel_receipts, 15, p_bank_charges_ccid);
1939: dbms_sql.define_column (sel_receipts, 16, p_code_combination_id);
1940: dbms_sql.define_column (sel_receipts, 17, p_cash_receipt_history_id);
1941: dbms_sql.define_column (sel_receipts, 18, p_crh_gl_date);
1942: dbms_sql.define_column (sel_receipts, 19, p_crh_trx_date);
1943: dbms_sql.define_column (sel_receipts, 20, p_payment_server_order_num,80);

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

1936: dbms_sql.define_column (sel_receipts, 13, p_cr_factor_discount_amount);
1937: dbms_sql.define_column (sel_receipts, 14, p_remmitance_ccid );
1938: dbms_sql.define_column (sel_receipts, 15, p_bank_charges_ccid);
1939: dbms_sql.define_column (sel_receipts, 16, p_code_combination_id);
1940: dbms_sql.define_column (sel_receipts, 17, p_cash_receipt_history_id);
1941: dbms_sql.define_column (sel_receipts, 18, p_crh_gl_date);
1942: dbms_sql.define_column (sel_receipts, 19, p_crh_trx_date);
1943: dbms_sql.define_column (sel_receipts, 20, p_payment_server_order_num,80);
1944: dbms_sql.define_column (sel_receipts, 21, p_approval_code,80);

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

1937: dbms_sql.define_column (sel_receipts, 14, p_remmitance_ccid );
1938: dbms_sql.define_column (sel_receipts, 15, p_bank_charges_ccid);
1939: dbms_sql.define_column (sel_receipts, 16, p_code_combination_id);
1940: dbms_sql.define_column (sel_receipts, 17, p_cash_receipt_history_id);
1941: dbms_sql.define_column (sel_receipts, 18, p_crh_gl_date);
1942: dbms_sql.define_column (sel_receipts, 19, p_crh_trx_date);
1943: dbms_sql.define_column (sel_receipts, 20, p_payment_server_order_num,80);
1944: dbms_sql.define_column (sel_receipts, 21, p_approval_code,80);
1945: dbms_sql.define_column (sel_receipts, 22, p_receipt_number,30);

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

1938: dbms_sql.define_column (sel_receipts, 15, p_bank_charges_ccid);
1939: dbms_sql.define_column (sel_receipts, 16, p_code_combination_id);
1940: dbms_sql.define_column (sel_receipts, 17, p_cash_receipt_history_id);
1941: dbms_sql.define_column (sel_receipts, 18, p_crh_gl_date);
1942: dbms_sql.define_column (sel_receipts, 19, p_crh_trx_date);
1943: dbms_sql.define_column (sel_receipts, 20, p_payment_server_order_num,80);
1944: dbms_sql.define_column (sel_receipts, 21, p_approval_code,80);
1945: dbms_sql.define_column (sel_receipts, 22, p_receipt_number,30);
1946: dbms_sql.define_column (sel_receipts, 23, p_unique_ref,32);

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

1939: dbms_sql.define_column (sel_receipts, 16, p_code_combination_id);
1940: dbms_sql.define_column (sel_receipts, 17, p_cash_receipt_history_id);
1941: dbms_sql.define_column (sel_receipts, 18, p_crh_gl_date);
1942: dbms_sql.define_column (sel_receipts, 19, p_crh_trx_date);
1943: dbms_sql.define_column (sel_receipts, 20, p_payment_server_order_num,80);
1944: dbms_sql.define_column (sel_receipts, 21, p_approval_code,80);
1945: dbms_sql.define_column (sel_receipts, 22, p_receipt_number,30);
1946: dbms_sql.define_column (sel_receipts, 23, p_unique_ref,32);
1947: dbms_sql.define_column (sel_receipts, 24, p_customer_bank_account_id);

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

1940: dbms_sql.define_column (sel_receipts, 17, p_cash_receipt_history_id);
1941: dbms_sql.define_column (sel_receipts, 18, p_crh_gl_date);
1942: dbms_sql.define_column (sel_receipts, 19, p_crh_trx_date);
1943: dbms_sql.define_column (sel_receipts, 20, p_payment_server_order_num,80);
1944: dbms_sql.define_column (sel_receipts, 21, p_approval_code,80);
1945: dbms_sql.define_column (sel_receipts, 22, p_receipt_number,30);
1946: dbms_sql.define_column (sel_receipts, 23, p_unique_ref,32);
1947: dbms_sql.define_column (sel_receipts, 24, p_customer_bank_account_id);
1948: dbms_sql.define_column (sel_receipts, 25, p_payment_trxn_extension_id);

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

1941: dbms_sql.define_column (sel_receipts, 18, p_crh_gl_date);
1942: dbms_sql.define_column (sel_receipts, 19, p_crh_trx_date);
1943: dbms_sql.define_column (sel_receipts, 20, p_payment_server_order_num,80);
1944: dbms_sql.define_column (sel_receipts, 21, p_approval_code,80);
1945: dbms_sql.define_column (sel_receipts, 22, p_receipt_number,30);
1946: dbms_sql.define_column (sel_receipts, 23, p_unique_ref,32);
1947: dbms_sql.define_column (sel_receipts, 24, p_customer_bank_account_id);
1948: dbms_sql.define_column (sel_receipts, 25, p_payment_trxn_extension_id);
1949:

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

1942: dbms_sql.define_column (sel_receipts, 19, p_crh_trx_date);
1943: dbms_sql.define_column (sel_receipts, 20, p_payment_server_order_num,80);
1944: dbms_sql.define_column (sel_receipts, 21, p_approval_code,80);
1945: dbms_sql.define_column (sel_receipts, 22, p_receipt_number,30);
1946: dbms_sql.define_column (sel_receipts, 23, p_unique_ref,32);
1947: dbms_sql.define_column (sel_receipts, 24, p_customer_bank_account_id);
1948: dbms_sql.define_column (sel_receipts, 25, p_payment_trxn_extension_id);
1949:
1950: IF PG_DEBUG in ('Y', 'C') THEN

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

1943: dbms_sql.define_column (sel_receipts, 20, p_payment_server_order_num,80);
1944: dbms_sql.define_column (sel_receipts, 21, p_approval_code,80);
1945: dbms_sql.define_column (sel_receipts, 22, p_receipt_number,30);
1946: dbms_sql.define_column (sel_receipts, 23, p_unique_ref,32);
1947: dbms_sql.define_column (sel_receipts, 24, p_customer_bank_account_id);
1948: dbms_sql.define_column (sel_receipts, 25, p_payment_trxn_extension_id);
1949:
1950: IF PG_DEBUG in ('Y', 'C') THEN
1951: fnd_file.put_line(FND_FILE.LOG, 'the select statemnt' || l_sel_stmt);

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

1944: dbms_sql.define_column (sel_receipts, 21, p_approval_code,80);
1945: dbms_sql.define_column (sel_receipts, 22, p_receipt_number,30);
1946: dbms_sql.define_column (sel_receipts, 23, p_unique_ref,32);
1947: dbms_sql.define_column (sel_receipts, 24, p_customer_bank_account_id);
1948: dbms_sql.define_column (sel_receipts, 25, p_payment_trxn_extension_id);
1949:
1950: IF PG_DEBUG in ('Y', 'C') THEN
1951: fnd_file.put_line(FND_FILE.LOG, 'the select statemnt' || l_sel_stmt);
1952: END IF;

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

1950: IF PG_DEBUG in ('Y', 'C') THEN
1951: fnd_file.put_line(FND_FILE.LOG, 'the select statemnt' || l_sel_stmt);
1952: END IF;
1953:
1954: l_rows_processed := dbms_sql.execute( sel_receipts);
1955:
1956: i:= 0;
1957:
1958: WHILE dbms_sql.fetch_rows( sel_receipts) > 0 LOOP

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

1954: l_rows_processed := dbms_sql.execute( sel_receipts);
1955:
1956: i:= 0;
1957:
1958: WHILE dbms_sql.fetch_rows( sel_receipts) > 0 LOOP
1959: fnd_file.put_line(FND_FILE.LOG,'the value of i- ent ' || to_char(i));
1960:
1961: dbms_sql.column_value (sel_receipts, 1, p_cash_receipt_id);
1962: dbms_sql.column_value (sel_receipts, 2, p_payment_type_code);

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

1957:
1958: WHILE dbms_sql.fetch_rows( sel_receipts) > 0 LOOP
1959: fnd_file.put_line(FND_FILE.LOG,'the value of i- ent ' || to_char(i));
1960:
1961: dbms_sql.column_value (sel_receipts, 1, p_cash_receipt_id);
1962: dbms_sql.column_value (sel_receipts, 2, p_payment_type_code);
1963: dbms_sql.column_value (sel_receipts, 3, p_merchant_ref);
1964: dbms_sql.column_value (sel_receipts, 4, p_currency_code);
1965: dbms_sql.column_value (sel_receipts, 5, p_pay_from_customer);

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

1958: WHILE dbms_sql.fetch_rows( sel_receipts) > 0 LOOP
1959: fnd_file.put_line(FND_FILE.LOG,'the value of i- ent ' || to_char(i));
1960:
1961: dbms_sql.column_value (sel_receipts, 1, p_cash_receipt_id);
1962: dbms_sql.column_value (sel_receipts, 2, p_payment_type_code);
1963: dbms_sql.column_value (sel_receipts, 3, p_merchant_ref);
1964: dbms_sql.column_value (sel_receipts, 4, p_currency_code);
1965: dbms_sql.column_value (sel_receipts, 5, p_pay_from_customer);
1966: dbms_sql.column_value (sel_receipts, 6, p_customer_site_use_id);

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

1959: fnd_file.put_line(FND_FILE.LOG,'the value of i- ent ' || to_char(i));
1960:
1961: dbms_sql.column_value (sel_receipts, 1, p_cash_receipt_id);
1962: dbms_sql.column_value (sel_receipts, 2, p_payment_type_code);
1963: dbms_sql.column_value (sel_receipts, 3, p_merchant_ref);
1964: dbms_sql.column_value (sel_receipts, 4, p_currency_code);
1965: dbms_sql.column_value (sel_receipts, 5, p_pay_from_customer);
1966: dbms_sql.column_value (sel_receipts, 6, p_customer_site_use_id);
1967: dbms_sql.column_value (sel_receipts, 7, p_prv_cash_receipt_hist_id);

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

1960:
1961: dbms_sql.column_value (sel_receipts, 1, p_cash_receipt_id);
1962: dbms_sql.column_value (sel_receipts, 2, p_payment_type_code);
1963: dbms_sql.column_value (sel_receipts, 3, p_merchant_ref);
1964: dbms_sql.column_value (sel_receipts, 4, p_currency_code);
1965: dbms_sql.column_value (sel_receipts, 5, p_pay_from_customer);
1966: dbms_sql.column_value (sel_receipts, 6, p_customer_site_use_id);
1967: dbms_sql.column_value (sel_receipts, 7, p_prv_cash_receipt_hist_id);
1968: dbms_sql.column_value (sel_receipts, 8, p_exchange_date);

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

1961: dbms_sql.column_value (sel_receipts, 1, p_cash_receipt_id);
1962: dbms_sql.column_value (sel_receipts, 2, p_payment_type_code);
1963: dbms_sql.column_value (sel_receipts, 3, p_merchant_ref);
1964: dbms_sql.column_value (sel_receipts, 4, p_currency_code);
1965: dbms_sql.column_value (sel_receipts, 5, p_pay_from_customer);
1966: dbms_sql.column_value (sel_receipts, 6, p_customer_site_use_id);
1967: dbms_sql.column_value (sel_receipts, 7, p_prv_cash_receipt_hist_id);
1968: dbms_sql.column_value (sel_receipts, 8, p_exchange_date);
1969: dbms_sql.column_value (sel_receipts, 9, p_exchange_rate);

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

1962: dbms_sql.column_value (sel_receipts, 2, p_payment_type_code);
1963: dbms_sql.column_value (sel_receipts, 3, p_merchant_ref);
1964: dbms_sql.column_value (sel_receipts, 4, p_currency_code);
1965: dbms_sql.column_value (sel_receipts, 5, p_pay_from_customer);
1966: dbms_sql.column_value (sel_receipts, 6, p_customer_site_use_id);
1967: dbms_sql.column_value (sel_receipts, 7, p_prv_cash_receipt_hist_id);
1968: dbms_sql.column_value (sel_receipts, 8, p_exchange_date);
1969: dbms_sql.column_value (sel_receipts, 9, p_exchange_rate);
1970: dbms_sql.column_value (sel_receipts, 10, p_exchange_type);

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

1963: dbms_sql.column_value (sel_receipts, 3, p_merchant_ref);
1964: dbms_sql.column_value (sel_receipts, 4, p_currency_code);
1965: dbms_sql.column_value (sel_receipts, 5, p_pay_from_customer);
1966: dbms_sql.column_value (sel_receipts, 6, p_customer_site_use_id);
1967: dbms_sql.column_value (sel_receipts, 7, p_prv_cash_receipt_hist_id);
1968: dbms_sql.column_value (sel_receipts, 8, p_exchange_date);
1969: dbms_sql.column_value (sel_receipts, 9, p_exchange_rate);
1970: dbms_sql.column_value (sel_receipts, 10, p_exchange_type);
1971: dbms_sql.column_value (sel_receipts, 11, p_cr_amount);

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

1964: dbms_sql.column_value (sel_receipts, 4, p_currency_code);
1965: dbms_sql.column_value (sel_receipts, 5, p_pay_from_customer);
1966: dbms_sql.column_value (sel_receipts, 6, p_customer_site_use_id);
1967: dbms_sql.column_value (sel_receipts, 7, p_prv_cash_receipt_hist_id);
1968: dbms_sql.column_value (sel_receipts, 8, p_exchange_date);
1969: dbms_sql.column_value (sel_receipts, 9, p_exchange_rate);
1970: dbms_sql.column_value (sel_receipts, 10, p_exchange_type);
1971: dbms_sql.column_value (sel_receipts, 11, p_cr_amount);
1972: dbms_sql.column_value (sel_receipts, 12, p_cr_acctd_amount);

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

1965: dbms_sql.column_value (sel_receipts, 5, p_pay_from_customer);
1966: dbms_sql.column_value (sel_receipts, 6, p_customer_site_use_id);
1967: dbms_sql.column_value (sel_receipts, 7, p_prv_cash_receipt_hist_id);
1968: dbms_sql.column_value (sel_receipts, 8, p_exchange_date);
1969: dbms_sql.column_value (sel_receipts, 9, p_exchange_rate);
1970: dbms_sql.column_value (sel_receipts, 10, p_exchange_type);
1971: dbms_sql.column_value (sel_receipts, 11, p_cr_amount);
1972: dbms_sql.column_value (sel_receipts, 12, p_cr_acctd_amount);
1973: dbms_sql.column_value (sel_receipts, 13, p_cr_factor_discount_amount);

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

1966: dbms_sql.column_value (sel_receipts, 6, p_customer_site_use_id);
1967: dbms_sql.column_value (sel_receipts, 7, p_prv_cash_receipt_hist_id);
1968: dbms_sql.column_value (sel_receipts, 8, p_exchange_date);
1969: dbms_sql.column_value (sel_receipts, 9, p_exchange_rate);
1970: dbms_sql.column_value (sel_receipts, 10, p_exchange_type);
1971: dbms_sql.column_value (sel_receipts, 11, p_cr_amount);
1972: dbms_sql.column_value (sel_receipts, 12, p_cr_acctd_amount);
1973: dbms_sql.column_value (sel_receipts, 13, p_cr_factor_discount_amount);
1974: dbms_sql.column_value (sel_receipts, 14, p_remmitance_ccid );

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

1967: dbms_sql.column_value (sel_receipts, 7, p_prv_cash_receipt_hist_id);
1968: dbms_sql.column_value (sel_receipts, 8, p_exchange_date);
1969: dbms_sql.column_value (sel_receipts, 9, p_exchange_rate);
1970: dbms_sql.column_value (sel_receipts, 10, p_exchange_type);
1971: dbms_sql.column_value (sel_receipts, 11, p_cr_amount);
1972: dbms_sql.column_value (sel_receipts, 12, p_cr_acctd_amount);
1973: dbms_sql.column_value (sel_receipts, 13, p_cr_factor_discount_amount);
1974: dbms_sql.column_value (sel_receipts, 14, p_remmitance_ccid );
1975: dbms_sql.column_value (sel_receipts, 15, p_bank_charges_ccid);

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

1968: dbms_sql.column_value (sel_receipts, 8, p_exchange_date);
1969: dbms_sql.column_value (sel_receipts, 9, p_exchange_rate);
1970: dbms_sql.column_value (sel_receipts, 10, p_exchange_type);
1971: dbms_sql.column_value (sel_receipts, 11, p_cr_amount);
1972: dbms_sql.column_value (sel_receipts, 12, p_cr_acctd_amount);
1973: dbms_sql.column_value (sel_receipts, 13, p_cr_factor_discount_amount);
1974: dbms_sql.column_value (sel_receipts, 14, p_remmitance_ccid );
1975: dbms_sql.column_value (sel_receipts, 15, p_bank_charges_ccid);
1976: dbms_sql.column_value (sel_receipts, 16, p_code_combination_id);

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

1969: dbms_sql.column_value (sel_receipts, 9, p_exchange_rate);
1970: dbms_sql.column_value (sel_receipts, 10, p_exchange_type);
1971: dbms_sql.column_value (sel_receipts, 11, p_cr_amount);
1972: dbms_sql.column_value (sel_receipts, 12, p_cr_acctd_amount);
1973: dbms_sql.column_value (sel_receipts, 13, p_cr_factor_discount_amount);
1974: dbms_sql.column_value (sel_receipts, 14, p_remmitance_ccid );
1975: dbms_sql.column_value (sel_receipts, 15, p_bank_charges_ccid);
1976: dbms_sql.column_value (sel_receipts, 16, p_code_combination_id);
1977: dbms_sql.column_value (sel_receipts, 17, p_cash_receipt_history_id);

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

1970: dbms_sql.column_value (sel_receipts, 10, p_exchange_type);
1971: dbms_sql.column_value (sel_receipts, 11, p_cr_amount);
1972: dbms_sql.column_value (sel_receipts, 12, p_cr_acctd_amount);
1973: dbms_sql.column_value (sel_receipts, 13, p_cr_factor_discount_amount);
1974: dbms_sql.column_value (sel_receipts, 14, p_remmitance_ccid );
1975: dbms_sql.column_value (sel_receipts, 15, p_bank_charges_ccid);
1976: dbms_sql.column_value (sel_receipts, 16, p_code_combination_id);
1977: dbms_sql.column_value (sel_receipts, 17, p_cash_receipt_history_id);
1978: dbms_sql.column_value (sel_receipts, 18, p_crh_gl_date);

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

1971: dbms_sql.column_value (sel_receipts, 11, p_cr_amount);
1972: dbms_sql.column_value (sel_receipts, 12, p_cr_acctd_amount);
1973: dbms_sql.column_value (sel_receipts, 13, p_cr_factor_discount_amount);
1974: dbms_sql.column_value (sel_receipts, 14, p_remmitance_ccid );
1975: dbms_sql.column_value (sel_receipts, 15, p_bank_charges_ccid);
1976: dbms_sql.column_value (sel_receipts, 16, p_code_combination_id);
1977: dbms_sql.column_value (sel_receipts, 17, p_cash_receipt_history_id);
1978: dbms_sql.column_value (sel_receipts, 18, p_crh_gl_date);
1979: dbms_sql.column_value (sel_receipts, 19, p_crh_trx_date);

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

1972: dbms_sql.column_value (sel_receipts, 12, p_cr_acctd_amount);
1973: dbms_sql.column_value (sel_receipts, 13, p_cr_factor_discount_amount);
1974: dbms_sql.column_value (sel_receipts, 14, p_remmitance_ccid );
1975: dbms_sql.column_value (sel_receipts, 15, p_bank_charges_ccid);
1976: dbms_sql.column_value (sel_receipts, 16, p_code_combination_id);
1977: dbms_sql.column_value (sel_receipts, 17, p_cash_receipt_history_id);
1978: dbms_sql.column_value (sel_receipts, 18, p_crh_gl_date);
1979: dbms_sql.column_value (sel_receipts, 19, p_crh_trx_date);
1980: dbms_sql.column_value (sel_receipts, 20, p_payment_server_order_num);

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

1973: dbms_sql.column_value (sel_receipts, 13, p_cr_factor_discount_amount);
1974: dbms_sql.column_value (sel_receipts, 14, p_remmitance_ccid );
1975: dbms_sql.column_value (sel_receipts, 15, p_bank_charges_ccid);
1976: dbms_sql.column_value (sel_receipts, 16, p_code_combination_id);
1977: dbms_sql.column_value (sel_receipts, 17, p_cash_receipt_history_id);
1978: dbms_sql.column_value (sel_receipts, 18, p_crh_gl_date);
1979: dbms_sql.column_value (sel_receipts, 19, p_crh_trx_date);
1980: dbms_sql.column_value (sel_receipts, 20, p_payment_server_order_num);
1981: dbms_sql.column_value (sel_receipts, 21, p_approval_code);

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

1974: dbms_sql.column_value (sel_receipts, 14, p_remmitance_ccid );
1975: dbms_sql.column_value (sel_receipts, 15, p_bank_charges_ccid);
1976: dbms_sql.column_value (sel_receipts, 16, p_code_combination_id);
1977: dbms_sql.column_value (sel_receipts, 17, p_cash_receipt_history_id);
1978: dbms_sql.column_value (sel_receipts, 18, p_crh_gl_date);
1979: dbms_sql.column_value (sel_receipts, 19, p_crh_trx_date);
1980: dbms_sql.column_value (sel_receipts, 20, p_payment_server_order_num);
1981: dbms_sql.column_value (sel_receipts, 21, p_approval_code);
1982: dbms_sql.column_value (sel_receipts, 22, p_receipt_number);

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

1975: dbms_sql.column_value (sel_receipts, 15, p_bank_charges_ccid);
1976: dbms_sql.column_value (sel_receipts, 16, p_code_combination_id);
1977: dbms_sql.column_value (sel_receipts, 17, p_cash_receipt_history_id);
1978: dbms_sql.column_value (sel_receipts, 18, p_crh_gl_date);
1979: dbms_sql.column_value (sel_receipts, 19, p_crh_trx_date);
1980: dbms_sql.column_value (sel_receipts, 20, p_payment_server_order_num);
1981: dbms_sql.column_value (sel_receipts, 21, p_approval_code);
1982: dbms_sql.column_value (sel_receipts, 22, p_receipt_number);
1983: dbms_sql.column_value (sel_receipts, 23, p_unique_ref);

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

1976: dbms_sql.column_value (sel_receipts, 16, p_code_combination_id);
1977: dbms_sql.column_value (sel_receipts, 17, p_cash_receipt_history_id);
1978: dbms_sql.column_value (sel_receipts, 18, p_crh_gl_date);
1979: dbms_sql.column_value (sel_receipts, 19, p_crh_trx_date);
1980: dbms_sql.column_value (sel_receipts, 20, p_payment_server_order_num);
1981: dbms_sql.column_value (sel_receipts, 21, p_approval_code);
1982: dbms_sql.column_value (sel_receipts, 22, p_receipt_number);
1983: dbms_sql.column_value (sel_receipts, 23, p_unique_ref);
1984: dbms_sql.column_value (sel_receipts, 24, p_customer_bank_account_id);

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

1977: dbms_sql.column_value (sel_receipts, 17, p_cash_receipt_history_id);
1978: dbms_sql.column_value (sel_receipts, 18, p_crh_gl_date);
1979: dbms_sql.column_value (sel_receipts, 19, p_crh_trx_date);
1980: dbms_sql.column_value (sel_receipts, 20, p_payment_server_order_num);
1981: dbms_sql.column_value (sel_receipts, 21, p_approval_code);
1982: dbms_sql.column_value (sel_receipts, 22, p_receipt_number);
1983: dbms_sql.column_value (sel_receipts, 23, p_unique_ref);
1984: dbms_sql.column_value (sel_receipts, 24, p_customer_bank_account_id);
1985: dbms_sql.column_value (sel_receipts, 25, p_payment_trxn_extension_id);

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

1978: dbms_sql.column_value (sel_receipts, 18, p_crh_gl_date);
1979: dbms_sql.column_value (sel_receipts, 19, p_crh_trx_date);
1980: dbms_sql.column_value (sel_receipts, 20, p_payment_server_order_num);
1981: dbms_sql.column_value (sel_receipts, 21, p_approval_code);
1982: dbms_sql.column_value (sel_receipts, 22, p_receipt_number);
1983: dbms_sql.column_value (sel_receipts, 23, p_unique_ref);
1984: dbms_sql.column_value (sel_receipts, 24, p_customer_bank_account_id);
1985: dbms_sql.column_value (sel_receipts, 25, p_payment_trxn_extension_id);
1986:

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

1979: dbms_sql.column_value (sel_receipts, 19, p_crh_trx_date);
1980: dbms_sql.column_value (sel_receipts, 20, p_payment_server_order_num);
1981: dbms_sql.column_value (sel_receipts, 21, p_approval_code);
1982: dbms_sql.column_value (sel_receipts, 22, p_receipt_number);
1983: dbms_sql.column_value (sel_receipts, 23, p_unique_ref);
1984: dbms_sql.column_value (sel_receipts, 24, p_customer_bank_account_id);
1985: dbms_sql.column_value (sel_receipts, 25, p_payment_trxn_extension_id);
1986:
1987:

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

1980: dbms_sql.column_value (sel_receipts, 20, p_payment_server_order_num);
1981: dbms_sql.column_value (sel_receipts, 21, p_approval_code);
1982: dbms_sql.column_value (sel_receipts, 22, p_receipt_number);
1983: dbms_sql.column_value (sel_receipts, 23, p_unique_ref);
1984: dbms_sql.column_value (sel_receipts, 24, p_customer_bank_account_id);
1985: dbms_sql.column_value (sel_receipts, 25, p_payment_trxn_extension_id);
1986:
1987:
1988:

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

1981: dbms_sql.column_value (sel_receipts, 21, p_approval_code);
1982: dbms_sql.column_value (sel_receipts, 22, p_receipt_number);
1983: dbms_sql.column_value (sel_receipts, 23, p_unique_ref);
1984: dbms_sql.column_value (sel_receipts, 24, p_customer_bank_account_id);
1985: dbms_sql.column_value (sel_receipts, 25, p_payment_trxn_extension_id);
1986:
1987:
1988:
1989: IF PG_DEBUG in ( 'Y','C') THEN

Line 2029: l_rows_fetched := dbms_sql.last_row_count ;

2025: END IF;
2026:
2027: END LOOP;
2028:
2029: l_rows_fetched := dbms_sql.last_row_count ;
2030:
2031: IF PG_DEBUG in ('Y', 'C') THEN
2032: fnd_file.put_line(FND_FILE.LOG,'the no of rows fetched ' || l_rows_fetched);
2033: END IF;

Line 2035: dbms_sql.close_cursor( sel_receipts);

2031: IF PG_DEBUG in ('Y', 'C') THEN
2032: fnd_file.put_line(FND_FILE.LOG,'the no of rows fetched ' || l_rows_fetched);
2033: END IF;
2034:
2035: dbms_sql.close_cursor( sel_receipts);
2036:
2037: IF PG_DEBUG in ('Y', 'C') THEN
2038: fnd_file.put_line(FND_FILE.LOG,'selrem and create and upd 1()-');
2039: END IF;

Line 2052: rem_t := dbms_sql.open_cursor;

2048: :c6_array,:c7_array,:c8_array,:c9_array,:c10_array,:c11_array,:c12_array,
2049: :c13_array,:c14_array,:c15_array,:c16_array,:c17_array,:c18_array,
2050: :c19_array,:c20_array,:c21_array,:c22_array,:c23_array,:c24_array,:c25_array)';
2051:
2052: rem_t := dbms_sql.open_cursor;
2053:
2054: dbms_sql.parse (rem_t,inst_stmt,dbms_sql.v7);
2055:
2056: dbms_sql.bind_array (rem_t,':c1_array',cash_receipt_id_array);

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

2050: :c19_array,:c20_array,:c21_array,:c22_array,:c23_array,:c24_array,:c25_array)';
2051:
2052: rem_t := dbms_sql.open_cursor;
2053:
2054: dbms_sql.parse (rem_t,inst_stmt,dbms_sql.v7);
2055:
2056: dbms_sql.bind_array (rem_t,':c1_array',cash_receipt_id_array);
2057: dbms_sql.bind_array (rem_t,':c2_array',payment_type_CODE_array);
2058: dbms_sql.bind_array (rem_t,':c3_array',merchant_ref_array);

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

2052: rem_t := dbms_sql.open_cursor;
2053:
2054: dbms_sql.parse (rem_t,inst_stmt,dbms_sql.v7);
2055:
2056: dbms_sql.bind_array (rem_t,':c1_array',cash_receipt_id_array);
2057: dbms_sql.bind_array (rem_t,':c2_array',payment_type_CODE_array);
2058: dbms_sql.bind_array (rem_t,':c3_array',merchant_ref_array);
2059: dbms_sql.bind_array (rem_t,':c4_array',currency_code_array);
2060: dbms_sql.bind_array (rem_t,':c5_array',pay_from_customer_array);

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

2053:
2054: dbms_sql.parse (rem_t,inst_stmt,dbms_sql.v7);
2055:
2056: dbms_sql.bind_array (rem_t,':c1_array',cash_receipt_id_array);
2057: dbms_sql.bind_array (rem_t,':c2_array',payment_type_CODE_array);
2058: dbms_sql.bind_array (rem_t,':c3_array',merchant_ref_array);
2059: dbms_sql.bind_array (rem_t,':c4_array',currency_code_array);
2060: dbms_sql.bind_array (rem_t,':c5_array',pay_from_customer_array);
2061: dbms_sql.bind_array (rem_t,':c6_array',customer_site_use_id_array);

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

2054: dbms_sql.parse (rem_t,inst_stmt,dbms_sql.v7);
2055:
2056: dbms_sql.bind_array (rem_t,':c1_array',cash_receipt_id_array);
2057: dbms_sql.bind_array (rem_t,':c2_array',payment_type_CODE_array);
2058: dbms_sql.bind_array (rem_t,':c3_array',merchant_ref_array);
2059: dbms_sql.bind_array (rem_t,':c4_array',currency_code_array);
2060: dbms_sql.bind_array (rem_t,':c5_array',pay_from_customer_array);
2061: dbms_sql.bind_array (rem_t,':c6_array',customer_site_use_id_array);
2062: dbms_sql.bind_array (rem_t,':c7_array',prv_cash_receipt_hist_id_array);

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

2055:
2056: dbms_sql.bind_array (rem_t,':c1_array',cash_receipt_id_array);
2057: dbms_sql.bind_array (rem_t,':c2_array',payment_type_CODE_array);
2058: dbms_sql.bind_array (rem_t,':c3_array',merchant_ref_array);
2059: dbms_sql.bind_array (rem_t,':c4_array',currency_code_array);
2060: dbms_sql.bind_array (rem_t,':c5_array',pay_from_customer_array);
2061: dbms_sql.bind_array (rem_t,':c6_array',customer_site_use_id_array);
2062: dbms_sql.bind_array (rem_t,':c7_array',prv_cash_receipt_hist_id_array);
2063: dbms_sql.bind_array (rem_t,':c8_array',exchange_date_array);

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

2056: dbms_sql.bind_array (rem_t,':c1_array',cash_receipt_id_array);
2057: dbms_sql.bind_array (rem_t,':c2_array',payment_type_CODE_array);
2058: dbms_sql.bind_array (rem_t,':c3_array',merchant_ref_array);
2059: dbms_sql.bind_array (rem_t,':c4_array',currency_code_array);
2060: dbms_sql.bind_array (rem_t,':c5_array',pay_from_customer_array);
2061: dbms_sql.bind_array (rem_t,':c6_array',customer_site_use_id_array);
2062: dbms_sql.bind_array (rem_t,':c7_array',prv_cash_receipt_hist_id_array);
2063: dbms_sql.bind_array (rem_t,':c8_array',exchange_date_array);
2064: dbms_sql.bind_array (rem_t,':c9_array',exchange_rate_array);

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

2057: dbms_sql.bind_array (rem_t,':c2_array',payment_type_CODE_array);
2058: dbms_sql.bind_array (rem_t,':c3_array',merchant_ref_array);
2059: dbms_sql.bind_array (rem_t,':c4_array',currency_code_array);
2060: dbms_sql.bind_array (rem_t,':c5_array',pay_from_customer_array);
2061: dbms_sql.bind_array (rem_t,':c6_array',customer_site_use_id_array);
2062: dbms_sql.bind_array (rem_t,':c7_array',prv_cash_receipt_hist_id_array);
2063: dbms_sql.bind_array (rem_t,':c8_array',exchange_date_array);
2064: dbms_sql.bind_array (rem_t,':c9_array',exchange_rate_array);
2065: dbms_sql.bind_array (rem_t,':c10_array',exchange_type_array);

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

2058: dbms_sql.bind_array (rem_t,':c3_array',merchant_ref_array);
2059: dbms_sql.bind_array (rem_t,':c4_array',currency_code_array);
2060: dbms_sql.bind_array (rem_t,':c5_array',pay_from_customer_array);
2061: dbms_sql.bind_array (rem_t,':c6_array',customer_site_use_id_array);
2062: dbms_sql.bind_array (rem_t,':c7_array',prv_cash_receipt_hist_id_array);
2063: dbms_sql.bind_array (rem_t,':c8_array',exchange_date_array);
2064: dbms_sql.bind_array (rem_t,':c9_array',exchange_rate_array);
2065: dbms_sql.bind_array (rem_t,':c10_array',exchange_type_array);
2066: dbms_sql.bind_array (rem_t,':c11_array',cr_amount_array);

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

2059: dbms_sql.bind_array (rem_t,':c4_array',currency_code_array);
2060: dbms_sql.bind_array (rem_t,':c5_array',pay_from_customer_array);
2061: dbms_sql.bind_array (rem_t,':c6_array',customer_site_use_id_array);
2062: dbms_sql.bind_array (rem_t,':c7_array',prv_cash_receipt_hist_id_array);
2063: dbms_sql.bind_array (rem_t,':c8_array',exchange_date_array);
2064: dbms_sql.bind_array (rem_t,':c9_array',exchange_rate_array);
2065: dbms_sql.bind_array (rem_t,':c10_array',exchange_type_array);
2066: dbms_sql.bind_array (rem_t,':c11_array',cr_amount_array);
2067: dbms_sql.bind_array (rem_t,':c12_array',cr_acctd_amount_array);

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

2060: dbms_sql.bind_array (rem_t,':c5_array',pay_from_customer_array);
2061: dbms_sql.bind_array (rem_t,':c6_array',customer_site_use_id_array);
2062: dbms_sql.bind_array (rem_t,':c7_array',prv_cash_receipt_hist_id_array);
2063: dbms_sql.bind_array (rem_t,':c8_array',exchange_date_array);
2064: dbms_sql.bind_array (rem_t,':c9_array',exchange_rate_array);
2065: dbms_sql.bind_array (rem_t,':c10_array',exchange_type_array);
2066: dbms_sql.bind_array (rem_t,':c11_array',cr_amount_array);
2067: dbms_sql.bind_array (rem_t,':c12_array',cr_acctd_amount_array);
2068: dbms_sql.bind_array (rem_t,':c13_array',cr_factor_discount_amt_array);

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

2061: dbms_sql.bind_array (rem_t,':c6_array',customer_site_use_id_array);
2062: dbms_sql.bind_array (rem_t,':c7_array',prv_cash_receipt_hist_id_array);
2063: dbms_sql.bind_array (rem_t,':c8_array',exchange_date_array);
2064: dbms_sql.bind_array (rem_t,':c9_array',exchange_rate_array);
2065: dbms_sql.bind_array (rem_t,':c10_array',exchange_type_array);
2066: dbms_sql.bind_array (rem_t,':c11_array',cr_amount_array);
2067: dbms_sql.bind_array (rem_t,':c12_array',cr_acctd_amount_array);
2068: dbms_sql.bind_array (rem_t,':c13_array',cr_factor_discount_amt_array);
2069: dbms_sql.bind_array (rem_t,':c14_array',remmitance_ccid_array);

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

2062: dbms_sql.bind_array (rem_t,':c7_array',prv_cash_receipt_hist_id_array);
2063: dbms_sql.bind_array (rem_t,':c8_array',exchange_date_array);
2064: dbms_sql.bind_array (rem_t,':c9_array',exchange_rate_array);
2065: dbms_sql.bind_array (rem_t,':c10_array',exchange_type_array);
2066: dbms_sql.bind_array (rem_t,':c11_array',cr_amount_array);
2067: dbms_sql.bind_array (rem_t,':c12_array',cr_acctd_amount_array);
2068: dbms_sql.bind_array (rem_t,':c13_array',cr_factor_discount_amt_array);
2069: dbms_sql.bind_array (rem_t,':c14_array',remmitance_ccid_array);
2070: dbms_sql.bind_array (rem_t,':c15_array',bank_charges_ccid_array);

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

2063: dbms_sql.bind_array (rem_t,':c8_array',exchange_date_array);
2064: dbms_sql.bind_array (rem_t,':c9_array',exchange_rate_array);
2065: dbms_sql.bind_array (rem_t,':c10_array',exchange_type_array);
2066: dbms_sql.bind_array (rem_t,':c11_array',cr_amount_array);
2067: dbms_sql.bind_array (rem_t,':c12_array',cr_acctd_amount_array);
2068: dbms_sql.bind_array (rem_t,':c13_array',cr_factor_discount_amt_array);
2069: dbms_sql.bind_array (rem_t,':c14_array',remmitance_ccid_array);
2070: dbms_sql.bind_array (rem_t,':c15_array',bank_charges_ccid_array);
2071: dbms_sql.bind_array (rem_t,':c16_array',code_combination_id_array);

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

2064: dbms_sql.bind_array (rem_t,':c9_array',exchange_rate_array);
2065: dbms_sql.bind_array (rem_t,':c10_array',exchange_type_array);
2066: dbms_sql.bind_array (rem_t,':c11_array',cr_amount_array);
2067: dbms_sql.bind_array (rem_t,':c12_array',cr_acctd_amount_array);
2068: dbms_sql.bind_array (rem_t,':c13_array',cr_factor_discount_amt_array);
2069: dbms_sql.bind_array (rem_t,':c14_array',remmitance_ccid_array);
2070: dbms_sql.bind_array (rem_t,':c15_array',bank_charges_ccid_array);
2071: dbms_sql.bind_array (rem_t,':c16_array',code_combination_id_array);
2072: dbms_sql.bind_array (rem_t,':c17_array',cash_receipt_history_id_array);

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

2065: dbms_sql.bind_array (rem_t,':c10_array',exchange_type_array);
2066: dbms_sql.bind_array (rem_t,':c11_array',cr_amount_array);
2067: dbms_sql.bind_array (rem_t,':c12_array',cr_acctd_amount_array);
2068: dbms_sql.bind_array (rem_t,':c13_array',cr_factor_discount_amt_array);
2069: dbms_sql.bind_array (rem_t,':c14_array',remmitance_ccid_array);
2070: dbms_sql.bind_array (rem_t,':c15_array',bank_charges_ccid_array);
2071: dbms_sql.bind_array (rem_t,':c16_array',code_combination_id_array);
2072: dbms_sql.bind_array (rem_t,':c17_array',cash_receipt_history_id_array);
2073: dbms_sql.bind_array (rem_t,':c18_array',crh_gl_date_array);

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

2066: dbms_sql.bind_array (rem_t,':c11_array',cr_amount_array);
2067: dbms_sql.bind_array (rem_t,':c12_array',cr_acctd_amount_array);
2068: dbms_sql.bind_array (rem_t,':c13_array',cr_factor_discount_amt_array);
2069: dbms_sql.bind_array (rem_t,':c14_array',remmitance_ccid_array);
2070: dbms_sql.bind_array (rem_t,':c15_array',bank_charges_ccid_array);
2071: dbms_sql.bind_array (rem_t,':c16_array',code_combination_id_array);
2072: dbms_sql.bind_array (rem_t,':c17_array',cash_receipt_history_id_array);
2073: dbms_sql.bind_array (rem_t,':c18_array',crh_gl_date_array);
2074: dbms_sql.bind_array (rem_t,':c19_array',crh_trx_date_array);

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

2067: dbms_sql.bind_array (rem_t,':c12_array',cr_acctd_amount_array);
2068: dbms_sql.bind_array (rem_t,':c13_array',cr_factor_discount_amt_array);
2069: dbms_sql.bind_array (rem_t,':c14_array',remmitance_ccid_array);
2070: dbms_sql.bind_array (rem_t,':c15_array',bank_charges_ccid_array);
2071: dbms_sql.bind_array (rem_t,':c16_array',code_combination_id_array);
2072: dbms_sql.bind_array (rem_t,':c17_array',cash_receipt_history_id_array);
2073: dbms_sql.bind_array (rem_t,':c18_array',crh_gl_date_array);
2074: dbms_sql.bind_array (rem_t,':c19_array',crh_trx_date_array);
2075: dbms_sql.bind_array (rem_t,':c20_array',payment_server_order_num_array);

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

2068: dbms_sql.bind_array (rem_t,':c13_array',cr_factor_discount_amt_array);
2069: dbms_sql.bind_array (rem_t,':c14_array',remmitance_ccid_array);
2070: dbms_sql.bind_array (rem_t,':c15_array',bank_charges_ccid_array);
2071: dbms_sql.bind_array (rem_t,':c16_array',code_combination_id_array);
2072: dbms_sql.bind_array (rem_t,':c17_array',cash_receipt_history_id_array);
2073: dbms_sql.bind_array (rem_t,':c18_array',crh_gl_date_array);
2074: dbms_sql.bind_array (rem_t,':c19_array',crh_trx_date_array);
2075: dbms_sql.bind_array (rem_t,':c20_array',payment_server_order_num_array);
2076: dbms_sql.bind_array (rem_t,':c21_array',approval_code_array);

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

2069: dbms_sql.bind_array (rem_t,':c14_array',remmitance_ccid_array);
2070: dbms_sql.bind_array (rem_t,':c15_array',bank_charges_ccid_array);
2071: dbms_sql.bind_array (rem_t,':c16_array',code_combination_id_array);
2072: dbms_sql.bind_array (rem_t,':c17_array',cash_receipt_history_id_array);
2073: dbms_sql.bind_array (rem_t,':c18_array',crh_gl_date_array);
2074: dbms_sql.bind_array (rem_t,':c19_array',crh_trx_date_array);
2075: dbms_sql.bind_array (rem_t,':c20_array',payment_server_order_num_array);
2076: dbms_sql.bind_array (rem_t,':c21_array',approval_code_array);
2077: dbms_sql.bind_array (rem_t,':c22_array',receipt_number_array);

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

2070: dbms_sql.bind_array (rem_t,':c15_array',bank_charges_ccid_array);
2071: dbms_sql.bind_array (rem_t,':c16_array',code_combination_id_array);
2072: dbms_sql.bind_array (rem_t,':c17_array',cash_receipt_history_id_array);
2073: dbms_sql.bind_array (rem_t,':c18_array',crh_gl_date_array);
2074: dbms_sql.bind_array (rem_t,':c19_array',crh_trx_date_array);
2075: dbms_sql.bind_array (rem_t,':c20_array',payment_server_order_num_array);
2076: dbms_sql.bind_array (rem_t,':c21_array',approval_code_array);
2077: dbms_sql.bind_array (rem_t,':c22_array',receipt_number_array);
2078: dbms_sql.bind_array (rem_t,':c23_array',unique_ref_array);

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

2071: dbms_sql.bind_array (rem_t,':c16_array',code_combination_id_array);
2072: dbms_sql.bind_array (rem_t,':c17_array',cash_receipt_history_id_array);
2073: dbms_sql.bind_array (rem_t,':c18_array',crh_gl_date_array);
2074: dbms_sql.bind_array (rem_t,':c19_array',crh_trx_date_array);
2075: dbms_sql.bind_array (rem_t,':c20_array',payment_server_order_num_array);
2076: dbms_sql.bind_array (rem_t,':c21_array',approval_code_array);
2077: dbms_sql.bind_array (rem_t,':c22_array',receipt_number_array);
2078: dbms_sql.bind_array (rem_t,':c23_array',unique_ref_array);
2079: dbms_sql.bind_array (rem_t,':c24_array',customer_bank_account_id_array);

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

2072: dbms_sql.bind_array (rem_t,':c17_array',cash_receipt_history_id_array);
2073: dbms_sql.bind_array (rem_t,':c18_array',crh_gl_date_array);
2074: dbms_sql.bind_array (rem_t,':c19_array',crh_trx_date_array);
2075: dbms_sql.bind_array (rem_t,':c20_array',payment_server_order_num_array);
2076: dbms_sql.bind_array (rem_t,':c21_array',approval_code_array);
2077: dbms_sql.bind_array (rem_t,':c22_array',receipt_number_array);
2078: dbms_sql.bind_array (rem_t,':c23_array',unique_ref_array);
2079: dbms_sql.bind_array (rem_t,':c24_array',customer_bank_account_id_array);
2080: dbms_sql.bind_array (rem_t,':c25_array',payment_trxn_extn_id_array);

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

2073: dbms_sql.bind_array (rem_t,':c18_array',crh_gl_date_array);
2074: dbms_sql.bind_array (rem_t,':c19_array',crh_trx_date_array);
2075: dbms_sql.bind_array (rem_t,':c20_array',payment_server_order_num_array);
2076: dbms_sql.bind_array (rem_t,':c21_array',approval_code_array);
2077: dbms_sql.bind_array (rem_t,':c22_array',receipt_number_array);
2078: dbms_sql.bind_array (rem_t,':c23_array',unique_ref_array);
2079: dbms_sql.bind_array (rem_t,':c24_array',customer_bank_account_id_array);
2080: dbms_sql.bind_array (rem_t,':c25_array',payment_trxn_extn_id_array);
2081:

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

2074: dbms_sql.bind_array (rem_t,':c19_array',crh_trx_date_array);
2075: dbms_sql.bind_array (rem_t,':c20_array',payment_server_order_num_array);
2076: dbms_sql.bind_array (rem_t,':c21_array',approval_code_array);
2077: dbms_sql.bind_array (rem_t,':c22_array',receipt_number_array);
2078: dbms_sql.bind_array (rem_t,':c23_array',unique_ref_array);
2079: dbms_sql.bind_array (rem_t,':c24_array',customer_bank_account_id_array);
2080: dbms_sql.bind_array (rem_t,':c25_array',payment_trxn_extn_id_array);
2081:
2082:

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

2075: dbms_sql.bind_array (rem_t,':c20_array',payment_server_order_num_array);
2076: dbms_sql.bind_array (rem_t,':c21_array',approval_code_array);
2077: dbms_sql.bind_array (rem_t,':c22_array',receipt_number_array);
2078: dbms_sql.bind_array (rem_t,':c23_array',unique_ref_array);
2079: dbms_sql.bind_array (rem_t,':c24_array',customer_bank_account_id_array);
2080: dbms_sql.bind_array (rem_t,':c25_array',payment_trxn_extn_id_array);
2081:
2082:
2083: dummy := dbms_sql.execute(rem_t);

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

2076: dbms_sql.bind_array (rem_t,':c21_array',approval_code_array);
2077: dbms_sql.bind_array (rem_t,':c22_array',receipt_number_array);
2078: dbms_sql.bind_array (rem_t,':c23_array',unique_ref_array);
2079: dbms_sql.bind_array (rem_t,':c24_array',customer_bank_account_id_array);
2080: dbms_sql.bind_array (rem_t,':c25_array',payment_trxn_extn_id_array);
2081:
2082:
2083: dummy := dbms_sql.execute(rem_t);
2084:

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

2079: dbms_sql.bind_array (rem_t,':c24_array',customer_bank_account_id_array);
2080: dbms_sql.bind_array (rem_t,':c25_array',payment_trxn_extn_id_array);
2081:
2082:
2083: dummy := dbms_sql.execute(rem_t);
2084:
2085: dbms_sql.close_cursor(rem_t);
2086:
2087: EXCEPTION WHEN OTHERS THEN

Line 2085: dbms_sql.close_cursor(rem_t);

2081:
2082:
2083: dummy := dbms_sql.execute(rem_t);
2084:
2085: dbms_sql.close_cursor(rem_t);
2086:
2087: EXCEPTION WHEN OTHERS THEN
2088: if dbms_sql.is_open(rem_t) then
2089: dbms_sql.close_cursor(rem_t);

Line 2088: if dbms_sql.is_open(rem_t) then

2084:
2085: dbms_sql.close_cursor(rem_t);
2086:
2087: EXCEPTION WHEN OTHERS THEN
2088: if dbms_sql.is_open(rem_t) then
2089: dbms_sql.close_cursor(rem_t);
2090: end if;
2091: fnd_file.put_line(FND_FILE.LOG,'error code() '|| to_char(SQLCODE));
2092: raise;

Line 2089: dbms_sql.close_cursor(rem_t);

2085: dbms_sql.close_cursor(rem_t);
2086:
2087: EXCEPTION WHEN OTHERS THEN
2088: if dbms_sql.is_open(rem_t) then
2089: dbms_sql.close_cursor(rem_t);
2090: end if;
2091: fnd_file.put_line(FND_FILE.LOG,'error code() '|| to_char(SQLCODE));
2092: raise;
2093:

Line 2126: rem_t1 := dbms_sql.open_cursor;

2122: AND status = ''CONFIRMED''
2123: ';
2124:
2125:
2126: rem_t1 := dbms_sql.open_cursor;
2127:
2128: dbms_sql.parse (rem_t1,upd_stmt1,dbms_sql.v7);
2129:
2130: dbms_sql.bind_array (rem_t1,':ucrh_id_array', cash_receipt_history_id_array);

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

2124:
2125:
2126: rem_t1 := dbms_sql.open_cursor;
2127:
2128: dbms_sql.parse (rem_t1,upd_stmt1,dbms_sql.v7);
2129:
2130: dbms_sql.bind_array (rem_t1,':ucrh_id_array', cash_receipt_history_id_array);
2131: dbms_sql.bind_array (rem_t1,':ucrh_gl_date_array',crh_gl_date_array );
2132: dbms_sql.bind_array (rem_t1,':cr_id_array', cash_receipt_id_array);

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

2126: rem_t1 := dbms_sql.open_cursor;
2127:
2128: dbms_sql.parse (rem_t1,upd_stmt1,dbms_sql.v7);
2129:
2130: dbms_sql.bind_array (rem_t1,':ucrh_id_array', cash_receipt_history_id_array);
2131: dbms_sql.bind_array (rem_t1,':ucrh_gl_date_array',crh_gl_date_array );
2132: dbms_sql.bind_array (rem_t1,':cr_id_array', cash_receipt_id_array);
2133: /* who cols*/
2134:

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

2127:
2128: dbms_sql.parse (rem_t1,upd_stmt1,dbms_sql.v7);
2129:
2130: dbms_sql.bind_array (rem_t1,':ucrh_id_array', cash_receipt_history_id_array);
2131: dbms_sql.bind_array (rem_t1,':ucrh_gl_date_array',crh_gl_date_array );
2132: dbms_sql.bind_array (rem_t1,':cr_id_array', cash_receipt_id_array);
2133: /* who cols*/
2134:
2135: dbms_sql.bind_variable (rem_t1,':i_last_updated_by',l_last_updated_by);

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

2128: dbms_sql.parse (rem_t1,upd_stmt1,dbms_sql.v7);
2129:
2130: dbms_sql.bind_array (rem_t1,':ucrh_id_array', cash_receipt_history_id_array);
2131: dbms_sql.bind_array (rem_t1,':ucrh_gl_date_array',crh_gl_date_array );
2132: dbms_sql.bind_array (rem_t1,':cr_id_array', cash_receipt_id_array);
2133: /* who cols*/
2134:
2135: dbms_sql.bind_variable (rem_t1,':i_last_updated_by',l_last_updated_by);
2136: dbms_sql.bind_variable (rem_t1,':i_last_update_login',l_last_update_login);

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

2131: dbms_sql.bind_array (rem_t1,':ucrh_gl_date_array',crh_gl_date_array );
2132: dbms_sql.bind_array (rem_t1,':cr_id_array', cash_receipt_id_array);
2133: /* who cols*/
2134:
2135: dbms_sql.bind_variable (rem_t1,':i_last_updated_by',l_last_updated_by);
2136: dbms_sql.bind_variable (rem_t1,':i_last_update_login',l_last_update_login);
2137: dbms_sql.bind_variable (rem_t1,':i_request_id',l_request_id);
2138: dbms_sql.bind_variable (rem_t1,':i_program_application_id',l_program_application_id);
2139: dbms_sql.bind_variable (rem_t1,':i_program_id',l_program_id);

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

2132: dbms_sql.bind_array (rem_t1,':cr_id_array', cash_receipt_id_array);
2133: /* who cols*/
2134:
2135: dbms_sql.bind_variable (rem_t1,':i_last_updated_by',l_last_updated_by);
2136: dbms_sql.bind_variable (rem_t1,':i_last_update_login',l_last_update_login);
2137: dbms_sql.bind_variable (rem_t1,':i_request_id',l_request_id);
2138: dbms_sql.bind_variable (rem_t1,':i_program_application_id',l_program_application_id);
2139: dbms_sql.bind_variable (rem_t1,':i_program_id',l_program_id);
2140:

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

2133: /* who cols*/
2134:
2135: dbms_sql.bind_variable (rem_t1,':i_last_updated_by',l_last_updated_by);
2136: dbms_sql.bind_variable (rem_t1,':i_last_update_login',l_last_update_login);
2137: dbms_sql.bind_variable (rem_t1,':i_request_id',l_request_id);
2138: dbms_sql.bind_variable (rem_t1,':i_program_application_id',l_program_application_id);
2139: dbms_sql.bind_variable (rem_t1,':i_program_id',l_program_id);
2140:
2141: dummy := dbms_sql.execute(rem_t1);

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

2134:
2135: dbms_sql.bind_variable (rem_t1,':i_last_updated_by',l_last_updated_by);
2136: dbms_sql.bind_variable (rem_t1,':i_last_update_login',l_last_update_login);
2137: dbms_sql.bind_variable (rem_t1,':i_request_id',l_request_id);
2138: dbms_sql.bind_variable (rem_t1,':i_program_application_id',l_program_application_id);
2139: dbms_sql.bind_variable (rem_t1,':i_program_id',l_program_id);
2140:
2141: dummy := dbms_sql.execute(rem_t1);
2142:

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

2135: dbms_sql.bind_variable (rem_t1,':i_last_updated_by',l_last_updated_by);
2136: dbms_sql.bind_variable (rem_t1,':i_last_update_login',l_last_update_login);
2137: dbms_sql.bind_variable (rem_t1,':i_request_id',l_request_id);
2138: dbms_sql.bind_variable (rem_t1,':i_program_application_id',l_program_application_id);
2139: dbms_sql.bind_variable (rem_t1,':i_program_id',l_program_id);
2140:
2141: dummy := dbms_sql.execute(rem_t1);
2142:
2143: dbms_sql.close_cursor(rem_t1);

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

2137: dbms_sql.bind_variable (rem_t1,':i_request_id',l_request_id);
2138: dbms_sql.bind_variable (rem_t1,':i_program_application_id',l_program_application_id);
2139: dbms_sql.bind_variable (rem_t1,':i_program_id',l_program_id);
2140:
2141: dummy := dbms_sql.execute(rem_t1);
2142:
2143: dbms_sql.close_cursor(rem_t1);
2144:
2145: IF PG_DEBUG in ('Y', 'C') THEN

Line 2143: dbms_sql.close_cursor(rem_t1);

2139: dbms_sql.bind_variable (rem_t1,':i_program_id',l_program_id);
2140:
2141: dummy := dbms_sql.execute(rem_t1);
2142:
2143: dbms_sql.close_cursor(rem_t1);
2144:
2145: IF PG_DEBUG in ('Y', 'C') THEN
2146: arp_standard.debug (to_char(SQL%ROWCOUNT) || ' row(s) updated.');
2147: fnd_file.put_line(FND_FILE.LOG,'upd-crh1 ()-');

Line 2151: if dbms_sql.is_open(rem_t1) then

2147: fnd_file.put_line(FND_FILE.LOG,'upd-crh1 ()-');
2148: END IF;
2149:
2150: EXCEPTION WHEN OTHERS THEN
2151: if dbms_sql.is_open(rem_t1) then
2152: dbms_sql.close_cursor(rem_t1);
2153: end if;
2154: IF PG_DEBUG in ('Y', 'C') THEN
2155: fnd_file.put_line(FND_FILE.LOG,'failed to update() '|| to_char(SQLCODE));

Line 2152: dbms_sql.close_cursor(rem_t1);

2148: END IF;
2149:
2150: EXCEPTION WHEN OTHERS THEN
2151: if dbms_sql.is_open(rem_t1) then
2152: dbms_sql.close_cursor(rem_t1);
2153: end if;
2154: IF PG_DEBUG in ('Y', 'C') THEN
2155: fnd_file.put_line(FND_FILE.LOG,'failed to update() '|| to_char(SQLCODE));
2156: END IF;

Line 2278: rem_t3 := dbms_sql.open_cursor;

2274: sysdate
2275: FROM AR_REMIT_GT r
2276: WHERE r.cash_receipt_history_id is not null';
2277:
2278: rem_t3 := dbms_sql.open_cursor;
2279:
2280: dbms_sql.parse (rem_t3,ins_crh1,dbms_sql.v7);
2281:
2282: IF PG_DEBUG in ('Y', 'C') THEN

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

2276: WHERE r.cash_receipt_history_id is not null';
2277:
2278: rem_t3 := dbms_sql.open_cursor;
2279:
2280: dbms_sql.parse (rem_t3,ins_crh1,dbms_sql.v7);
2281:
2282: IF PG_DEBUG in ('Y', 'C') THEN
2283: fnd_file.put_line(FND_FILE.LOG, 'the batch_id ' || p_batch_id);
2284: END IF;

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

2283: fnd_file.put_line(FND_FILE.LOG, 'the batch_id ' || p_batch_id);
2284: END IF;
2285:
2286:
2287: dbms_sql.bind_variable (rem_t3,':i_batch_id',p_batch_id); -- NOTE THIS ONE
2288: dbms_sql.bind_variable (rem_t3,':factor_flag',l_factor_flag); -- NOTE THIS ONE
2289: /* who cols */
2290: dbms_sql.bind_variable (rem_t3,':i_created_by',l_created_by);
2291: dbms_sql.bind_variable (rem_t3,':i_last_updated_by',l_last_updated_by);

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

2284: END IF;
2285:
2286:
2287: dbms_sql.bind_variable (rem_t3,':i_batch_id',p_batch_id); -- NOTE THIS ONE
2288: dbms_sql.bind_variable (rem_t3,':factor_flag',l_factor_flag); -- NOTE THIS ONE
2289: /* who cols */
2290: dbms_sql.bind_variable (rem_t3,':i_created_by',l_created_by);
2291: dbms_sql.bind_variable (rem_t3,':i_last_updated_by',l_last_updated_by);
2292: dbms_sql.bind_variable (rem_t3,':i_last_update_login',l_last_update_login);

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

2286:
2287: dbms_sql.bind_variable (rem_t3,':i_batch_id',p_batch_id); -- NOTE THIS ONE
2288: dbms_sql.bind_variable (rem_t3,':factor_flag',l_factor_flag); -- NOTE THIS ONE
2289: /* who cols */
2290: dbms_sql.bind_variable (rem_t3,':i_created_by',l_created_by);
2291: dbms_sql.bind_variable (rem_t3,':i_last_updated_by',l_last_updated_by);
2292: dbms_sql.bind_variable (rem_t3,':i_last_update_login',l_last_update_login);
2293: dbms_sql.bind_variable (rem_t3,':i_request_id',l_request_id);
2294: dbms_sql.bind_variable (rem_t3,':i_org_id',l_org_id);

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

2287: dbms_sql.bind_variable (rem_t3,':i_batch_id',p_batch_id); -- NOTE THIS ONE
2288: dbms_sql.bind_variable (rem_t3,':factor_flag',l_factor_flag); -- NOTE THIS ONE
2289: /* who cols */
2290: dbms_sql.bind_variable (rem_t3,':i_created_by',l_created_by);
2291: dbms_sql.bind_variable (rem_t3,':i_last_updated_by',l_last_updated_by);
2292: dbms_sql.bind_variable (rem_t3,':i_last_update_login',l_last_update_login);
2293: dbms_sql.bind_variable (rem_t3,':i_request_id',l_request_id);
2294: dbms_sql.bind_variable (rem_t3,':i_org_id',l_org_id);
2295: dbms_sql.bind_variable (rem_t3,':i_program_application_id',l_program_application_id);

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

2288: dbms_sql.bind_variable (rem_t3,':factor_flag',l_factor_flag); -- NOTE THIS ONE
2289: /* who cols */
2290: dbms_sql.bind_variable (rem_t3,':i_created_by',l_created_by);
2291: dbms_sql.bind_variable (rem_t3,':i_last_updated_by',l_last_updated_by);
2292: dbms_sql.bind_variable (rem_t3,':i_last_update_login',l_last_update_login);
2293: dbms_sql.bind_variable (rem_t3,':i_request_id',l_request_id);
2294: dbms_sql.bind_variable (rem_t3,':i_org_id',l_org_id);
2295: dbms_sql.bind_variable (rem_t3,':i_program_application_id',l_program_application_id);
2296: dbms_sql.bind_variable (rem_t3,':i_program_id',l_program_id);

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

2289: /* who cols */
2290: dbms_sql.bind_variable (rem_t3,':i_created_by',l_created_by);
2291: dbms_sql.bind_variable (rem_t3,':i_last_updated_by',l_last_updated_by);
2292: dbms_sql.bind_variable (rem_t3,':i_last_update_login',l_last_update_login);
2293: dbms_sql.bind_variable (rem_t3,':i_request_id',l_request_id);
2294: dbms_sql.bind_variable (rem_t3,':i_org_id',l_org_id);
2295: dbms_sql.bind_variable (rem_t3,':i_program_application_id',l_program_application_id);
2296: dbms_sql.bind_variable (rem_t3,':i_program_id',l_program_id);
2297:

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

2290: dbms_sql.bind_variable (rem_t3,':i_created_by',l_created_by);
2291: dbms_sql.bind_variable (rem_t3,':i_last_updated_by',l_last_updated_by);
2292: dbms_sql.bind_variable (rem_t3,':i_last_update_login',l_last_update_login);
2293: dbms_sql.bind_variable (rem_t3,':i_request_id',l_request_id);
2294: dbms_sql.bind_variable (rem_t3,':i_org_id',l_org_id);
2295: dbms_sql.bind_variable (rem_t3,':i_program_application_id',l_program_application_id);
2296: dbms_sql.bind_variable (rem_t3,':i_program_id',l_program_id);
2297:
2298:

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

2291: dbms_sql.bind_variable (rem_t3,':i_last_updated_by',l_last_updated_by);
2292: dbms_sql.bind_variable (rem_t3,':i_last_update_login',l_last_update_login);
2293: dbms_sql.bind_variable (rem_t3,':i_request_id',l_request_id);
2294: dbms_sql.bind_variable (rem_t3,':i_org_id',l_org_id);
2295: dbms_sql.bind_variable (rem_t3,':i_program_application_id',l_program_application_id);
2296: dbms_sql.bind_variable (rem_t3,':i_program_id',l_program_id);
2297:
2298:
2299: IF PG_DEBUG in ('Y', 'C') THEN

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

2292: dbms_sql.bind_variable (rem_t3,':i_last_update_login',l_last_update_login);
2293: dbms_sql.bind_variable (rem_t3,':i_request_id',l_request_id);
2294: dbms_sql.bind_variable (rem_t3,':i_org_id',l_org_id);
2295: dbms_sql.bind_variable (rem_t3,':i_program_application_id',l_program_application_id);
2296: dbms_sql.bind_variable (rem_t3,':i_program_id',l_program_id);
2297:
2298:
2299: IF PG_DEBUG in ('Y', 'C') THEN
2300: fnd_file.put_line(FND_FILE.LOG, 'the insert statemnt' || ins_crh1);

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

2299: IF PG_DEBUG in ('Y', 'C') THEN
2300: fnd_file.put_line(FND_FILE.LOG, 'the insert statemnt' || ins_crh1);
2301: END IF;
2302:
2303: dummy := dbms_sql.execute(rem_t3);
2304:
2305: dbms_sql.close_cursor(rem_t3);
2306:
2307:

Line 2305: dbms_sql.close_cursor(rem_t3);

2301: END IF;
2302:
2303: dummy := dbms_sql.execute(rem_t3);
2304:
2305: dbms_sql.close_cursor(rem_t3);
2306:
2307:
2308: /* BICHATTE after the insert into crh we have to fire the XLA event */
2309:

Line 2341: if dbms_sql.is_open(rem_t3) then

2337:
2338:
2339: EXCEPTION WHEN OTHERS THEN
2340: fnd_file.put_line(FND_FILE.LOG, 'the insert statemnt' || ins_crh1);
2341: if dbms_sql.is_open(rem_t3) then
2342: dbms_sql.close_cursor(rem_t3);
2343: end if;
2344: IF PG_DEBUG in ('Y', 'C') THEN
2345: fnd_file.put_line(FND_FILE.LOG,'failed to insert() '|| to_char(SQLCODE));

Line 2342: dbms_sql.close_cursor(rem_t3);

2338:
2339: EXCEPTION WHEN OTHERS THEN
2340: fnd_file.put_line(FND_FILE.LOG, 'the insert statemnt' || ins_crh1);
2341: if dbms_sql.is_open(rem_t3) then
2342: dbms_sql.close_cursor(rem_t3);
2343: end if;
2344: IF PG_DEBUG in ('Y', 'C') THEN
2345: fnd_file.put_line(FND_FILE.LOG,'failed to insert() '|| to_char(SQLCODE));
2346: fnd_file.put_line(FND_FILE.LOG, 'the insert statemnt' || ins_crh1);

Line 2448: rem_t4 := dbms_sql.open_cursor;

2444: WHERE crh.cash_receipt_history_id = r.cash_receipt_history_id
2445: AND l.lookup_type = ''AR_CARTESIAN_JOIN''
2446: AND l.lookup_code IN (''1'',''2'')';
2447:
2448: rem_t4 := dbms_sql.open_cursor;
2449:
2450: dbms_sql.parse (rem_t4,ins_dist1,dbms_sql.v7);
2451:
2452: IF PG_DEBUG in ('Y', 'C') THEN

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

2446: AND l.lookup_code IN (''1'',''2'')';
2447:
2448: rem_t4 := dbms_sql.open_cursor;
2449:
2450: dbms_sql.parse (rem_t4,ins_dist1,dbms_sql.v7);
2451:
2452: IF PG_DEBUG in ('Y', 'C') THEN
2453: fnd_file.put_line(FND_FILE.LOG, 'the insert dist statement is ' || ins_dist1);
2454: END IF;

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

2452: IF PG_DEBUG in ('Y', 'C') THEN
2453: fnd_file.put_line(FND_FILE.LOG, 'the insert dist statement is ' || ins_dist1);
2454: END IF;
2455:
2456: dbms_sql.bind_variable (rem_t4,':factor_flag',l_factor_flag); -- NOTE THIS ONE
2457: /* who cols */
2458: dbms_sql.bind_variable (rem_t4,':i_created_by',l_created_by);
2459: dbms_sql.bind_variable (rem_t4,':i_last_updated_by',l_last_updated_by);
2460: dbms_sql.bind_variable (rem_t4,':i_org_id',l_org_id);

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

2454: END IF;
2455:
2456: dbms_sql.bind_variable (rem_t4,':factor_flag',l_factor_flag); -- NOTE THIS ONE
2457: /* who cols */
2458: dbms_sql.bind_variable (rem_t4,':i_created_by',l_created_by);
2459: dbms_sql.bind_variable (rem_t4,':i_last_updated_by',l_last_updated_by);
2460: dbms_sql.bind_variable (rem_t4,':i_org_id',l_org_id);
2461: dbms_sql.bind_variable (rem_t4,':i_last_update_login',l_last_update_login);
2462:

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

2455:
2456: dbms_sql.bind_variable (rem_t4,':factor_flag',l_factor_flag); -- NOTE THIS ONE
2457: /* who cols */
2458: dbms_sql.bind_variable (rem_t4,':i_created_by',l_created_by);
2459: dbms_sql.bind_variable (rem_t4,':i_last_updated_by',l_last_updated_by);
2460: dbms_sql.bind_variable (rem_t4,':i_org_id',l_org_id);
2461: dbms_sql.bind_variable (rem_t4,':i_last_update_login',l_last_update_login);
2462:
2463:

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

2456: dbms_sql.bind_variable (rem_t4,':factor_flag',l_factor_flag); -- NOTE THIS ONE
2457: /* who cols */
2458: dbms_sql.bind_variable (rem_t4,':i_created_by',l_created_by);
2459: dbms_sql.bind_variable (rem_t4,':i_last_updated_by',l_last_updated_by);
2460: dbms_sql.bind_variable (rem_t4,':i_org_id',l_org_id);
2461: dbms_sql.bind_variable (rem_t4,':i_last_update_login',l_last_update_login);
2462:
2463:
2464: d2 := dbms_sql.execute(rem_t4);

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

2457: /* who cols */
2458: dbms_sql.bind_variable (rem_t4,':i_created_by',l_created_by);
2459: dbms_sql.bind_variable (rem_t4,':i_last_updated_by',l_last_updated_by);
2460: dbms_sql.bind_variable (rem_t4,':i_org_id',l_org_id);
2461: dbms_sql.bind_variable (rem_t4,':i_last_update_login',l_last_update_login);
2462:
2463:
2464: d2 := dbms_sql.execute(rem_t4);
2465:

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

2460: dbms_sql.bind_variable (rem_t4,':i_org_id',l_org_id);
2461: dbms_sql.bind_variable (rem_t4,':i_last_update_login',l_last_update_login);
2462:
2463:
2464: d2 := dbms_sql.execute(rem_t4);
2465:
2466: dbms_sql.close_cursor(rem_t4);
2467:
2468: IF PG_DEBUG in ('Y', 'C') THEN

Line 2466: dbms_sql.close_cursor(rem_t4);

2462:
2463:
2464: d2 := dbms_sql.execute(rem_t4);
2465:
2466: dbms_sql.close_cursor(rem_t4);
2467:
2468: IF PG_DEBUG in ('Y', 'C') THEN
2469: fnd_file.put_line(FND_FILE.LOG,'ins_dist1 ()-');
2470: END IF;

Line 2473: if dbms_sql.is_open(rem_t4) then

2469: fnd_file.put_line(FND_FILE.LOG,'ins_dist1 ()-');
2470: END IF;
2471:
2472: EXCEPTION WHEN OTHERS THEN
2473: if dbms_sql.is_open(rem_t4) then
2474: dbms_sql.close_cursor(rem_t4);
2475: end if;
2476: IF PG_DEBUG in ('Y', 'C') THEN
2477: fnd_file.put_line(FND_FILE.LOG, 'the insert dist statement is ' || ins_dist1);

Line 2474: dbms_sql.close_cursor(rem_t4);

2470: END IF;
2471:
2472: EXCEPTION WHEN OTHERS THEN
2473: if dbms_sql.is_open(rem_t4) then
2474: dbms_sql.close_cursor(rem_t4);
2475: end if;
2476: IF PG_DEBUG in ('Y', 'C') THEN
2477: fnd_file.put_line(FND_FILE.LOG, 'the insert dist statement is ' || ins_dist1);
2478: fnd_file.put_line(FND_FILE.LOG,'DIST failed to insert() '|| to_char(SQLCODE));

Line 2562: cash_receipt_id_array dbms_sql.Number_Table;

2558: /* declare the insert array elements */
2559: i NUMBER;
2560: dummy NUMBER;
2561: inst_stmt varchar2(2000);
2562: cash_receipt_id_array dbms_sql.Number_Table;
2563: payment_type_CODE_array dbms_sql.varchar2_Table;
2564: merchant_ref_array dbms_sql.varchar2_Table;
2565: currency_code_array dbms_sql.varchar2_Table;
2566: pay_from_customer_array dbms_sql.varchar2_Table;

Line 2563: payment_type_CODE_array dbms_sql.varchar2_Table;

2559: i NUMBER;
2560: dummy NUMBER;
2561: inst_stmt varchar2(2000);
2562: cash_receipt_id_array dbms_sql.Number_Table;
2563: payment_type_CODE_array dbms_sql.varchar2_Table;
2564: merchant_ref_array dbms_sql.varchar2_Table;
2565: currency_code_array dbms_sql.varchar2_Table;
2566: pay_from_customer_array dbms_sql.varchar2_Table;
2567: customer_site_use_id_array dbms_sql.Number_Table;

Line 2564: merchant_ref_array dbms_sql.varchar2_Table;

2560: dummy NUMBER;
2561: inst_stmt varchar2(2000);
2562: cash_receipt_id_array dbms_sql.Number_Table;
2563: payment_type_CODE_array dbms_sql.varchar2_Table;
2564: merchant_ref_array dbms_sql.varchar2_Table;
2565: currency_code_array dbms_sql.varchar2_Table;
2566: pay_from_customer_array dbms_sql.varchar2_Table;
2567: customer_site_use_id_array dbms_sql.Number_Table;
2568: prv_cash_receipt_hist_id_array dbms_sql.Number_Table;

Line 2565: currency_code_array dbms_sql.varchar2_Table;

2561: inst_stmt varchar2(2000);
2562: cash_receipt_id_array dbms_sql.Number_Table;
2563: payment_type_CODE_array dbms_sql.varchar2_Table;
2564: merchant_ref_array dbms_sql.varchar2_Table;
2565: currency_code_array dbms_sql.varchar2_Table;
2566: pay_from_customer_array dbms_sql.varchar2_Table;
2567: customer_site_use_id_array dbms_sql.Number_Table;
2568: prv_cash_receipt_hist_id_array dbms_sql.Number_Table;
2569: exchange_date_array dbms_sql.date_Table;

Line 2566: pay_from_customer_array dbms_sql.varchar2_Table;

2562: cash_receipt_id_array dbms_sql.Number_Table;
2563: payment_type_CODE_array dbms_sql.varchar2_Table;
2564: merchant_ref_array dbms_sql.varchar2_Table;
2565: currency_code_array dbms_sql.varchar2_Table;
2566: pay_from_customer_array dbms_sql.varchar2_Table;
2567: customer_site_use_id_array dbms_sql.Number_Table;
2568: prv_cash_receipt_hist_id_array dbms_sql.Number_Table;
2569: exchange_date_array dbms_sql.date_Table;
2570: exchange_rate_array dbms_sql.Number_Table;

Line 2567: customer_site_use_id_array dbms_sql.Number_Table;

2563: payment_type_CODE_array dbms_sql.varchar2_Table;
2564: merchant_ref_array dbms_sql.varchar2_Table;
2565: currency_code_array dbms_sql.varchar2_Table;
2566: pay_from_customer_array dbms_sql.varchar2_Table;
2567: customer_site_use_id_array dbms_sql.Number_Table;
2568: prv_cash_receipt_hist_id_array dbms_sql.Number_Table;
2569: exchange_date_array dbms_sql.date_Table;
2570: exchange_rate_array dbms_sql.Number_Table;
2571: exchange_type_array dbms_sql.varchar2_Table;

Line 2568: prv_cash_receipt_hist_id_array dbms_sql.Number_Table;

2564: merchant_ref_array dbms_sql.varchar2_Table;
2565: currency_code_array dbms_sql.varchar2_Table;
2566: pay_from_customer_array dbms_sql.varchar2_Table;
2567: customer_site_use_id_array dbms_sql.Number_Table;
2568: prv_cash_receipt_hist_id_array dbms_sql.Number_Table;
2569: exchange_date_array dbms_sql.date_Table;
2570: exchange_rate_array dbms_sql.Number_Table;
2571: exchange_type_array dbms_sql.varchar2_Table;
2572: cr_amount_array dbms_sql.Number_Table;

Line 2569: exchange_date_array dbms_sql.date_Table;

2565: currency_code_array dbms_sql.varchar2_Table;
2566: pay_from_customer_array dbms_sql.varchar2_Table;
2567: customer_site_use_id_array dbms_sql.Number_Table;
2568: prv_cash_receipt_hist_id_array dbms_sql.Number_Table;
2569: exchange_date_array dbms_sql.date_Table;
2570: exchange_rate_array dbms_sql.Number_Table;
2571: exchange_type_array dbms_sql.varchar2_Table;
2572: cr_amount_array dbms_sql.Number_Table;
2573: cr_acctd_amount_array dbms_sql.Number_Table;

Line 2570: exchange_rate_array dbms_sql.Number_Table;

2566: pay_from_customer_array dbms_sql.varchar2_Table;
2567: customer_site_use_id_array dbms_sql.Number_Table;
2568: prv_cash_receipt_hist_id_array dbms_sql.Number_Table;
2569: exchange_date_array dbms_sql.date_Table;
2570: exchange_rate_array dbms_sql.Number_Table;
2571: exchange_type_array dbms_sql.varchar2_Table;
2572: cr_amount_array dbms_sql.Number_Table;
2573: cr_acctd_amount_array dbms_sql.Number_Table;
2574: cr_factor_discount_amt_array dbms_sql.Number_Table;

Line 2571: exchange_type_array dbms_sql.varchar2_Table;

2567: customer_site_use_id_array dbms_sql.Number_Table;
2568: prv_cash_receipt_hist_id_array dbms_sql.Number_Table;
2569: exchange_date_array dbms_sql.date_Table;
2570: exchange_rate_array dbms_sql.Number_Table;
2571: exchange_type_array dbms_sql.varchar2_Table;
2572: cr_amount_array dbms_sql.Number_Table;
2573: cr_acctd_amount_array dbms_sql.Number_Table;
2574: cr_factor_discount_amt_array dbms_sql.Number_Table;
2575: remmitance_ccid_array dbms_sql.Number_Table;

Line 2572: cr_amount_array dbms_sql.Number_Table;

2568: prv_cash_receipt_hist_id_array dbms_sql.Number_Table;
2569: exchange_date_array dbms_sql.date_Table;
2570: exchange_rate_array dbms_sql.Number_Table;
2571: exchange_type_array dbms_sql.varchar2_Table;
2572: cr_amount_array dbms_sql.Number_Table;
2573: cr_acctd_amount_array dbms_sql.Number_Table;
2574: cr_factor_discount_amt_array dbms_sql.Number_Table;
2575: remmitance_ccid_array dbms_sql.Number_Table;
2576: bank_charges_ccid_array dbms_sql.Number_Table;

Line 2573: cr_acctd_amount_array dbms_sql.Number_Table;

2569: exchange_date_array dbms_sql.date_Table;
2570: exchange_rate_array dbms_sql.Number_Table;
2571: exchange_type_array dbms_sql.varchar2_Table;
2572: cr_amount_array dbms_sql.Number_Table;
2573: cr_acctd_amount_array dbms_sql.Number_Table;
2574: cr_factor_discount_amt_array dbms_sql.Number_Table;
2575: remmitance_ccid_array dbms_sql.Number_Table;
2576: bank_charges_ccid_array dbms_sql.Number_Table;
2577: code_combination_id_array dbms_sql.Number_Table;

Line 2574: cr_factor_discount_amt_array dbms_sql.Number_Table;

2570: exchange_rate_array dbms_sql.Number_Table;
2571: exchange_type_array dbms_sql.varchar2_Table;
2572: cr_amount_array dbms_sql.Number_Table;
2573: cr_acctd_amount_array dbms_sql.Number_Table;
2574: cr_factor_discount_amt_array dbms_sql.Number_Table;
2575: remmitance_ccid_array dbms_sql.Number_Table;
2576: bank_charges_ccid_array dbms_sql.Number_Table;
2577: code_combination_id_array dbms_sql.Number_Table;
2578: cash_receipt_history_id_array dbms_sql.Number_Table;

Line 2575: remmitance_ccid_array dbms_sql.Number_Table;

2571: exchange_type_array dbms_sql.varchar2_Table;
2572: cr_amount_array dbms_sql.Number_Table;
2573: cr_acctd_amount_array dbms_sql.Number_Table;
2574: cr_factor_discount_amt_array dbms_sql.Number_Table;
2575: remmitance_ccid_array dbms_sql.Number_Table;
2576: bank_charges_ccid_array dbms_sql.Number_Table;
2577: code_combination_id_array dbms_sql.Number_Table;
2578: cash_receipt_history_id_array dbms_sql.Number_Table;
2579: crh_gl_date_array dbms_sql.date_Table;

Line 2576: bank_charges_ccid_array dbms_sql.Number_Table;

2572: cr_amount_array dbms_sql.Number_Table;
2573: cr_acctd_amount_array dbms_sql.Number_Table;
2574: cr_factor_discount_amt_array dbms_sql.Number_Table;
2575: remmitance_ccid_array dbms_sql.Number_Table;
2576: bank_charges_ccid_array dbms_sql.Number_Table;
2577: code_combination_id_array dbms_sql.Number_Table;
2578: cash_receipt_history_id_array dbms_sql.Number_Table;
2579: crh_gl_date_array dbms_sql.date_Table;
2580: crh_trx_date_array dbms_sql.date_Table;

Line 2577: code_combination_id_array dbms_sql.Number_Table;

2573: cr_acctd_amount_array dbms_sql.Number_Table;
2574: cr_factor_discount_amt_array dbms_sql.Number_Table;
2575: remmitance_ccid_array dbms_sql.Number_Table;
2576: bank_charges_ccid_array dbms_sql.Number_Table;
2577: code_combination_id_array dbms_sql.Number_Table;
2578: cash_receipt_history_id_array dbms_sql.Number_Table;
2579: crh_gl_date_array dbms_sql.date_Table;
2580: crh_trx_date_array dbms_sql.date_Table;
2581: payment_server_order_num_array dbms_sql.varchar2_Table;

Line 2578: cash_receipt_history_id_array dbms_sql.Number_Table;

2574: cr_factor_discount_amt_array dbms_sql.Number_Table;
2575: remmitance_ccid_array dbms_sql.Number_Table;
2576: bank_charges_ccid_array dbms_sql.Number_Table;
2577: code_combination_id_array dbms_sql.Number_Table;
2578: cash_receipt_history_id_array dbms_sql.Number_Table;
2579: crh_gl_date_array dbms_sql.date_Table;
2580: crh_trx_date_array dbms_sql.date_Table;
2581: payment_server_order_num_array dbms_sql.varchar2_Table;
2582: approval_code_array dbms_sql.varchar2_Table;

Line 2579: crh_gl_date_array dbms_sql.date_Table;

2575: remmitance_ccid_array dbms_sql.Number_Table;
2576: bank_charges_ccid_array dbms_sql.Number_Table;
2577: code_combination_id_array dbms_sql.Number_Table;
2578: cash_receipt_history_id_array dbms_sql.Number_Table;
2579: crh_gl_date_array dbms_sql.date_Table;
2580: crh_trx_date_array dbms_sql.date_Table;
2581: payment_server_order_num_array dbms_sql.varchar2_Table;
2582: approval_code_array dbms_sql.varchar2_Table;
2583: receipt_number_array dbms_sql.varchar2_Table;

Line 2580: crh_trx_date_array dbms_sql.date_Table;

2576: bank_charges_ccid_array dbms_sql.Number_Table;
2577: code_combination_id_array dbms_sql.Number_Table;
2578: cash_receipt_history_id_array dbms_sql.Number_Table;
2579: crh_gl_date_array dbms_sql.date_Table;
2580: crh_trx_date_array dbms_sql.date_Table;
2581: payment_server_order_num_array dbms_sql.varchar2_Table;
2582: approval_code_array dbms_sql.varchar2_Table;
2583: receipt_number_array dbms_sql.varchar2_Table;
2584: unique_ref_array dbms_sql.varchar2_Table;

Line 2581: payment_server_order_num_array dbms_sql.varchar2_Table;

2577: code_combination_id_array dbms_sql.Number_Table;
2578: cash_receipt_history_id_array dbms_sql.Number_Table;
2579: crh_gl_date_array dbms_sql.date_Table;
2580: crh_trx_date_array dbms_sql.date_Table;
2581: payment_server_order_num_array dbms_sql.varchar2_Table;
2582: approval_code_array dbms_sql.varchar2_Table;
2583: receipt_number_array dbms_sql.varchar2_Table;
2584: unique_ref_array dbms_sql.varchar2_Table;
2585: customer_bank_account_id_array dbms_sql.Number_Table;

Line 2582: approval_code_array dbms_sql.varchar2_Table;

2578: cash_receipt_history_id_array dbms_sql.Number_Table;
2579: crh_gl_date_array dbms_sql.date_Table;
2580: crh_trx_date_array dbms_sql.date_Table;
2581: payment_server_order_num_array dbms_sql.varchar2_Table;
2582: approval_code_array dbms_sql.varchar2_Table;
2583: receipt_number_array dbms_sql.varchar2_Table;
2584: unique_ref_array dbms_sql.varchar2_Table;
2585: customer_bank_account_id_array dbms_sql.Number_Table;
2586: payment_trxn_extn_id_array dbms_sql.Number_Table;

Line 2583: receipt_number_array dbms_sql.varchar2_Table;

2579: crh_gl_date_array dbms_sql.date_Table;
2580: crh_trx_date_array dbms_sql.date_Table;
2581: payment_server_order_num_array dbms_sql.varchar2_Table;
2582: approval_code_array dbms_sql.varchar2_Table;
2583: receipt_number_array dbms_sql.varchar2_Table;
2584: unique_ref_array dbms_sql.varchar2_Table;
2585: customer_bank_account_id_array dbms_sql.Number_Table;
2586: payment_trxn_extn_id_array dbms_sql.Number_Table;
2587: rem_t NUMBER;

Line 2584: unique_ref_array dbms_sql.varchar2_Table;

2580: crh_trx_date_array dbms_sql.date_Table;
2581: payment_server_order_num_array dbms_sql.varchar2_Table;
2582: approval_code_array dbms_sql.varchar2_Table;
2583: receipt_number_array dbms_sql.varchar2_Table;
2584: unique_ref_array dbms_sql.varchar2_Table;
2585: customer_bank_account_id_array dbms_sql.Number_Table;
2586: payment_trxn_extn_id_array dbms_sql.Number_Table;
2587: rem_t NUMBER;
2588: /* end declare */

Line 2585: customer_bank_account_id_array dbms_sql.Number_Table;

2581: payment_server_order_num_array dbms_sql.varchar2_Table;
2582: approval_code_array dbms_sql.varchar2_Table;
2583: receipt_number_array dbms_sql.varchar2_Table;
2584: unique_ref_array dbms_sql.varchar2_Table;
2585: customer_bank_account_id_array dbms_sql.Number_Table;
2586: payment_trxn_extn_id_array dbms_sql.Number_Table;
2587: rem_t NUMBER;
2588: /* end declare */
2589:

Line 2586: payment_trxn_extn_id_array dbms_sql.Number_Table;

2582: approval_code_array dbms_sql.varchar2_Table;
2583: receipt_number_array dbms_sql.varchar2_Table;
2584: unique_ref_array dbms_sql.varchar2_Table;
2585: customer_bank_account_id_array dbms_sql.Number_Table;
2586: payment_trxn_extn_id_array dbms_sql.Number_Table;
2587: rem_t NUMBER;
2588: /* end declare */
2589:
2590:

Line 2679: sel_receipts := dbms_sql.open_cursor;

2675: WHERE batch_id = :ab_batch_id
2676: AND current_worker = :h_worker_number
2677: ';
2678:
2679: sel_receipts := dbms_sql.open_cursor;
2680:
2681: dbms_sql.parse (sel_receipts,l_sel_stmt,dbms_sql.v7);
2682:
2683: dbms_sql.bind_variable (sel_receipts,':ab_batch_id',p_batch_id);

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

2677: ';
2678:
2679: sel_receipts := dbms_sql.open_cursor;
2680:
2681: dbms_sql.parse (sel_receipts,l_sel_stmt,dbms_sql.v7);
2682:
2683: dbms_sql.bind_variable (sel_receipts,':ab_batch_id',p_batch_id);
2684: dbms_sql.bind_variable (sel_receipts,':h_worker_number', WORKER_NUMBER);
2685:

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

2679: sel_receipts := dbms_sql.open_cursor;
2680:
2681: dbms_sql.parse (sel_receipts,l_sel_stmt,dbms_sql.v7);
2682:
2683: dbms_sql.bind_variable (sel_receipts,':ab_batch_id',p_batch_id);
2684: dbms_sql.bind_variable (sel_receipts,':h_worker_number', WORKER_NUMBER);
2685:
2686:
2687: dbms_sql.define_column (sel_receipts, 1, p_cash_receipt_id);

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

2680:
2681: dbms_sql.parse (sel_receipts,l_sel_stmt,dbms_sql.v7);
2682:
2683: dbms_sql.bind_variable (sel_receipts,':ab_batch_id',p_batch_id);
2684: dbms_sql.bind_variable (sel_receipts,':h_worker_number', WORKER_NUMBER);
2685:
2686:
2687: dbms_sql.define_column (sel_receipts, 1, p_cash_receipt_id);
2688: dbms_sql.define_column (sel_receipts, 2, p_payment_type_code,30);

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

2683: dbms_sql.bind_variable (sel_receipts,':ab_batch_id',p_batch_id);
2684: dbms_sql.bind_variable (sel_receipts,':h_worker_number', WORKER_NUMBER);
2685:
2686:
2687: dbms_sql.define_column (sel_receipts, 1, p_cash_receipt_id);
2688: dbms_sql.define_column (sel_receipts, 2, p_payment_type_code,30);
2689: dbms_sql.define_column (sel_receipts, 3, p_merchant_ref,80);
2690: dbms_sql.define_column (sel_receipts, 4, p_currency_code,15);
2691: dbms_sql.define_column (sel_receipts, 5, p_pay_from_customer);

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

2684: dbms_sql.bind_variable (sel_receipts,':h_worker_number', WORKER_NUMBER);
2685:
2686:
2687: dbms_sql.define_column (sel_receipts, 1, p_cash_receipt_id);
2688: dbms_sql.define_column (sel_receipts, 2, p_payment_type_code,30);
2689: dbms_sql.define_column (sel_receipts, 3, p_merchant_ref,80);
2690: dbms_sql.define_column (sel_receipts, 4, p_currency_code,15);
2691: dbms_sql.define_column (sel_receipts, 5, p_pay_from_customer);
2692: dbms_sql.define_column (sel_receipts, 6, p_customer_site_use_id);

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

2685:
2686:
2687: dbms_sql.define_column (sel_receipts, 1, p_cash_receipt_id);
2688: dbms_sql.define_column (sel_receipts, 2, p_payment_type_code,30);
2689: dbms_sql.define_column (sel_receipts, 3, p_merchant_ref,80);
2690: dbms_sql.define_column (sel_receipts, 4, p_currency_code,15);
2691: dbms_sql.define_column (sel_receipts, 5, p_pay_from_customer);
2692: dbms_sql.define_column (sel_receipts, 6, p_customer_site_use_id);
2693: dbms_sql.define_column (sel_receipts, 7, p_prv_cash_receipt_hist_id);

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

2686:
2687: dbms_sql.define_column (sel_receipts, 1, p_cash_receipt_id);
2688: dbms_sql.define_column (sel_receipts, 2, p_payment_type_code,30);
2689: dbms_sql.define_column (sel_receipts, 3, p_merchant_ref,80);
2690: dbms_sql.define_column (sel_receipts, 4, p_currency_code,15);
2691: dbms_sql.define_column (sel_receipts, 5, p_pay_from_customer);
2692: dbms_sql.define_column (sel_receipts, 6, p_customer_site_use_id);
2693: dbms_sql.define_column (sel_receipts, 7, p_prv_cash_receipt_hist_id);
2694: dbms_sql.define_column (sel_receipts, 8, p_exchange_date);

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

2687: dbms_sql.define_column (sel_receipts, 1, p_cash_receipt_id);
2688: dbms_sql.define_column (sel_receipts, 2, p_payment_type_code,30);
2689: dbms_sql.define_column (sel_receipts, 3, p_merchant_ref,80);
2690: dbms_sql.define_column (sel_receipts, 4, p_currency_code,15);
2691: dbms_sql.define_column (sel_receipts, 5, p_pay_from_customer);
2692: dbms_sql.define_column (sel_receipts, 6, p_customer_site_use_id);
2693: dbms_sql.define_column (sel_receipts, 7, p_prv_cash_receipt_hist_id);
2694: dbms_sql.define_column (sel_receipts, 8, p_exchange_date);
2695: dbms_sql.define_column (sel_receipts, 9, p_exchange_rate);

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

2688: dbms_sql.define_column (sel_receipts, 2, p_payment_type_code,30);
2689: dbms_sql.define_column (sel_receipts, 3, p_merchant_ref,80);
2690: dbms_sql.define_column (sel_receipts, 4, p_currency_code,15);
2691: dbms_sql.define_column (sel_receipts, 5, p_pay_from_customer);
2692: dbms_sql.define_column (sel_receipts, 6, p_customer_site_use_id);
2693: dbms_sql.define_column (sel_receipts, 7, p_prv_cash_receipt_hist_id);
2694: dbms_sql.define_column (sel_receipts, 8, p_exchange_date);
2695: dbms_sql.define_column (sel_receipts, 9, p_exchange_rate);
2696: dbms_sql.define_column (sel_receipts, 10, p_exchange_type,30);

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

2689: dbms_sql.define_column (sel_receipts, 3, p_merchant_ref,80);
2690: dbms_sql.define_column (sel_receipts, 4, p_currency_code,15);
2691: dbms_sql.define_column (sel_receipts, 5, p_pay_from_customer);
2692: dbms_sql.define_column (sel_receipts, 6, p_customer_site_use_id);
2693: dbms_sql.define_column (sel_receipts, 7, p_prv_cash_receipt_hist_id);
2694: dbms_sql.define_column (sel_receipts, 8, p_exchange_date);
2695: dbms_sql.define_column (sel_receipts, 9, p_exchange_rate);
2696: dbms_sql.define_column (sel_receipts, 10, p_exchange_type,30);
2697: dbms_sql.define_column (sel_receipts, 11, p_cr_amount);

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

2690: dbms_sql.define_column (sel_receipts, 4, p_currency_code,15);
2691: dbms_sql.define_column (sel_receipts, 5, p_pay_from_customer);
2692: dbms_sql.define_column (sel_receipts, 6, p_customer_site_use_id);
2693: dbms_sql.define_column (sel_receipts, 7, p_prv_cash_receipt_hist_id);
2694: dbms_sql.define_column (sel_receipts, 8, p_exchange_date);
2695: dbms_sql.define_column (sel_receipts, 9, p_exchange_rate);
2696: dbms_sql.define_column (sel_receipts, 10, p_exchange_type,30);
2697: dbms_sql.define_column (sel_receipts, 11, p_cr_amount);
2698: dbms_sql.define_column (sel_receipts, 12, p_cr_acctd_amount);

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

2691: dbms_sql.define_column (sel_receipts, 5, p_pay_from_customer);
2692: dbms_sql.define_column (sel_receipts, 6, p_customer_site_use_id);
2693: dbms_sql.define_column (sel_receipts, 7, p_prv_cash_receipt_hist_id);
2694: dbms_sql.define_column (sel_receipts, 8, p_exchange_date);
2695: dbms_sql.define_column (sel_receipts, 9, p_exchange_rate);
2696: dbms_sql.define_column (sel_receipts, 10, p_exchange_type,30);
2697: dbms_sql.define_column (sel_receipts, 11, p_cr_amount);
2698: dbms_sql.define_column (sel_receipts, 12, p_cr_acctd_amount);
2699: dbms_sql.define_column (sel_receipts, 13, p_cr_factor_discount_amount);

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

2692: dbms_sql.define_column (sel_receipts, 6, p_customer_site_use_id);
2693: dbms_sql.define_column (sel_receipts, 7, p_prv_cash_receipt_hist_id);
2694: dbms_sql.define_column (sel_receipts, 8, p_exchange_date);
2695: dbms_sql.define_column (sel_receipts, 9, p_exchange_rate);
2696: dbms_sql.define_column (sel_receipts, 10, p_exchange_type,30);
2697: dbms_sql.define_column (sel_receipts, 11, p_cr_amount);
2698: dbms_sql.define_column (sel_receipts, 12, p_cr_acctd_amount);
2699: dbms_sql.define_column (sel_receipts, 13, p_cr_factor_discount_amount);
2700: dbms_sql.define_column (sel_receipts, 14, p_remmitance_ccid );

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

2693: dbms_sql.define_column (sel_receipts, 7, p_prv_cash_receipt_hist_id);
2694: dbms_sql.define_column (sel_receipts, 8, p_exchange_date);
2695: dbms_sql.define_column (sel_receipts, 9, p_exchange_rate);
2696: dbms_sql.define_column (sel_receipts, 10, p_exchange_type,30);
2697: dbms_sql.define_column (sel_receipts, 11, p_cr_amount);
2698: dbms_sql.define_column (sel_receipts, 12, p_cr_acctd_amount);
2699: dbms_sql.define_column (sel_receipts, 13, p_cr_factor_discount_amount);
2700: dbms_sql.define_column (sel_receipts, 14, p_remmitance_ccid );
2701: dbms_sql.define_column (sel_receipts, 15, p_bank_charges_ccid);

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

2694: dbms_sql.define_column (sel_receipts, 8, p_exchange_date);
2695: dbms_sql.define_column (sel_receipts, 9, p_exchange_rate);
2696: dbms_sql.define_column (sel_receipts, 10, p_exchange_type,30);
2697: dbms_sql.define_column (sel_receipts, 11, p_cr_amount);
2698: dbms_sql.define_column (sel_receipts, 12, p_cr_acctd_amount);
2699: dbms_sql.define_column (sel_receipts, 13, p_cr_factor_discount_amount);
2700: dbms_sql.define_column (sel_receipts, 14, p_remmitance_ccid );
2701: dbms_sql.define_column (sel_receipts, 15, p_bank_charges_ccid);
2702: dbms_sql.define_column (sel_receipts, 16, p_code_combination_id);

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

2695: dbms_sql.define_column (sel_receipts, 9, p_exchange_rate);
2696: dbms_sql.define_column (sel_receipts, 10, p_exchange_type,30);
2697: dbms_sql.define_column (sel_receipts, 11, p_cr_amount);
2698: dbms_sql.define_column (sel_receipts, 12, p_cr_acctd_amount);
2699: dbms_sql.define_column (sel_receipts, 13, p_cr_factor_discount_amount);
2700: dbms_sql.define_column (sel_receipts, 14, p_remmitance_ccid );
2701: dbms_sql.define_column (sel_receipts, 15, p_bank_charges_ccid);
2702: dbms_sql.define_column (sel_receipts, 16, p_code_combination_id);
2703: dbms_sql.define_column (sel_receipts, 17, p_cash_receipt_history_id);

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

2696: dbms_sql.define_column (sel_receipts, 10, p_exchange_type,30);
2697: dbms_sql.define_column (sel_receipts, 11, p_cr_amount);
2698: dbms_sql.define_column (sel_receipts, 12, p_cr_acctd_amount);
2699: dbms_sql.define_column (sel_receipts, 13, p_cr_factor_discount_amount);
2700: dbms_sql.define_column (sel_receipts, 14, p_remmitance_ccid );
2701: dbms_sql.define_column (sel_receipts, 15, p_bank_charges_ccid);
2702: dbms_sql.define_column (sel_receipts, 16, p_code_combination_id);
2703: dbms_sql.define_column (sel_receipts, 17, p_cash_receipt_history_id);
2704: dbms_sql.define_column (sel_receipts, 18, p_crh_gl_date);

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

2697: dbms_sql.define_column (sel_receipts, 11, p_cr_amount);
2698: dbms_sql.define_column (sel_receipts, 12, p_cr_acctd_amount);
2699: dbms_sql.define_column (sel_receipts, 13, p_cr_factor_discount_amount);
2700: dbms_sql.define_column (sel_receipts, 14, p_remmitance_ccid );
2701: dbms_sql.define_column (sel_receipts, 15, p_bank_charges_ccid);
2702: dbms_sql.define_column (sel_receipts, 16, p_code_combination_id);
2703: dbms_sql.define_column (sel_receipts, 17, p_cash_receipt_history_id);
2704: dbms_sql.define_column (sel_receipts, 18, p_crh_gl_date);
2705: dbms_sql.define_column (sel_receipts, 19, p_crh_trx_date);

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

2698: dbms_sql.define_column (sel_receipts, 12, p_cr_acctd_amount);
2699: dbms_sql.define_column (sel_receipts, 13, p_cr_factor_discount_amount);
2700: dbms_sql.define_column (sel_receipts, 14, p_remmitance_ccid );
2701: dbms_sql.define_column (sel_receipts, 15, p_bank_charges_ccid);
2702: dbms_sql.define_column (sel_receipts, 16, p_code_combination_id);
2703: dbms_sql.define_column (sel_receipts, 17, p_cash_receipt_history_id);
2704: dbms_sql.define_column (sel_receipts, 18, p_crh_gl_date);
2705: dbms_sql.define_column (sel_receipts, 19, p_crh_trx_date);
2706: dbms_sql.define_column (sel_receipts, 20, p_payment_server_order_num,80);

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

2699: dbms_sql.define_column (sel_receipts, 13, p_cr_factor_discount_amount);
2700: dbms_sql.define_column (sel_receipts, 14, p_remmitance_ccid );
2701: dbms_sql.define_column (sel_receipts, 15, p_bank_charges_ccid);
2702: dbms_sql.define_column (sel_receipts, 16, p_code_combination_id);
2703: dbms_sql.define_column (sel_receipts, 17, p_cash_receipt_history_id);
2704: dbms_sql.define_column (sel_receipts, 18, p_crh_gl_date);
2705: dbms_sql.define_column (sel_receipts, 19, p_crh_trx_date);
2706: dbms_sql.define_column (sel_receipts, 20, p_payment_server_order_num,80);
2707: dbms_sql.define_column (sel_receipts, 21, p_approval_code,80);

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

2700: dbms_sql.define_column (sel_receipts, 14, p_remmitance_ccid );
2701: dbms_sql.define_column (sel_receipts, 15, p_bank_charges_ccid);
2702: dbms_sql.define_column (sel_receipts, 16, p_code_combination_id);
2703: dbms_sql.define_column (sel_receipts, 17, p_cash_receipt_history_id);
2704: dbms_sql.define_column (sel_receipts, 18, p_crh_gl_date);
2705: dbms_sql.define_column (sel_receipts, 19, p_crh_trx_date);
2706: dbms_sql.define_column (sel_receipts, 20, p_payment_server_order_num,80);
2707: dbms_sql.define_column (sel_receipts, 21, p_approval_code,80);
2708: dbms_sql.define_column (sel_receipts, 22, p_receipt_number,30);

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

2701: dbms_sql.define_column (sel_receipts, 15, p_bank_charges_ccid);
2702: dbms_sql.define_column (sel_receipts, 16, p_code_combination_id);
2703: dbms_sql.define_column (sel_receipts, 17, p_cash_receipt_history_id);
2704: dbms_sql.define_column (sel_receipts, 18, p_crh_gl_date);
2705: dbms_sql.define_column (sel_receipts, 19, p_crh_trx_date);
2706: dbms_sql.define_column (sel_receipts, 20, p_payment_server_order_num,80);
2707: dbms_sql.define_column (sel_receipts, 21, p_approval_code,80);
2708: dbms_sql.define_column (sel_receipts, 22, p_receipt_number,30);
2709: dbms_sql.define_column (sel_receipts, 23, p_unique_ref,32);

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

2702: dbms_sql.define_column (sel_receipts, 16, p_code_combination_id);
2703: dbms_sql.define_column (sel_receipts, 17, p_cash_receipt_history_id);
2704: dbms_sql.define_column (sel_receipts, 18, p_crh_gl_date);
2705: dbms_sql.define_column (sel_receipts, 19, p_crh_trx_date);
2706: dbms_sql.define_column (sel_receipts, 20, p_payment_server_order_num,80);
2707: dbms_sql.define_column (sel_receipts, 21, p_approval_code,80);
2708: dbms_sql.define_column (sel_receipts, 22, p_receipt_number,30);
2709: dbms_sql.define_column (sel_receipts, 23, p_unique_ref,32);
2710: dbms_sql.define_column (sel_receipts, 24, p_customer_bank_account_id);

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

2703: dbms_sql.define_column (sel_receipts, 17, p_cash_receipt_history_id);
2704: dbms_sql.define_column (sel_receipts, 18, p_crh_gl_date);
2705: dbms_sql.define_column (sel_receipts, 19, p_crh_trx_date);
2706: dbms_sql.define_column (sel_receipts, 20, p_payment_server_order_num,80);
2707: dbms_sql.define_column (sel_receipts, 21, p_approval_code,80);
2708: dbms_sql.define_column (sel_receipts, 22, p_receipt_number,30);
2709: dbms_sql.define_column (sel_receipts, 23, p_unique_ref,32);
2710: dbms_sql.define_column (sel_receipts, 24, p_customer_bank_account_id);
2711: dbms_sql.define_column (sel_receipts, 25, p_payment_trxn_extension_id);

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

2704: dbms_sql.define_column (sel_receipts, 18, p_crh_gl_date);
2705: dbms_sql.define_column (sel_receipts, 19, p_crh_trx_date);
2706: dbms_sql.define_column (sel_receipts, 20, p_payment_server_order_num,80);
2707: dbms_sql.define_column (sel_receipts, 21, p_approval_code,80);
2708: dbms_sql.define_column (sel_receipts, 22, p_receipt_number,30);
2709: dbms_sql.define_column (sel_receipts, 23, p_unique_ref,32);
2710: dbms_sql.define_column (sel_receipts, 24, p_customer_bank_account_id);
2711: dbms_sql.define_column (sel_receipts, 25, p_payment_trxn_extension_id);
2712:

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

2705: dbms_sql.define_column (sel_receipts, 19, p_crh_trx_date);
2706: dbms_sql.define_column (sel_receipts, 20, p_payment_server_order_num,80);
2707: dbms_sql.define_column (sel_receipts, 21, p_approval_code,80);
2708: dbms_sql.define_column (sel_receipts, 22, p_receipt_number,30);
2709: dbms_sql.define_column (sel_receipts, 23, p_unique_ref,32);
2710: dbms_sql.define_column (sel_receipts, 24, p_customer_bank_account_id);
2711: dbms_sql.define_column (sel_receipts, 25, p_payment_trxn_extension_id);
2712:
2713: IF PG_DEBUG in ('Y', 'C') THEN

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

2706: dbms_sql.define_column (sel_receipts, 20, p_payment_server_order_num,80);
2707: dbms_sql.define_column (sel_receipts, 21, p_approval_code,80);
2708: dbms_sql.define_column (sel_receipts, 22, p_receipt_number,30);
2709: dbms_sql.define_column (sel_receipts, 23, p_unique_ref,32);
2710: dbms_sql.define_column (sel_receipts, 24, p_customer_bank_account_id);
2711: dbms_sql.define_column (sel_receipts, 25, p_payment_trxn_extension_id);
2712:
2713: IF PG_DEBUG in ('Y', 'C') THEN
2714: fnd_file.put_line(FND_FILE.LOG, 'the select statemnt' || l_sel_stmt);

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

2707: dbms_sql.define_column (sel_receipts, 21, p_approval_code,80);
2708: dbms_sql.define_column (sel_receipts, 22, p_receipt_number,30);
2709: dbms_sql.define_column (sel_receipts, 23, p_unique_ref,32);
2710: dbms_sql.define_column (sel_receipts, 24, p_customer_bank_account_id);
2711: dbms_sql.define_column (sel_receipts, 25, p_payment_trxn_extension_id);
2712:
2713: IF PG_DEBUG in ('Y', 'C') THEN
2714: fnd_file.put_line(FND_FILE.LOG, 'the select statemnt' || l_sel_stmt);
2715: END IF;

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

2713: IF PG_DEBUG in ('Y', 'C') THEN
2714: fnd_file.put_line(FND_FILE.LOG, 'the select statemnt' || l_sel_stmt);
2715: END IF;
2716:
2717: l_rows_processed := dbms_sql.execute( sel_receipts);
2718:
2719: i:= 0;
2720:
2721: WHILE dbms_sql.fetch_rows( sel_receipts) > 0 LOOP

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

2717: l_rows_processed := dbms_sql.execute( sel_receipts);
2718:
2719: i:= 0;
2720:
2721: WHILE dbms_sql.fetch_rows( sel_receipts) > 0 LOOP
2722: dbms_sql.column_value (sel_receipts, 1, p_cash_receipt_id);
2723: dbms_sql.column_value (sel_receipts, 2, p_payment_type_code);
2724: dbms_sql.column_value (sel_receipts, 3, p_merchant_ref);
2725: dbms_sql.column_value (sel_receipts, 4, p_currency_code);

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

2718:
2719: i:= 0;
2720:
2721: WHILE dbms_sql.fetch_rows( sel_receipts) > 0 LOOP
2722: dbms_sql.column_value (sel_receipts, 1, p_cash_receipt_id);
2723: dbms_sql.column_value (sel_receipts, 2, p_payment_type_code);
2724: dbms_sql.column_value (sel_receipts, 3, p_merchant_ref);
2725: dbms_sql.column_value (sel_receipts, 4, p_currency_code);
2726: dbms_sql.column_value (sel_receipts, 5, p_pay_from_customer);

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

2719: i:= 0;
2720:
2721: WHILE dbms_sql.fetch_rows( sel_receipts) > 0 LOOP
2722: dbms_sql.column_value (sel_receipts, 1, p_cash_receipt_id);
2723: dbms_sql.column_value (sel_receipts, 2, p_payment_type_code);
2724: dbms_sql.column_value (sel_receipts, 3, p_merchant_ref);
2725: dbms_sql.column_value (sel_receipts, 4, p_currency_code);
2726: dbms_sql.column_value (sel_receipts, 5, p_pay_from_customer);
2727: dbms_sql.column_value (sel_receipts, 6, p_customer_site_use_id);

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

2720:
2721: WHILE dbms_sql.fetch_rows( sel_receipts) > 0 LOOP
2722: dbms_sql.column_value (sel_receipts, 1, p_cash_receipt_id);
2723: dbms_sql.column_value (sel_receipts, 2, p_payment_type_code);
2724: dbms_sql.column_value (sel_receipts, 3, p_merchant_ref);
2725: dbms_sql.column_value (sel_receipts, 4, p_currency_code);
2726: dbms_sql.column_value (sel_receipts, 5, p_pay_from_customer);
2727: dbms_sql.column_value (sel_receipts, 6, p_customer_site_use_id);
2728: dbms_sql.column_value (sel_receipts, 7, p_prv_cash_receipt_hist_id);

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

2721: WHILE dbms_sql.fetch_rows( sel_receipts) > 0 LOOP
2722: dbms_sql.column_value (sel_receipts, 1, p_cash_receipt_id);
2723: dbms_sql.column_value (sel_receipts, 2, p_payment_type_code);
2724: dbms_sql.column_value (sel_receipts, 3, p_merchant_ref);
2725: dbms_sql.column_value (sel_receipts, 4, p_currency_code);
2726: dbms_sql.column_value (sel_receipts, 5, p_pay_from_customer);
2727: dbms_sql.column_value (sel_receipts, 6, p_customer_site_use_id);
2728: dbms_sql.column_value (sel_receipts, 7, p_prv_cash_receipt_hist_id);
2729: dbms_sql.column_value (sel_receipts, 8, p_exchange_date);

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

2722: dbms_sql.column_value (sel_receipts, 1, p_cash_receipt_id);
2723: dbms_sql.column_value (sel_receipts, 2, p_payment_type_code);
2724: dbms_sql.column_value (sel_receipts, 3, p_merchant_ref);
2725: dbms_sql.column_value (sel_receipts, 4, p_currency_code);
2726: dbms_sql.column_value (sel_receipts, 5, p_pay_from_customer);
2727: dbms_sql.column_value (sel_receipts, 6, p_customer_site_use_id);
2728: dbms_sql.column_value (sel_receipts, 7, p_prv_cash_receipt_hist_id);
2729: dbms_sql.column_value (sel_receipts, 8, p_exchange_date);
2730: dbms_sql.column_value (sel_receipts, 9, p_exchange_rate);

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

2723: dbms_sql.column_value (sel_receipts, 2, p_payment_type_code);
2724: dbms_sql.column_value (sel_receipts, 3, p_merchant_ref);
2725: dbms_sql.column_value (sel_receipts, 4, p_currency_code);
2726: dbms_sql.column_value (sel_receipts, 5, p_pay_from_customer);
2727: dbms_sql.column_value (sel_receipts, 6, p_customer_site_use_id);
2728: dbms_sql.column_value (sel_receipts, 7, p_prv_cash_receipt_hist_id);
2729: dbms_sql.column_value (sel_receipts, 8, p_exchange_date);
2730: dbms_sql.column_value (sel_receipts, 9, p_exchange_rate);
2731: dbms_sql.column_value (sel_receipts, 10, p_exchange_type);

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

2724: dbms_sql.column_value (sel_receipts, 3, p_merchant_ref);
2725: dbms_sql.column_value (sel_receipts, 4, p_currency_code);
2726: dbms_sql.column_value (sel_receipts, 5, p_pay_from_customer);
2727: dbms_sql.column_value (sel_receipts, 6, p_customer_site_use_id);
2728: dbms_sql.column_value (sel_receipts, 7, p_prv_cash_receipt_hist_id);
2729: dbms_sql.column_value (sel_receipts, 8, p_exchange_date);
2730: dbms_sql.column_value (sel_receipts, 9, p_exchange_rate);
2731: dbms_sql.column_value (sel_receipts, 10, p_exchange_type);
2732: dbms_sql.column_value (sel_receipts, 11, p_cr_amount);

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

2725: dbms_sql.column_value (sel_receipts, 4, p_currency_code);
2726: dbms_sql.column_value (sel_receipts, 5, p_pay_from_customer);
2727: dbms_sql.column_value (sel_receipts, 6, p_customer_site_use_id);
2728: dbms_sql.column_value (sel_receipts, 7, p_prv_cash_receipt_hist_id);
2729: dbms_sql.column_value (sel_receipts, 8, p_exchange_date);
2730: dbms_sql.column_value (sel_receipts, 9, p_exchange_rate);
2731: dbms_sql.column_value (sel_receipts, 10, p_exchange_type);
2732: dbms_sql.column_value (sel_receipts, 11, p_cr_amount);
2733: dbms_sql.column_value (sel_receipts, 12, p_cr_acctd_amount);

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

2726: dbms_sql.column_value (sel_receipts, 5, p_pay_from_customer);
2727: dbms_sql.column_value (sel_receipts, 6, p_customer_site_use_id);
2728: dbms_sql.column_value (sel_receipts, 7, p_prv_cash_receipt_hist_id);
2729: dbms_sql.column_value (sel_receipts, 8, p_exchange_date);
2730: dbms_sql.column_value (sel_receipts, 9, p_exchange_rate);
2731: dbms_sql.column_value (sel_receipts, 10, p_exchange_type);
2732: dbms_sql.column_value (sel_receipts, 11, p_cr_amount);
2733: dbms_sql.column_value (sel_receipts, 12, p_cr_acctd_amount);
2734: dbms_sql.column_value (sel_receipts, 13, p_cr_factor_discount_amount);

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

2727: dbms_sql.column_value (sel_receipts, 6, p_customer_site_use_id);
2728: dbms_sql.column_value (sel_receipts, 7, p_prv_cash_receipt_hist_id);
2729: dbms_sql.column_value (sel_receipts, 8, p_exchange_date);
2730: dbms_sql.column_value (sel_receipts, 9, p_exchange_rate);
2731: dbms_sql.column_value (sel_receipts, 10, p_exchange_type);
2732: dbms_sql.column_value (sel_receipts, 11, p_cr_amount);
2733: dbms_sql.column_value (sel_receipts, 12, p_cr_acctd_amount);
2734: dbms_sql.column_value (sel_receipts, 13, p_cr_factor_discount_amount);
2735: dbms_sql.column_value (sel_receipts, 14, p_remmitance_ccid );

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

2728: dbms_sql.column_value (sel_receipts, 7, p_prv_cash_receipt_hist_id);
2729: dbms_sql.column_value (sel_receipts, 8, p_exchange_date);
2730: dbms_sql.column_value (sel_receipts, 9, p_exchange_rate);
2731: dbms_sql.column_value (sel_receipts, 10, p_exchange_type);
2732: dbms_sql.column_value (sel_receipts, 11, p_cr_amount);
2733: dbms_sql.column_value (sel_receipts, 12, p_cr_acctd_amount);
2734: dbms_sql.column_value (sel_receipts, 13, p_cr_factor_discount_amount);
2735: dbms_sql.column_value (sel_receipts, 14, p_remmitance_ccid );
2736: dbms_sql.column_value (sel_receipts, 15, p_bank_charges_ccid);

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

2729: dbms_sql.column_value (sel_receipts, 8, p_exchange_date);
2730: dbms_sql.column_value (sel_receipts, 9, p_exchange_rate);
2731: dbms_sql.column_value (sel_receipts, 10, p_exchange_type);
2732: dbms_sql.column_value (sel_receipts, 11, p_cr_amount);
2733: dbms_sql.column_value (sel_receipts, 12, p_cr_acctd_amount);
2734: dbms_sql.column_value (sel_receipts, 13, p_cr_factor_discount_amount);
2735: dbms_sql.column_value (sel_receipts, 14, p_remmitance_ccid );
2736: dbms_sql.column_value (sel_receipts, 15, p_bank_charges_ccid);
2737: dbms_sql.column_value (sel_receipts, 16, p_code_combination_id);

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

2730: dbms_sql.column_value (sel_receipts, 9, p_exchange_rate);
2731: dbms_sql.column_value (sel_receipts, 10, p_exchange_type);
2732: dbms_sql.column_value (sel_receipts, 11, p_cr_amount);
2733: dbms_sql.column_value (sel_receipts, 12, p_cr_acctd_amount);
2734: dbms_sql.column_value (sel_receipts, 13, p_cr_factor_discount_amount);
2735: dbms_sql.column_value (sel_receipts, 14, p_remmitance_ccid );
2736: dbms_sql.column_value (sel_receipts, 15, p_bank_charges_ccid);
2737: dbms_sql.column_value (sel_receipts, 16, p_code_combination_id);
2738: dbms_sql.column_value (sel_receipts, 17, p_cash_receipt_history_id);

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

2731: dbms_sql.column_value (sel_receipts, 10, p_exchange_type);
2732: dbms_sql.column_value (sel_receipts, 11, p_cr_amount);
2733: dbms_sql.column_value (sel_receipts, 12, p_cr_acctd_amount);
2734: dbms_sql.column_value (sel_receipts, 13, p_cr_factor_discount_amount);
2735: dbms_sql.column_value (sel_receipts, 14, p_remmitance_ccid );
2736: dbms_sql.column_value (sel_receipts, 15, p_bank_charges_ccid);
2737: dbms_sql.column_value (sel_receipts, 16, p_code_combination_id);
2738: dbms_sql.column_value (sel_receipts, 17, p_cash_receipt_history_id);
2739: dbms_sql.column_value (sel_receipts, 18, p_crh_gl_date);

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

2732: dbms_sql.column_value (sel_receipts, 11, p_cr_amount);
2733: dbms_sql.column_value (sel_receipts, 12, p_cr_acctd_amount);
2734: dbms_sql.column_value (sel_receipts, 13, p_cr_factor_discount_amount);
2735: dbms_sql.column_value (sel_receipts, 14, p_remmitance_ccid );
2736: dbms_sql.column_value (sel_receipts, 15, p_bank_charges_ccid);
2737: dbms_sql.column_value (sel_receipts, 16, p_code_combination_id);
2738: dbms_sql.column_value (sel_receipts, 17, p_cash_receipt_history_id);
2739: dbms_sql.column_value (sel_receipts, 18, p_crh_gl_date);
2740: dbms_sql.column_value (sel_receipts, 19, p_crh_trx_date);

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

2733: dbms_sql.column_value (sel_receipts, 12, p_cr_acctd_amount);
2734: dbms_sql.column_value (sel_receipts, 13, p_cr_factor_discount_amount);
2735: dbms_sql.column_value (sel_receipts, 14, p_remmitance_ccid );
2736: dbms_sql.column_value (sel_receipts, 15, p_bank_charges_ccid);
2737: dbms_sql.column_value (sel_receipts, 16, p_code_combination_id);
2738: dbms_sql.column_value (sel_receipts, 17, p_cash_receipt_history_id);
2739: dbms_sql.column_value (sel_receipts, 18, p_crh_gl_date);
2740: dbms_sql.column_value (sel_receipts, 19, p_crh_trx_date);
2741: dbms_sql.column_value (sel_receipts, 20, p_payment_server_order_num);

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

2734: dbms_sql.column_value (sel_receipts, 13, p_cr_factor_discount_amount);
2735: dbms_sql.column_value (sel_receipts, 14, p_remmitance_ccid );
2736: dbms_sql.column_value (sel_receipts, 15, p_bank_charges_ccid);
2737: dbms_sql.column_value (sel_receipts, 16, p_code_combination_id);
2738: dbms_sql.column_value (sel_receipts, 17, p_cash_receipt_history_id);
2739: dbms_sql.column_value (sel_receipts, 18, p_crh_gl_date);
2740: dbms_sql.column_value (sel_receipts, 19, p_crh_trx_date);
2741: dbms_sql.column_value (sel_receipts, 20, p_payment_server_order_num);
2742: dbms_sql.column_value (sel_receipts, 21, p_approval_code);

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

2735: dbms_sql.column_value (sel_receipts, 14, p_remmitance_ccid );
2736: dbms_sql.column_value (sel_receipts, 15, p_bank_charges_ccid);
2737: dbms_sql.column_value (sel_receipts, 16, p_code_combination_id);
2738: dbms_sql.column_value (sel_receipts, 17, p_cash_receipt_history_id);
2739: dbms_sql.column_value (sel_receipts, 18, p_crh_gl_date);
2740: dbms_sql.column_value (sel_receipts, 19, p_crh_trx_date);
2741: dbms_sql.column_value (sel_receipts, 20, p_payment_server_order_num);
2742: dbms_sql.column_value (sel_receipts, 21, p_approval_code);
2743: dbms_sql.column_value (sel_receipts, 22, p_receipt_number);

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

2736: dbms_sql.column_value (sel_receipts, 15, p_bank_charges_ccid);
2737: dbms_sql.column_value (sel_receipts, 16, p_code_combination_id);
2738: dbms_sql.column_value (sel_receipts, 17, p_cash_receipt_history_id);
2739: dbms_sql.column_value (sel_receipts, 18, p_crh_gl_date);
2740: dbms_sql.column_value (sel_receipts, 19, p_crh_trx_date);
2741: dbms_sql.column_value (sel_receipts, 20, p_payment_server_order_num);
2742: dbms_sql.column_value (sel_receipts, 21, p_approval_code);
2743: dbms_sql.column_value (sel_receipts, 22, p_receipt_number);
2744: dbms_sql.column_value (sel_receipts, 23, p_unique_ref);

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

2737: dbms_sql.column_value (sel_receipts, 16, p_code_combination_id);
2738: dbms_sql.column_value (sel_receipts, 17, p_cash_receipt_history_id);
2739: dbms_sql.column_value (sel_receipts, 18, p_crh_gl_date);
2740: dbms_sql.column_value (sel_receipts, 19, p_crh_trx_date);
2741: dbms_sql.column_value (sel_receipts, 20, p_payment_server_order_num);
2742: dbms_sql.column_value (sel_receipts, 21, p_approval_code);
2743: dbms_sql.column_value (sel_receipts, 22, p_receipt_number);
2744: dbms_sql.column_value (sel_receipts, 23, p_unique_ref);
2745: dbms_sql.column_value (sel_receipts, 24, p_customer_bank_account_id);

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

2738: dbms_sql.column_value (sel_receipts, 17, p_cash_receipt_history_id);
2739: dbms_sql.column_value (sel_receipts, 18, p_crh_gl_date);
2740: dbms_sql.column_value (sel_receipts, 19, p_crh_trx_date);
2741: dbms_sql.column_value (sel_receipts, 20, p_payment_server_order_num);
2742: dbms_sql.column_value (sel_receipts, 21, p_approval_code);
2743: dbms_sql.column_value (sel_receipts, 22, p_receipt_number);
2744: dbms_sql.column_value (sel_receipts, 23, p_unique_ref);
2745: dbms_sql.column_value (sel_receipts, 24, p_customer_bank_account_id);
2746: dbms_sql.column_value (sel_receipts, 25, p_payment_trxn_extension_id);

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

2739: dbms_sql.column_value (sel_receipts, 18, p_crh_gl_date);
2740: dbms_sql.column_value (sel_receipts, 19, p_crh_trx_date);
2741: dbms_sql.column_value (sel_receipts, 20, p_payment_server_order_num);
2742: dbms_sql.column_value (sel_receipts, 21, p_approval_code);
2743: dbms_sql.column_value (sel_receipts, 22, p_receipt_number);
2744: dbms_sql.column_value (sel_receipts, 23, p_unique_ref);
2745: dbms_sql.column_value (sel_receipts, 24, p_customer_bank_account_id);
2746: dbms_sql.column_value (sel_receipts, 25, p_payment_trxn_extension_id);
2747:

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

2740: dbms_sql.column_value (sel_receipts, 19, p_crh_trx_date);
2741: dbms_sql.column_value (sel_receipts, 20, p_payment_server_order_num);
2742: dbms_sql.column_value (sel_receipts, 21, p_approval_code);
2743: dbms_sql.column_value (sel_receipts, 22, p_receipt_number);
2744: dbms_sql.column_value (sel_receipts, 23, p_unique_ref);
2745: dbms_sql.column_value (sel_receipts, 24, p_customer_bank_account_id);
2746: dbms_sql.column_value (sel_receipts, 25, p_payment_trxn_extension_id);
2747:
2748: IF PG_DEBUG in ( 'Y','C') THEN

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

2741: dbms_sql.column_value (sel_receipts, 20, p_payment_server_order_num);
2742: dbms_sql.column_value (sel_receipts, 21, p_approval_code);
2743: dbms_sql.column_value (sel_receipts, 22, p_receipt_number);
2744: dbms_sql.column_value (sel_receipts, 23, p_unique_ref);
2745: dbms_sql.column_value (sel_receipts, 24, p_customer_bank_account_id);
2746: dbms_sql.column_value (sel_receipts, 25, p_payment_trxn_extension_id);
2747:
2748: IF PG_DEBUG in ( 'Y','C') THEN
2749: fnd_file.put_line(FND_FILE.LOG,

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

2742: dbms_sql.column_value (sel_receipts, 21, p_approval_code);
2743: dbms_sql.column_value (sel_receipts, 22, p_receipt_number);
2744: dbms_sql.column_value (sel_receipts, 23, p_unique_ref);
2745: dbms_sql.column_value (sel_receipts, 24, p_customer_bank_account_id);
2746: dbms_sql.column_value (sel_receipts, 25, p_payment_trxn_extension_id);
2747:
2748: IF PG_DEBUG in ( 'Y','C') THEN
2749: fnd_file.put_line(FND_FILE.LOG,
2750: 'the value of ps_id ' || p_cash_receipt_id);

Line 2789: l_rows_fetched := dbms_sql.last_row_count ;

2785: END IF;
2786:
2787: END LOOP;
2788:
2789: l_rows_fetched := dbms_sql.last_row_count ;
2790:
2791: IF PG_DEBUG in ('Y', 'C') THEN
2792: fnd_file.put_line(FND_FILE.LOG,'the no of rows fetched ' || l_rows_fetched);
2793: END IF;

Line 2795: dbms_sql.close_cursor( sel_receipts);

2791: IF PG_DEBUG in ('Y', 'C') THEN
2792: fnd_file.put_line(FND_FILE.LOG,'the no of rows fetched ' || l_rows_fetched);
2793: END IF;
2794:
2795: dbms_sql.close_cursor( sel_receipts);
2796:
2797: IF PG_DEBUG in ('Y', 'C') THEN
2798: fnd_file.put_line(FND_FILE.LOG,'selrem and create and upd 1()-');
2799: END IF;

Line 2811: rem_t := dbms_sql.open_cursor;

2807: :c6_array,:c7_array,:c8_array,:c9_array,:c10_array,:c11_array,:c12_array,
2808: :c13_array,:c14_array,:c15_array,:c16_array,:c17_array,:c18_array,
2809: :c19_array,:c20_array,:c21_array,:c22_array,:c23_array,:c24_array,:c25_array)';
2810:
2811: rem_t := dbms_sql.open_cursor;
2812:
2813: dbms_sql.parse (rem_t,inst_stmt,dbms_sql.v7);
2814:
2815: dbms_sql.bind_array (rem_t,':c1_array',cash_receipt_id_array);

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

2809: :c19_array,:c20_array,:c21_array,:c22_array,:c23_array,:c24_array,:c25_array)';
2810:
2811: rem_t := dbms_sql.open_cursor;
2812:
2813: dbms_sql.parse (rem_t,inst_stmt,dbms_sql.v7);
2814:
2815: dbms_sql.bind_array (rem_t,':c1_array',cash_receipt_id_array);
2816: dbms_sql.bind_array (rem_t,':c2_array',payment_type_CODE_array);
2817: dbms_sql.bind_array (rem_t,':c3_array',merchant_ref_array);

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

2811: rem_t := dbms_sql.open_cursor;
2812:
2813: dbms_sql.parse (rem_t,inst_stmt,dbms_sql.v7);
2814:
2815: dbms_sql.bind_array (rem_t,':c1_array',cash_receipt_id_array);
2816: dbms_sql.bind_array (rem_t,':c2_array',payment_type_CODE_array);
2817: dbms_sql.bind_array (rem_t,':c3_array',merchant_ref_array);
2818: dbms_sql.bind_array (rem_t,':c4_array',currency_code_array);
2819: dbms_sql.bind_array (rem_t,':c5_array',pay_from_customer_array);

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

2812:
2813: dbms_sql.parse (rem_t,inst_stmt,dbms_sql.v7);
2814:
2815: dbms_sql.bind_array (rem_t,':c1_array',cash_receipt_id_array);
2816: dbms_sql.bind_array (rem_t,':c2_array',payment_type_CODE_array);
2817: dbms_sql.bind_array (rem_t,':c3_array',merchant_ref_array);
2818: dbms_sql.bind_array (rem_t,':c4_array',currency_code_array);
2819: dbms_sql.bind_array (rem_t,':c5_array',pay_from_customer_array);
2820: dbms_sql.bind_array (rem_t,':c6_array',customer_site_use_id_array);

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

2813: dbms_sql.parse (rem_t,inst_stmt,dbms_sql.v7);
2814:
2815: dbms_sql.bind_array (rem_t,':c1_array',cash_receipt_id_array);
2816: dbms_sql.bind_array (rem_t,':c2_array',payment_type_CODE_array);
2817: dbms_sql.bind_array (rem_t,':c3_array',merchant_ref_array);
2818: dbms_sql.bind_array (rem_t,':c4_array',currency_code_array);
2819: dbms_sql.bind_array (rem_t,':c5_array',pay_from_customer_array);
2820: dbms_sql.bind_array (rem_t,':c6_array',customer_site_use_id_array);
2821: dbms_sql.bind_array (rem_t,':c7_array',prv_cash_receipt_hist_id_array);

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

2814:
2815: dbms_sql.bind_array (rem_t,':c1_array',cash_receipt_id_array);
2816: dbms_sql.bind_array (rem_t,':c2_array',payment_type_CODE_array);
2817: dbms_sql.bind_array (rem_t,':c3_array',merchant_ref_array);
2818: dbms_sql.bind_array (rem_t,':c4_array',currency_code_array);
2819: dbms_sql.bind_array (rem_t,':c5_array',pay_from_customer_array);
2820: dbms_sql.bind_array (rem_t,':c6_array',customer_site_use_id_array);
2821: dbms_sql.bind_array (rem_t,':c7_array',prv_cash_receipt_hist_id_array);
2822: dbms_sql.bind_array (rem_t,':c8_array',exchange_date_array);

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

2815: dbms_sql.bind_array (rem_t,':c1_array',cash_receipt_id_array);
2816: dbms_sql.bind_array (rem_t,':c2_array',payment_type_CODE_array);
2817: dbms_sql.bind_array (rem_t,':c3_array',merchant_ref_array);
2818: dbms_sql.bind_array (rem_t,':c4_array',currency_code_array);
2819: dbms_sql.bind_array (rem_t,':c5_array',pay_from_customer_array);
2820: dbms_sql.bind_array (rem_t,':c6_array',customer_site_use_id_array);
2821: dbms_sql.bind_array (rem_t,':c7_array',prv_cash_receipt_hist_id_array);
2822: dbms_sql.bind_array (rem_t,':c8_array',exchange_date_array);
2823: dbms_sql.bind_array (rem_t,':c9_array',exchange_rate_array);

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

2816: dbms_sql.bind_array (rem_t,':c2_array',payment_type_CODE_array);
2817: dbms_sql.bind_array (rem_t,':c3_array',merchant_ref_array);
2818: dbms_sql.bind_array (rem_t,':c4_array',currency_code_array);
2819: dbms_sql.bind_array (rem_t,':c5_array',pay_from_customer_array);
2820: dbms_sql.bind_array (rem_t,':c6_array',customer_site_use_id_array);
2821: dbms_sql.bind_array (rem_t,':c7_array',prv_cash_receipt_hist_id_array);
2822: dbms_sql.bind_array (rem_t,':c8_array',exchange_date_array);
2823: dbms_sql.bind_array (rem_t,':c9_array',exchange_rate_array);
2824: dbms_sql.bind_array (rem_t,':c10_array',exchange_type_array);

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

2817: dbms_sql.bind_array (rem_t,':c3_array',merchant_ref_array);
2818: dbms_sql.bind_array (rem_t,':c4_array',currency_code_array);
2819: dbms_sql.bind_array (rem_t,':c5_array',pay_from_customer_array);
2820: dbms_sql.bind_array (rem_t,':c6_array',customer_site_use_id_array);
2821: dbms_sql.bind_array (rem_t,':c7_array',prv_cash_receipt_hist_id_array);
2822: dbms_sql.bind_array (rem_t,':c8_array',exchange_date_array);
2823: dbms_sql.bind_array (rem_t,':c9_array',exchange_rate_array);
2824: dbms_sql.bind_array (rem_t,':c10_array',exchange_type_array);
2825: dbms_sql.bind_array (rem_t,':c11_array',cr_amount_array);

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

2818: dbms_sql.bind_array (rem_t,':c4_array',currency_code_array);
2819: dbms_sql.bind_array (rem_t,':c5_array',pay_from_customer_array);
2820: dbms_sql.bind_array (rem_t,':c6_array',customer_site_use_id_array);
2821: dbms_sql.bind_array (rem_t,':c7_array',prv_cash_receipt_hist_id_array);
2822: dbms_sql.bind_array (rem_t,':c8_array',exchange_date_array);
2823: dbms_sql.bind_array (rem_t,':c9_array',exchange_rate_array);
2824: dbms_sql.bind_array (rem_t,':c10_array',exchange_type_array);
2825: dbms_sql.bind_array (rem_t,':c11_array',cr_amount_array);
2826: dbms_sql.bind_array (rem_t,':c12_array',cr_acctd_amount_array);

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

2819: dbms_sql.bind_array (rem_t,':c5_array',pay_from_customer_array);
2820: dbms_sql.bind_array (rem_t,':c6_array',customer_site_use_id_array);
2821: dbms_sql.bind_array (rem_t,':c7_array',prv_cash_receipt_hist_id_array);
2822: dbms_sql.bind_array (rem_t,':c8_array',exchange_date_array);
2823: dbms_sql.bind_array (rem_t,':c9_array',exchange_rate_array);
2824: dbms_sql.bind_array (rem_t,':c10_array',exchange_type_array);
2825: dbms_sql.bind_array (rem_t,':c11_array',cr_amount_array);
2826: dbms_sql.bind_array (rem_t,':c12_array',cr_acctd_amount_array);
2827: dbms_sql.bind_array (rem_t,':c13_array',cr_factor_discount_amt_array);

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

2820: dbms_sql.bind_array (rem_t,':c6_array',customer_site_use_id_array);
2821: dbms_sql.bind_array (rem_t,':c7_array',prv_cash_receipt_hist_id_array);
2822: dbms_sql.bind_array (rem_t,':c8_array',exchange_date_array);
2823: dbms_sql.bind_array (rem_t,':c9_array',exchange_rate_array);
2824: dbms_sql.bind_array (rem_t,':c10_array',exchange_type_array);
2825: dbms_sql.bind_array (rem_t,':c11_array',cr_amount_array);
2826: dbms_sql.bind_array (rem_t,':c12_array',cr_acctd_amount_array);
2827: dbms_sql.bind_array (rem_t,':c13_array',cr_factor_discount_amt_array);
2828: dbms_sql.bind_array (rem_t,':c14_array',remmitance_ccid_array);

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

2821: dbms_sql.bind_array (rem_t,':c7_array',prv_cash_receipt_hist_id_array);
2822: dbms_sql.bind_array (rem_t,':c8_array',exchange_date_array);
2823: dbms_sql.bind_array (rem_t,':c9_array',exchange_rate_array);
2824: dbms_sql.bind_array (rem_t,':c10_array',exchange_type_array);
2825: dbms_sql.bind_array (rem_t,':c11_array',cr_amount_array);
2826: dbms_sql.bind_array (rem_t,':c12_array',cr_acctd_amount_array);
2827: dbms_sql.bind_array (rem_t,':c13_array',cr_factor_discount_amt_array);
2828: dbms_sql.bind_array (rem_t,':c14_array',remmitance_ccid_array);
2829: dbms_sql.bind_array (rem_t,':c15_array',bank_charges_ccid_array);

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

2822: dbms_sql.bind_array (rem_t,':c8_array',exchange_date_array);
2823: dbms_sql.bind_array (rem_t,':c9_array',exchange_rate_array);
2824: dbms_sql.bind_array (rem_t,':c10_array',exchange_type_array);
2825: dbms_sql.bind_array (rem_t,':c11_array',cr_amount_array);
2826: dbms_sql.bind_array (rem_t,':c12_array',cr_acctd_amount_array);
2827: dbms_sql.bind_array (rem_t,':c13_array',cr_factor_discount_amt_array);
2828: dbms_sql.bind_array (rem_t,':c14_array',remmitance_ccid_array);
2829: dbms_sql.bind_array (rem_t,':c15_array',bank_charges_ccid_array);
2830: dbms_sql.bind_array (rem_t,':c16_array',code_combination_id_array);

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

2823: dbms_sql.bind_array (rem_t,':c9_array',exchange_rate_array);
2824: dbms_sql.bind_array (rem_t,':c10_array',exchange_type_array);
2825: dbms_sql.bind_array (rem_t,':c11_array',cr_amount_array);
2826: dbms_sql.bind_array (rem_t,':c12_array',cr_acctd_amount_array);
2827: dbms_sql.bind_array (rem_t,':c13_array',cr_factor_discount_amt_array);
2828: dbms_sql.bind_array (rem_t,':c14_array',remmitance_ccid_array);
2829: dbms_sql.bind_array (rem_t,':c15_array',bank_charges_ccid_array);
2830: dbms_sql.bind_array (rem_t,':c16_array',code_combination_id_array);
2831: dbms_sql.bind_array (rem_t,':c17_array',cash_receipt_history_id_array);

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

2824: dbms_sql.bind_array (rem_t,':c10_array',exchange_type_array);
2825: dbms_sql.bind_array (rem_t,':c11_array',cr_amount_array);
2826: dbms_sql.bind_array (rem_t,':c12_array',cr_acctd_amount_array);
2827: dbms_sql.bind_array (rem_t,':c13_array',cr_factor_discount_amt_array);
2828: dbms_sql.bind_array (rem_t,':c14_array',remmitance_ccid_array);
2829: dbms_sql.bind_array (rem_t,':c15_array',bank_charges_ccid_array);
2830: dbms_sql.bind_array (rem_t,':c16_array',code_combination_id_array);
2831: dbms_sql.bind_array (rem_t,':c17_array',cash_receipt_history_id_array);
2832: dbms_sql.bind_array (rem_t,':c18_array',crh_gl_date_array);

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

2825: dbms_sql.bind_array (rem_t,':c11_array',cr_amount_array);
2826: dbms_sql.bind_array (rem_t,':c12_array',cr_acctd_amount_array);
2827: dbms_sql.bind_array (rem_t,':c13_array',cr_factor_discount_amt_array);
2828: dbms_sql.bind_array (rem_t,':c14_array',remmitance_ccid_array);
2829: dbms_sql.bind_array (rem_t,':c15_array',bank_charges_ccid_array);
2830: dbms_sql.bind_array (rem_t,':c16_array',code_combination_id_array);
2831: dbms_sql.bind_array (rem_t,':c17_array',cash_receipt_history_id_array);
2832: dbms_sql.bind_array (rem_t,':c18_array',crh_gl_date_array);
2833: dbms_sql.bind_array (rem_t,':c19_array',crh_trx_date_array);

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

2826: dbms_sql.bind_array (rem_t,':c12_array',cr_acctd_amount_array);
2827: dbms_sql.bind_array (rem_t,':c13_array',cr_factor_discount_amt_array);
2828: dbms_sql.bind_array (rem_t,':c14_array',remmitance_ccid_array);
2829: dbms_sql.bind_array (rem_t,':c15_array',bank_charges_ccid_array);
2830: dbms_sql.bind_array (rem_t,':c16_array',code_combination_id_array);
2831: dbms_sql.bind_array (rem_t,':c17_array',cash_receipt_history_id_array);
2832: dbms_sql.bind_array (rem_t,':c18_array',crh_gl_date_array);
2833: dbms_sql.bind_array (rem_t,':c19_array',crh_trx_date_array);
2834: dbms_sql.bind_array (rem_t,':c20_array',payment_server_order_num_array);

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

2827: dbms_sql.bind_array (rem_t,':c13_array',cr_factor_discount_amt_array);
2828: dbms_sql.bind_array (rem_t,':c14_array',remmitance_ccid_array);
2829: dbms_sql.bind_array (rem_t,':c15_array',bank_charges_ccid_array);
2830: dbms_sql.bind_array (rem_t,':c16_array',code_combination_id_array);
2831: dbms_sql.bind_array (rem_t,':c17_array',cash_receipt_history_id_array);
2832: dbms_sql.bind_array (rem_t,':c18_array',crh_gl_date_array);
2833: dbms_sql.bind_array (rem_t,':c19_array',crh_trx_date_array);
2834: dbms_sql.bind_array (rem_t,':c20_array',payment_server_order_num_array);
2835: dbms_sql.bind_array (rem_t,':c21_array',approval_code_array);

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

2828: dbms_sql.bind_array (rem_t,':c14_array',remmitance_ccid_array);
2829: dbms_sql.bind_array (rem_t,':c15_array',bank_charges_ccid_array);
2830: dbms_sql.bind_array (rem_t,':c16_array',code_combination_id_array);
2831: dbms_sql.bind_array (rem_t,':c17_array',cash_receipt_history_id_array);
2832: dbms_sql.bind_array (rem_t,':c18_array',crh_gl_date_array);
2833: dbms_sql.bind_array (rem_t,':c19_array',crh_trx_date_array);
2834: dbms_sql.bind_array (rem_t,':c20_array',payment_server_order_num_array);
2835: dbms_sql.bind_array (rem_t,':c21_array',approval_code_array);
2836: dbms_sql.bind_array (rem_t,':c22_array',receipt_number_array);

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

2829: dbms_sql.bind_array (rem_t,':c15_array',bank_charges_ccid_array);
2830: dbms_sql.bind_array (rem_t,':c16_array',code_combination_id_array);
2831: dbms_sql.bind_array (rem_t,':c17_array',cash_receipt_history_id_array);
2832: dbms_sql.bind_array (rem_t,':c18_array',crh_gl_date_array);
2833: dbms_sql.bind_array (rem_t,':c19_array',crh_trx_date_array);
2834: dbms_sql.bind_array (rem_t,':c20_array',payment_server_order_num_array);
2835: dbms_sql.bind_array (rem_t,':c21_array',approval_code_array);
2836: dbms_sql.bind_array (rem_t,':c22_array',receipt_number_array);
2837: dbms_sql.bind_array (rem_t,':c23_array',unique_ref_array);

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

2830: dbms_sql.bind_array (rem_t,':c16_array',code_combination_id_array);
2831: dbms_sql.bind_array (rem_t,':c17_array',cash_receipt_history_id_array);
2832: dbms_sql.bind_array (rem_t,':c18_array',crh_gl_date_array);
2833: dbms_sql.bind_array (rem_t,':c19_array',crh_trx_date_array);
2834: dbms_sql.bind_array (rem_t,':c20_array',payment_server_order_num_array);
2835: dbms_sql.bind_array (rem_t,':c21_array',approval_code_array);
2836: dbms_sql.bind_array (rem_t,':c22_array',receipt_number_array);
2837: dbms_sql.bind_array (rem_t,':c23_array',unique_ref_array);
2838: dbms_sql.bind_array (rem_t,':c24_array',customer_bank_account_id_array);

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

2831: dbms_sql.bind_array (rem_t,':c17_array',cash_receipt_history_id_array);
2832: dbms_sql.bind_array (rem_t,':c18_array',crh_gl_date_array);
2833: dbms_sql.bind_array (rem_t,':c19_array',crh_trx_date_array);
2834: dbms_sql.bind_array (rem_t,':c20_array',payment_server_order_num_array);
2835: dbms_sql.bind_array (rem_t,':c21_array',approval_code_array);
2836: dbms_sql.bind_array (rem_t,':c22_array',receipt_number_array);
2837: dbms_sql.bind_array (rem_t,':c23_array',unique_ref_array);
2838: dbms_sql.bind_array (rem_t,':c24_array',customer_bank_account_id_array);
2839: dbms_sql.bind_array (rem_t,':c25_array',payment_trxn_extn_id_array);

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

2832: dbms_sql.bind_array (rem_t,':c18_array',crh_gl_date_array);
2833: dbms_sql.bind_array (rem_t,':c19_array',crh_trx_date_array);
2834: dbms_sql.bind_array (rem_t,':c20_array',payment_server_order_num_array);
2835: dbms_sql.bind_array (rem_t,':c21_array',approval_code_array);
2836: dbms_sql.bind_array (rem_t,':c22_array',receipt_number_array);
2837: dbms_sql.bind_array (rem_t,':c23_array',unique_ref_array);
2838: dbms_sql.bind_array (rem_t,':c24_array',customer_bank_account_id_array);
2839: dbms_sql.bind_array (rem_t,':c25_array',payment_trxn_extn_id_array);
2840:

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

2833: dbms_sql.bind_array (rem_t,':c19_array',crh_trx_date_array);
2834: dbms_sql.bind_array (rem_t,':c20_array',payment_server_order_num_array);
2835: dbms_sql.bind_array (rem_t,':c21_array',approval_code_array);
2836: dbms_sql.bind_array (rem_t,':c22_array',receipt_number_array);
2837: dbms_sql.bind_array (rem_t,':c23_array',unique_ref_array);
2838: dbms_sql.bind_array (rem_t,':c24_array',customer_bank_account_id_array);
2839: dbms_sql.bind_array (rem_t,':c25_array',payment_trxn_extn_id_array);
2840:
2841:

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

2834: dbms_sql.bind_array (rem_t,':c20_array',payment_server_order_num_array);
2835: dbms_sql.bind_array (rem_t,':c21_array',approval_code_array);
2836: dbms_sql.bind_array (rem_t,':c22_array',receipt_number_array);
2837: dbms_sql.bind_array (rem_t,':c23_array',unique_ref_array);
2838: dbms_sql.bind_array (rem_t,':c24_array',customer_bank_account_id_array);
2839: dbms_sql.bind_array (rem_t,':c25_array',payment_trxn_extn_id_array);
2840:
2841:
2842: dummy := dbms_sql.execute(rem_t);

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

2835: dbms_sql.bind_array (rem_t,':c21_array',approval_code_array);
2836: dbms_sql.bind_array (rem_t,':c22_array',receipt_number_array);
2837: dbms_sql.bind_array (rem_t,':c23_array',unique_ref_array);
2838: dbms_sql.bind_array (rem_t,':c24_array',customer_bank_account_id_array);
2839: dbms_sql.bind_array (rem_t,':c25_array',payment_trxn_extn_id_array);
2840:
2841:
2842: dummy := dbms_sql.execute(rem_t);
2843:

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

2838: dbms_sql.bind_array (rem_t,':c24_array',customer_bank_account_id_array);
2839: dbms_sql.bind_array (rem_t,':c25_array',payment_trxn_extn_id_array);
2840:
2841:
2842: dummy := dbms_sql.execute(rem_t);
2843:
2844: dbms_sql.close_cursor(rem_t);
2845:
2846: EXCEPTION WHEN OTHERS THEN

Line 2844: dbms_sql.close_cursor(rem_t);

2840:
2841:
2842: dummy := dbms_sql.execute(rem_t);
2843:
2844: dbms_sql.close_cursor(rem_t);
2845:
2846: EXCEPTION WHEN OTHERS THEN
2847: if dbms_sql.is_open(rem_t) then
2848: dbms_sql.close_cursor(rem_t);

Line 2847: if dbms_sql.is_open(rem_t) then

2843:
2844: dbms_sql.close_cursor(rem_t);
2845:
2846: EXCEPTION WHEN OTHERS THEN
2847: if dbms_sql.is_open(rem_t) then
2848: dbms_sql.close_cursor(rem_t);
2849: end if;
2850: fnd_file.put_line(FND_FILE.LOG,'error code() '|| to_char(SQLCODE));
2851: raise;

Line 2848: dbms_sql.close_cursor(rem_t);

2844: dbms_sql.close_cursor(rem_t);
2845:
2846: EXCEPTION WHEN OTHERS THEN
2847: if dbms_sql.is_open(rem_t) then
2848: dbms_sql.close_cursor(rem_t);
2849: end if;
2850: fnd_file.put_line(FND_FILE.LOG,'error code() '|| to_char(SQLCODE));
2851: raise;
2852:

Line 2885: rem_t1 := dbms_sql.open_cursor;

2881: AND status = ''CONFIRMED''
2882: ';
2883:
2884:
2885: rem_t1 := dbms_sql.open_cursor;
2886:
2887: dbms_sql.parse (rem_t1,upd_stmt1,dbms_sql.v7);
2888:
2889: dbms_sql.bind_array (rem_t1,':ucrh_id_array', cash_receipt_history_id_array);

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

2883:
2884:
2885: rem_t1 := dbms_sql.open_cursor;
2886:
2887: dbms_sql.parse (rem_t1,upd_stmt1,dbms_sql.v7);
2888:
2889: dbms_sql.bind_array (rem_t1,':ucrh_id_array', cash_receipt_history_id_array);
2890: dbms_sql.bind_array (rem_t1,':ucrh_gl_date_array',crh_gl_date_array );
2891: dbms_sql.bind_array (rem_t1,':cr_id_array', cash_receipt_id_array);

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

2885: rem_t1 := dbms_sql.open_cursor;
2886:
2887: dbms_sql.parse (rem_t1,upd_stmt1,dbms_sql.v7);
2888:
2889: dbms_sql.bind_array (rem_t1,':ucrh_id_array', cash_receipt_history_id_array);
2890: dbms_sql.bind_array (rem_t1,':ucrh_gl_date_array',crh_gl_date_array );
2891: dbms_sql.bind_array (rem_t1,':cr_id_array', cash_receipt_id_array);
2892: /* who cols*/
2893:

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

2886:
2887: dbms_sql.parse (rem_t1,upd_stmt1,dbms_sql.v7);
2888:
2889: dbms_sql.bind_array (rem_t1,':ucrh_id_array', cash_receipt_history_id_array);
2890: dbms_sql.bind_array (rem_t1,':ucrh_gl_date_array',crh_gl_date_array );
2891: dbms_sql.bind_array (rem_t1,':cr_id_array', cash_receipt_id_array);
2892: /* who cols*/
2893:
2894: dbms_sql.bind_variable (rem_t1,':i_last_updated_by',l_last_updated_by);

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

2887: dbms_sql.parse (rem_t1,upd_stmt1,dbms_sql.v7);
2888:
2889: dbms_sql.bind_array (rem_t1,':ucrh_id_array', cash_receipt_history_id_array);
2890: dbms_sql.bind_array (rem_t1,':ucrh_gl_date_array',crh_gl_date_array );
2891: dbms_sql.bind_array (rem_t1,':cr_id_array', cash_receipt_id_array);
2892: /* who cols*/
2893:
2894: dbms_sql.bind_variable (rem_t1,':i_last_updated_by',l_last_updated_by);
2895: dbms_sql.bind_variable (rem_t1,':i_last_update_login',l_last_update_login);

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

2890: dbms_sql.bind_array (rem_t1,':ucrh_gl_date_array',crh_gl_date_array );
2891: dbms_sql.bind_array (rem_t1,':cr_id_array', cash_receipt_id_array);
2892: /* who cols*/
2893:
2894: dbms_sql.bind_variable (rem_t1,':i_last_updated_by',l_last_updated_by);
2895: dbms_sql.bind_variable (rem_t1,':i_last_update_login',l_last_update_login);
2896: dbms_sql.bind_variable (rem_t1,':i_request_id',l_request_id);
2897: dbms_sql.bind_variable (rem_t1,':i_program_application_id',l_program_application_id);
2898: dbms_sql.bind_variable (rem_t1,':i_program_id',l_program_id);

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

2891: dbms_sql.bind_array (rem_t1,':cr_id_array', cash_receipt_id_array);
2892: /* who cols*/
2893:
2894: dbms_sql.bind_variable (rem_t1,':i_last_updated_by',l_last_updated_by);
2895: dbms_sql.bind_variable (rem_t1,':i_last_update_login',l_last_update_login);
2896: dbms_sql.bind_variable (rem_t1,':i_request_id',l_request_id);
2897: dbms_sql.bind_variable (rem_t1,':i_program_application_id',l_program_application_id);
2898: dbms_sql.bind_variable (rem_t1,':i_program_id',l_program_id);
2899:

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

2892: /* who cols*/
2893:
2894: dbms_sql.bind_variable (rem_t1,':i_last_updated_by',l_last_updated_by);
2895: dbms_sql.bind_variable (rem_t1,':i_last_update_login',l_last_update_login);
2896: dbms_sql.bind_variable (rem_t1,':i_request_id',l_request_id);
2897: dbms_sql.bind_variable (rem_t1,':i_program_application_id',l_program_application_id);
2898: dbms_sql.bind_variable (rem_t1,':i_program_id',l_program_id);
2899:
2900: dummy := dbms_sql.execute(rem_t1);

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

2893:
2894: dbms_sql.bind_variable (rem_t1,':i_last_updated_by',l_last_updated_by);
2895: dbms_sql.bind_variable (rem_t1,':i_last_update_login',l_last_update_login);
2896: dbms_sql.bind_variable (rem_t1,':i_request_id',l_request_id);
2897: dbms_sql.bind_variable (rem_t1,':i_program_application_id',l_program_application_id);
2898: dbms_sql.bind_variable (rem_t1,':i_program_id',l_program_id);
2899:
2900: dummy := dbms_sql.execute(rem_t1);
2901:

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

2894: dbms_sql.bind_variable (rem_t1,':i_last_updated_by',l_last_updated_by);
2895: dbms_sql.bind_variable (rem_t1,':i_last_update_login',l_last_update_login);
2896: dbms_sql.bind_variable (rem_t1,':i_request_id',l_request_id);
2897: dbms_sql.bind_variable (rem_t1,':i_program_application_id',l_program_application_id);
2898: dbms_sql.bind_variable (rem_t1,':i_program_id',l_program_id);
2899:
2900: dummy := dbms_sql.execute(rem_t1);
2901:
2902: dbms_sql.close_cursor(rem_t1);

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

2896: dbms_sql.bind_variable (rem_t1,':i_request_id',l_request_id);
2897: dbms_sql.bind_variable (rem_t1,':i_program_application_id',l_program_application_id);
2898: dbms_sql.bind_variable (rem_t1,':i_program_id',l_program_id);
2899:
2900: dummy := dbms_sql.execute(rem_t1);
2901:
2902: dbms_sql.close_cursor(rem_t1);
2903:
2904: IF PG_DEBUG in ('Y', 'C') THEN

Line 2902: dbms_sql.close_cursor(rem_t1);

2898: dbms_sql.bind_variable (rem_t1,':i_program_id',l_program_id);
2899:
2900: dummy := dbms_sql.execute(rem_t1);
2901:
2902: dbms_sql.close_cursor(rem_t1);
2903:
2904: IF PG_DEBUG in ('Y', 'C') THEN
2905: arp_standard.debug (to_char(SQL%ROWCOUNT) || ' row(s) updated.');
2906: fnd_file.put_line(FND_FILE.LOG,'upd-crh1 ()-');

Line 2910: if dbms_sql.is_open(rem_t1) then

2906: fnd_file.put_line(FND_FILE.LOG,'upd-crh1 ()-');
2907: END IF;
2908:
2909: EXCEPTION WHEN OTHERS THEN
2910: if dbms_sql.is_open(rem_t1) then
2911: dbms_sql.close_cursor(rem_t1);
2912: end if;
2913: IF PG_DEBUG in ('Y', 'C') THEN
2914: fnd_file.put_line(FND_FILE.LOG,'failed to update() '|| to_char(SQLCODE));

Line 2911: dbms_sql.close_cursor(rem_t1);

2907: END IF;
2908:
2909: EXCEPTION WHEN OTHERS THEN
2910: if dbms_sql.is_open(rem_t1) then
2911: dbms_sql.close_cursor(rem_t1);
2912: end if;
2913: IF PG_DEBUG in ('Y', 'C') THEN
2914: fnd_file.put_line(FND_FILE.LOG,'failed to update() '|| to_char(SQLCODE));
2915: END IF;

Line 3037: rem_t3 := dbms_sql.open_cursor;

3033: sysdate
3034: FROM AR_REMIT_GT r
3035: WHERE r.cash_receipt_history_id is not null';
3036:
3037: rem_t3 := dbms_sql.open_cursor;
3038:
3039: dbms_sql.parse (rem_t3,ins_crh1,dbms_sql.v7);
3040:
3041: IF PG_DEBUG in ('Y', 'C') THEN

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

3035: WHERE r.cash_receipt_history_id is not null';
3036:
3037: rem_t3 := dbms_sql.open_cursor;
3038:
3039: dbms_sql.parse (rem_t3,ins_crh1,dbms_sql.v7);
3040:
3041: IF PG_DEBUG in ('Y', 'C') THEN
3042: fnd_file.put_line(FND_FILE.LOG, 'the batch_id ' || p_batch_id);
3043: END IF;

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

3042: fnd_file.put_line(FND_FILE.LOG, 'the batch_id ' || p_batch_id);
3043: END IF;
3044:
3045:
3046: dbms_sql.bind_variable (rem_t3,':i_batch_id',p_batch_id);
3047: dbms_sql.bind_variable (rem_t3,':factor_flag',l_factor_flag);
3048: /* who cols */
3049: dbms_sql.bind_variable (rem_t3,':i_created_by',l_created_by);
3050: dbms_sql.bind_variable (rem_t3,':i_last_updated_by',l_last_updated_by);

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

3043: END IF;
3044:
3045:
3046: dbms_sql.bind_variable (rem_t3,':i_batch_id',p_batch_id);
3047: dbms_sql.bind_variable (rem_t3,':factor_flag',l_factor_flag);
3048: /* who cols */
3049: dbms_sql.bind_variable (rem_t3,':i_created_by',l_created_by);
3050: dbms_sql.bind_variable (rem_t3,':i_last_updated_by',l_last_updated_by);
3051: dbms_sql.bind_variable (rem_t3,':i_last_update_login',l_last_update_login);

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

3045:
3046: dbms_sql.bind_variable (rem_t3,':i_batch_id',p_batch_id);
3047: dbms_sql.bind_variable (rem_t3,':factor_flag',l_factor_flag);
3048: /* who cols */
3049: dbms_sql.bind_variable (rem_t3,':i_created_by',l_created_by);
3050: dbms_sql.bind_variable (rem_t3,':i_last_updated_by',l_last_updated_by);
3051: dbms_sql.bind_variable (rem_t3,':i_last_update_login',l_last_update_login);
3052: dbms_sql.bind_variable (rem_t3,':i_request_id',l_request_id);
3053: dbms_sql.bind_variable (rem_t3,':i_org_id',l_org_id);

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

3046: dbms_sql.bind_variable (rem_t3,':i_batch_id',p_batch_id);
3047: dbms_sql.bind_variable (rem_t3,':factor_flag',l_factor_flag);
3048: /* who cols */
3049: dbms_sql.bind_variable (rem_t3,':i_created_by',l_created_by);
3050: dbms_sql.bind_variable (rem_t3,':i_last_updated_by',l_last_updated_by);
3051: dbms_sql.bind_variable (rem_t3,':i_last_update_login',l_last_update_login);
3052: dbms_sql.bind_variable (rem_t3,':i_request_id',l_request_id);
3053: dbms_sql.bind_variable (rem_t3,':i_org_id',l_org_id);
3054: dbms_sql.bind_variable (rem_t3,':i_program_application_id',l_program_application_id);

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

3047: dbms_sql.bind_variable (rem_t3,':factor_flag',l_factor_flag);
3048: /* who cols */
3049: dbms_sql.bind_variable (rem_t3,':i_created_by',l_created_by);
3050: dbms_sql.bind_variable (rem_t3,':i_last_updated_by',l_last_updated_by);
3051: dbms_sql.bind_variable (rem_t3,':i_last_update_login',l_last_update_login);
3052: dbms_sql.bind_variable (rem_t3,':i_request_id',l_request_id);
3053: dbms_sql.bind_variable (rem_t3,':i_org_id',l_org_id);
3054: dbms_sql.bind_variable (rem_t3,':i_program_application_id',l_program_application_id);
3055: dbms_sql.bind_variable (rem_t3,':i_program_id',l_program_id);

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

3048: /* who cols */
3049: dbms_sql.bind_variable (rem_t3,':i_created_by',l_created_by);
3050: dbms_sql.bind_variable (rem_t3,':i_last_updated_by',l_last_updated_by);
3051: dbms_sql.bind_variable (rem_t3,':i_last_update_login',l_last_update_login);
3052: dbms_sql.bind_variable (rem_t3,':i_request_id',l_request_id);
3053: dbms_sql.bind_variable (rem_t3,':i_org_id',l_org_id);
3054: dbms_sql.bind_variable (rem_t3,':i_program_application_id',l_program_application_id);
3055: dbms_sql.bind_variable (rem_t3,':i_program_id',l_program_id);
3056:

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

3049: dbms_sql.bind_variable (rem_t3,':i_created_by',l_created_by);
3050: dbms_sql.bind_variable (rem_t3,':i_last_updated_by',l_last_updated_by);
3051: dbms_sql.bind_variable (rem_t3,':i_last_update_login',l_last_update_login);
3052: dbms_sql.bind_variable (rem_t3,':i_request_id',l_request_id);
3053: dbms_sql.bind_variable (rem_t3,':i_org_id',l_org_id);
3054: dbms_sql.bind_variable (rem_t3,':i_program_application_id',l_program_application_id);
3055: dbms_sql.bind_variable (rem_t3,':i_program_id',l_program_id);
3056:
3057:

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

3050: dbms_sql.bind_variable (rem_t3,':i_last_updated_by',l_last_updated_by);
3051: dbms_sql.bind_variable (rem_t3,':i_last_update_login',l_last_update_login);
3052: dbms_sql.bind_variable (rem_t3,':i_request_id',l_request_id);
3053: dbms_sql.bind_variable (rem_t3,':i_org_id',l_org_id);
3054: dbms_sql.bind_variable (rem_t3,':i_program_application_id',l_program_application_id);
3055: dbms_sql.bind_variable (rem_t3,':i_program_id',l_program_id);
3056:
3057:
3058: IF PG_DEBUG in ('Y', 'C') THEN

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

3051: dbms_sql.bind_variable (rem_t3,':i_last_update_login',l_last_update_login);
3052: dbms_sql.bind_variable (rem_t3,':i_request_id',l_request_id);
3053: dbms_sql.bind_variable (rem_t3,':i_org_id',l_org_id);
3054: dbms_sql.bind_variable (rem_t3,':i_program_application_id',l_program_application_id);
3055: dbms_sql.bind_variable (rem_t3,':i_program_id',l_program_id);
3056:
3057:
3058: IF PG_DEBUG in ('Y', 'C') THEN
3059: fnd_file.put_line(FND_FILE.LOG, 'the insert statemnt' || ins_crh1);

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

3058: IF PG_DEBUG in ('Y', 'C') THEN
3059: fnd_file.put_line(FND_FILE.LOG, 'the insert statemnt' || ins_crh1);
3060: END IF;
3061:
3062: dummy := dbms_sql.execute(rem_t3);
3063:
3064: dbms_sql.close_cursor(rem_t3);
3065:
3066:

Line 3064: dbms_sql.close_cursor(rem_t3);

3060: END IF;
3061:
3062: dummy := dbms_sql.execute(rem_t3);
3063:
3064: dbms_sql.close_cursor(rem_t3);
3065:
3066:
3067: /* BICHATTE after the insert into crh we have to fire the XLA event */
3068:

Line 3100: if dbms_sql.is_open(rem_t3) then

3096:
3097:
3098: EXCEPTION WHEN OTHERS THEN
3099: fnd_file.put_line(FND_FILE.LOG, 'the insert statemnt' || ins_crh1);
3100: if dbms_sql.is_open(rem_t3) then
3101: dbms_sql.close_cursor(rem_t3);
3102: end if;
3103: IF PG_DEBUG in ('Y', 'C') THEN
3104: fnd_file.put_line(FND_FILE.LOG,'failed to insert() '|| to_char(SQLCODE));

Line 3101: dbms_sql.close_cursor(rem_t3);

3097:
3098: EXCEPTION WHEN OTHERS THEN
3099: fnd_file.put_line(FND_FILE.LOG, 'the insert statemnt' || ins_crh1);
3100: if dbms_sql.is_open(rem_t3) then
3101: dbms_sql.close_cursor(rem_t3);
3102: end if;
3103: IF PG_DEBUG in ('Y', 'C') THEN
3104: fnd_file.put_line(FND_FILE.LOG,'failed to insert() '|| to_char(SQLCODE));
3105: fnd_file.put_line(FND_FILE.LOG, 'the insert statemnt' || ins_crh1);

Line 3207: rem_t4 := dbms_sql.open_cursor;

3203: WHERE crh.cash_receipt_history_id = r.cash_receipt_history_id
3204: AND l.lookup_type = ''AR_CARTESIAN_JOIN''
3205: AND l.lookup_code IN (''1'',''2'')';
3206:
3207: rem_t4 := dbms_sql.open_cursor;
3208:
3209: dbms_sql.parse (rem_t4,ins_dist1,dbms_sql.v7);
3210:
3211: IF PG_DEBUG in ('Y', 'C') THEN

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

3205: AND l.lookup_code IN (''1'',''2'')';
3206:
3207: rem_t4 := dbms_sql.open_cursor;
3208:
3209: dbms_sql.parse (rem_t4,ins_dist1,dbms_sql.v7);
3210:
3211: IF PG_DEBUG in ('Y', 'C') THEN
3212: fnd_file.put_line(FND_FILE.LOG, 'the insert dist statement is ' || ins_dist1);
3213: END IF;

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

3211: IF PG_DEBUG in ('Y', 'C') THEN
3212: fnd_file.put_line(FND_FILE.LOG, 'the insert dist statement is ' || ins_dist1);
3213: END IF;
3214:
3215: dbms_sql.bind_variable (rem_t4,':factor_flag',l_factor_flag);
3216: /* who cols */
3217: dbms_sql.bind_variable (rem_t4,':i_created_by',l_created_by);
3218: dbms_sql.bind_variable (rem_t4,':i_last_updated_by',l_last_updated_by);
3219: dbms_sql.bind_variable (rem_t4,':i_org_id',l_org_id);

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

3213: END IF;
3214:
3215: dbms_sql.bind_variable (rem_t4,':factor_flag',l_factor_flag);
3216: /* who cols */
3217: dbms_sql.bind_variable (rem_t4,':i_created_by',l_created_by);
3218: dbms_sql.bind_variable (rem_t4,':i_last_updated_by',l_last_updated_by);
3219: dbms_sql.bind_variable (rem_t4,':i_org_id',l_org_id);
3220: dbms_sql.bind_variable (rem_t4,':i_last_update_login',l_last_update_login);
3221:

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

3214:
3215: dbms_sql.bind_variable (rem_t4,':factor_flag',l_factor_flag);
3216: /* who cols */
3217: dbms_sql.bind_variable (rem_t4,':i_created_by',l_created_by);
3218: dbms_sql.bind_variable (rem_t4,':i_last_updated_by',l_last_updated_by);
3219: dbms_sql.bind_variable (rem_t4,':i_org_id',l_org_id);
3220: dbms_sql.bind_variable (rem_t4,':i_last_update_login',l_last_update_login);
3221:
3222:

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

3215: dbms_sql.bind_variable (rem_t4,':factor_flag',l_factor_flag);
3216: /* who cols */
3217: dbms_sql.bind_variable (rem_t4,':i_created_by',l_created_by);
3218: dbms_sql.bind_variable (rem_t4,':i_last_updated_by',l_last_updated_by);
3219: dbms_sql.bind_variable (rem_t4,':i_org_id',l_org_id);
3220: dbms_sql.bind_variable (rem_t4,':i_last_update_login',l_last_update_login);
3221:
3222:
3223: d2 := dbms_sql.execute(rem_t4);

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

3216: /* who cols */
3217: dbms_sql.bind_variable (rem_t4,':i_created_by',l_created_by);
3218: dbms_sql.bind_variable (rem_t4,':i_last_updated_by',l_last_updated_by);
3219: dbms_sql.bind_variable (rem_t4,':i_org_id',l_org_id);
3220: dbms_sql.bind_variable (rem_t4,':i_last_update_login',l_last_update_login);
3221:
3222:
3223: d2 := dbms_sql.execute(rem_t4);
3224:

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

3219: dbms_sql.bind_variable (rem_t4,':i_org_id',l_org_id);
3220: dbms_sql.bind_variable (rem_t4,':i_last_update_login',l_last_update_login);
3221:
3222:
3223: d2 := dbms_sql.execute(rem_t4);
3224:
3225: dbms_sql.close_cursor(rem_t4);
3226:
3227: IF PG_DEBUG in ('Y', 'C') THEN

Line 3225: dbms_sql.close_cursor(rem_t4);

3221:
3222:
3223: d2 := dbms_sql.execute(rem_t4);
3224:
3225: dbms_sql.close_cursor(rem_t4);
3226:
3227: IF PG_DEBUG in ('Y', 'C') THEN
3228: fnd_file.put_line(FND_FILE.LOG,'ins_dist1 ()-');
3229: END IF;

Line 3232: if dbms_sql.is_open(rem_t4) then

3228: fnd_file.put_line(FND_FILE.LOG,'ins_dist1 ()-');
3229: END IF;
3230:
3231: EXCEPTION WHEN OTHERS THEN
3232: if dbms_sql.is_open(rem_t4) then
3233: dbms_sql.close_cursor(rem_t4);
3234: end if;
3235: IF PG_DEBUG in ('Y', 'C') THEN
3236: fnd_file.put_line(FND_FILE.LOG, 'the insert dist statement is ' || ins_dist1);

Line 3233: dbms_sql.close_cursor(rem_t4);

3229: END IF;
3230:
3231: EXCEPTION WHEN OTHERS THEN
3232: if dbms_sql.is_open(rem_t4) then
3233: dbms_sql.close_cursor(rem_t4);
3234: end if;
3235: IF PG_DEBUG in ('Y', 'C') THEN
3236: fnd_file.put_line(FND_FILE.LOG, 'the insert dist statement is ' || ins_dist1);
3237: fnd_file.put_line(FND_FILE.LOG,'DIST failed to insert() '|| to_char(SQLCODE));

Line 3307: cash_receipt_id_array dbms_sql.Number_Table;

3303: l_rows_fetched INTEGER;
3304: p_cash_receipt_id NUMBER(15);
3305: p_amount ar_cash_receipts.amount%TYPE;
3306: p_payment_method_id ar_receipt_methods.receipt_method_id%TYPE;
3307: cash_receipt_id_array dbms_sql.Number_Table;
3308: cr_id_array dbms_sql.Number_Table;
3309: amt_array dbms_sql.Number_Table;
3310: ins_recs INTEGER;
3311:

Line 3308: cr_id_array dbms_sql.Number_Table;

3304: p_cash_receipt_id NUMBER(15);
3305: p_amount ar_cash_receipts.amount%TYPE;
3306: p_payment_method_id ar_receipt_methods.receipt_method_id%TYPE;
3307: cash_receipt_id_array dbms_sql.Number_Table;
3308: cr_id_array dbms_sql.Number_Table;
3309: amt_array dbms_sql.Number_Table;
3310: ins_recs INTEGER;
3311:
3312: i number;

Line 3309: amt_array dbms_sql.Number_Table;

3305: p_amount ar_cash_receipts.amount%TYPE;
3306: p_payment_method_id ar_receipt_methods.receipt_method_id%TYPE;
3307: cash_receipt_id_array dbms_sql.Number_Table;
3308: cr_id_array dbms_sql.Number_Table;
3309: amt_array dbms_sql.Number_Table;
3310: ins_recs INTEGER;
3311:
3312: i number;
3313: dummy number;

Line 3371: ins_recs := dbms_sql.open_cursor;

3367: crh.current_record_flag = ''Y'' ';
3368: commit;
3369: execute immediate 'alter session enable parallel dml';
3370: --move all the receipts in confirmed status to GT table
3371: ins_recs := dbms_sql.open_cursor;
3372: dbms_sql.parse (ins_recs, ins_stmt, dbms_sql.v7);
3373: ignore := dbms_sql.execute(ins_recs);
3374: commit;
3375:

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

3368: commit;
3369: execute immediate 'alter session enable parallel dml';
3370: --move all the receipts in confirmed status to GT table
3371: ins_recs := dbms_sql.open_cursor;
3372: dbms_sql.parse (ins_recs, ins_stmt, dbms_sql.v7);
3373: ignore := dbms_sql.execute(ins_recs);
3374: commit;
3375:
3376: IF PG_PARALLEL IN ('Y', 'C') THEN

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

3369: execute immediate 'alter session enable parallel dml';
3370: --move all the receipts in confirmed status to GT table
3371: ins_recs := dbms_sql.open_cursor;
3372: dbms_sql.parse (ins_recs, ins_stmt, dbms_sql.v7);
3373: ignore := dbms_sql.execute(ins_recs);
3374: commit;
3375:
3376: IF PG_PARALLEL IN ('Y', 'C') THEN
3377: 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) */';

Line 3502: remit_recs := dbms_sql.open_cursor;

3498: WHERE selected_remittance_batch_id is null ';
3499:
3500: l_sel_stmt := upd_stmt2 ||' AND cash_receipt_id IN ( '|| l_sel_stmt || ')';
3501:
3502: remit_recs := dbms_sql.open_cursor;
3503:
3504: dbms_sql.parse (remit_recs,l_sel_stmt,dbms_sql.v7);
3505:
3506: /* bind the variables used in update statement */

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

3500: l_sel_stmt := upd_stmt2 ||' AND cash_receipt_id IN ( '|| l_sel_stmt || ')';
3501:
3502: remit_recs := dbms_sql.open_cursor;
3503:
3504: dbms_sql.parse (remit_recs,l_sel_stmt,dbms_sql.v7);
3505:
3506: /* bind the variables used in update statement */
3507: dbms_sql.bind_variable (remit_recs,':u_batch_id',p_batch_id);
3508: dbms_sql.bind_variable (remit_recs,':u_remit_bank_account_id',p_remit_bank_account_id);

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

3503:
3504: dbms_sql.parse (remit_recs,l_sel_stmt,dbms_sql.v7);
3505:
3506: /* bind the variables used in update statement */
3507: dbms_sql.bind_variable (remit_recs,':u_batch_id',p_batch_id);
3508: dbms_sql.bind_variable (remit_recs,':u_remit_bank_account_id',p_remit_bank_account_id);
3509:
3510: /* who cols */
3511: dbms_sql.bind_variable (remit_recs,':i_last_updated_by',l_last_updated_by);

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

3504: dbms_sql.parse (remit_recs,l_sel_stmt,dbms_sql.v7);
3505:
3506: /* bind the variables used in update statement */
3507: dbms_sql.bind_variable (remit_recs,':u_batch_id',p_batch_id);
3508: dbms_sql.bind_variable (remit_recs,':u_remit_bank_account_id',p_remit_bank_account_id);
3509:
3510: /* who cols */
3511: dbms_sql.bind_variable (remit_recs,':i_last_updated_by',l_last_updated_by);
3512: dbms_sql.bind_variable (remit_recs,':i_last_update_login',l_last_update_login);

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

3507: dbms_sql.bind_variable (remit_recs,':u_batch_id',p_batch_id);
3508: dbms_sql.bind_variable (remit_recs,':u_remit_bank_account_id',p_remit_bank_account_id);
3509:
3510: /* who cols */
3511: dbms_sql.bind_variable (remit_recs,':i_last_updated_by',l_last_updated_by);
3512: dbms_sql.bind_variable (remit_recs,':i_last_update_login',l_last_update_login);
3513: dbms_sql.bind_variable (remit_recs,':i_request_id',l_request_id);
3514: dbms_sql.bind_variable (remit_recs,':i_program_application_id',l_program_application_id);
3515: dbms_sql.bind_variable (remit_recs,':i_program_id',l_program_id);

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

3508: dbms_sql.bind_variable (remit_recs,':u_remit_bank_account_id',p_remit_bank_account_id);
3509:
3510: /* who cols */
3511: dbms_sql.bind_variable (remit_recs,':i_last_updated_by',l_last_updated_by);
3512: dbms_sql.bind_variable (remit_recs,':i_last_update_login',l_last_update_login);
3513: dbms_sql.bind_variable (remit_recs,':i_request_id',l_request_id);
3514: dbms_sql.bind_variable (remit_recs,':i_program_application_id',l_program_application_id);
3515: dbms_sql.bind_variable (remit_recs,':i_program_id',l_program_id);
3516:

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

3509:
3510: /* who cols */
3511: dbms_sql.bind_variable (remit_recs,':i_last_updated_by',l_last_updated_by);
3512: dbms_sql.bind_variable (remit_recs,':i_last_update_login',l_last_update_login);
3513: dbms_sql.bind_variable (remit_recs,':i_request_id',l_request_id);
3514: dbms_sql.bind_variable (remit_recs,':i_program_application_id',l_program_application_id);
3515: dbms_sql.bind_variable (remit_recs,':i_program_id',l_program_id);
3516:
3517: /* bind the variables */

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

3510: /* who cols */
3511: dbms_sql.bind_variable (remit_recs,':i_last_updated_by',l_last_updated_by);
3512: dbms_sql.bind_variable (remit_recs,':i_last_update_login',l_last_update_login);
3513: dbms_sql.bind_variable (remit_recs,':i_request_id',l_request_id);
3514: dbms_sql.bind_variable (remit_recs,':i_program_application_id',l_program_application_id);
3515: dbms_sql.bind_variable (remit_recs,':i_program_id',l_program_id);
3516:
3517: /* bind the variables */
3518: dbms_sql.bind_variable (remit_recs,':bs_receipt_method_id',p_receipt_method_id);

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

3511: dbms_sql.bind_variable (remit_recs,':i_last_updated_by',l_last_updated_by);
3512: dbms_sql.bind_variable (remit_recs,':i_last_update_login',l_last_update_login);
3513: dbms_sql.bind_variable (remit_recs,':i_request_id',l_request_id);
3514: dbms_sql.bind_variable (remit_recs,':i_program_application_id',l_program_application_id);
3515: dbms_sql.bind_variable (remit_recs,':i_program_id',l_program_id);
3516:
3517: /* bind the variables */
3518: dbms_sql.bind_variable (remit_recs,':bs_receipt_method_id',p_receipt_method_id);
3519: dbms_sql.bind_variable (remit_recs,':bs_currency',p_currency_code);

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

3514: dbms_sql.bind_variable (remit_recs,':i_program_application_id',l_program_application_id);
3515: dbms_sql.bind_variable (remit_recs,':i_program_id',l_program_id);
3516:
3517: /* bind the variables */
3518: dbms_sql.bind_variable (remit_recs,':bs_receipt_method_id',p_receipt_method_id);
3519: dbms_sql.bind_variable (remit_recs,':bs_currency',p_currency_code);
3520:
3521: IF p_receipt_method_id IS NOT NULL THEN
3522: dbms_sql.bind_variable (remit_recs,':bs_payment_type_code', p_payment_type_code);

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

3515: dbms_sql.bind_variable (remit_recs,':i_program_id',l_program_id);
3516:
3517: /* bind the variables */
3518: dbms_sql.bind_variable (remit_recs,':bs_receipt_method_id',p_receipt_method_id);
3519: dbms_sql.bind_variable (remit_recs,':bs_currency',p_currency_code);
3520:
3521: IF p_receipt_method_id IS NOT NULL THEN
3522: dbms_sql.bind_variable (remit_recs,':bs_payment_type_code', p_payment_type_code);
3523: END IF;

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

3518: dbms_sql.bind_variable (remit_recs,':bs_receipt_method_id',p_receipt_method_id);
3519: dbms_sql.bind_variable (remit_recs,':bs_currency',p_currency_code);
3520:
3521: IF p_receipt_method_id IS NOT NULL THEN
3522: dbms_sql.bind_variable (remit_recs,':bs_payment_type_code', p_payment_type_code);
3523: END IF;
3524:
3525: dbms_sql.bind_variable (remit_recs,':bs_sob_id', p_sob_id);
3526: dbms_sql.bind_variable (remit_recs,':bs_remit_method_code',p_remit_method_code);

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

3521: IF p_receipt_method_id IS NOT NULL THEN
3522: dbms_sql.bind_variable (remit_recs,':bs_payment_type_code', p_payment_type_code);
3523: END IF;
3524:
3525: dbms_sql.bind_variable (remit_recs,':bs_sob_id', p_sob_id);
3526: dbms_sql.bind_variable (remit_recs,':bs_remit_method_code',p_remit_method_code);
3527: dbms_sql.bind_variable (remit_recs,':bs_remit_account_id', p_remit_bank_account_id);
3528:
3529: IF p_customer_number_l IS NOT NULL THEN

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

3522: dbms_sql.bind_variable (remit_recs,':bs_payment_type_code', p_payment_type_code);
3523: END IF;
3524:
3525: dbms_sql.bind_variable (remit_recs,':bs_sob_id', p_sob_id);
3526: dbms_sql.bind_variable (remit_recs,':bs_remit_method_code',p_remit_method_code);
3527: dbms_sql.bind_variable (remit_recs,':bs_remit_account_id', p_remit_bank_account_id);
3528:
3529: IF p_customer_number_l IS NOT NULL THEN
3530: dbms_sql.bind_variable (remit_recs,':customer_number_l',p_customer_number_l);

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

3523: END IF;
3524:
3525: dbms_sql.bind_variable (remit_recs,':bs_sob_id', p_sob_id);
3526: dbms_sql.bind_variable (remit_recs,':bs_remit_method_code',p_remit_method_code);
3527: dbms_sql.bind_variable (remit_recs,':bs_remit_account_id', p_remit_bank_account_id);
3528:
3529: IF p_customer_number_l IS NOT NULL THEN
3530: dbms_sql.bind_variable (remit_recs,':customer_number_l',p_customer_number_l);
3531: END IF;

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

3526: dbms_sql.bind_variable (remit_recs,':bs_remit_method_code',p_remit_method_code);
3527: dbms_sql.bind_variable (remit_recs,':bs_remit_account_id', p_remit_bank_account_id);
3528:
3529: IF p_customer_number_l IS NOT NULL THEN
3530: dbms_sql.bind_variable (remit_recs,':customer_number_l',p_customer_number_l);
3531: END IF;
3532:
3533: IF p_customer_number_h IS NOT NULL THEN
3534: dbms_sql.bind_variable (remit_recs,':customer_number_h',p_customer_number_h);

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

3530: dbms_sql.bind_variable (remit_recs,':customer_number_l',p_customer_number_l);
3531: END IF;
3532:
3533: IF p_customer_number_h IS NOT NULL THEN
3534: dbms_sql.bind_variable (remit_recs,':customer_number_h',p_customer_number_h);
3535: END IF;
3536:
3537: IF p_due_date_l IS NOT NULL THEN
3538: dbms_sql.bind_variable (remit_recs,':due_date_l',p_due_date_l);

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

3534: dbms_sql.bind_variable (remit_recs,':customer_number_h',p_customer_number_h);
3535: END IF;
3536:
3537: IF p_due_date_l IS NOT NULL THEN
3538: dbms_sql.bind_variable (remit_recs,':due_date_l',p_due_date_l);
3539: END IF;
3540:
3541: IF p_due_date_h IS NOT NULL THEN
3542: dbms_sql.bind_variable (remit_recs,':due_date_h',p_due_date_h);

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

3538: dbms_sql.bind_variable (remit_recs,':due_date_l',p_due_date_l);
3539: END IF;
3540:
3541: IF p_due_date_h IS NOT NULL THEN
3542: dbms_sql.bind_variable (remit_recs,':due_date_h',p_due_date_h);
3543: END IF;
3544:
3545: IF p_trx_date_l IS NOT NULL THEN
3546: dbms_sql.bind_variable (remit_recs,':trx_date_l',p_trx_date_l);

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

3542: dbms_sql.bind_variable (remit_recs,':due_date_h',p_due_date_h);
3543: END IF;
3544:
3545: IF p_trx_date_l IS NOT NULL THEN
3546: dbms_sql.bind_variable (remit_recs,':trx_date_l',p_trx_date_l);
3547: END IF;
3548:
3549: IF p_trx_date_h IS NOT NULL THEN
3550: dbms_sql.bind_variable (remit_recs,':trx_date_h',p_trx_date_h);

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

3546: dbms_sql.bind_variable (remit_recs,':trx_date_l',p_trx_date_l);
3547: END IF;
3548:
3549: IF p_trx_date_h IS NOT NULL THEN
3550: dbms_sql.bind_variable (remit_recs,':trx_date_h',p_trx_date_h);
3551: END IF;
3552:
3553: IF p_trx_num_l IS NOT NULL THEN
3554: dbms_sql.bind_variable (remit_recs,':rcpt_number_l',p_trx_num_l);

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

3550: dbms_sql.bind_variable (remit_recs,':trx_date_h',p_trx_date_h);
3551: END IF;
3552:
3553: IF p_trx_num_l IS NOT NULL THEN
3554: dbms_sql.bind_variable (remit_recs,':rcpt_number_l',p_trx_num_l);
3555: END IF;
3556:
3557: IF p_trx_num_h IS NOT NULL THEN
3558: dbms_sql.bind_variable (remit_recs,':rcpt_number_h',p_trx_num_h);

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

3554: dbms_sql.bind_variable (remit_recs,':rcpt_number_l',p_trx_num_l);
3555: END IF;
3556:
3557: IF p_trx_num_h IS NOT NULL THEN
3558: dbms_sql.bind_variable (remit_recs,':rcpt_number_h',p_trx_num_h);
3559: END IF;
3560:
3561: IF p_remittance_total_to IS NOT NULL THEN
3562: dbms_sql.bind_variable (remit_recs,':remittance_total_to',p_remittance_total_to );

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

3558: dbms_sql.bind_variable (remit_recs,':rcpt_number_h',p_trx_num_h);
3559: END IF;
3560:
3561: IF p_remittance_total_to IS NOT NULL THEN
3562: dbms_sql.bind_variable (remit_recs,':remittance_total_to',p_remittance_total_to );
3563: END IF;
3564:
3565: IF p_remittance_total_from IS NOT NULL THEN
3566: dbms_sql.bind_variable (remit_recs,':remittance_total_from',p_remittance_total_from );

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

3562: dbms_sql.bind_variable (remit_recs,':remittance_total_to',p_remittance_total_to );
3563: END IF;
3564:
3565: IF p_remittance_total_from IS NOT NULL THEN
3566: dbms_sql.bind_variable (remit_recs,':remittance_total_from',p_remittance_total_from );
3567: END IF;
3568:
3569: IF PG_DEBUG in ('Y', 'C') THEN
3570: fnd_file.put_line(FND_FILE.LOG, 'the select statemnt' || l_sel_stmt);

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

3571: END IF;
3572:
3573: commit;
3574: execute immediate 'alter session enable parallel dml';
3575: l_rows_processed := dbms_sql.execute( remit_recs );
3576: commit;
3577:
3578: l_rows_fetched := dbms_sql.last_row_count ;
3579:

Line 3578: l_rows_fetched := dbms_sql.last_row_count ;

3574: execute immediate 'alter session enable parallel dml';
3575: l_rows_processed := dbms_sql.execute( remit_recs );
3576: commit;
3577:
3578: l_rows_fetched := dbms_sql.last_row_count ;
3579:
3580: IF PG_DEBUG in ('Y', 'C') THEN
3581: fnd_file.put_line(FND_FILE.LOG,'the no of rows fetched ' || l_rows_fetched);
3582: END IF;

Line 3584: dbms_sql.close_cursor( remit_recs );

3580: IF PG_DEBUG in ('Y', 'C') THEN
3581: fnd_file.put_line(FND_FILE.LOG,'the no of rows fetched ' || l_rows_fetched);
3582: END IF;
3583:
3584: dbms_sql.close_cursor( remit_recs );
3585:
3586: IF PG_DEBUG in ('Y', 'C') THEN
3587: fnd_file.put_line(FND_FILE.LOG,'sel_and_update recs ()-');
3588: END IF;