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_AUTOREC_API dependencies on DBMS_SQL

Line 1593: ps_id_array dbms_sql.NUmber_Table;

1589: l_total_workers NUMBER;
1590:
1591: -- insert variables
1592: inst_stmt varchar2(1000);
1593: ps_id_array dbms_sql.NUmber_Table;
1594: trx_id_array dbms_sql.NUmber_Table;
1595: cr_id_array dbms_sql.Number_Table;
1596: paying_customer_id_array dbms_sql.Number_Table;
1597: paying_site_use_id_array dbms_sql.Number_Table;

Line 1594: trx_id_array dbms_sql.NUmber_Table;

1590:
1591: -- insert variables
1592: inst_stmt varchar2(1000);
1593: ps_id_array dbms_sql.NUmber_Table;
1594: trx_id_array dbms_sql.NUmber_Table;
1595: cr_id_array dbms_sql.Number_Table;
1596: paying_customer_id_array dbms_sql.Number_Table;
1597: paying_site_use_id_array dbms_sql.Number_Table;
1598: due_date_array dbms_sql.date_Table;

Line 1595: cr_id_array dbms_sql.Number_Table;

1591: -- insert variables
1592: inst_stmt varchar2(1000);
1593: ps_id_array dbms_sql.NUmber_Table;
1594: trx_id_array dbms_sql.NUmber_Table;
1595: cr_id_array dbms_sql.Number_Table;
1596: paying_customer_id_array dbms_sql.Number_Table;
1597: paying_site_use_id_array dbms_sql.Number_Table;
1598: due_date_array dbms_sql.date_Table;
1599: adr_array dbms_sql.Number_Table;

Line 1596: paying_customer_id_array dbms_sql.Number_Table;

1592: inst_stmt varchar2(1000);
1593: ps_id_array dbms_sql.NUmber_Table;
1594: trx_id_array dbms_sql.NUmber_Table;
1595: cr_id_array dbms_sql.Number_Table;
1596: paying_customer_id_array dbms_sql.Number_Table;
1597: paying_site_use_id_array dbms_sql.Number_Table;
1598: due_date_array dbms_sql.date_Table;
1599: adr_array dbms_sql.Number_Table;
1600: cust_bank_acct_id_array dbms_sql.Number_Table;

Line 1597: paying_site_use_id_array dbms_sql.Number_Table;

1593: ps_id_array dbms_sql.NUmber_Table;
1594: trx_id_array dbms_sql.NUmber_Table;
1595: cr_id_array dbms_sql.Number_Table;
1596: paying_customer_id_array dbms_sql.Number_Table;
1597: paying_site_use_id_array dbms_sql.Number_Table;
1598: due_date_array dbms_sql.date_Table;
1599: adr_array dbms_sql.Number_Table;
1600: cust_bank_acct_id_array dbms_sql.Number_Table;
1601: cust_min_amt_array dbms_sql.Number_Table;

Line 1598: due_date_array dbms_sql.date_Table;

1594: trx_id_array dbms_sql.NUmber_Table;
1595: cr_id_array dbms_sql.Number_Table;
1596: paying_customer_id_array dbms_sql.Number_Table;
1597: paying_site_use_id_array dbms_sql.Number_Table;
1598: due_date_array dbms_sql.date_Table;
1599: adr_array dbms_sql.Number_Table;
1600: cust_bank_acct_id_array dbms_sql.Number_Table;
1601: cust_min_amt_array dbms_sql.Number_Table;
1602: pmt_trxn_ext_id_array dbms_sql.Number_Table;

Line 1599: adr_array dbms_sql.Number_Table;

1595: cr_id_array dbms_sql.Number_Table;
1596: paying_customer_id_array dbms_sql.Number_Table;
1597: paying_site_use_id_array dbms_sql.Number_Table;
1598: due_date_array dbms_sql.date_Table;
1599: adr_array dbms_sql.Number_Table;
1600: cust_bank_acct_id_array dbms_sql.Number_Table;
1601: cust_min_amt_array dbms_sql.Number_Table;
1602: pmt_trxn_ext_id_array dbms_sql.Number_Table;
1603: pmt_channel_array dbms_sql.varchar2_Table;

Line 1600: cust_bank_acct_id_array dbms_sql.Number_Table;

1596: paying_customer_id_array dbms_sql.Number_Table;
1597: paying_site_use_id_array dbms_sql.Number_Table;
1598: due_date_array dbms_sql.date_Table;
1599: adr_array dbms_sql.Number_Table;
1600: cust_bank_acct_id_array dbms_sql.Number_Table;
1601: cust_min_amt_array dbms_sql.Number_Table;
1602: pmt_trxn_ext_id_array dbms_sql.Number_Table;
1603: pmt_channel_array dbms_sql.varchar2_Table;
1604: pmt_instrument_type_array dbms_sql.varchar2_Table;

Line 1601: cust_min_amt_array dbms_sql.Number_Table;

1597: paying_site_use_id_array dbms_sql.Number_Table;
1598: due_date_array dbms_sql.date_Table;
1599: adr_array dbms_sql.Number_Table;
1600: cust_bank_acct_id_array dbms_sql.Number_Table;
1601: cust_min_amt_array dbms_sql.Number_Table;
1602: pmt_trxn_ext_id_array dbms_sql.Number_Table;
1603: pmt_channel_array dbms_sql.varchar2_Table;
1604: pmt_instrument_type_array dbms_sql.varchar2_Table;
1605: rec_t number;

Line 1602: pmt_trxn_ext_id_array dbms_sql.Number_Table;

1598: due_date_array dbms_sql.date_Table;
1599: adr_array dbms_sql.Number_Table;
1600: cust_bank_acct_id_array dbms_sql.Number_Table;
1601: cust_min_amt_array dbms_sql.Number_Table;
1602: pmt_trxn_ext_id_array dbms_sql.Number_Table;
1603: pmt_channel_array dbms_sql.varchar2_Table;
1604: pmt_instrument_type_array dbms_sql.varchar2_Table;
1605: rec_t number;
1606: dummy number;

Line 1603: pmt_channel_array dbms_sql.varchar2_Table;

1599: adr_array dbms_sql.Number_Table;
1600: cust_bank_acct_id_array dbms_sql.Number_Table;
1601: cust_min_amt_array dbms_sql.Number_Table;
1602: pmt_trxn_ext_id_array dbms_sql.Number_Table;
1603: pmt_channel_array dbms_sql.varchar2_Table;
1604: pmt_instrument_type_array dbms_sql.varchar2_Table;
1605: rec_t number;
1606: dummy number;
1607: i number;

Line 1604: pmt_instrument_type_array dbms_sql.varchar2_Table;

1600: cust_bank_acct_id_array dbms_sql.Number_Table;
1601: cust_min_amt_array dbms_sql.Number_Table;
1602: pmt_trxn_ext_id_array dbms_sql.Number_Table;
1603: pmt_channel_array dbms_sql.varchar2_Table;
1604: pmt_instrument_type_array dbms_sql.varchar2_Table;
1605: rec_t number;
1606: dummy number;
1607: i number;
1608:

Line 1808: trx_invoices := dbms_sql.open_cursor;

1804: END IF ;
1805: --Bug6734688, end.
1806: --l_sel_stmt := l_sel_stmt || ' FOR UPDATE OF ps.selected_for_receipt_batch_id ';
1807:
1808: trx_invoices := dbms_sql.open_cursor;
1809:
1810: dbms_sql.parse (trx_invoices,l_sel_stmt,dbms_sql.v7);
1811:
1812: IF p_approve_only_flag = 'A' THEN

Line 1810: dbms_sql.parse (trx_invoices,l_sel_stmt,dbms_sql.v7);

1806: --l_sel_stmt := l_sel_stmt || ' FOR UPDATE OF ps.selected_for_receipt_batch_id ';
1807:
1808: trx_invoices := dbms_sql.open_cursor;
1809:
1810: dbms_sql.parse (trx_invoices,l_sel_stmt,dbms_sql.v7);
1811:
1812: IF p_approve_only_flag = 'A' THEN
1813: dbms_sql.bind_variable (trx_invoices,':batch_id',p_batch_id);
1814: END IF;

Line 1813: dbms_sql.bind_variable (trx_invoices,':batch_id',p_batch_id);

1809:
1810: dbms_sql.parse (trx_invoices,l_sel_stmt,dbms_sql.v7);
1811:
1812: IF p_approve_only_flag = 'A' THEN
1813: dbms_sql.bind_variable (trx_invoices,':batch_id',p_batch_id);
1814: END IF;
1815:
1816: dbms_sql.bind_variable (trx_invoices,':batch_date',p_batch_date);
1817: dbms_sql.bind_variable (trx_invoices,':lead_days',p_lead_days);

Line 1816: dbms_sql.bind_variable (trx_invoices,':batch_date',p_batch_date);

1812: IF p_approve_only_flag = 'A' THEN
1813: dbms_sql.bind_variable (trx_invoices,':batch_id',p_batch_id);
1814: END IF;
1815:
1816: dbms_sql.bind_variable (trx_invoices,':batch_date',p_batch_date);
1817: dbms_sql.bind_variable (trx_invoices,':lead_days',p_lead_days);
1818: dbms_sql.bind_variable (trx_invoices,':currency_code',p_currency_code);
1819: dbms_sql.bind_variable (trx_invoices,':currency_code',p_currency_code);
1820: dbms_sql.bind_variable (trx_invoices,':currency_code',p_currency_code);

Line 1817: dbms_sql.bind_variable (trx_invoices,':lead_days',p_lead_days);

1813: dbms_sql.bind_variable (trx_invoices,':batch_id',p_batch_id);
1814: END IF;
1815:
1816: dbms_sql.bind_variable (trx_invoices,':batch_date',p_batch_date);
1817: dbms_sql.bind_variable (trx_invoices,':lead_days',p_lead_days);
1818: dbms_sql.bind_variable (trx_invoices,':currency_code',p_currency_code);
1819: dbms_sql.bind_variable (trx_invoices,':currency_code',p_currency_code);
1820: dbms_sql.bind_variable (trx_invoices,':currency_code',p_currency_code);
1821: dbms_sql.bind_variable (trx_invoices,':receipt_method_id',p_receipt_method_id);

Line 1818: dbms_sql.bind_variable (trx_invoices,':currency_code',p_currency_code);

1814: END IF;
1815:
1816: dbms_sql.bind_variable (trx_invoices,':batch_date',p_batch_date);
1817: dbms_sql.bind_variable (trx_invoices,':lead_days',p_lead_days);
1818: dbms_sql.bind_variable (trx_invoices,':currency_code',p_currency_code);
1819: dbms_sql.bind_variable (trx_invoices,':currency_code',p_currency_code);
1820: dbms_sql.bind_variable (trx_invoices,':currency_code',p_currency_code);
1821: dbms_sql.bind_variable (trx_invoices,':receipt_method_id',p_receipt_method_id);
1822: dbms_sql.bind_variable (trx_invoices,':creation_rule',p_creation_rule);

Line 1819: dbms_sql.bind_variable (trx_invoices,':currency_code',p_currency_code);

1815:
1816: dbms_sql.bind_variable (trx_invoices,':batch_date',p_batch_date);
1817: dbms_sql.bind_variable (trx_invoices,':lead_days',p_lead_days);
1818: dbms_sql.bind_variable (trx_invoices,':currency_code',p_currency_code);
1819: dbms_sql.bind_variable (trx_invoices,':currency_code',p_currency_code);
1820: dbms_sql.bind_variable (trx_invoices,':currency_code',p_currency_code);
1821: dbms_sql.bind_variable (trx_invoices,':receipt_method_id',p_receipt_method_id);
1822: dbms_sql.bind_variable (trx_invoices,':creation_rule',p_creation_rule);
1823: dbms_sql.bind_variable (trx_invoices,':apply_date',p_batch_date);

Line 1820: dbms_sql.bind_variable (trx_invoices,':currency_code',p_currency_code);

1816: dbms_sql.bind_variable (trx_invoices,':batch_date',p_batch_date);
1817: dbms_sql.bind_variable (trx_invoices,':lead_days',p_lead_days);
1818: dbms_sql.bind_variable (trx_invoices,':currency_code',p_currency_code);
1819: dbms_sql.bind_variable (trx_invoices,':currency_code',p_currency_code);
1820: dbms_sql.bind_variable (trx_invoices,':currency_code',p_currency_code);
1821: dbms_sql.bind_variable (trx_invoices,':receipt_method_id',p_receipt_method_id);
1822: dbms_sql.bind_variable (trx_invoices,':creation_rule',p_creation_rule);
1823: dbms_sql.bind_variable (trx_invoices,':apply_date',p_batch_date);
1824:

Line 1821: dbms_sql.bind_variable (trx_invoices,':receipt_method_id',p_receipt_method_id);

1817: dbms_sql.bind_variable (trx_invoices,':lead_days',p_lead_days);
1818: dbms_sql.bind_variable (trx_invoices,':currency_code',p_currency_code);
1819: dbms_sql.bind_variable (trx_invoices,':currency_code',p_currency_code);
1820: dbms_sql.bind_variable (trx_invoices,':currency_code',p_currency_code);
1821: dbms_sql.bind_variable (trx_invoices,':receipt_method_id',p_receipt_method_id);
1822: dbms_sql.bind_variable (trx_invoices,':creation_rule',p_creation_rule);
1823: dbms_sql.bind_variable (trx_invoices,':apply_date',p_batch_date);
1824:
1825: IF p_trx_num_l IS NOT NULL THEN

Line 1822: dbms_sql.bind_variable (trx_invoices,':creation_rule',p_creation_rule);

1818: dbms_sql.bind_variable (trx_invoices,':currency_code',p_currency_code);
1819: dbms_sql.bind_variable (trx_invoices,':currency_code',p_currency_code);
1820: dbms_sql.bind_variable (trx_invoices,':currency_code',p_currency_code);
1821: dbms_sql.bind_variable (trx_invoices,':receipt_method_id',p_receipt_method_id);
1822: dbms_sql.bind_variable (trx_invoices,':creation_rule',p_creation_rule);
1823: dbms_sql.bind_variable (trx_invoices,':apply_date',p_batch_date);
1824:
1825: IF p_trx_num_l IS NOT NULL THEN
1826: dbms_sql.bind_variable (trx_invoices,':trx_num_l',p_trx_num_l);

Line 1823: dbms_sql.bind_variable (trx_invoices,':apply_date',p_batch_date);

1819: dbms_sql.bind_variable (trx_invoices,':currency_code',p_currency_code);
1820: dbms_sql.bind_variable (trx_invoices,':currency_code',p_currency_code);
1821: dbms_sql.bind_variable (trx_invoices,':receipt_method_id',p_receipt_method_id);
1822: dbms_sql.bind_variable (trx_invoices,':creation_rule',p_creation_rule);
1823: dbms_sql.bind_variable (trx_invoices,':apply_date',p_batch_date);
1824:
1825: IF p_trx_num_l IS NOT NULL THEN
1826: dbms_sql.bind_variable (trx_invoices,':trx_num_l',p_trx_num_l);
1827: END IF;

Line 1826: dbms_sql.bind_variable (trx_invoices,':trx_num_l',p_trx_num_l);

1822: dbms_sql.bind_variable (trx_invoices,':creation_rule',p_creation_rule);
1823: dbms_sql.bind_variable (trx_invoices,':apply_date',p_batch_date);
1824:
1825: IF p_trx_num_l IS NOT NULL THEN
1826: dbms_sql.bind_variable (trx_invoices,':trx_num_l',p_trx_num_l);
1827: END IF;
1828:
1829: IF p_trx_num_h IS NOT NULL THEN
1830: dbms_sql.bind_variable (trx_invoices,':trx_num_h',p_trx_num_h);

Line 1830: dbms_sql.bind_variable (trx_invoices,':trx_num_h',p_trx_num_h);

1826: dbms_sql.bind_variable (trx_invoices,':trx_num_l',p_trx_num_l);
1827: END IF;
1828:
1829: IF p_trx_num_h IS NOT NULL THEN
1830: dbms_sql.bind_variable (trx_invoices,':trx_num_h',p_trx_num_h);
1831: END IF;
1832:
1833: IF p_due_date_l IS NOT NULL THEN
1834: dbms_sql.bind_variable (trx_invoices,':due_date_l',p_due_date_l);

Line 1834: dbms_sql.bind_variable (trx_invoices,':due_date_l',p_due_date_l);

1830: dbms_sql.bind_variable (trx_invoices,':trx_num_h',p_trx_num_h);
1831: END IF;
1832:
1833: IF p_due_date_l IS NOT NULL THEN
1834: dbms_sql.bind_variable (trx_invoices,':due_date_l',p_due_date_l);
1835: END IF;
1836: IF p_due_date_h IS NOT NULL THEN
1837: dbms_sql.bind_variable (trx_invoices,':due_date_h',p_due_date_h);
1838: END IF;

Line 1837: dbms_sql.bind_variable (trx_invoices,':due_date_h',p_due_date_h);

1833: IF p_due_date_l IS NOT NULL THEN
1834: dbms_sql.bind_variable (trx_invoices,':due_date_l',p_due_date_l);
1835: END IF;
1836: IF p_due_date_h IS NOT NULL THEN
1837: dbms_sql.bind_variable (trx_invoices,':due_date_h',p_due_date_h);
1838: END IF;
1839:
1840: IF p_trx_date_l IS NOT NULL THEN
1841: dbms_sql.bind_variable (trx_invoices,':trx_date_l',p_trx_date_l);

Line 1841: dbms_sql.bind_variable (trx_invoices,':trx_date_l',p_trx_date_l);

1837: dbms_sql.bind_variable (trx_invoices,':due_date_h',p_due_date_h);
1838: END IF;
1839:
1840: IF p_trx_date_l IS NOT NULL THEN
1841: dbms_sql.bind_variable (trx_invoices,':trx_date_l',p_trx_date_l);
1842: END IF;
1843: IF p_trx_date_h IS NOT NULL THEN
1844: dbms_sql.bind_variable (trx_invoices,':trx_date_h',p_trx_date_h);
1845: END IF;

Line 1844: dbms_sql.bind_variable (trx_invoices,':trx_date_h',p_trx_date_h);

1840: IF p_trx_date_l IS NOT NULL THEN
1841: dbms_sql.bind_variable (trx_invoices,':trx_date_l',p_trx_date_l);
1842: END IF;
1843: IF p_trx_date_h IS NOT NULL THEN
1844: dbms_sql.bind_variable (trx_invoices,':trx_date_h',p_trx_date_h);
1845: END IF;
1846:
1847: IF p_doc_num_l IS NOT NULL THEN
1848: dbms_sql.bind_variable (trx_invoices,':doc_num_l',p_doc_num_l);

Line 1848: dbms_sql.bind_variable (trx_invoices,':doc_num_l',p_doc_num_l);

1844: dbms_sql.bind_variable (trx_invoices,':trx_date_h',p_trx_date_h);
1845: END IF;
1846:
1847: IF p_doc_num_l IS NOT NULL THEN
1848: dbms_sql.bind_variable (trx_invoices,':doc_num_l',p_doc_num_l);
1849: END IF;
1850: IF p_doc_num_h IS NOT NULL THEN
1851: dbms_sql.bind_variable (trx_invoices,':doc_num_h',p_doc_num_h);
1852: END IF;

Line 1851: dbms_sql.bind_variable (trx_invoices,':doc_num_h',p_doc_num_h);

1847: IF p_doc_num_l IS NOT NULL THEN
1848: dbms_sql.bind_variable (trx_invoices,':doc_num_l',p_doc_num_l);
1849: END IF;
1850: IF p_doc_num_h IS NOT NULL THEN
1851: dbms_sql.bind_variable (trx_invoices,':doc_num_h',p_doc_num_h);
1852: END IF;
1853:
1854: --Bug6734688
1855: IF p_customer_number_l IS NOT NULL THEN

Line 1856: dbms_sql.bind_variable (trx_invoices,':customer_number_l',p_customer_number_l);

1852: END IF;
1853:
1854: --Bug6734688
1855: IF p_customer_number_l IS NOT NULL THEN
1856: dbms_sql.bind_variable (trx_invoices,':customer_number_l',p_customer_number_l);
1857: END IF;
1858: IF p_customer_number_h IS NOT NULL THEN
1859: dbms_sql.bind_variable (trx_invoices,':customer_number_h',p_customer_number_h);
1860: END IF;

Line 1859: dbms_sql.bind_variable (trx_invoices,':customer_number_h',p_customer_number_h);

1855: IF p_customer_number_l IS NOT NULL THEN
1856: dbms_sql.bind_variable (trx_invoices,':customer_number_l',p_customer_number_l);
1857: END IF;
1858: IF p_customer_number_h IS NOT NULL THEN
1859: dbms_sql.bind_variable (trx_invoices,':customer_number_h',p_customer_number_h);
1860: END IF;
1861:
1862: IF p_customer_name_l IS NOT NULL THEN
1863: dbms_sql.bind_variable (trx_invoices,':customer_name_l',p_customer_name_l);

Line 1863: dbms_sql.bind_variable (trx_invoices,':customer_name_l',p_customer_name_l);

1859: dbms_sql.bind_variable (trx_invoices,':customer_number_h',p_customer_number_h);
1860: END IF;
1861:
1862: IF p_customer_name_l IS NOT NULL THEN
1863: dbms_sql.bind_variable (trx_invoices,':customer_name_l',p_customer_name_l);
1864: END IF;
1865: IF p_customer_name_h IS NOT NULL THEN
1866: dbms_sql.bind_variable (trx_invoices,':customer_name_h',p_customer_name_h);
1867: END IF;

Line 1866: dbms_sql.bind_variable (trx_invoices,':customer_name_h',p_customer_name_h);

1862: IF p_customer_name_l IS NOT NULL THEN
1863: dbms_sql.bind_variable (trx_invoices,':customer_name_l',p_customer_name_l);
1864: END IF;
1865: IF p_customer_name_h IS NOT NULL THEN
1866: dbms_sql.bind_variable (trx_invoices,':customer_name_h',p_customer_name_h);
1867: END IF;
1868: --Bug6734688, end.
1869:
1870: dbms_sql.bind_variable (trx_invoices,':l_total_workers',l_total_workers);

Line 1870: dbms_sql.bind_variable (trx_invoices,':l_total_workers',l_total_workers);

1866: dbms_sql.bind_variable (trx_invoices,':customer_name_h',p_customer_name_h);
1867: END IF;
1868: --Bug6734688, end.
1869:
1870: dbms_sql.bind_variable (trx_invoices,':l_total_workers',l_total_workers);
1871:
1872: IF PG_DEBUG in ('Y', 'C') THEN
1873: arp_debug.debug( 'the select statement ' || l_sel_stmt);
1874: END IF;

Line 1887: l_rows_processed := dbms_sql.execute( trx_invoices );

1883: COMMIT;
1884: EXECUTE IMMEDIATE 'ALTER SESSION ENABLE PARALLEL DML';
1885: END IF;
1886:
1887: l_rows_processed := dbms_sql.execute( trx_invoices );
1888:
1889: IF PG_PARALLEL IN ('Y', 'C') THEN
1890: COMMIT; /* Bug 8249909 */
1891: END IF;

Line 1897: dbms_sql.close_cursor( trx_invoices);

1893: IF PG_DEBUG in ('Y', 'C') THEN
1894: arp_debug.debug('Number of invoices selected : '||l_rows_processed);
1895: END IF;
1896:
1897: dbms_sql.close_cursor( trx_invoices);
1898:
1899: IF p_approve_only_flag = 'N' THEN
1900: IF PG_DEBUG in ('Y', 'C') THEN
1901: arp_debug.debug('Stamping batch_id to PS : '||l_rows_processed);

Line 1920: dbms_sql.close_cursor( trx_invoices);

1916:
1917: EXCEPTION
1918: WHEN OTHERS THEN
1919: G_ERROR := 'Y';
1920: dbms_sql.close_cursor( trx_invoices);
1921: IF PG_DEBUG in ('Y', 'C') THEN
1922: arp_debug.debug('Exception : select_valid_invoices() '|| SQLERRM);
1923: arp_debug.debug('Error while executing>' || l_sel_stmt);
1924: END IF;

Line 3182: p_cr_id_array IN DBMS_SQL.NUMBER_TABLE,

3178:
3179:
3180: PROCEDURE update_ar_receipts_gt(p_creation_rule IN VARCHAR2,
3181: p_update_stmt IN VARCHAR2,
3182: p_cr_id_array IN DBMS_SQL.NUMBER_TABLE,
3183: p_cr_number_array IN DBMS_SQL.VARCHAR2_TABLE,
3184: p_gt_id_array IN DBMS_SQL.NUMBER_TABLE,
3185: p_ps_id_array IN DBMS_SQL.NUMBER_TABLE,
3186: p_paying_customer_id_array IN DBMS_SQL.NUMBER_TABLE,

Line 3183: p_cr_number_array IN DBMS_SQL.VARCHAR2_TABLE,

3179:
3180: PROCEDURE update_ar_receipts_gt(p_creation_rule IN VARCHAR2,
3181: p_update_stmt IN VARCHAR2,
3182: p_cr_id_array IN DBMS_SQL.NUMBER_TABLE,
3183: p_cr_number_array IN DBMS_SQL.VARCHAR2_TABLE,
3184: p_gt_id_array IN DBMS_SQL.NUMBER_TABLE,
3185: p_ps_id_array IN DBMS_SQL.NUMBER_TABLE,
3186: p_paying_customer_id_array IN DBMS_SQL.NUMBER_TABLE,
3187: p_pmt_instrument_array IN DBMS_SQL.VARCHAR2_TABLE,

Line 3184: p_gt_id_array IN DBMS_SQL.NUMBER_TABLE,

3180: PROCEDURE update_ar_receipts_gt(p_creation_rule IN VARCHAR2,
3181: p_update_stmt IN VARCHAR2,
3182: p_cr_id_array IN DBMS_SQL.NUMBER_TABLE,
3183: p_cr_number_array IN DBMS_SQL.VARCHAR2_TABLE,
3184: p_gt_id_array IN DBMS_SQL.NUMBER_TABLE,
3185: p_ps_id_array IN DBMS_SQL.NUMBER_TABLE,
3186: p_paying_customer_id_array IN DBMS_SQL.NUMBER_TABLE,
3187: p_pmt_instrument_array IN DBMS_SQL.VARCHAR2_TABLE,
3188: p_paying_site_use_id_array IN DBMS_SQL.NUMBER_TABLE,

Line 3185: p_ps_id_array IN DBMS_SQL.NUMBER_TABLE,

3181: p_update_stmt IN VARCHAR2,
3182: p_cr_id_array IN DBMS_SQL.NUMBER_TABLE,
3183: p_cr_number_array IN DBMS_SQL.VARCHAR2_TABLE,
3184: p_gt_id_array IN DBMS_SQL.NUMBER_TABLE,
3185: p_ps_id_array IN DBMS_SQL.NUMBER_TABLE,
3186: p_paying_customer_id_array IN DBMS_SQL.NUMBER_TABLE,
3187: p_pmt_instrument_array IN DBMS_SQL.VARCHAR2_TABLE,
3188: p_paying_site_use_id_array IN DBMS_SQL.NUMBER_TABLE,
3189: p_due_date_array IN DBMS_SQL.DATE_TABLE,

Line 3186: p_paying_customer_id_array IN DBMS_SQL.NUMBER_TABLE,

3182: p_cr_id_array IN DBMS_SQL.NUMBER_TABLE,
3183: p_cr_number_array IN DBMS_SQL.VARCHAR2_TABLE,
3184: p_gt_id_array IN DBMS_SQL.NUMBER_TABLE,
3185: p_ps_id_array IN DBMS_SQL.NUMBER_TABLE,
3186: p_paying_customer_id_array IN DBMS_SQL.NUMBER_TABLE,
3187: p_pmt_instrument_array IN DBMS_SQL.VARCHAR2_TABLE,
3188: p_paying_site_use_id_array IN DBMS_SQL.NUMBER_TABLE,
3189: p_due_date_array IN DBMS_SQL.DATE_TABLE,
3190: p_pmt_channel_code_array IN DBMS_SQL.VARCHAR2_TABLE,

Line 3187: p_pmt_instrument_array IN DBMS_SQL.VARCHAR2_TABLE,

3183: p_cr_number_array IN DBMS_SQL.VARCHAR2_TABLE,
3184: p_gt_id_array IN DBMS_SQL.NUMBER_TABLE,
3185: p_ps_id_array IN DBMS_SQL.NUMBER_TABLE,
3186: p_paying_customer_id_array IN DBMS_SQL.NUMBER_TABLE,
3187: p_pmt_instrument_array IN DBMS_SQL.VARCHAR2_TABLE,
3188: p_paying_site_use_id_array IN DBMS_SQL.NUMBER_TABLE,
3189: p_due_date_array IN DBMS_SQL.DATE_TABLE,
3190: p_pmt_channel_code_array IN DBMS_SQL.VARCHAR2_TABLE,
3191: p_cust_bank_acct_id_array IN DBMS_SQL.NUMBER_TABLE,

Line 3188: p_paying_site_use_id_array IN DBMS_SQL.NUMBER_TABLE,

3184: p_gt_id_array IN DBMS_SQL.NUMBER_TABLE,
3185: p_ps_id_array IN DBMS_SQL.NUMBER_TABLE,
3186: p_paying_customer_id_array IN DBMS_SQL.NUMBER_TABLE,
3187: p_pmt_instrument_array IN DBMS_SQL.VARCHAR2_TABLE,
3188: p_paying_site_use_id_array IN DBMS_SQL.NUMBER_TABLE,
3189: p_due_date_array IN DBMS_SQL.DATE_TABLE,
3190: p_pmt_channel_code_array IN DBMS_SQL.VARCHAR2_TABLE,
3191: p_cust_bank_acct_id_array IN DBMS_SQL.NUMBER_TABLE,
3192: p_trxn_extension_id_array IN DBMS_SQL.NUMBER_TABLE,

Line 3189: p_due_date_array IN DBMS_SQL.DATE_TABLE,

3185: p_ps_id_array IN DBMS_SQL.NUMBER_TABLE,
3186: p_paying_customer_id_array IN DBMS_SQL.NUMBER_TABLE,
3187: p_pmt_instrument_array IN DBMS_SQL.VARCHAR2_TABLE,
3188: p_paying_site_use_id_array IN DBMS_SQL.NUMBER_TABLE,
3189: p_due_date_array IN DBMS_SQL.DATE_TABLE,
3190: p_pmt_channel_code_array IN DBMS_SQL.VARCHAR2_TABLE,
3191: p_cust_bank_acct_id_array IN DBMS_SQL.NUMBER_TABLE,
3192: p_trxn_extension_id_array IN DBMS_SQL.NUMBER_TABLE,
3193: p_authorization_id_array IN DBMS_SQL.NUMBER_TABLE )IS

Line 3190: p_pmt_channel_code_array IN DBMS_SQL.VARCHAR2_TABLE,

3186: p_paying_customer_id_array IN DBMS_SQL.NUMBER_TABLE,
3187: p_pmt_instrument_array IN DBMS_SQL.VARCHAR2_TABLE,
3188: p_paying_site_use_id_array IN DBMS_SQL.NUMBER_TABLE,
3189: p_due_date_array IN DBMS_SQL.DATE_TABLE,
3190: p_pmt_channel_code_array IN DBMS_SQL.VARCHAR2_TABLE,
3191: p_cust_bank_acct_id_array IN DBMS_SQL.NUMBER_TABLE,
3192: p_trxn_extension_id_array IN DBMS_SQL.NUMBER_TABLE,
3193: p_authorization_id_array IN DBMS_SQL.NUMBER_TABLE )IS
3194: l_update_cursor NUMBER;

Line 3191: p_cust_bank_acct_id_array IN DBMS_SQL.NUMBER_TABLE,

3187: p_pmt_instrument_array IN DBMS_SQL.VARCHAR2_TABLE,
3188: p_paying_site_use_id_array IN DBMS_SQL.NUMBER_TABLE,
3189: p_due_date_array IN DBMS_SQL.DATE_TABLE,
3190: p_pmt_channel_code_array IN DBMS_SQL.VARCHAR2_TABLE,
3191: p_cust_bank_acct_id_array IN DBMS_SQL.NUMBER_TABLE,
3192: p_trxn_extension_id_array IN DBMS_SQL.NUMBER_TABLE,
3193: p_authorization_id_array IN DBMS_SQL.NUMBER_TABLE )IS
3194: l_update_cursor NUMBER;
3195: l_dummy NUMBER;

Line 3192: p_trxn_extension_id_array IN DBMS_SQL.NUMBER_TABLE,

3188: p_paying_site_use_id_array IN DBMS_SQL.NUMBER_TABLE,
3189: p_due_date_array IN DBMS_SQL.DATE_TABLE,
3190: p_pmt_channel_code_array IN DBMS_SQL.VARCHAR2_TABLE,
3191: p_cust_bank_acct_id_array IN DBMS_SQL.NUMBER_TABLE,
3192: p_trxn_extension_id_array IN DBMS_SQL.NUMBER_TABLE,
3193: p_authorization_id_array IN DBMS_SQL.NUMBER_TABLE )IS
3194: l_update_cursor NUMBER;
3195: l_dummy NUMBER;
3196:

Line 3193: p_authorization_id_array IN DBMS_SQL.NUMBER_TABLE )IS

3189: p_due_date_array IN DBMS_SQL.DATE_TABLE,
3190: p_pmt_channel_code_array IN DBMS_SQL.VARCHAR2_TABLE,
3191: p_cust_bank_acct_id_array IN DBMS_SQL.NUMBER_TABLE,
3192: p_trxn_extension_id_array IN DBMS_SQL.NUMBER_TABLE,
3193: p_authorization_id_array IN DBMS_SQL.NUMBER_TABLE )IS
3194: l_update_cursor NUMBER;
3195: l_dummy NUMBER;
3196:
3197: BEGIN

Line 3204: l_update_cursor := dbms_sql.open_cursor;

3200: arp_debug.debug('p_creation_rule '||p_creation_rule);
3201: arp_debug.debug('p_update_stmt '||p_update_stmt);
3202: END IF;
3203:
3204: l_update_cursor := dbms_sql.open_cursor;
3205:
3206: dbms_sql.parse (l_update_cursor, p_update_stmt,dbms_sql.v7);
3207:
3208: dbms_sql.bind_array (l_update_cursor,':l_receipt_num_array',p_cr_number_array);

Line 3206: dbms_sql.parse (l_update_cursor, p_update_stmt,dbms_sql.v7);

3202: END IF;
3203:
3204: l_update_cursor := dbms_sql.open_cursor;
3205:
3206: dbms_sql.parse (l_update_cursor, p_update_stmt,dbms_sql.v7);
3207:
3208: dbms_sql.bind_array (l_update_cursor,':l_receipt_num_array',p_cr_number_array);
3209: dbms_sql.bind_array (l_update_cursor,':l_receipt_id_array',p_cr_id_array);
3210: dbms_sql.bind_array (l_update_cursor,':l_gt_id_array',p_gt_id_array);

Line 3208: dbms_sql.bind_array (l_update_cursor,':l_receipt_num_array',p_cr_number_array);

3204: l_update_cursor := dbms_sql.open_cursor;
3205:
3206: dbms_sql.parse (l_update_cursor, p_update_stmt,dbms_sql.v7);
3207:
3208: dbms_sql.bind_array (l_update_cursor,':l_receipt_num_array',p_cr_number_array);
3209: dbms_sql.bind_array (l_update_cursor,':l_receipt_id_array',p_cr_id_array);
3210: dbms_sql.bind_array (l_update_cursor,':l_gt_id_array',p_gt_id_array);
3211:
3212: IF p_creation_rule = 'PER_INVOICE' THEN

Line 3209: dbms_sql.bind_array (l_update_cursor,':l_receipt_id_array',p_cr_id_array);

3205:
3206: dbms_sql.parse (l_update_cursor, p_update_stmt,dbms_sql.v7);
3207:
3208: dbms_sql.bind_array (l_update_cursor,':l_receipt_num_array',p_cr_number_array);
3209: dbms_sql.bind_array (l_update_cursor,':l_receipt_id_array',p_cr_id_array);
3210: dbms_sql.bind_array (l_update_cursor,':l_gt_id_array',p_gt_id_array);
3211:
3212: IF p_creation_rule = 'PER_INVOICE' THEN
3213: dbms_sql.bind_array (l_update_cursor,':l_ps_id_array',p_ps_id_array);

Line 3210: dbms_sql.bind_array (l_update_cursor,':l_gt_id_array',p_gt_id_array);

3206: dbms_sql.parse (l_update_cursor, p_update_stmt,dbms_sql.v7);
3207:
3208: dbms_sql.bind_array (l_update_cursor,':l_receipt_num_array',p_cr_number_array);
3209: dbms_sql.bind_array (l_update_cursor,':l_receipt_id_array',p_cr_id_array);
3210: dbms_sql.bind_array (l_update_cursor,':l_gt_id_array',p_gt_id_array);
3211:
3212: IF p_creation_rule = 'PER_INVOICE' THEN
3213: dbms_sql.bind_array (l_update_cursor,':l_ps_id_array',p_ps_id_array);
3214:

Line 3213: dbms_sql.bind_array (l_update_cursor,':l_ps_id_array',p_ps_id_array);

3209: dbms_sql.bind_array (l_update_cursor,':l_receipt_id_array',p_cr_id_array);
3210: dbms_sql.bind_array (l_update_cursor,':l_gt_id_array',p_gt_id_array);
3211:
3212: IF p_creation_rule = 'PER_INVOICE' THEN
3213: dbms_sql.bind_array (l_update_cursor,':l_ps_id_array',p_ps_id_array);
3214:
3215: ELSIF p_creation_rule = 'PER_CUSTOMER' THEN
3216: dbms_sql.bind_array (l_update_cursor,':l_paying_customer_id_array',p_paying_customer_id_array);
3217: dbms_sql.bind_array (l_update_cursor,':l_pmt_instrument_array',p_pmt_instrument_array);

Line 3216: dbms_sql.bind_array (l_update_cursor,':l_paying_customer_id_array',p_paying_customer_id_array);

3212: IF p_creation_rule = 'PER_INVOICE' THEN
3213: dbms_sql.bind_array (l_update_cursor,':l_ps_id_array',p_ps_id_array);
3214:
3215: ELSIF p_creation_rule = 'PER_CUSTOMER' THEN
3216: dbms_sql.bind_array (l_update_cursor,':l_paying_customer_id_array',p_paying_customer_id_array);
3217: dbms_sql.bind_array (l_update_cursor,':l_pmt_instrument_array',p_pmt_instrument_array);
3218:
3219: ELSIF p_creation_rule = 'PER_SITE' THEN
3220: dbms_sql.bind_array (l_update_cursor,':l_paying_customer_id_array',p_paying_customer_id_array);

Line 3217: dbms_sql.bind_array (l_update_cursor,':l_pmt_instrument_array',p_pmt_instrument_array);

3213: dbms_sql.bind_array (l_update_cursor,':l_ps_id_array',p_ps_id_array);
3214:
3215: ELSIF p_creation_rule = 'PER_CUSTOMER' THEN
3216: dbms_sql.bind_array (l_update_cursor,':l_paying_customer_id_array',p_paying_customer_id_array);
3217: dbms_sql.bind_array (l_update_cursor,':l_pmt_instrument_array',p_pmt_instrument_array);
3218:
3219: ELSIF p_creation_rule = 'PER_SITE' THEN
3220: dbms_sql.bind_array (l_update_cursor,':l_paying_customer_id_array',p_paying_customer_id_array);
3221: dbms_sql.bind_array (l_update_cursor,':l_pmt_instrument_array',p_pmt_instrument_array);

Line 3220: dbms_sql.bind_array (l_update_cursor,':l_paying_customer_id_array',p_paying_customer_id_array);

3216: dbms_sql.bind_array (l_update_cursor,':l_paying_customer_id_array',p_paying_customer_id_array);
3217: dbms_sql.bind_array (l_update_cursor,':l_pmt_instrument_array',p_pmt_instrument_array);
3218:
3219: ELSIF p_creation_rule = 'PER_SITE' THEN
3220: dbms_sql.bind_array (l_update_cursor,':l_paying_customer_id_array',p_paying_customer_id_array);
3221: dbms_sql.bind_array (l_update_cursor,':l_pmt_instrument_array',p_pmt_instrument_array);
3222: dbms_sql.bind_array (l_update_cursor,':l_paying_site_use_id_array',p_paying_site_use_id_array);
3223:
3224: ELSIF (p_creation_rule = 'PER_SITE_DUE_DATE') THEN

Line 3221: dbms_sql.bind_array (l_update_cursor,':l_pmt_instrument_array',p_pmt_instrument_array);

3217: dbms_sql.bind_array (l_update_cursor,':l_pmt_instrument_array',p_pmt_instrument_array);
3218:
3219: ELSIF p_creation_rule = 'PER_SITE' THEN
3220: dbms_sql.bind_array (l_update_cursor,':l_paying_customer_id_array',p_paying_customer_id_array);
3221: dbms_sql.bind_array (l_update_cursor,':l_pmt_instrument_array',p_pmt_instrument_array);
3222: dbms_sql.bind_array (l_update_cursor,':l_paying_site_use_id_array',p_paying_site_use_id_array);
3223:
3224: ELSIF (p_creation_rule = 'PER_SITE_DUE_DATE') THEN
3225: dbms_sql.bind_array (l_update_cursor,':l_paying_customer_id_array',p_paying_customer_id_array);

Line 3222: dbms_sql.bind_array (l_update_cursor,':l_paying_site_use_id_array',p_paying_site_use_id_array);

3218:
3219: ELSIF p_creation_rule = 'PER_SITE' THEN
3220: dbms_sql.bind_array (l_update_cursor,':l_paying_customer_id_array',p_paying_customer_id_array);
3221: dbms_sql.bind_array (l_update_cursor,':l_pmt_instrument_array',p_pmt_instrument_array);
3222: dbms_sql.bind_array (l_update_cursor,':l_paying_site_use_id_array',p_paying_site_use_id_array);
3223:
3224: ELSIF (p_creation_rule = 'PER_SITE_DUE_DATE') THEN
3225: dbms_sql.bind_array (l_update_cursor,':l_paying_customer_id_array',p_paying_customer_id_array);
3226: dbms_sql.bind_array (l_update_cursor,':l_pmt_instrument_array',p_pmt_instrument_array);

Line 3225: dbms_sql.bind_array (l_update_cursor,':l_paying_customer_id_array',p_paying_customer_id_array);

3221: dbms_sql.bind_array (l_update_cursor,':l_pmt_instrument_array',p_pmt_instrument_array);
3222: dbms_sql.bind_array (l_update_cursor,':l_paying_site_use_id_array',p_paying_site_use_id_array);
3223:
3224: ELSIF (p_creation_rule = 'PER_SITE_DUE_DATE') THEN
3225: dbms_sql.bind_array (l_update_cursor,':l_paying_customer_id_array',p_paying_customer_id_array);
3226: dbms_sql.bind_array (l_update_cursor,':l_pmt_instrument_array',p_pmt_instrument_array);
3227: dbms_sql.bind_array (l_update_cursor,':l_paying_site_use_id_array',p_paying_site_use_id_array);
3228: dbms_sql.bind_array (l_update_cursor,':l_due_date_array',p_due_date_array);
3229:

Line 3226: dbms_sql.bind_array (l_update_cursor,':l_pmt_instrument_array',p_pmt_instrument_array);

3222: dbms_sql.bind_array (l_update_cursor,':l_paying_site_use_id_array',p_paying_site_use_id_array);
3223:
3224: ELSIF (p_creation_rule = 'PER_SITE_DUE_DATE') THEN
3225: dbms_sql.bind_array (l_update_cursor,':l_paying_customer_id_array',p_paying_customer_id_array);
3226: dbms_sql.bind_array (l_update_cursor,':l_pmt_instrument_array',p_pmt_instrument_array);
3227: dbms_sql.bind_array (l_update_cursor,':l_paying_site_use_id_array',p_paying_site_use_id_array);
3228: dbms_sql.bind_array (l_update_cursor,':l_due_date_array',p_due_date_array);
3229:
3230: ELSIF (p_creation_rule = 'PER_CUSTOMER_DUE_DATE') THEN

Line 3227: dbms_sql.bind_array (l_update_cursor,':l_paying_site_use_id_array',p_paying_site_use_id_array);

3223:
3224: ELSIF (p_creation_rule = 'PER_SITE_DUE_DATE') THEN
3225: dbms_sql.bind_array (l_update_cursor,':l_paying_customer_id_array',p_paying_customer_id_array);
3226: dbms_sql.bind_array (l_update_cursor,':l_pmt_instrument_array',p_pmt_instrument_array);
3227: dbms_sql.bind_array (l_update_cursor,':l_paying_site_use_id_array',p_paying_site_use_id_array);
3228: dbms_sql.bind_array (l_update_cursor,':l_due_date_array',p_due_date_array);
3229:
3230: ELSIF (p_creation_rule = 'PER_CUSTOMER_DUE_DATE') THEN
3231: dbms_sql.bind_array (l_update_cursor,':l_paying_customer_id_array',p_paying_customer_id_array);

Line 3228: dbms_sql.bind_array (l_update_cursor,':l_due_date_array',p_due_date_array);

3224: ELSIF (p_creation_rule = 'PER_SITE_DUE_DATE') THEN
3225: dbms_sql.bind_array (l_update_cursor,':l_paying_customer_id_array',p_paying_customer_id_array);
3226: dbms_sql.bind_array (l_update_cursor,':l_pmt_instrument_array',p_pmt_instrument_array);
3227: dbms_sql.bind_array (l_update_cursor,':l_paying_site_use_id_array',p_paying_site_use_id_array);
3228: dbms_sql.bind_array (l_update_cursor,':l_due_date_array',p_due_date_array);
3229:
3230: ELSIF (p_creation_rule = 'PER_CUSTOMER_DUE_DATE') THEN
3231: dbms_sql.bind_array (l_update_cursor,':l_paying_customer_id_array',p_paying_customer_id_array);
3232: dbms_sql.bind_array (l_update_cursor,':l_pmt_instrument_array',p_pmt_instrument_array);

Line 3231: dbms_sql.bind_array (l_update_cursor,':l_paying_customer_id_array',p_paying_customer_id_array);

3227: dbms_sql.bind_array (l_update_cursor,':l_paying_site_use_id_array',p_paying_site_use_id_array);
3228: dbms_sql.bind_array (l_update_cursor,':l_due_date_array',p_due_date_array);
3229:
3230: ELSIF (p_creation_rule = 'PER_CUSTOMER_DUE_DATE') THEN
3231: dbms_sql.bind_array (l_update_cursor,':l_paying_customer_id_array',p_paying_customer_id_array);
3232: dbms_sql.bind_array (l_update_cursor,':l_pmt_instrument_array',p_pmt_instrument_array);
3233: dbms_sql.bind_array (l_update_cursor,':l_due_date_array',p_due_date_array);
3234:
3235: ELSIF (p_creation_rule = 'PAYMENT_CHANNEL_CODE') THEN

Line 3232: dbms_sql.bind_array (l_update_cursor,':l_pmt_instrument_array',p_pmt_instrument_array);

3228: dbms_sql.bind_array (l_update_cursor,':l_due_date_array',p_due_date_array);
3229:
3230: ELSIF (p_creation_rule = 'PER_CUSTOMER_DUE_DATE') THEN
3231: dbms_sql.bind_array (l_update_cursor,':l_paying_customer_id_array',p_paying_customer_id_array);
3232: dbms_sql.bind_array (l_update_cursor,':l_pmt_instrument_array',p_pmt_instrument_array);
3233: dbms_sql.bind_array (l_update_cursor,':l_due_date_array',p_due_date_array);
3234:
3235: ELSIF (p_creation_rule = 'PAYMENT_CHANNEL_CODE') THEN
3236: dbms_sql.bind_array (l_update_cursor,':l_paying_customer_id_array',p_paying_customer_id_array);

Line 3233: dbms_sql.bind_array (l_update_cursor,':l_due_date_array',p_due_date_array);

3229:
3230: ELSIF (p_creation_rule = 'PER_CUSTOMER_DUE_DATE') THEN
3231: dbms_sql.bind_array (l_update_cursor,':l_paying_customer_id_array',p_paying_customer_id_array);
3232: dbms_sql.bind_array (l_update_cursor,':l_pmt_instrument_array',p_pmt_instrument_array);
3233: dbms_sql.bind_array (l_update_cursor,':l_due_date_array',p_due_date_array);
3234:
3235: ELSIF (p_creation_rule = 'PAYMENT_CHANNEL_CODE') THEN
3236: dbms_sql.bind_array (l_update_cursor,':l_paying_customer_id_array',p_paying_customer_id_array);
3237: dbms_sql.bind_array (l_update_cursor,':l_trxn_extension_id_array',p_trxn_extension_id_array);

Line 3236: dbms_sql.bind_array (l_update_cursor,':l_paying_customer_id_array',p_paying_customer_id_array);

3232: dbms_sql.bind_array (l_update_cursor,':l_pmt_instrument_array',p_pmt_instrument_array);
3233: dbms_sql.bind_array (l_update_cursor,':l_due_date_array',p_due_date_array);
3234:
3235: ELSIF (p_creation_rule = 'PAYMENT_CHANNEL_CODE') THEN
3236: dbms_sql.bind_array (l_update_cursor,':l_paying_customer_id_array',p_paying_customer_id_array);
3237: dbms_sql.bind_array (l_update_cursor,':l_trxn_extension_id_array',p_trxn_extension_id_array);
3238: dbms_sql.bind_array (l_update_cursor,':l_pmt_channel_code_array',p_pmt_channel_code_array);
3239: dbms_sql.bind_array (l_update_cursor,':l_cust_bank_acct_id_array',p_cust_bank_acct_id_array);
3240:

Line 3237: dbms_sql.bind_array (l_update_cursor,':l_trxn_extension_id_array',p_trxn_extension_id_array);

3233: dbms_sql.bind_array (l_update_cursor,':l_due_date_array',p_due_date_array);
3234:
3235: ELSIF (p_creation_rule = 'PAYMENT_CHANNEL_CODE') THEN
3236: dbms_sql.bind_array (l_update_cursor,':l_paying_customer_id_array',p_paying_customer_id_array);
3237: dbms_sql.bind_array (l_update_cursor,':l_trxn_extension_id_array',p_trxn_extension_id_array);
3238: dbms_sql.bind_array (l_update_cursor,':l_pmt_channel_code_array',p_pmt_channel_code_array);
3239: dbms_sql.bind_array (l_update_cursor,':l_cust_bank_acct_id_array',p_cust_bank_acct_id_array);
3240:
3241: ELSIF (p_creation_rule = 'PAYMENT_INSTRUMENT') THEN

Line 3238: dbms_sql.bind_array (l_update_cursor,':l_pmt_channel_code_array',p_pmt_channel_code_array);

3234:
3235: ELSIF (p_creation_rule = 'PAYMENT_CHANNEL_CODE') THEN
3236: dbms_sql.bind_array (l_update_cursor,':l_paying_customer_id_array',p_paying_customer_id_array);
3237: dbms_sql.bind_array (l_update_cursor,':l_trxn_extension_id_array',p_trxn_extension_id_array);
3238: dbms_sql.bind_array (l_update_cursor,':l_pmt_channel_code_array',p_pmt_channel_code_array);
3239: dbms_sql.bind_array (l_update_cursor,':l_cust_bank_acct_id_array',p_cust_bank_acct_id_array);
3240:
3241: ELSIF (p_creation_rule = 'PAYMENT_INSTRUMENT') THEN
3242: dbms_sql.bind_array (l_update_cursor,':l_paying_customer_id_array',p_paying_customer_id_array);

Line 3239: dbms_sql.bind_array (l_update_cursor,':l_cust_bank_acct_id_array',p_cust_bank_acct_id_array);

3235: ELSIF (p_creation_rule = 'PAYMENT_CHANNEL_CODE') THEN
3236: dbms_sql.bind_array (l_update_cursor,':l_paying_customer_id_array',p_paying_customer_id_array);
3237: dbms_sql.bind_array (l_update_cursor,':l_trxn_extension_id_array',p_trxn_extension_id_array);
3238: dbms_sql.bind_array (l_update_cursor,':l_pmt_channel_code_array',p_pmt_channel_code_array);
3239: dbms_sql.bind_array (l_update_cursor,':l_cust_bank_acct_id_array',p_cust_bank_acct_id_array);
3240:
3241: ELSIF (p_creation_rule = 'PAYMENT_INSTRUMENT') THEN
3242: dbms_sql.bind_array (l_update_cursor,':l_paying_customer_id_array',p_paying_customer_id_array);
3243: dbms_sql.bind_array (l_update_cursor,':l_trxn_extension_id_array',p_trxn_extension_id_array);

Line 3242: dbms_sql.bind_array (l_update_cursor,':l_paying_customer_id_array',p_paying_customer_id_array);

3238: dbms_sql.bind_array (l_update_cursor,':l_pmt_channel_code_array',p_pmt_channel_code_array);
3239: dbms_sql.bind_array (l_update_cursor,':l_cust_bank_acct_id_array',p_cust_bank_acct_id_array);
3240:
3241: ELSIF (p_creation_rule = 'PAYMENT_INSTRUMENT') THEN
3242: dbms_sql.bind_array (l_update_cursor,':l_paying_customer_id_array',p_paying_customer_id_array);
3243: dbms_sql.bind_array (l_update_cursor,':l_trxn_extension_id_array',p_trxn_extension_id_array);
3244: dbms_sql.bind_array (l_update_cursor,':l_pmt_instrument_array',p_pmt_instrument_array);
3245:
3246: ELSIF (p_creation_rule = 'AUTHORIZATION_ID') THEN

Line 3243: dbms_sql.bind_array (l_update_cursor,':l_trxn_extension_id_array',p_trxn_extension_id_array);

3239: dbms_sql.bind_array (l_update_cursor,':l_cust_bank_acct_id_array',p_cust_bank_acct_id_array);
3240:
3241: ELSIF (p_creation_rule = 'PAYMENT_INSTRUMENT') THEN
3242: dbms_sql.bind_array (l_update_cursor,':l_paying_customer_id_array',p_paying_customer_id_array);
3243: dbms_sql.bind_array (l_update_cursor,':l_trxn_extension_id_array',p_trxn_extension_id_array);
3244: dbms_sql.bind_array (l_update_cursor,':l_pmt_instrument_array',p_pmt_instrument_array);
3245:
3246: ELSIF (p_creation_rule = 'AUTHORIZATION_ID') THEN
3247: dbms_sql.bind_array (l_update_cursor,':l_paying_customer_id_array',p_paying_customer_id_array);

Line 3244: dbms_sql.bind_array (l_update_cursor,':l_pmt_instrument_array',p_pmt_instrument_array);

3240:
3241: ELSIF (p_creation_rule = 'PAYMENT_INSTRUMENT') THEN
3242: dbms_sql.bind_array (l_update_cursor,':l_paying_customer_id_array',p_paying_customer_id_array);
3243: dbms_sql.bind_array (l_update_cursor,':l_trxn_extension_id_array',p_trxn_extension_id_array);
3244: dbms_sql.bind_array (l_update_cursor,':l_pmt_instrument_array',p_pmt_instrument_array);
3245:
3246: ELSIF (p_creation_rule = 'AUTHORIZATION_ID') THEN
3247: dbms_sql.bind_array (l_update_cursor,':l_paying_customer_id_array',p_paying_customer_id_array);
3248: dbms_sql.bind_array (l_update_cursor,':l_trxn_extension_id_array',p_trxn_extension_id_array);

Line 3247: dbms_sql.bind_array (l_update_cursor,':l_paying_customer_id_array',p_paying_customer_id_array);

3243: dbms_sql.bind_array (l_update_cursor,':l_trxn_extension_id_array',p_trxn_extension_id_array);
3244: dbms_sql.bind_array (l_update_cursor,':l_pmt_instrument_array',p_pmt_instrument_array);
3245:
3246: ELSIF (p_creation_rule = 'AUTHORIZATION_ID') THEN
3247: dbms_sql.bind_array (l_update_cursor,':l_paying_customer_id_array',p_paying_customer_id_array);
3248: dbms_sql.bind_array (l_update_cursor,':l_trxn_extension_id_array',p_trxn_extension_id_array);
3249: dbms_sql.bind_array (l_update_cursor,':l_authorization_id_array',p_authorization_id_array);
3250: END IF;
3251:

Line 3248: dbms_sql.bind_array (l_update_cursor,':l_trxn_extension_id_array',p_trxn_extension_id_array);

3244: dbms_sql.bind_array (l_update_cursor,':l_pmt_instrument_array',p_pmt_instrument_array);
3245:
3246: ELSIF (p_creation_rule = 'AUTHORIZATION_ID') THEN
3247: dbms_sql.bind_array (l_update_cursor,':l_paying_customer_id_array',p_paying_customer_id_array);
3248: dbms_sql.bind_array (l_update_cursor,':l_trxn_extension_id_array',p_trxn_extension_id_array);
3249: dbms_sql.bind_array (l_update_cursor,':l_authorization_id_array',p_authorization_id_array);
3250: END IF;
3251:
3252: l_dummy := dbms_sql.execute(l_update_cursor);

Line 3249: dbms_sql.bind_array (l_update_cursor,':l_authorization_id_array',p_authorization_id_array);

3245:
3246: ELSIF (p_creation_rule = 'AUTHORIZATION_ID') THEN
3247: dbms_sql.bind_array (l_update_cursor,':l_paying_customer_id_array',p_paying_customer_id_array);
3248: dbms_sql.bind_array (l_update_cursor,':l_trxn_extension_id_array',p_trxn_extension_id_array);
3249: dbms_sql.bind_array (l_update_cursor,':l_authorization_id_array',p_authorization_id_array);
3250: END IF;
3251:
3252: l_dummy := dbms_sql.execute(l_update_cursor);
3253:

Line 3252: l_dummy := dbms_sql.execute(l_update_cursor);

3248: dbms_sql.bind_array (l_update_cursor,':l_trxn_extension_id_array',p_trxn_extension_id_array);
3249: dbms_sql.bind_array (l_update_cursor,':l_authorization_id_array',p_authorization_id_array);
3250: END IF;
3251:
3252: l_dummy := dbms_sql.execute(l_update_cursor);
3253:
3254: dbms_sql.close_cursor(l_update_cursor);
3255:
3256: IF PG_DEBUG in ('Y', 'C') THEN

Line 3254: dbms_sql.close_cursor(l_update_cursor);

3250: END IF;
3251:
3252: l_dummy := dbms_sql.execute(l_update_cursor);
3253:
3254: dbms_sql.close_cursor(l_update_cursor);
3255:
3256: IF PG_DEBUG in ('Y', 'C') THEN
3257: arp_debug.debug('Rows updated :'||SQL%ROWCOUNT);
3258: arp_debug.debug('update_ar_receipts_gt()-');

Line 3263: if dbms_sql.is_open(l_update_cursor) then

3259: END IF;
3260:
3261: EXCEPTION
3262: WHEN OTHERS THEN
3263: if dbms_sql.is_open(l_update_cursor) then
3264: dbms_sql.close_cursor(l_update_cursor);
3265: end if;
3266: arp_debug.debug('update_ar_receipts_gt : error code() '|| to_char(SQLCODE));
3267:

Line 3264: dbms_sql.close_cursor(l_update_cursor);

3260:
3261: EXCEPTION
3262: WHEN OTHERS THEN
3263: if dbms_sql.is_open(l_update_cursor) then
3264: dbms_sql.close_cursor(l_update_cursor);
3265: end if;
3266: arp_debug.debug('update_ar_receipts_gt : error code() '|| to_char(SQLCODE));
3267:
3268: insert_exceptions( p_batch_id => NVL(g_batch_id, -333),

Line 3790: p_receipt_num_array OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE,

3786: PROCEDURE populate_receipt_numbers( p_rcpt_method_name IN ar_receipt_methods.name%TYPE,
3787: p_sob_id IN ar_batches.set_of_books_id%TYPE,
3788: p_batch_date IN DATE,
3789: p_receipt_method_id IN NUMBER,
3790: p_receipt_num_array OUT NOCOPY DBMS_SQL.VARCHAR2_TABLE,
3791: p_count IN NUMBER) IS
3792: l_error_flag VARCHAR2(1) := 'N';
3793: l_status NUMBER;
3794: l_doc_sequence_value ra_customer_trx.doc_sequence_value%TYPE;

Line 3892: l_paying_customer_id_array DBMS_SQL.NUMBER_TABLE;

3888: l_remittance_bank_account_id ar_receipt_method_accounts_all.remit_bank_acct_use_id%TYPE;
3889: l_state ar_receipt_classes.creation_status%TYPE;
3890: l_old_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
3891:
3892: l_paying_customer_id_array DBMS_SQL.NUMBER_TABLE;
3893: l_paying_site_use_id_array DBMS_SQL.NUMBER_TABLE;
3894: l_due_date_array DBMS_SQL.DATE_TABLE;
3895: l_pmt_instrument_array DBMS_SQL.VARCHAR2_TABLE;
3896: l_pmt_channel_code_array DBMS_SQL.VARCHAR2_TABLE;

Line 3893: l_paying_site_use_id_array DBMS_SQL.NUMBER_TABLE;

3889: l_state ar_receipt_classes.creation_status%TYPE;
3890: l_old_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
3891:
3892: l_paying_customer_id_array DBMS_SQL.NUMBER_TABLE;
3893: l_paying_site_use_id_array DBMS_SQL.NUMBER_TABLE;
3894: l_due_date_array DBMS_SQL.DATE_TABLE;
3895: l_pmt_instrument_array DBMS_SQL.VARCHAR2_TABLE;
3896: l_pmt_channel_code_array DBMS_SQL.VARCHAR2_TABLE;
3897: l_pmt_trxn_extn_id_array DBMS_SQL.NUMBER_TABLE;

Line 3894: l_due_date_array DBMS_SQL.DATE_TABLE;

3890: l_old_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;
3891:
3892: l_paying_customer_id_array DBMS_SQL.NUMBER_TABLE;
3893: l_paying_site_use_id_array DBMS_SQL.NUMBER_TABLE;
3894: l_due_date_array DBMS_SQL.DATE_TABLE;
3895: l_pmt_instrument_array DBMS_SQL.VARCHAR2_TABLE;
3896: l_pmt_channel_code_array DBMS_SQL.VARCHAR2_TABLE;
3897: l_pmt_trxn_extn_id_array DBMS_SQL.NUMBER_TABLE;
3898: l_authorization_id_array DBMS_SQL.NUMBER_TABLE;

Line 3895: l_pmt_instrument_array DBMS_SQL.VARCHAR2_TABLE;

3891:
3892: l_paying_customer_id_array DBMS_SQL.NUMBER_TABLE;
3893: l_paying_site_use_id_array DBMS_SQL.NUMBER_TABLE;
3894: l_due_date_array DBMS_SQL.DATE_TABLE;
3895: l_pmt_instrument_array DBMS_SQL.VARCHAR2_TABLE;
3896: l_pmt_channel_code_array DBMS_SQL.VARCHAR2_TABLE;
3897: l_pmt_trxn_extn_id_array DBMS_SQL.NUMBER_TABLE;
3898: l_authorization_id_array DBMS_SQL.NUMBER_TABLE;
3899: l_cust_bank_acct_id_array DBMS_SQL.NUMBER_TABLE;

Line 3896: l_pmt_channel_code_array DBMS_SQL.VARCHAR2_TABLE;

3892: l_paying_customer_id_array DBMS_SQL.NUMBER_TABLE;
3893: l_paying_site_use_id_array DBMS_SQL.NUMBER_TABLE;
3894: l_due_date_array DBMS_SQL.DATE_TABLE;
3895: l_pmt_instrument_array DBMS_SQL.VARCHAR2_TABLE;
3896: l_pmt_channel_code_array DBMS_SQL.VARCHAR2_TABLE;
3897: l_pmt_trxn_extn_id_array DBMS_SQL.NUMBER_TABLE;
3898: l_authorization_id_array DBMS_SQL.NUMBER_TABLE;
3899: l_cust_bank_acct_id_array DBMS_SQL.NUMBER_TABLE;
3900: l_amount_array DBMS_SQL.NUMBER_TABLE;

Line 3897: l_pmt_trxn_extn_id_array DBMS_SQL.NUMBER_TABLE;

3893: l_paying_site_use_id_array DBMS_SQL.NUMBER_TABLE;
3894: l_due_date_array DBMS_SQL.DATE_TABLE;
3895: l_pmt_instrument_array DBMS_SQL.VARCHAR2_TABLE;
3896: l_pmt_channel_code_array DBMS_SQL.VARCHAR2_TABLE;
3897: l_pmt_trxn_extn_id_array DBMS_SQL.NUMBER_TABLE;
3898: l_authorization_id_array DBMS_SQL.NUMBER_TABLE;
3899: l_cust_bank_acct_id_array DBMS_SQL.NUMBER_TABLE;
3900: l_amount_array DBMS_SQL.NUMBER_TABLE;
3901: l_receipt_id_array DBMS_SQL.NUMBER_TABLE;

Line 3898: l_authorization_id_array DBMS_SQL.NUMBER_TABLE;

3894: l_due_date_array DBMS_SQL.DATE_TABLE;
3895: l_pmt_instrument_array DBMS_SQL.VARCHAR2_TABLE;
3896: l_pmt_channel_code_array DBMS_SQL.VARCHAR2_TABLE;
3897: l_pmt_trxn_extn_id_array DBMS_SQL.NUMBER_TABLE;
3898: l_authorization_id_array DBMS_SQL.NUMBER_TABLE;
3899: l_cust_bank_acct_id_array DBMS_SQL.NUMBER_TABLE;
3900: l_amount_array DBMS_SQL.NUMBER_TABLE;
3901: l_receipt_id_array DBMS_SQL.NUMBER_TABLE;
3902: l_receipt_num_array DBMS_SQL.VARCHAR2_TABLE;

Line 3899: l_cust_bank_acct_id_array DBMS_SQL.NUMBER_TABLE;

3895: l_pmt_instrument_array DBMS_SQL.VARCHAR2_TABLE;
3896: l_pmt_channel_code_array DBMS_SQL.VARCHAR2_TABLE;
3897: l_pmt_trxn_extn_id_array DBMS_SQL.NUMBER_TABLE;
3898: l_authorization_id_array DBMS_SQL.NUMBER_TABLE;
3899: l_cust_bank_acct_id_array DBMS_SQL.NUMBER_TABLE;
3900: l_amount_array DBMS_SQL.NUMBER_TABLE;
3901: l_receipt_id_array DBMS_SQL.NUMBER_TABLE;
3902: l_receipt_num_array DBMS_SQL.VARCHAR2_TABLE;
3903: l_ps_id_array DBMS_SQL.NUMBER_TABLE;

Line 3900: l_amount_array DBMS_SQL.NUMBER_TABLE;

3896: l_pmt_channel_code_array DBMS_SQL.VARCHAR2_TABLE;
3897: l_pmt_trxn_extn_id_array DBMS_SQL.NUMBER_TABLE;
3898: l_authorization_id_array DBMS_SQL.NUMBER_TABLE;
3899: l_cust_bank_acct_id_array DBMS_SQL.NUMBER_TABLE;
3900: l_amount_array DBMS_SQL.NUMBER_TABLE;
3901: l_receipt_id_array DBMS_SQL.NUMBER_TABLE;
3902: l_receipt_num_array DBMS_SQL.VARCHAR2_TABLE;
3903: l_ps_id_array DBMS_SQL.NUMBER_TABLE;
3904: l_gt_id_array DBMS_SQL.NUMBER_TABLE;

Line 3901: l_receipt_id_array DBMS_SQL.NUMBER_TABLE;

3897: l_pmt_trxn_extn_id_array DBMS_SQL.NUMBER_TABLE;
3898: l_authorization_id_array DBMS_SQL.NUMBER_TABLE;
3899: l_cust_bank_acct_id_array DBMS_SQL.NUMBER_TABLE;
3900: l_amount_array DBMS_SQL.NUMBER_TABLE;
3901: l_receipt_id_array DBMS_SQL.NUMBER_TABLE;
3902: l_receipt_num_array DBMS_SQL.VARCHAR2_TABLE;
3903: l_ps_id_array DBMS_SQL.NUMBER_TABLE;
3904: l_gt_id_array DBMS_SQL.NUMBER_TABLE;
3905:

Line 3902: l_receipt_num_array DBMS_SQL.VARCHAR2_TABLE;

3898: l_authorization_id_array DBMS_SQL.NUMBER_TABLE;
3899: l_cust_bank_acct_id_array DBMS_SQL.NUMBER_TABLE;
3900: l_amount_array DBMS_SQL.NUMBER_TABLE;
3901: l_receipt_id_array DBMS_SQL.NUMBER_TABLE;
3902: l_receipt_num_array DBMS_SQL.VARCHAR2_TABLE;
3903: l_ps_id_array DBMS_SQL.NUMBER_TABLE;
3904: l_gt_id_array DBMS_SQL.NUMBER_TABLE;
3905:
3906: l_err_rcpt_num_array DBMS_SQL.VARCHAR2_TABLE;

Line 3903: l_ps_id_array DBMS_SQL.NUMBER_TABLE;

3899: l_cust_bank_acct_id_array DBMS_SQL.NUMBER_TABLE;
3900: l_amount_array DBMS_SQL.NUMBER_TABLE;
3901: l_receipt_id_array DBMS_SQL.NUMBER_TABLE;
3902: l_receipt_num_array DBMS_SQL.VARCHAR2_TABLE;
3903: l_ps_id_array DBMS_SQL.NUMBER_TABLE;
3904: l_gt_id_array DBMS_SQL.NUMBER_TABLE;
3905:
3906: l_err_rcpt_num_array DBMS_SQL.VARCHAR2_TABLE;
3907: l_err_code_array DBMS_SQL.VARCHAR2_TABLE;

Line 3904: l_gt_id_array DBMS_SQL.NUMBER_TABLE;

3900: l_amount_array DBMS_SQL.NUMBER_TABLE;
3901: l_receipt_id_array DBMS_SQL.NUMBER_TABLE;
3902: l_receipt_num_array DBMS_SQL.VARCHAR2_TABLE;
3903: l_ps_id_array DBMS_SQL.NUMBER_TABLE;
3904: l_gt_id_array DBMS_SQL.NUMBER_TABLE;
3905:
3906: l_err_rcpt_num_array DBMS_SQL.VARCHAR2_TABLE;
3907: l_err_code_array DBMS_SQL.VARCHAR2_TABLE;
3908: l_err_rcpt_index INTEGER;

Line 3906: l_err_rcpt_num_array DBMS_SQL.VARCHAR2_TABLE;

3902: l_receipt_num_array DBMS_SQL.VARCHAR2_TABLE;
3903: l_ps_id_array DBMS_SQL.NUMBER_TABLE;
3904: l_gt_id_array DBMS_SQL.NUMBER_TABLE;
3905:
3906: l_err_rcpt_num_array DBMS_SQL.VARCHAR2_TABLE;
3907: l_err_code_array DBMS_SQL.VARCHAR2_TABLE;
3908: l_err_rcpt_index INTEGER;
3909: l_cc_err_code_array DBMS_SQL.VARCHAR2_TABLE;
3910: l_cc_err_text_array DBMS_SQL.VARCHAR2_TABLE;

Line 3907: l_err_code_array DBMS_SQL.VARCHAR2_TABLE;

3903: l_ps_id_array DBMS_SQL.NUMBER_TABLE;
3904: l_gt_id_array DBMS_SQL.NUMBER_TABLE;
3905:
3906: l_err_rcpt_num_array DBMS_SQL.VARCHAR2_TABLE;
3907: l_err_code_array DBMS_SQL.VARCHAR2_TABLE;
3908: l_err_rcpt_index INTEGER;
3909: l_cc_err_code_array DBMS_SQL.VARCHAR2_TABLE;
3910: l_cc_err_text_array DBMS_SQL.VARCHAR2_TABLE;
3911:

Line 3909: l_cc_err_code_array DBMS_SQL.VARCHAR2_TABLE;

3905:
3906: l_err_rcpt_num_array DBMS_SQL.VARCHAR2_TABLE;
3907: l_err_code_array DBMS_SQL.VARCHAR2_TABLE;
3908: l_err_rcpt_index INTEGER;
3909: l_cc_err_code_array DBMS_SQL.VARCHAR2_TABLE;
3910: l_cc_err_text_array DBMS_SQL.VARCHAR2_TABLE;
3911:
3912: l_apply_fail VARCHAR2(1) := 'N';
3913: l_pay_process_fail VARCHAR2(1) := 'N';

Line 3910: l_cc_err_text_array DBMS_SQL.VARCHAR2_TABLE;

3906: l_err_rcpt_num_array DBMS_SQL.VARCHAR2_TABLE;
3907: l_err_code_array DBMS_SQL.VARCHAR2_TABLE;
3908: l_err_rcpt_index INTEGER;
3909: l_cc_err_code_array DBMS_SQL.VARCHAR2_TABLE;
3910: l_cc_err_text_array DBMS_SQL.VARCHAR2_TABLE;
3911:
3912: l_apply_fail VARCHAR2(1) := 'N';
3913: l_pay_process_fail VARCHAR2(1) := 'N';
3914: l_exchange_rate ar_batches.exchange_rate%TYPE;

Line 5133: IF( dbms_sql.is_open( l_create_stmt_c) ) THEN

5129: COMMIT;
5130:
5131: -- no more rows to fetch
5132: IF l_rows_fetched < MAX_ARRAY_SIZE THEN
5133: IF( dbms_sql.is_open( l_create_stmt_c) ) THEN
5134: dbms_sql.close_cursor( l_create_stmt_c );
5135: END IF;
5136:
5137: IF PG_DEBUG in ('Y', 'C') THEN

Line 5134: dbms_sql.close_cursor( l_create_stmt_c );

5130:
5131: -- no more rows to fetch
5132: IF l_rows_fetched < MAX_ARRAY_SIZE THEN
5133: IF( dbms_sql.is_open( l_create_stmt_c) ) THEN
5134: dbms_sql.close_cursor( l_create_stmt_c );
5135: END IF;
5136:
5137: IF PG_DEBUG in ('Y', 'C') THEN
5138: arp_debug.debug('l_rows_fetched < MAX_ARRAY_SIZE Cursor closed');