APPS.AR_AUTOREC_API dependencies on DBMS_SQL

Line 1229: ps_id_array dbms_sql.NUmber_Table;

1225: p_currency_code VARCHAR2(20);
1226:
1227: -- insert variables
1228: inst_stmt varchar2(1000);
1229: ps_id_array dbms_sql.NUmber_Table;
1230: trx_id_array dbms_sql.NUmber_Table;
1231: cr_id_array dbms_sql.Number_Table;
1232: paying_customer_id_array dbms_sql.Number_Table;
1233: paying_site_use_id_array dbms_sql.Number_Table;

Line 1230: trx_id_array dbms_sql.NUmber_Table;

1226:
1227: -- insert variables
1228: inst_stmt varchar2(1000);
1229: ps_id_array dbms_sql.NUmber_Table;
1230: trx_id_array dbms_sql.NUmber_Table;
1231: cr_id_array dbms_sql.Number_Table;
1232: paying_customer_id_array dbms_sql.Number_Table;
1233: paying_site_use_id_array dbms_sql.Number_Table;
1234: due_date_array dbms_sql.date_Table;

Line 1231: cr_id_array dbms_sql.Number_Table;

1227: -- insert variables
1228: inst_stmt varchar2(1000);
1229: ps_id_array dbms_sql.NUmber_Table;
1230: trx_id_array dbms_sql.NUmber_Table;
1231: cr_id_array dbms_sql.Number_Table;
1232: paying_customer_id_array dbms_sql.Number_Table;
1233: paying_site_use_id_array dbms_sql.Number_Table;
1234: due_date_array dbms_sql.date_Table;
1235: adr_array dbms_sql.Number_Table;

Line 1232: paying_customer_id_array dbms_sql.Number_Table;

1228: inst_stmt varchar2(1000);
1229: ps_id_array dbms_sql.NUmber_Table;
1230: trx_id_array dbms_sql.NUmber_Table;
1231: cr_id_array dbms_sql.Number_Table;
1232: paying_customer_id_array dbms_sql.Number_Table;
1233: paying_site_use_id_array dbms_sql.Number_Table;
1234: due_date_array dbms_sql.date_Table;
1235: adr_array dbms_sql.Number_Table;
1236: cust_bank_acct_id_array dbms_sql.Number_Table;

Line 1233: paying_site_use_id_array dbms_sql.Number_Table;

1229: ps_id_array dbms_sql.NUmber_Table;
1230: trx_id_array dbms_sql.NUmber_Table;
1231: cr_id_array dbms_sql.Number_Table;
1232: paying_customer_id_array dbms_sql.Number_Table;
1233: paying_site_use_id_array dbms_sql.Number_Table;
1234: due_date_array dbms_sql.date_Table;
1235: adr_array dbms_sql.Number_Table;
1236: cust_bank_acct_id_array dbms_sql.Number_Table;
1237: cust_min_amt_array dbms_sql.Number_Table;

Line 1234: due_date_array dbms_sql.date_Table;

1230: trx_id_array dbms_sql.NUmber_Table;
1231: cr_id_array dbms_sql.Number_Table;
1232: paying_customer_id_array dbms_sql.Number_Table;
1233: paying_site_use_id_array dbms_sql.Number_Table;
1234: due_date_array dbms_sql.date_Table;
1235: adr_array dbms_sql.Number_Table;
1236: cust_bank_acct_id_array dbms_sql.Number_Table;
1237: cust_min_amt_array dbms_sql.Number_Table;
1238: pmt_trxn_ext_id_array dbms_sql.Number_Table;

Line 1235: adr_array dbms_sql.Number_Table;

1231: cr_id_array dbms_sql.Number_Table;
1232: paying_customer_id_array dbms_sql.Number_Table;
1233: paying_site_use_id_array dbms_sql.Number_Table;
1234: due_date_array dbms_sql.date_Table;
1235: adr_array dbms_sql.Number_Table;
1236: cust_bank_acct_id_array dbms_sql.Number_Table;
1237: cust_min_amt_array dbms_sql.Number_Table;
1238: pmt_trxn_ext_id_array dbms_sql.Number_Table;
1239: pmt_channel_array dbms_sql.varchar2_Table;

Line 1236: cust_bank_acct_id_array dbms_sql.Number_Table;

1232: paying_customer_id_array dbms_sql.Number_Table;
1233: paying_site_use_id_array dbms_sql.Number_Table;
1234: due_date_array dbms_sql.date_Table;
1235: adr_array dbms_sql.Number_Table;
1236: cust_bank_acct_id_array dbms_sql.Number_Table;
1237: cust_min_amt_array dbms_sql.Number_Table;
1238: pmt_trxn_ext_id_array dbms_sql.Number_Table;
1239: pmt_channel_array dbms_sql.varchar2_Table;
1240: pmt_instrument_type_array dbms_sql.varchar2_Table;

Line 1237: cust_min_amt_array dbms_sql.Number_Table;

1233: paying_site_use_id_array dbms_sql.Number_Table;
1234: due_date_array dbms_sql.date_Table;
1235: adr_array dbms_sql.Number_Table;
1236: cust_bank_acct_id_array dbms_sql.Number_Table;
1237: cust_min_amt_array dbms_sql.Number_Table;
1238: pmt_trxn_ext_id_array dbms_sql.Number_Table;
1239: pmt_channel_array dbms_sql.varchar2_Table;
1240: pmt_instrument_type_array dbms_sql.varchar2_Table;
1241: rec_t number;

Line 1238: pmt_trxn_ext_id_array dbms_sql.Number_Table;

1234: due_date_array dbms_sql.date_Table;
1235: adr_array dbms_sql.Number_Table;
1236: cust_bank_acct_id_array dbms_sql.Number_Table;
1237: cust_min_amt_array dbms_sql.Number_Table;
1238: pmt_trxn_ext_id_array dbms_sql.Number_Table;
1239: pmt_channel_array dbms_sql.varchar2_Table;
1240: pmt_instrument_type_array dbms_sql.varchar2_Table;
1241: rec_t number;
1242: dummy number;

Line 1239: pmt_channel_array dbms_sql.varchar2_Table;

1235: adr_array dbms_sql.Number_Table;
1236: cust_bank_acct_id_array dbms_sql.Number_Table;
1237: cust_min_amt_array dbms_sql.Number_Table;
1238: pmt_trxn_ext_id_array dbms_sql.Number_Table;
1239: pmt_channel_array dbms_sql.varchar2_Table;
1240: pmt_instrument_type_array dbms_sql.varchar2_Table;
1241: rec_t number;
1242: dummy number;
1243: i number;

Line 1240: pmt_instrument_type_array dbms_sql.varchar2_Table;

1236: cust_bank_acct_id_array dbms_sql.Number_Table;
1237: cust_min_amt_array dbms_sql.Number_Table;
1238: pmt_trxn_ext_id_array dbms_sql.Number_Table;
1239: pmt_channel_array dbms_sql.varchar2_Table;
1240: pmt_instrument_type_array dbms_sql.varchar2_Table;
1241: rec_t number;
1242: dummy number;
1243: i number;
1244: BEGIN

Line 1418: trx_invoices := dbms_sql.open_cursor;

1414: --Bug6734688, end.
1415:
1416: l_sel_stmt := l_sel_stmt || ' FOR UPDATE OF ps.selected_for_receipt_batch_id ';
1417:
1418: trx_invoices := dbms_sql.open_cursor;
1419:
1420: dbms_sql.parse (trx_invoices,l_sel_stmt,dbms_sql.v7);
1421:
1422: if p_approve_only_flag = 'A' then

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

1416: l_sel_stmt := l_sel_stmt || ' FOR UPDATE OF ps.selected_for_receipt_batch_id ';
1417:
1418: trx_invoices := dbms_sql.open_cursor;
1419:
1420: dbms_sql.parse (trx_invoices,l_sel_stmt,dbms_sql.v7);
1421:
1422: if p_approve_only_flag = 'A' then
1423: dbms_sql.bind_variable (trx_invoices,':batch_id',p_batch_id);
1424: end if;

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

1419:
1420: dbms_sql.parse (trx_invoices,l_sel_stmt,dbms_sql.v7);
1421:
1422: if p_approve_only_flag = 'A' then
1423: dbms_sql.bind_variable (trx_invoices,':batch_id',p_batch_id);
1424: end if;
1425:
1426: dbms_sql.bind_variable (trx_invoices,':batch_date',p_batch_date);
1427: dbms_sql.bind_variable (trx_invoices,':lead_days',p_lead_days);

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

1422: if p_approve_only_flag = 'A' then
1423: dbms_sql.bind_variable (trx_invoices,':batch_id',p_batch_id);
1424: end if;
1425:
1426: dbms_sql.bind_variable (trx_invoices,':batch_date',p_batch_date);
1427: dbms_sql.bind_variable (trx_invoices,':lead_days',p_lead_days);
1428: dbms_sql.bind_variable (trx_invoices,':currency_code',p_currency_code);
1429: dbms_sql.bind_variable (trx_invoices,':receipt_method_id',p_receipt_method_id);
1430: dbms_sql.bind_variable (trx_invoices,':creation_rule',p_creation_rule);

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

1423: dbms_sql.bind_variable (trx_invoices,':batch_id',p_batch_id);
1424: end if;
1425:
1426: dbms_sql.bind_variable (trx_invoices,':batch_date',p_batch_date);
1427: dbms_sql.bind_variable (trx_invoices,':lead_days',p_lead_days);
1428: dbms_sql.bind_variable (trx_invoices,':currency_code',p_currency_code);
1429: dbms_sql.bind_variable (trx_invoices,':receipt_method_id',p_receipt_method_id);
1430: dbms_sql.bind_variable (trx_invoices,':creation_rule',p_creation_rule);
1431: dbms_sql.bind_variable (trx_invoices,':apply_date',p_batch_date);

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

1424: end if;
1425:
1426: dbms_sql.bind_variable (trx_invoices,':batch_date',p_batch_date);
1427: dbms_sql.bind_variable (trx_invoices,':lead_days',p_lead_days);
1428: dbms_sql.bind_variable (trx_invoices,':currency_code',p_currency_code);
1429: dbms_sql.bind_variable (trx_invoices,':receipt_method_id',p_receipt_method_id);
1430: dbms_sql.bind_variable (trx_invoices,':creation_rule',p_creation_rule);
1431: dbms_sql.bind_variable (trx_invoices,':apply_date',p_batch_date);
1432:

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

1425:
1426: dbms_sql.bind_variable (trx_invoices,':batch_date',p_batch_date);
1427: dbms_sql.bind_variable (trx_invoices,':lead_days',p_lead_days);
1428: dbms_sql.bind_variable (trx_invoices,':currency_code',p_currency_code);
1429: dbms_sql.bind_variable (trx_invoices,':receipt_method_id',p_receipt_method_id);
1430: dbms_sql.bind_variable (trx_invoices,':creation_rule',p_creation_rule);
1431: dbms_sql.bind_variable (trx_invoices,':apply_date',p_batch_date);
1432:
1433: IF p_trx_num_l IS NOT NULL THEN

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

1426: dbms_sql.bind_variable (trx_invoices,':batch_date',p_batch_date);
1427: dbms_sql.bind_variable (trx_invoices,':lead_days',p_lead_days);
1428: dbms_sql.bind_variable (trx_invoices,':currency_code',p_currency_code);
1429: dbms_sql.bind_variable (trx_invoices,':receipt_method_id',p_receipt_method_id);
1430: dbms_sql.bind_variable (trx_invoices,':creation_rule',p_creation_rule);
1431: dbms_sql.bind_variable (trx_invoices,':apply_date',p_batch_date);
1432:
1433: IF p_trx_num_l IS NOT NULL THEN
1434: dbms_sql.bind_variable (trx_invoices,':trx_num_l',p_trx_num_l);

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

1427: dbms_sql.bind_variable (trx_invoices,':lead_days',p_lead_days);
1428: dbms_sql.bind_variable (trx_invoices,':currency_code',p_currency_code);
1429: dbms_sql.bind_variable (trx_invoices,':receipt_method_id',p_receipt_method_id);
1430: dbms_sql.bind_variable (trx_invoices,':creation_rule',p_creation_rule);
1431: dbms_sql.bind_variable (trx_invoices,':apply_date',p_batch_date);
1432:
1433: IF p_trx_num_l IS NOT NULL THEN
1434: dbms_sql.bind_variable (trx_invoices,':trx_num_l',p_trx_num_l);
1435: END IF;

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

1430: dbms_sql.bind_variable (trx_invoices,':creation_rule',p_creation_rule);
1431: dbms_sql.bind_variable (trx_invoices,':apply_date',p_batch_date);
1432:
1433: IF p_trx_num_l IS NOT NULL THEN
1434: dbms_sql.bind_variable (trx_invoices,':trx_num_l',p_trx_num_l);
1435: END IF;
1436: IF p_trx_num_h IS NOT NULL THEN
1437: dbms_sql.bind_variable (trx_invoices,':trx_num_h',p_trx_num_h);
1438: END IF;

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

1433: IF p_trx_num_l IS NOT NULL THEN
1434: dbms_sql.bind_variable (trx_invoices,':trx_num_l',p_trx_num_l);
1435: END IF;
1436: IF p_trx_num_h IS NOT NULL THEN
1437: dbms_sql.bind_variable (trx_invoices,':trx_num_h',p_trx_num_h);
1438: END IF;
1439:
1440: IF p_due_date_l IS NOT NULL THEN
1441: dbms_sql.bind_variable (trx_invoices,':due_date_l',p_due_date_l);

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

1437: dbms_sql.bind_variable (trx_invoices,':trx_num_h',p_trx_num_h);
1438: END IF;
1439:
1440: IF p_due_date_l IS NOT NULL THEN
1441: dbms_sql.bind_variable (trx_invoices,':due_date_l',p_due_date_l);
1442: END IF;
1443: IF p_due_date_h IS NOT NULL THEN
1444: dbms_sql.bind_variable (trx_invoices,':due_date_h',p_due_date_h);
1445: END IF;

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

1440: IF p_due_date_l IS NOT NULL THEN
1441: dbms_sql.bind_variable (trx_invoices,':due_date_l',p_due_date_l);
1442: END IF;
1443: IF p_due_date_h IS NOT NULL THEN
1444: dbms_sql.bind_variable (trx_invoices,':due_date_h',p_due_date_h);
1445: END IF;
1446:
1447: IF p_trx_date_l IS NOT NULL THEN
1448: dbms_sql.bind_variable (trx_invoices,':trx_date_l',p_trx_date_l);

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

1444: dbms_sql.bind_variable (trx_invoices,':due_date_h',p_due_date_h);
1445: END IF;
1446:
1447: IF p_trx_date_l IS NOT NULL THEN
1448: dbms_sql.bind_variable (trx_invoices,':trx_date_l',p_trx_date_l);
1449: END IF;
1450: IF p_trx_date_h IS NOT NULL THEN
1451: dbms_sql.bind_variable (trx_invoices,':trx_date_h',p_trx_date_h);
1452: END IF;

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

1447: IF p_trx_date_l IS NOT NULL THEN
1448: dbms_sql.bind_variable (trx_invoices,':trx_date_l',p_trx_date_l);
1449: END IF;
1450: IF p_trx_date_h IS NOT NULL THEN
1451: dbms_sql.bind_variable (trx_invoices,':trx_date_h',p_trx_date_h);
1452: END IF;
1453:
1454: IF p_doc_num_l IS NOT NULL THEN
1455: dbms_sql.bind_variable (trx_invoices,':doc_num_l',p_doc_num_l);

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

1451: dbms_sql.bind_variable (trx_invoices,':trx_date_h',p_trx_date_h);
1452: END IF;
1453:
1454: IF p_doc_num_l IS NOT NULL THEN
1455: dbms_sql.bind_variable (trx_invoices,':doc_num_l',p_doc_num_l);
1456: END IF;
1457: IF p_doc_num_h IS NOT NULL THEN
1458: dbms_sql.bind_variable (trx_invoices,':doc_num_h',p_doc_num_h);
1459: END IF;

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

1454: IF p_doc_num_l IS NOT NULL THEN
1455: dbms_sql.bind_variable (trx_invoices,':doc_num_l',p_doc_num_l);
1456: END IF;
1457: IF p_doc_num_h IS NOT NULL THEN
1458: dbms_sql.bind_variable (trx_invoices,':doc_num_h',p_doc_num_h);
1459: END IF;
1460:
1461: --Bug6734688
1462: IF p_customer_number_l IS NOT NULL THEN

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

1459: END IF;
1460:
1461: --Bug6734688
1462: IF p_customer_number_l IS NOT NULL THEN
1463: dbms_sql.bind_variable (trx_invoices,':customer_number_l',p_customer_number_l);
1464: END IF;
1465: IF p_customer_number_h IS NOT NULL THEN
1466: dbms_sql.bind_variable (trx_invoices,':customer_number_h',p_customer_number_h);
1467: END IF;

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

1462: IF p_customer_number_l IS NOT NULL THEN
1463: dbms_sql.bind_variable (trx_invoices,':customer_number_l',p_customer_number_l);
1464: END IF;
1465: IF p_customer_number_h IS NOT NULL THEN
1466: dbms_sql.bind_variable (trx_invoices,':customer_number_h',p_customer_number_h);
1467: END IF;
1468:
1469: IF p_customer_name_l IS NOT NULL THEN
1470: dbms_sql.bind_variable (trx_invoices,':customer_name_l',p_customer_name_l);

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

1466: dbms_sql.bind_variable (trx_invoices,':customer_number_h',p_customer_number_h);
1467: END IF;
1468:
1469: IF p_customer_name_l IS NOT NULL THEN
1470: dbms_sql.bind_variable (trx_invoices,':customer_name_l',p_customer_name_l);
1471: END IF;
1472: IF p_customer_name_h IS NOT NULL THEN
1473: dbms_sql.bind_variable (trx_invoices,':customer_name_h',p_customer_name_h);
1474: END IF;

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

1469: IF p_customer_name_l IS NOT NULL THEN
1470: dbms_sql.bind_variable (trx_invoices,':customer_name_l',p_customer_name_l);
1471: END IF;
1472: IF p_customer_name_h IS NOT NULL THEN
1473: dbms_sql.bind_variable (trx_invoices,':customer_name_h',p_customer_name_h);
1474: END IF;
1475: --Bug6734688, end.
1476:
1477: dbms_sql.define_column (trx_invoices, 1, p_payment_schedule_id);

Line 1477: dbms_sql.define_column (trx_invoices, 1, p_payment_schedule_id);

1473: dbms_sql.bind_variable (trx_invoices,':customer_name_h',p_customer_name_h);
1474: END IF;
1475: --Bug6734688, end.
1476:
1477: dbms_sql.define_column (trx_invoices, 1, p_payment_schedule_id);
1478: dbms_sql.define_column (trx_invoices, 2, p_customer_trx_id);
1479: dbms_sql.define_column (trx_invoices, 3, p_cash_receipt_id);
1480: dbms_sql.define_column (trx_invoices, 4, p_paying_customer_id);
1481: dbms_sql.define_column (trx_invoices, 5, p_paying_site_use_id);

Line 1478: dbms_sql.define_column (trx_invoices, 2, p_customer_trx_id);

1474: END IF;
1475: --Bug6734688, end.
1476:
1477: dbms_sql.define_column (trx_invoices, 1, p_payment_schedule_id);
1478: dbms_sql.define_column (trx_invoices, 2, p_customer_trx_id);
1479: dbms_sql.define_column (trx_invoices, 3, p_cash_receipt_id);
1480: dbms_sql.define_column (trx_invoices, 4, p_paying_customer_id);
1481: dbms_sql.define_column (trx_invoices, 5, p_paying_site_use_id);
1482: dbms_sql.define_column (trx_invoices, 6, p_payment_trxn_extension_id);

Line 1479: dbms_sql.define_column (trx_invoices, 3, p_cash_receipt_id);

1475: --Bug6734688, end.
1476:
1477: dbms_sql.define_column (trx_invoices, 1, p_payment_schedule_id);
1478: dbms_sql.define_column (trx_invoices, 2, p_customer_trx_id);
1479: dbms_sql.define_column (trx_invoices, 3, p_cash_receipt_id);
1480: dbms_sql.define_column (trx_invoices, 4, p_paying_customer_id);
1481: dbms_sql.define_column (trx_invoices, 5, p_paying_site_use_id);
1482: dbms_sql.define_column (trx_invoices, 6, p_payment_trxn_extension_id);
1483: dbms_sql.define_column (trx_invoices, 7, p_due_date);

Line 1480: dbms_sql.define_column (trx_invoices, 4, p_paying_customer_id);

1476:
1477: dbms_sql.define_column (trx_invoices, 1, p_payment_schedule_id);
1478: dbms_sql.define_column (trx_invoices, 2, p_customer_trx_id);
1479: dbms_sql.define_column (trx_invoices, 3, p_cash_receipt_id);
1480: dbms_sql.define_column (trx_invoices, 4, p_paying_customer_id);
1481: dbms_sql.define_column (trx_invoices, 5, p_paying_site_use_id);
1482: dbms_sql.define_column (trx_invoices, 6, p_payment_trxn_extension_id);
1483: dbms_sql.define_column (trx_invoices, 7, p_due_date);
1484: dbms_sql.define_column (trx_invoices, 8, p_amount_due_remaining);

Line 1481: dbms_sql.define_column (trx_invoices, 5, p_paying_site_use_id);

1477: dbms_sql.define_column (trx_invoices, 1, p_payment_schedule_id);
1478: dbms_sql.define_column (trx_invoices, 2, p_customer_trx_id);
1479: dbms_sql.define_column (trx_invoices, 3, p_cash_receipt_id);
1480: dbms_sql.define_column (trx_invoices, 4, p_paying_customer_id);
1481: dbms_sql.define_column (trx_invoices, 5, p_paying_site_use_id);
1482: dbms_sql.define_column (trx_invoices, 6, p_payment_trxn_extension_id);
1483: dbms_sql.define_column (trx_invoices, 7, p_due_date);
1484: dbms_sql.define_column (trx_invoices, 8, p_amount_due_remaining);
1485: dbms_sql.define_column (trx_invoices, 9, p_cust_bank_account_id);

Line 1482: dbms_sql.define_column (trx_invoices, 6, p_payment_trxn_extension_id);

1478: dbms_sql.define_column (trx_invoices, 2, p_customer_trx_id);
1479: dbms_sql.define_column (trx_invoices, 3, p_cash_receipt_id);
1480: dbms_sql.define_column (trx_invoices, 4, p_paying_customer_id);
1481: dbms_sql.define_column (trx_invoices, 5, p_paying_site_use_id);
1482: dbms_sql.define_column (trx_invoices, 6, p_payment_trxn_extension_id);
1483: dbms_sql.define_column (trx_invoices, 7, p_due_date);
1484: dbms_sql.define_column (trx_invoices, 8, p_amount_due_remaining);
1485: dbms_sql.define_column (trx_invoices, 9, p_cust_bank_account_id);
1486: dbms_sql.define_column (trx_invoices, 10, p_cust_min_amt);

Line 1483: dbms_sql.define_column (trx_invoices, 7, p_due_date);

1479: dbms_sql.define_column (trx_invoices, 3, p_cash_receipt_id);
1480: dbms_sql.define_column (trx_invoices, 4, p_paying_customer_id);
1481: dbms_sql.define_column (trx_invoices, 5, p_paying_site_use_id);
1482: dbms_sql.define_column (trx_invoices, 6, p_payment_trxn_extension_id);
1483: dbms_sql.define_column (trx_invoices, 7, p_due_date);
1484: dbms_sql.define_column (trx_invoices, 8, p_amount_due_remaining);
1485: dbms_sql.define_column (trx_invoices, 9, p_cust_bank_account_id);
1486: dbms_sql.define_column (trx_invoices, 10, p_cust_min_amt);
1487: dbms_sql.define_column (trx_invoices, 11, p_payment_channel_code,30);

Line 1484: dbms_sql.define_column (trx_invoices, 8, p_amount_due_remaining);

1480: dbms_sql.define_column (trx_invoices, 4, p_paying_customer_id);
1481: dbms_sql.define_column (trx_invoices, 5, p_paying_site_use_id);
1482: dbms_sql.define_column (trx_invoices, 6, p_payment_trxn_extension_id);
1483: dbms_sql.define_column (trx_invoices, 7, p_due_date);
1484: dbms_sql.define_column (trx_invoices, 8, p_amount_due_remaining);
1485: dbms_sql.define_column (trx_invoices, 9, p_cust_bank_account_id);
1486: dbms_sql.define_column (trx_invoices, 10, p_cust_min_amt);
1487: dbms_sql.define_column (trx_invoices, 11, p_payment_channel_code,30);
1488: dbms_sql.define_column (trx_invoices, 12, p_instrument_type,30);

Line 1485: dbms_sql.define_column (trx_invoices, 9, p_cust_bank_account_id);

1481: dbms_sql.define_column (trx_invoices, 5, p_paying_site_use_id);
1482: dbms_sql.define_column (trx_invoices, 6, p_payment_trxn_extension_id);
1483: dbms_sql.define_column (trx_invoices, 7, p_due_date);
1484: dbms_sql.define_column (trx_invoices, 8, p_amount_due_remaining);
1485: dbms_sql.define_column (trx_invoices, 9, p_cust_bank_account_id);
1486: dbms_sql.define_column (trx_invoices, 10, p_cust_min_amt);
1487: dbms_sql.define_column (trx_invoices, 11, p_payment_channel_code,30);
1488: dbms_sql.define_column (trx_invoices, 12, p_instrument_type,30);
1489:

Line 1486: dbms_sql.define_column (trx_invoices, 10, p_cust_min_amt);

1482: dbms_sql.define_column (trx_invoices, 6, p_payment_trxn_extension_id);
1483: dbms_sql.define_column (trx_invoices, 7, p_due_date);
1484: dbms_sql.define_column (trx_invoices, 8, p_amount_due_remaining);
1485: dbms_sql.define_column (trx_invoices, 9, p_cust_bank_account_id);
1486: dbms_sql.define_column (trx_invoices, 10, p_cust_min_amt);
1487: dbms_sql.define_column (trx_invoices, 11, p_payment_channel_code,30);
1488: dbms_sql.define_column (trx_invoices, 12, p_instrument_type,30);
1489:
1490:

Line 1487: dbms_sql.define_column (trx_invoices, 11, p_payment_channel_code,30);

1483: dbms_sql.define_column (trx_invoices, 7, p_due_date);
1484: dbms_sql.define_column (trx_invoices, 8, p_amount_due_remaining);
1485: dbms_sql.define_column (trx_invoices, 9, p_cust_bank_account_id);
1486: dbms_sql.define_column (trx_invoices, 10, p_cust_min_amt);
1487: dbms_sql.define_column (trx_invoices, 11, p_payment_channel_code,30);
1488: dbms_sql.define_column (trx_invoices, 12, p_instrument_type,30);
1489:
1490:
1491:

Line 1488: dbms_sql.define_column (trx_invoices, 12, p_instrument_type,30);

1484: dbms_sql.define_column (trx_invoices, 8, p_amount_due_remaining);
1485: dbms_sql.define_column (trx_invoices, 9, p_cust_bank_account_id);
1486: dbms_sql.define_column (trx_invoices, 10, p_cust_min_amt);
1487: dbms_sql.define_column (trx_invoices, 11, p_payment_channel_code,30);
1488: dbms_sql.define_column (trx_invoices, 12, p_instrument_type,30);
1489:
1490:
1491:
1492: IF PG_DEBUG in ('Y', 'C') THEN

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

1492: IF PG_DEBUG in ('Y', 'C') THEN
1493: arp_standard.debug( 'the select statemnt' || l_sel_stmt);
1494: END IF;
1495:
1496: l_rows_processed := dbms_sql.execute( trx_invoices);
1497:
1498: i:= 0;
1499:
1500: WHILE dbms_sql.fetch_rows( trx_invoices) > 0 LOOP

Line 1500: WHILE dbms_sql.fetch_rows( trx_invoices) > 0 LOOP

1496: l_rows_processed := dbms_sql.execute( trx_invoices);
1497:
1498: i:= 0;
1499:
1500: WHILE dbms_sql.fetch_rows( trx_invoices) > 0 LOOP
1501: arp_standard.debug ('the value of i- ent ' || to_char(i));
1502: dbms_sql.column_value (trx_invoices, 1, p_payment_schedule_id);
1503: dbms_sql.column_value (trx_invoices, 2, p_customer_trx_id);
1504: dbms_sql.column_value (trx_invoices, 3, p_cash_receipt_id);

Line 1502: dbms_sql.column_value (trx_invoices, 1, p_payment_schedule_id);

1498: i:= 0;
1499:
1500: WHILE dbms_sql.fetch_rows( trx_invoices) > 0 LOOP
1501: arp_standard.debug ('the value of i- ent ' || to_char(i));
1502: dbms_sql.column_value (trx_invoices, 1, p_payment_schedule_id);
1503: dbms_sql.column_value (trx_invoices, 2, p_customer_trx_id);
1504: dbms_sql.column_value (trx_invoices, 3, p_cash_receipt_id);
1505: dbms_sql.column_value (trx_invoices, 4, p_paying_customer_id);
1506: dbms_sql.column_value (trx_invoices, 5, p_paying_site_use_id);

Line 1503: dbms_sql.column_value (trx_invoices, 2, p_customer_trx_id);

1499:
1500: WHILE dbms_sql.fetch_rows( trx_invoices) > 0 LOOP
1501: arp_standard.debug ('the value of i- ent ' || to_char(i));
1502: dbms_sql.column_value (trx_invoices, 1, p_payment_schedule_id);
1503: dbms_sql.column_value (trx_invoices, 2, p_customer_trx_id);
1504: dbms_sql.column_value (trx_invoices, 3, p_cash_receipt_id);
1505: dbms_sql.column_value (trx_invoices, 4, p_paying_customer_id);
1506: dbms_sql.column_value (trx_invoices, 5, p_paying_site_use_id);
1507: dbms_sql.column_value (trx_invoices, 6, p_payment_trxn_extension_id);

Line 1504: dbms_sql.column_value (trx_invoices, 3, p_cash_receipt_id);

1500: WHILE dbms_sql.fetch_rows( trx_invoices) > 0 LOOP
1501: arp_standard.debug ('the value of i- ent ' || to_char(i));
1502: dbms_sql.column_value (trx_invoices, 1, p_payment_schedule_id);
1503: dbms_sql.column_value (trx_invoices, 2, p_customer_trx_id);
1504: dbms_sql.column_value (trx_invoices, 3, p_cash_receipt_id);
1505: dbms_sql.column_value (trx_invoices, 4, p_paying_customer_id);
1506: dbms_sql.column_value (trx_invoices, 5, p_paying_site_use_id);
1507: dbms_sql.column_value (trx_invoices, 6, p_payment_trxn_extension_id);
1508: dbms_sql.column_value (trx_invoices, 7, p_due_date);

Line 1505: dbms_sql.column_value (trx_invoices, 4, p_paying_customer_id);

1501: arp_standard.debug ('the value of i- ent ' || to_char(i));
1502: dbms_sql.column_value (trx_invoices, 1, p_payment_schedule_id);
1503: dbms_sql.column_value (trx_invoices, 2, p_customer_trx_id);
1504: dbms_sql.column_value (trx_invoices, 3, p_cash_receipt_id);
1505: dbms_sql.column_value (trx_invoices, 4, p_paying_customer_id);
1506: dbms_sql.column_value (trx_invoices, 5, p_paying_site_use_id);
1507: dbms_sql.column_value (trx_invoices, 6, p_payment_trxn_extension_id);
1508: dbms_sql.column_value (trx_invoices, 7, p_due_date);
1509: dbms_sql.column_value (trx_invoices, 8, p_amount_due_remaining);

Line 1506: dbms_sql.column_value (trx_invoices, 5, p_paying_site_use_id);

1502: dbms_sql.column_value (trx_invoices, 1, p_payment_schedule_id);
1503: dbms_sql.column_value (trx_invoices, 2, p_customer_trx_id);
1504: dbms_sql.column_value (trx_invoices, 3, p_cash_receipt_id);
1505: dbms_sql.column_value (trx_invoices, 4, p_paying_customer_id);
1506: dbms_sql.column_value (trx_invoices, 5, p_paying_site_use_id);
1507: dbms_sql.column_value (trx_invoices, 6, p_payment_trxn_extension_id);
1508: dbms_sql.column_value (trx_invoices, 7, p_due_date);
1509: dbms_sql.column_value (trx_invoices, 8, p_amount_due_remaining);
1510: dbms_sql.column_value (trx_invoices, 9, p_cust_bank_account_id);

Line 1507: dbms_sql.column_value (trx_invoices, 6, p_payment_trxn_extension_id);

1503: dbms_sql.column_value (trx_invoices, 2, p_customer_trx_id);
1504: dbms_sql.column_value (trx_invoices, 3, p_cash_receipt_id);
1505: dbms_sql.column_value (trx_invoices, 4, p_paying_customer_id);
1506: dbms_sql.column_value (trx_invoices, 5, p_paying_site_use_id);
1507: dbms_sql.column_value (trx_invoices, 6, p_payment_trxn_extension_id);
1508: dbms_sql.column_value (trx_invoices, 7, p_due_date);
1509: dbms_sql.column_value (trx_invoices, 8, p_amount_due_remaining);
1510: dbms_sql.column_value (trx_invoices, 9, p_cust_bank_account_id);
1511: dbms_sql.column_value (trx_invoices, 10, p_cust_min_amt);

Line 1508: dbms_sql.column_value (trx_invoices, 7, p_due_date);

1504: dbms_sql.column_value (trx_invoices, 3, p_cash_receipt_id);
1505: dbms_sql.column_value (trx_invoices, 4, p_paying_customer_id);
1506: dbms_sql.column_value (trx_invoices, 5, p_paying_site_use_id);
1507: dbms_sql.column_value (trx_invoices, 6, p_payment_trxn_extension_id);
1508: dbms_sql.column_value (trx_invoices, 7, p_due_date);
1509: dbms_sql.column_value (trx_invoices, 8, p_amount_due_remaining);
1510: dbms_sql.column_value (trx_invoices, 9, p_cust_bank_account_id);
1511: dbms_sql.column_value (trx_invoices, 10, p_cust_min_amt);
1512: dbms_sql.column_value (trx_invoices, 11, p_payment_channel_code);

Line 1509: dbms_sql.column_value (trx_invoices, 8, p_amount_due_remaining);

1505: dbms_sql.column_value (trx_invoices, 4, p_paying_customer_id);
1506: dbms_sql.column_value (trx_invoices, 5, p_paying_site_use_id);
1507: dbms_sql.column_value (trx_invoices, 6, p_payment_trxn_extension_id);
1508: dbms_sql.column_value (trx_invoices, 7, p_due_date);
1509: dbms_sql.column_value (trx_invoices, 8, p_amount_due_remaining);
1510: dbms_sql.column_value (trx_invoices, 9, p_cust_bank_account_id);
1511: dbms_sql.column_value (trx_invoices, 10, p_cust_min_amt);
1512: dbms_sql.column_value (trx_invoices, 11, p_payment_channel_code);
1513: dbms_sql.column_value (trx_invoices, 12, p_instrument_type);

Line 1510: dbms_sql.column_value (trx_invoices, 9, p_cust_bank_account_id);

1506: dbms_sql.column_value (trx_invoices, 5, p_paying_site_use_id);
1507: dbms_sql.column_value (trx_invoices, 6, p_payment_trxn_extension_id);
1508: dbms_sql.column_value (trx_invoices, 7, p_due_date);
1509: dbms_sql.column_value (trx_invoices, 8, p_amount_due_remaining);
1510: dbms_sql.column_value (trx_invoices, 9, p_cust_bank_account_id);
1511: dbms_sql.column_value (trx_invoices, 10, p_cust_min_amt);
1512: dbms_sql.column_value (trx_invoices, 11, p_payment_channel_code);
1513: dbms_sql.column_value (trx_invoices, 12, p_instrument_type);
1514:

Line 1511: dbms_sql.column_value (trx_invoices, 10, p_cust_min_amt);

1507: dbms_sql.column_value (trx_invoices, 6, p_payment_trxn_extension_id);
1508: dbms_sql.column_value (trx_invoices, 7, p_due_date);
1509: dbms_sql.column_value (trx_invoices, 8, p_amount_due_remaining);
1510: dbms_sql.column_value (trx_invoices, 9, p_cust_bank_account_id);
1511: dbms_sql.column_value (trx_invoices, 10, p_cust_min_amt);
1512: dbms_sql.column_value (trx_invoices, 11, p_payment_channel_code);
1513: dbms_sql.column_value (trx_invoices, 12, p_instrument_type);
1514:
1515: IF PG_DEBUG in ( 'Y','C') THEN

Line 1512: dbms_sql.column_value (trx_invoices, 11, p_payment_channel_code);

1508: dbms_sql.column_value (trx_invoices, 7, p_due_date);
1509: dbms_sql.column_value (trx_invoices, 8, p_amount_due_remaining);
1510: dbms_sql.column_value (trx_invoices, 9, p_cust_bank_account_id);
1511: dbms_sql.column_value (trx_invoices, 10, p_cust_min_amt);
1512: dbms_sql.column_value (trx_invoices, 11, p_payment_channel_code);
1513: dbms_sql.column_value (trx_invoices, 12, p_instrument_type);
1514:
1515: IF PG_DEBUG in ( 'Y','C') THEN
1516: arp_standard.debug ('the value of ps_id ' || p_payment_schedule_id);

Line 1513: dbms_sql.column_value (trx_invoices, 12, p_instrument_type);

1509: dbms_sql.column_value (trx_invoices, 8, p_amount_due_remaining);
1510: dbms_sql.column_value (trx_invoices, 9, p_cust_bank_account_id);
1511: dbms_sql.column_value (trx_invoices, 10, p_cust_min_amt);
1512: dbms_sql.column_value (trx_invoices, 11, p_payment_channel_code);
1513: dbms_sql.column_value (trx_invoices, 12, p_instrument_type);
1514:
1515: IF PG_DEBUG in ( 'Y','C') THEN
1516: arp_standard.debug ('the value of ps_id ' || p_payment_schedule_id);
1517: arp_standard.debug ('the value of payment_trxn_id ' || p_payment_trxn_extension_id);

Line 1543: l_rows_fetched := dbms_sql.last_row_count ;

1539: END IF;
1540:
1541: END LOOP;
1542:
1543: l_rows_fetched := dbms_sql.last_row_count ;
1544:
1545: IF PG_DEBUG in ('Y', 'C') THEN
1546: arp_standard.debug ('the no of rows fetched ' || l_rows_fetched);
1547: END IF;

Line 1549: dbms_sql.close_cursor( trx_invoices);

1545: IF PG_DEBUG in ('Y', 'C') THEN
1546: arp_standard.debug ('the no of rows fetched ' || l_rows_fetched);
1547: END IF;
1548:
1549: dbms_sql.close_cursor( trx_invoices);
1550:
1551: fnd_file.put_line(fnd_file.log,'Number of Rows Fetched :'||l_rows_fetched);
1552: IF l_rows_fetched > 0 THEN -- Changed as per Bug:5331158 for avoiding error ORA-06569
1553: -- Bulk Insert into AR_RECEIPTS_GT

Line 1562: rec_t := dbms_sql.open_cursor;

1558: inst_stmt := 'insert into ar_receipts_gt values ( :psid_array,:trxid_array,:crid_array,
1559: :paycust_array,:paysite_array,:pmt_trxn_id_array,
1560: :duedate_array,:amtdue_array,:custbank_array,
1561: :cust_amt_array,null,:pmt_channel_array,:pmt_instr_array,null)';
1562: rec_t := dbms_sql.open_cursor;
1563:
1564: dbms_sql.parse (rec_t,inst_stmt,dbms_sql.v7);
1565:
1566: dbms_sql.bind_array (rec_t,':psid_array', ps_id_array);

Line 1564: dbms_sql.parse (rec_t,inst_stmt,dbms_sql.v7);

1560: :duedate_array,:amtdue_array,:custbank_array,
1561: :cust_amt_array,null,:pmt_channel_array,:pmt_instr_array,null)';
1562: rec_t := dbms_sql.open_cursor;
1563:
1564: dbms_sql.parse (rec_t,inst_stmt,dbms_sql.v7);
1565:
1566: dbms_sql.bind_array (rec_t,':psid_array', ps_id_array);
1567: dbms_sql.bind_array (rec_t,':trxid_array', trx_id_array);
1568: dbms_sql.bind_array (rec_t,':crid_array', cr_id_array);

Line 1566: dbms_sql.bind_array (rec_t,':psid_array', ps_id_array);

1562: rec_t := dbms_sql.open_cursor;
1563:
1564: dbms_sql.parse (rec_t,inst_stmt,dbms_sql.v7);
1565:
1566: dbms_sql.bind_array (rec_t,':psid_array', ps_id_array);
1567: dbms_sql.bind_array (rec_t,':trxid_array', trx_id_array);
1568: dbms_sql.bind_array (rec_t,':crid_array', cr_id_array);
1569: dbms_sql.bind_array (rec_t,':paycust_array',paying_customer_id_array);
1570: dbms_sql.bind_array (rec_t,':paysite_array',paying_site_use_id_array);

Line 1567: dbms_sql.bind_array (rec_t,':trxid_array', trx_id_array);

1563:
1564: dbms_sql.parse (rec_t,inst_stmt,dbms_sql.v7);
1565:
1566: dbms_sql.bind_array (rec_t,':psid_array', ps_id_array);
1567: dbms_sql.bind_array (rec_t,':trxid_array', trx_id_array);
1568: dbms_sql.bind_array (rec_t,':crid_array', cr_id_array);
1569: dbms_sql.bind_array (rec_t,':paycust_array',paying_customer_id_array);
1570: dbms_sql.bind_array (rec_t,':paysite_array',paying_site_use_id_array);
1571: dbms_sql.bind_array (rec_t,':pmt_trxn_id_array',pmt_trxn_ext_id_array);

Line 1568: dbms_sql.bind_array (rec_t,':crid_array', cr_id_array);

1564: dbms_sql.parse (rec_t,inst_stmt,dbms_sql.v7);
1565:
1566: dbms_sql.bind_array (rec_t,':psid_array', ps_id_array);
1567: dbms_sql.bind_array (rec_t,':trxid_array', trx_id_array);
1568: dbms_sql.bind_array (rec_t,':crid_array', cr_id_array);
1569: dbms_sql.bind_array (rec_t,':paycust_array',paying_customer_id_array);
1570: dbms_sql.bind_array (rec_t,':paysite_array',paying_site_use_id_array);
1571: dbms_sql.bind_array (rec_t,':pmt_trxn_id_array',pmt_trxn_ext_id_array);
1572: dbms_sql.bind_array (rec_t,':duedate_array',due_date_array);

Line 1569: dbms_sql.bind_array (rec_t,':paycust_array',paying_customer_id_array);

1565:
1566: dbms_sql.bind_array (rec_t,':psid_array', ps_id_array);
1567: dbms_sql.bind_array (rec_t,':trxid_array', trx_id_array);
1568: dbms_sql.bind_array (rec_t,':crid_array', cr_id_array);
1569: dbms_sql.bind_array (rec_t,':paycust_array',paying_customer_id_array);
1570: dbms_sql.bind_array (rec_t,':paysite_array',paying_site_use_id_array);
1571: dbms_sql.bind_array (rec_t,':pmt_trxn_id_array',pmt_trxn_ext_id_array);
1572: dbms_sql.bind_array (rec_t,':duedate_array',due_date_array);
1573: dbms_sql.bind_array (rec_t,':amtdue_array',adr_array);

Line 1570: dbms_sql.bind_array (rec_t,':paysite_array',paying_site_use_id_array);

1566: dbms_sql.bind_array (rec_t,':psid_array', ps_id_array);
1567: dbms_sql.bind_array (rec_t,':trxid_array', trx_id_array);
1568: dbms_sql.bind_array (rec_t,':crid_array', cr_id_array);
1569: dbms_sql.bind_array (rec_t,':paycust_array',paying_customer_id_array);
1570: dbms_sql.bind_array (rec_t,':paysite_array',paying_site_use_id_array);
1571: dbms_sql.bind_array (rec_t,':pmt_trxn_id_array',pmt_trxn_ext_id_array);
1572: dbms_sql.bind_array (rec_t,':duedate_array',due_date_array);
1573: dbms_sql.bind_array (rec_t,':amtdue_array',adr_array);
1574: dbms_sql.bind_array (rec_t,':custbank_array',cust_bank_acct_id_array);

Line 1571: dbms_sql.bind_array (rec_t,':pmt_trxn_id_array',pmt_trxn_ext_id_array);

1567: dbms_sql.bind_array (rec_t,':trxid_array', trx_id_array);
1568: dbms_sql.bind_array (rec_t,':crid_array', cr_id_array);
1569: dbms_sql.bind_array (rec_t,':paycust_array',paying_customer_id_array);
1570: dbms_sql.bind_array (rec_t,':paysite_array',paying_site_use_id_array);
1571: dbms_sql.bind_array (rec_t,':pmt_trxn_id_array',pmt_trxn_ext_id_array);
1572: dbms_sql.bind_array (rec_t,':duedate_array',due_date_array);
1573: dbms_sql.bind_array (rec_t,':amtdue_array',adr_array);
1574: dbms_sql.bind_array (rec_t,':custbank_array',cust_bank_acct_id_array);
1575: dbms_sql.bind_array (rec_t,':cust_amt_array',cust_min_amt_array);

Line 1572: dbms_sql.bind_array (rec_t,':duedate_array',due_date_array);

1568: dbms_sql.bind_array (rec_t,':crid_array', cr_id_array);
1569: dbms_sql.bind_array (rec_t,':paycust_array',paying_customer_id_array);
1570: dbms_sql.bind_array (rec_t,':paysite_array',paying_site_use_id_array);
1571: dbms_sql.bind_array (rec_t,':pmt_trxn_id_array',pmt_trxn_ext_id_array);
1572: dbms_sql.bind_array (rec_t,':duedate_array',due_date_array);
1573: dbms_sql.bind_array (rec_t,':amtdue_array',adr_array);
1574: dbms_sql.bind_array (rec_t,':custbank_array',cust_bank_acct_id_array);
1575: dbms_sql.bind_array (rec_t,':cust_amt_array',cust_min_amt_array);
1576: dbms_sql.bind_array (rec_t,':pmt_channel_array',pmt_channel_array);

Line 1573: dbms_sql.bind_array (rec_t,':amtdue_array',adr_array);

1569: dbms_sql.bind_array (rec_t,':paycust_array',paying_customer_id_array);
1570: dbms_sql.bind_array (rec_t,':paysite_array',paying_site_use_id_array);
1571: dbms_sql.bind_array (rec_t,':pmt_trxn_id_array',pmt_trxn_ext_id_array);
1572: dbms_sql.bind_array (rec_t,':duedate_array',due_date_array);
1573: dbms_sql.bind_array (rec_t,':amtdue_array',adr_array);
1574: dbms_sql.bind_array (rec_t,':custbank_array',cust_bank_acct_id_array);
1575: dbms_sql.bind_array (rec_t,':cust_amt_array',cust_min_amt_array);
1576: dbms_sql.bind_array (rec_t,':pmt_channel_array',pmt_channel_array);
1577: dbms_sql.bind_array (rec_t,':pmt_instr_array',pmt_instrument_type_array);

Line 1574: dbms_sql.bind_array (rec_t,':custbank_array',cust_bank_acct_id_array);

1570: dbms_sql.bind_array (rec_t,':paysite_array',paying_site_use_id_array);
1571: dbms_sql.bind_array (rec_t,':pmt_trxn_id_array',pmt_trxn_ext_id_array);
1572: dbms_sql.bind_array (rec_t,':duedate_array',due_date_array);
1573: dbms_sql.bind_array (rec_t,':amtdue_array',adr_array);
1574: dbms_sql.bind_array (rec_t,':custbank_array',cust_bank_acct_id_array);
1575: dbms_sql.bind_array (rec_t,':cust_amt_array',cust_min_amt_array);
1576: dbms_sql.bind_array (rec_t,':pmt_channel_array',pmt_channel_array);
1577: dbms_sql.bind_array (rec_t,':pmt_instr_array',pmt_instrument_type_array);
1578:

Line 1575: dbms_sql.bind_array (rec_t,':cust_amt_array',cust_min_amt_array);

1571: dbms_sql.bind_array (rec_t,':pmt_trxn_id_array',pmt_trxn_ext_id_array);
1572: dbms_sql.bind_array (rec_t,':duedate_array',due_date_array);
1573: dbms_sql.bind_array (rec_t,':amtdue_array',adr_array);
1574: dbms_sql.bind_array (rec_t,':custbank_array',cust_bank_acct_id_array);
1575: dbms_sql.bind_array (rec_t,':cust_amt_array',cust_min_amt_array);
1576: dbms_sql.bind_array (rec_t,':pmt_channel_array',pmt_channel_array);
1577: dbms_sql.bind_array (rec_t,':pmt_instr_array',pmt_instrument_type_array);
1578:
1579:

Line 1576: dbms_sql.bind_array (rec_t,':pmt_channel_array',pmt_channel_array);

1572: dbms_sql.bind_array (rec_t,':duedate_array',due_date_array);
1573: dbms_sql.bind_array (rec_t,':amtdue_array',adr_array);
1574: dbms_sql.bind_array (rec_t,':custbank_array',cust_bank_acct_id_array);
1575: dbms_sql.bind_array (rec_t,':cust_amt_array',cust_min_amt_array);
1576: dbms_sql.bind_array (rec_t,':pmt_channel_array',pmt_channel_array);
1577: dbms_sql.bind_array (rec_t,':pmt_instr_array',pmt_instrument_type_array);
1578:
1579:
1580: dummy := dbms_sql.execute(rec_t);

Line 1577: dbms_sql.bind_array (rec_t,':pmt_instr_array',pmt_instrument_type_array);

1573: dbms_sql.bind_array (rec_t,':amtdue_array',adr_array);
1574: dbms_sql.bind_array (rec_t,':custbank_array',cust_bank_acct_id_array);
1575: dbms_sql.bind_array (rec_t,':cust_amt_array',cust_min_amt_array);
1576: dbms_sql.bind_array (rec_t,':pmt_channel_array',pmt_channel_array);
1577: dbms_sql.bind_array (rec_t,':pmt_instr_array',pmt_instrument_type_array);
1578:
1579:
1580: dummy := dbms_sql.execute(rec_t);
1581:

Line 1580: dummy := dbms_sql.execute(rec_t);

1576: dbms_sql.bind_array (rec_t,':pmt_channel_array',pmt_channel_array);
1577: dbms_sql.bind_array (rec_t,':pmt_instr_array',pmt_instrument_type_array);
1578:
1579:
1580: dummy := dbms_sql.execute(rec_t);
1581:
1582: dbms_sql.close_cursor(rec_t);
1583:
1584: EXCEPTION WHEN OTHERS THEN

Line 1582: dbms_sql.close_cursor(rec_t);

1578:
1579:
1580: dummy := dbms_sql.execute(rec_t);
1581:
1582: dbms_sql.close_cursor(rec_t);
1583:
1584: EXCEPTION WHEN OTHERS THEN
1585: G_ERROR := 'Y';
1586: if dbms_sql.is_open(rec_t) then

Line 1586: if dbms_sql.is_open(rec_t) then

1582: dbms_sql.close_cursor(rec_t);
1583:
1584: EXCEPTION WHEN OTHERS THEN
1585: G_ERROR := 'Y';
1586: if dbms_sql.is_open(rec_t) then
1587: dbms_sql.close_cursor(rec_t);
1588: end if;
1589: raise;
1590:

Line 1587: dbms_sql.close_cursor(rec_t);

1583:
1584: EXCEPTION WHEN OTHERS THEN
1585: G_ERROR := 'Y';
1586: if dbms_sql.is_open(rec_t) then
1587: dbms_sql.close_cursor(rec_t);
1588: end if;
1589: raise;
1590:
1591: