APPS.PAY_MAG_TAPE dependencies on DBMS_SQL

Line 10: sql_curs := dbms_sql.open_cursor;

6: rows_processed integer;
7: statem varchar2(256);
8: begin
9: statem := 'BEGIN '||comm||'; END;';
10: sql_curs := dbms_sql.open_cursor;
11: dbms_sql.parse(sql_curs,
12: statem,
13: dbms_sql.v7);
14: rows_processed := dbms_sql.execute(sql_curs);

Line 11: dbms_sql.parse(sql_curs,

7: statem varchar2(256);
8: begin
9: statem := 'BEGIN '||comm||'; END;';
10: sql_curs := dbms_sql.open_cursor;
11: dbms_sql.parse(sql_curs,
12: statem,
13: dbms_sql.v7);
14: rows_processed := dbms_sql.execute(sql_curs);
15: dbms_sql.close_cursor(sql_curs);

Line 13: dbms_sql.v7);

9: statem := 'BEGIN '||comm||'; END;';
10: sql_curs := dbms_sql.open_cursor;
11: dbms_sql.parse(sql_curs,
12: statem,
13: dbms_sql.v7);
14: rows_processed := dbms_sql.execute(sql_curs);
15: dbms_sql.close_cursor(sql_curs);
16: exception
17: when no_data_found then

Line 14: rows_processed := dbms_sql.execute(sql_curs);

10: sql_curs := dbms_sql.open_cursor;
11: dbms_sql.parse(sql_curs,
12: statem,
13: dbms_sql.v7);
14: rows_processed := dbms_sql.execute(sql_curs);
15: dbms_sql.close_cursor(sql_curs);
16: exception
17: when no_data_found then
18: dbms_sql.close_cursor(sql_curs);

Line 15: dbms_sql.close_cursor(sql_curs);

11: dbms_sql.parse(sql_curs,
12: statem,
13: dbms_sql.v7);
14: rows_processed := dbms_sql.execute(sql_curs);
15: dbms_sql.close_cursor(sql_curs);
16: exception
17: when no_data_found then
18: dbms_sql.close_cursor(sql_curs);
19: raise;

Line 18: dbms_sql.close_cursor(sql_curs);

14: rows_processed := dbms_sql.execute(sql_curs);
15: dbms_sql.close_cursor(sql_curs);
16: exception
17: when no_data_found then
18: dbms_sql.close_cursor(sql_curs);
19: raise;
20: end;
21:
22:

Line 55: sql_curs := dbms_sql.open_cursor;

51: from pay_file_details
52: where file_detail_id = pay_mag_tape.g_blob_file_id;
53:
54: statem := 'BEGIN '||comm||'; END;';
55: sql_curs := dbms_sql.open_cursor;
56: dbms_sql.parse(sql_curs,
57: statem,
58: dbms_sql.v7);
59: rows_processed := dbms_sql.execute(sql_curs);

Line 56: dbms_sql.parse(sql_curs,

52: where file_detail_id = pay_mag_tape.g_blob_file_id;
53:
54: statem := 'BEGIN '||comm||'; END;';
55: sql_curs := dbms_sql.open_cursor;
56: dbms_sql.parse(sql_curs,
57: statem,
58: dbms_sql.v7);
59: rows_processed := dbms_sql.execute(sql_curs);
60: dbms_sql.close_cursor(sql_curs);

Line 58: dbms_sql.v7);

54: statem := 'BEGIN '||comm||'; END;';
55: sql_curs := dbms_sql.open_cursor;
56: dbms_sql.parse(sql_curs,
57: statem,
58: dbms_sql.v7);
59: rows_processed := dbms_sql.execute(sql_curs);
60: dbms_sql.close_cursor(sql_curs);
61:
62: pay_core_files.close_file ( p_file_id => pay_mag_tape.g_blob_file_id);

Line 59: rows_processed := dbms_sql.execute(sql_curs);

55: sql_curs := dbms_sql.open_cursor;
56: dbms_sql.parse(sql_curs,
57: statem,
58: dbms_sql.v7);
59: rows_processed := dbms_sql.execute(sql_curs);
60: dbms_sql.close_cursor(sql_curs);
61:
62: pay_core_files.close_file ( p_file_id => pay_mag_tape.g_blob_file_id);
63:

Line 60: dbms_sql.close_cursor(sql_curs);

56: dbms_sql.parse(sql_curs,
57: statem,
58: dbms_sql.v7);
59: rows_processed := dbms_sql.execute(sql_curs);
60: dbms_sql.close_cursor(sql_curs);
61:
62: pay_core_files.close_file ( p_file_id => pay_mag_tape.g_blob_file_id);
63:
64: end;

Line 111: sql_curs := dbms_sql.open_cursor;

107: and legislation_code=leg_code;
108:
109: /* call procedure */
110: statem := 'BEGIN '||proc_name||'; END;';
111: sql_curs := dbms_sql.open_cursor;
112: dbms_sql.parse(sql_curs,
113: statem,
114: dbms_sql.v7);
115: rows_processed := dbms_sql.execute(sql_curs);

Line 112: dbms_sql.parse(sql_curs,

108:
109: /* call procedure */
110: statem := 'BEGIN '||proc_name||'; END;';
111: sql_curs := dbms_sql.open_cursor;
112: dbms_sql.parse(sql_curs,
113: statem,
114: dbms_sql.v7);
115: rows_processed := dbms_sql.execute(sql_curs);
116: dbms_sql.close_cursor(sql_curs);

Line 114: dbms_sql.v7);

110: statem := 'BEGIN '||proc_name||'; END;';
111: sql_curs := dbms_sql.open_cursor;
112: dbms_sql.parse(sql_curs,
113: statem,
114: dbms_sql.v7);
115: rows_processed := dbms_sql.execute(sql_curs);
116: dbms_sql.close_cursor(sql_curs);
117:
118: EXCEPTION

Line 115: rows_processed := dbms_sql.execute(sql_curs);

111: sql_curs := dbms_sql.open_cursor;
112: dbms_sql.parse(sql_curs,
113: statem,
114: dbms_sql.v7);
115: rows_processed := dbms_sql.execute(sql_curs);
116: dbms_sql.close_cursor(sql_curs);
117:
118: EXCEPTION
119: WHEN NO_DATA_FOUND THEN

Line 116: dbms_sql.close_cursor(sql_curs);

112: dbms_sql.parse(sql_curs,
113: statem,
114: dbms_sql.v7);
115: rows_processed := dbms_sql.execute(sql_curs);
116: dbms_sql.close_cursor(sql_curs);
117:
118: EXCEPTION
119: WHEN NO_DATA_FOUND THEN
120: return;