APPS.CSF_DEBRIEF_PUB dependencies on DBMS_SQL

Line 883: v_cursorid := DBMS_SQL.open_cursor;

879: x_return_status := fnd_api.g_ret_sts_success;
880:
881: FOR i IN c1
882: LOOP
883: v_cursorid := DBMS_SQL.open_cursor;
884: v_blockstr :=
885: ' begin ' || i.hook_package || '.' || i.hook_api || '(:1); end; ';
886: DBMS_SQL.parse (v_cursorid, v_blockstr, DBMS_SQL.v7);
887: DBMS_SQL.bind_variable (v_cursorid, ':1', x_return_status, 20);

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

882: LOOP
883: v_cursorid := DBMS_SQL.open_cursor;
884: v_blockstr :=
885: ' begin ' || i.hook_package || '.' || i.hook_api || '(:1); end; ';
886: DBMS_SQL.parse (v_cursorid, v_blockstr, DBMS_SQL.v7);
887: DBMS_SQL.bind_variable (v_cursorid, ':1', x_return_status, 20);
888: v_dummy := DBMS_SQL.execute (v_cursorid);
889: DBMS_SQL.variable_value (v_cursorid, ':1', x_return_status);
890: DBMS_SQL.close_cursor (v_cursorid);

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

883: v_cursorid := DBMS_SQL.open_cursor;
884: v_blockstr :=
885: ' begin ' || i.hook_package || '.' || i.hook_api || '(:1); end; ';
886: DBMS_SQL.parse (v_cursorid, v_blockstr, DBMS_SQL.v7);
887: DBMS_SQL.bind_variable (v_cursorid, ':1', x_return_status, 20);
888: v_dummy := DBMS_SQL.execute (v_cursorid);
889: DBMS_SQL.variable_value (v_cursorid, ':1', x_return_status);
890: DBMS_SQL.close_cursor (v_cursorid);
891:

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

884: v_blockstr :=
885: ' begin ' || i.hook_package || '.' || i.hook_api || '(:1); end; ';
886: DBMS_SQL.parse (v_cursorid, v_blockstr, DBMS_SQL.v7);
887: DBMS_SQL.bind_variable (v_cursorid, ':1', x_return_status, 20);
888: v_dummy := DBMS_SQL.execute (v_cursorid);
889: DBMS_SQL.variable_value (v_cursorid, ':1', x_return_status);
890: DBMS_SQL.close_cursor (v_cursorid);
891:
892: IF NOT (x_return_status = fnd_api.g_ret_sts_success)

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

885: ' begin ' || i.hook_package || '.' || i.hook_api || '(:1); end; ';
886: DBMS_SQL.parse (v_cursorid, v_blockstr, DBMS_SQL.v7);
887: DBMS_SQL.bind_variable (v_cursorid, ':1', x_return_status, 20);
888: v_dummy := DBMS_SQL.execute (v_cursorid);
889: DBMS_SQL.variable_value (v_cursorid, ':1', x_return_status);
890: DBMS_SQL.close_cursor (v_cursorid);
891:
892: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
893: THEN

Line 890: DBMS_SQL.close_cursor (v_cursorid);

886: DBMS_SQL.parse (v_cursorid, v_blockstr, DBMS_SQL.v7);
887: DBMS_SQL.bind_variable (v_cursorid, ':1', x_return_status, 20);
888: v_dummy := DBMS_SQL.execute (v_cursorid);
889: DBMS_SQL.variable_value (v_cursorid, ':1', x_return_status);
890: DBMS_SQL.close_cursor (v_cursorid);
891:
892: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
893: THEN
894: fnd_message.set_name ('JTF', 'JTF_TASK_MISSING_RETURN_STATUS');