APPS.JTF_TASK_UTL dependencies on DBMS_SQL

Line 92: v_cursorid := DBMS_SQL.open_cursor;

88: x_return_status := fnd_api.g_ret_sts_success;
89:
90: FOR i IN c1
91: LOOP
92: v_cursorid := DBMS_SQL.open_cursor;
93: v_blockstr :=
94: ' begin ' || i.hook_package || '.' || i.hook_api || '(:1); end; ';
95: DBMS_SQL.parse (v_cursorid, v_blockstr, DBMS_SQL.v7);
96: DBMS_SQL.bind_variable (v_cursorid, ':1', x_return_status, 20);

Line 95: DBMS_SQL.parse (v_cursorid, v_blockstr, DBMS_SQL.v7);

91: LOOP
92: v_cursorid := DBMS_SQL.open_cursor;
93: v_blockstr :=
94: ' begin ' || i.hook_package || '.' || i.hook_api || '(:1); end; ';
95: DBMS_SQL.parse (v_cursorid, v_blockstr, DBMS_SQL.v7);
96: DBMS_SQL.bind_variable (v_cursorid, ':1', x_return_status, 20);
97: v_dummy := DBMS_SQL.execute (v_cursorid);
98: DBMS_SQL.variable_value (v_cursorid, ':1', x_return_status);
99: DBMS_SQL.close_cursor (v_cursorid);

Line 96: DBMS_SQL.bind_variable (v_cursorid, ':1', x_return_status, 20);

92: v_cursorid := DBMS_SQL.open_cursor;
93: v_blockstr :=
94: ' begin ' || i.hook_package || '.' || i.hook_api || '(:1); end; ';
95: DBMS_SQL.parse (v_cursorid, v_blockstr, DBMS_SQL.v7);
96: DBMS_SQL.bind_variable (v_cursorid, ':1', x_return_status, 20);
97: v_dummy := DBMS_SQL.execute (v_cursorid);
98: DBMS_SQL.variable_value (v_cursorid, ':1', x_return_status);
99: DBMS_SQL.close_cursor (v_cursorid);
100:

Line 97: v_dummy := DBMS_SQL.execute (v_cursorid);

93: v_blockstr :=
94: ' begin ' || i.hook_package || '.' || i.hook_api || '(:1); end; ';
95: DBMS_SQL.parse (v_cursorid, v_blockstr, DBMS_SQL.v7);
96: DBMS_SQL.bind_variable (v_cursorid, ':1', x_return_status, 20);
97: v_dummy := DBMS_SQL.execute (v_cursorid);
98: DBMS_SQL.variable_value (v_cursorid, ':1', x_return_status);
99: DBMS_SQL.close_cursor (v_cursorid);
100:
101: -- check for null first

Line 98: DBMS_SQL.variable_value (v_cursorid, ':1', x_return_status);

94: ' begin ' || i.hook_package || '.' || i.hook_api || '(:1); end; ';
95: DBMS_SQL.parse (v_cursorid, v_blockstr, DBMS_SQL.v7);
96: DBMS_SQL.bind_variable (v_cursorid, ':1', x_return_status, 20);
97: v_dummy := DBMS_SQL.execute (v_cursorid);
98: DBMS_SQL.variable_value (v_cursorid, ':1', x_return_status);
99: DBMS_SQL.close_cursor (v_cursorid);
100:
101: -- check for null first
102: -- record the package name in the error stack

Line 99: DBMS_SQL.close_cursor (v_cursorid);

95: DBMS_SQL.parse (v_cursorid, v_blockstr, DBMS_SQL.v7);
96: DBMS_SQL.bind_variable (v_cursorid, ':1', x_return_status, 20);
97: v_dummy := DBMS_SQL.execute (v_cursorid);
98: DBMS_SQL.variable_value (v_cursorid, ':1', x_return_status);
99: DBMS_SQL.close_cursor (v_cursorid);
100:
101: -- check for null first
102: -- record the package name in the error stack
103: IF x_return_status IS NULL