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.ARP_PROCESS_LOCKBOX dependencies on DBMS_SQL

Line 1285: dbms_sql.bind_variable(l_cursor_name, ':b_current_matching_date', l_current_matching_date);

1281: -- into :l_current_customer_id, :r_current_invoice_number, :r_current_invoice_date;
1282: debug1('Now binding the variables for Dyn SQL.');
1283: begin
1284: debug1('Binding b_current_matching_date with: ' || to_char(l_current_matching_date));
1285: dbms_sql.bind_variable(l_cursor_name, ':b_current_matching_date', l_current_matching_date);
1286: exception
1287: when bind_var_does_not_exist then null;
1288: when others then raise;
1289: end;

Line 1292: dbms_sql.bind_variable(l_cursor_name, ':b_current_matching_number', l_current_matching_number);

1288: when others then raise;
1289: end;
1290: begin
1291: debug1('Binding b_current_matching_number with: ' || l_current_matching_number);
1292: dbms_sql.bind_variable(l_cursor_name, ':b_current_matching_number', l_current_matching_number);
1293: exception
1294: when bind_var_does_not_exist then null;
1295: when others then raise;
1296: end;

Line 1299: dbms_sql.bind_variable(l_cursor_name, ':b_pay_unrelated_customers', p_pay_unrelated_invoices);

1295: when others then raise;
1296: end;
1297: begin
1298: debug1('Binding b_pay_unrelated_customers with: ' || p_pay_unrelated_invoices);
1299: dbms_sql.bind_variable(l_cursor_name, ':b_pay_unrelated_customers', p_pay_unrelated_invoices);
1300: exception
1301: when bind_var_does_not_exist then null;
1302: when others then raise;
1303: end;

Line 1306: dbms_sql.bind_variable(l_cursor_name, ':b_customer_id', p_customer_id);

1302: when others then raise;
1303: end;
1304: begin
1305: debug1('Binding b_customer_id with: ' || to_char(p_customer_id));
1306: dbms_sql.bind_variable(l_cursor_name, ':b_customer_id', p_customer_id);
1307: exception
1308: when bind_var_does_not_exist then null;
1309: when others then raise;
1310: end;

Line 1313: dbms_sql.bind_variable(l_cursor_name, ':b_receipt_date', to_char(p_receipt_date,'YYYYMMDD'));

1309: when others then raise;
1310: end;
1311: begin
1312: debug1('Binding b_receipt_date with: ' || to_char(p_receipt_date,'YYYYMMDD'));
1313: dbms_sql.bind_variable(l_cursor_name, ':b_receipt_date', to_char(p_receipt_date,'YYYYMMDD'));
1314: exception
1315: when bind_var_does_not_exist then null;
1316: when others then raise;
1317: end;

Line 1320: dbms_sql.bind_variable(l_cursor_name, ':b_current_installment', l_current_installment);

1316: when others then raise;
1317: end;
1318: begin
1319: debug1('Binding b_current_installment with: ' || to_char(l_current_installment));
1320: dbms_sql.bind_variable(l_cursor_name, ':b_current_installment', l_current_installment);
1321: exception
1322: when bind_var_does_not_exist then null;
1323: when others then raise;
1324: end;

Line 1327: dbms_sql.bind_variable(l_cursor_name, ':b_lockbox_matching_option', p_lockbox_matching_option);

1323: when others then raise;
1324: end;
1325: begin
1326: debug1('Binding b_lockbox_matching_option with: ' || p_lockbox_matching_option);
1327: dbms_sql.bind_variable(l_cursor_name, ':b_lockbox_matching_option', p_lockbox_matching_option);
1328: exception
1329: when bind_var_does_not_exist then null;
1330: when others then raise;
1331: end;

Line 1334: dbms_sql.bind_variable(l_cursor_name, ':b_use_matching_date', p_use_matching_date);

1330: when others then raise;
1331: end;
1332: begin
1333: debug1('Binding b_use_matching_date with: ' || p_use_matching_date);
1334: dbms_sql.bind_variable(l_cursor_name, ':b_use_matching_date', p_use_matching_date);
1335: exception
1336: when bind_var_does_not_exist then null;
1337: when others then raise;
1338: end;

Line 1341: dbms_sql.define_column(l_cursor_name, 1, l_current_customer_id);

1337: when others then raise;
1338: end;
1339: -- Define the columns to fetch the values INTO appropriate variables.
1340: debug1('Now Defining columns for Dyn SQL.');
1341: dbms_sql.define_column(l_cursor_name, 1, l_current_customer_id);
1342: dbms_sql.define_column(l_cursor_name, 2, r_current_invoice_number, 50);
1343: dbms_sql.define_column(l_cursor_name, 3, r_current_invoice_date);
1344: -- Fetch and execute the record.
1345: -- At this point we expect the query to return only one record,

Line 1342: dbms_sql.define_column(l_cursor_name, 2, r_current_invoice_number, 50);

1338: end;
1339: -- Define the columns to fetch the values INTO appropriate variables.
1340: debug1('Now Defining columns for Dyn SQL.');
1341: dbms_sql.define_column(l_cursor_name, 1, l_current_customer_id);
1342: dbms_sql.define_column(l_cursor_name, 2, r_current_invoice_number, 50);
1343: dbms_sql.define_column(l_cursor_name, 3, r_current_invoice_date);
1344: -- Fetch and execute the record.
1345: -- At this point we expect the query to return only one record,
1346: -- so it should raise error exception in case it fetches more than one

Line 1343: dbms_sql.define_column(l_cursor_name, 3, r_current_invoice_date);

1339: -- Define the columns to fetch the values INTO appropriate variables.
1340: debug1('Now Defining columns for Dyn SQL.');
1341: dbms_sql.define_column(l_cursor_name, 1, l_current_customer_id);
1342: dbms_sql.define_column(l_cursor_name, 2, r_current_invoice_number, 50);
1343: dbms_sql.define_column(l_cursor_name, 3, r_current_invoice_date);
1344: -- Fetch and execute the record.
1345: -- At this point we expect the query to return only one record,
1346: -- so it should raise error exception in case it fetches more than one
1347: -- record.

Line 1351: r_temp_int := dbms_sql.execute_and_fetch(l_cursor_name, TRUE);

1347: -- record.
1348: --
1349: debug1('Now executing and fetching data from Dyn SQL..');
1350: begin
1351: r_temp_int := dbms_sql.execute_and_fetch(l_cursor_name, TRUE);
1352: /** r_temp_int := dbms_sql.execute(l_cursor_name);
1353: debug1('After exeucute .. ');
1354: r_temp_int := dbms_sql.fetch_rows(l_cursor_name);
1355: **/

Line 1352: /** r_temp_int := dbms_sql.execute(l_cursor_name);

1348: --
1349: debug1('Now executing and fetching data from Dyn SQL..');
1350: begin
1351: r_temp_int := dbms_sql.execute_and_fetch(l_cursor_name, TRUE);
1352: /** r_temp_int := dbms_sql.execute(l_cursor_name);
1353: debug1('After exeucute .. ');
1354: r_temp_int := dbms_sql.fetch_rows(l_cursor_name);
1355: **/
1356: debug1('After fetch .. ');

Line 1354: r_temp_int := dbms_sql.fetch_rows(l_cursor_name);

1350: begin
1351: r_temp_int := dbms_sql.execute_and_fetch(l_cursor_name, TRUE);
1352: /** r_temp_int := dbms_sql.execute(l_cursor_name);
1353: debug1('After exeucute .. ');
1354: r_temp_int := dbms_sql.fetch_rows(l_cursor_name);
1355: **/
1356: debug1('After fetch .. ');
1357: exception
1358: when not_all_var_bound then

Line 1367: dbms_sql.column_value(l_cursor_name, 1, l_current_customer_id);

1363: raise;
1364: end;
1365: --
1366: debug1('Now putting data in columns..Dyn SQL..');
1367: dbms_sql.column_value(l_cursor_name, 1, l_current_customer_id);
1368: dbms_sql.column_value(l_cursor_name, 2, r_current_invoice_number);
1369: dbms_sql.column_value(l_cursor_name, 3, r_current_invoice_date);
1370: debug1('l_current_customer_id is ' || to_char(l_current_customer_id));
1371: debug1('r_current_invoice_number is ' || r_current_invoice_number);

Line 1368: dbms_sql.column_value(l_cursor_name, 2, r_current_invoice_number);

1364: end;
1365: --
1366: debug1('Now putting data in columns..Dyn SQL..');
1367: dbms_sql.column_value(l_cursor_name, 1, l_current_customer_id);
1368: dbms_sql.column_value(l_cursor_name, 2, r_current_invoice_number);
1369: dbms_sql.column_value(l_cursor_name, 3, r_current_invoice_date);
1370: debug1('l_current_customer_id is ' || to_char(l_current_customer_id));
1371: debug1('r_current_invoice_number is ' || r_current_invoice_number);
1372: --

Line 1369: dbms_sql.column_value(l_cursor_name, 3, r_current_invoice_date);

1365: --
1366: debug1('Now putting data in columns..Dyn SQL..');
1367: dbms_sql.column_value(l_cursor_name, 1, l_current_customer_id);
1368: dbms_sql.column_value(l_cursor_name, 2, r_current_invoice_number);
1369: dbms_sql.column_value(l_cursor_name, 3, r_current_invoice_date);
1370: debug1('l_current_customer_id is ' || to_char(l_current_customer_id));
1371: debug1('r_current_invoice_number is ' || r_current_invoice_number);
1372: --
1373: IF (i = 1) THEN

Line 2074: IF (dbms_sql.is_open(opened_cursor_table(i).cursor_name)) THEN

2070: debug1('arp_process_lockbox.get_cursor_name()+');
2071: --
2072: FOR i in 1 .. g_total_maching_options
2073: LOOP
2074: IF (dbms_sql.is_open(opened_cursor_table(i).cursor_name)) THEN
2075: debug1('Closing Cursor for index ' || to_char(i));
2076: dbms_sql.close_cursor(opened_cursor_table(i).cursor_name);
2077: END IF;
2078: END LOOP; -- End loop for 1 to g_total_maching_options matching numbers.

Line 2076: dbms_sql.close_cursor(opened_cursor_table(i).cursor_name);

2072: FOR i in 1 .. g_total_maching_options
2073: LOOP
2074: IF (dbms_sql.is_open(opened_cursor_table(i).cursor_name)) THEN
2075: debug1('Closing Cursor for index ' || to_char(i));
2076: dbms_sql.close_cursor(opened_cursor_table(i).cursor_name);
2077: END IF;
2078: END LOOP; -- End loop for 1 to g_total_maching_options matching numbers.
2079: --
2080: debug1('arp_process_lockbox.get_cursor_name()-');

Line 4247: g_cursor_name := dbms_sql.open_cursor;

4243: null;
4244: END IF;
4245: --
4246: debug1('Now Opening the cursor..');
4247: g_cursor_name := dbms_sql.open_cursor;
4248: debug1(g_cursor_string);
4249: debug1('Opened the cursor.. Now Parsing cursor..');
4250: dbms_sql.parse(g_cursor_name, g_cursor_string, dbms_sql.NATIVE);
4251: debug1('Parsed cursor.');

Line 4250: dbms_sql.parse(g_cursor_name, g_cursor_string, dbms_sql.NATIVE);

4246: debug1('Now Opening the cursor..');
4247: g_cursor_name := dbms_sql.open_cursor;
4248: debug1(g_cursor_string);
4249: debug1('Opened the cursor.. Now Parsing cursor..');
4250: dbms_sql.parse(g_cursor_name, g_cursor_string, dbms_sql.NATIVE);
4251: debug1('Parsed cursor.');
4252: g_total_maching_options := g_total_maching_options + 1;
4253: -- Insert into PL/SQL table here values of matching_option, cursor_name
4254: --