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 1284: dbms_sql.bind_variable(l_cursor_name, ':b_current_matching_date', l_current_matching_date);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 4145: g_cursor_name := dbms_sql.open_cursor;

4141: null;
4142: END IF;
4143: --
4144: debug1('Now Opening the cursor..');
4145: g_cursor_name := dbms_sql.open_cursor;
4146: debug1('Opened the cursor.. Now Parsing cursor..');
4147: --debug1('Stmt :' || g_cursor_string);
4148: --fnd_file.put_line(FND_FILE.LOG, 'Stmt : ' || g_cursor_string);
4149: dbms_sql.parse(g_cursor_name, g_cursor_string, dbms_sql.NATIVE);

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

4145: g_cursor_name := dbms_sql.open_cursor;
4146: debug1('Opened the cursor.. Now Parsing cursor..');
4147: --debug1('Stmt :' || g_cursor_string);
4148: --fnd_file.put_line(FND_FILE.LOG, 'Stmt : ' || g_cursor_string);
4149: dbms_sql.parse(g_cursor_name, g_cursor_string, dbms_sql.NATIVE);
4150: debug1('Parsed cursor.');
4151: g_total_maching_options := g_total_maching_options + 1;
4152: -- Insert into PL/SQL table here values of matching_option, cursor_name
4153: --