APPS.HR_TRANSACTION_SS dependencies on DBMS_SQL

Line 1230: l_cursor := dbms_sql.open_cursor;

1226: 'begin '||p_api_name||
1227: '(p_transaction_step_id => '||':transaction_step_id'||
1228: l_extra_parameter_text||'); end;';
1229: -- open the dynamic cursor
1230: l_cursor := dbms_sql.open_cursor;
1231: -- parse the dynamic cursor
1232: dbms_sql.parse(l_cursor, l_sqlbuf, dbms_sql.v7);
1233: -- bind the transaction step identifier
1234: dbms_sql.bind_variable

Line 1232: dbms_sql.parse(l_cursor, l_sqlbuf, dbms_sql.v7);

1228: l_extra_parameter_text||'); end;';
1229: -- open the dynamic cursor
1230: l_cursor := dbms_sql.open_cursor;
1231: -- parse the dynamic cursor
1232: dbms_sql.parse(l_cursor, l_sqlbuf, dbms_sql.v7);
1233: -- bind the transaction step identifier
1234: dbms_sql.bind_variable
1235: (l_cursor, ':transaction_step_id', p_transaction_step_id);
1236: if l_extra_parameter_text is not null then

Line 1234: dbms_sql.bind_variable

1230: l_cursor := dbms_sql.open_cursor;
1231: -- parse the dynamic cursor
1232: dbms_sql.parse(l_cursor, l_sqlbuf, dbms_sql.v7);
1233: -- bind the transaction step identifier
1234: dbms_sql.bind_variable
1235: (l_cursor, ':transaction_step_id', p_transaction_step_id);
1236: if l_extra_parameter_text is not null then
1237: dbms_sql.bind_variable
1238: (l_cursor, ':'||p_extra_parameter_name, p_extra_parameter_value);

Line 1237: dbms_sql.bind_variable

1233: -- bind the transaction step identifier
1234: dbms_sql.bind_variable
1235: (l_cursor, ':transaction_step_id', p_transaction_step_id);
1236: if l_extra_parameter_text is not null then
1237: dbms_sql.bind_variable
1238: (l_cursor, ':'||p_extra_parameter_name, p_extra_parameter_value);
1239: end if;
1240: -- execute the dynamic statement
1241: l_row_processed := dbms_sql.execute(l_cursor);

Line 1241: l_row_processed := dbms_sql.execute(l_cursor);

1237: dbms_sql.bind_variable
1238: (l_cursor, ':'||p_extra_parameter_name, p_extra_parameter_value);
1239: end if;
1240: -- execute the dynamic statement
1241: l_row_processed := dbms_sql.execute(l_cursor);
1242: -- close the cursor
1243: dbms_sql.close_cursor(l_cursor);
1244: --
1245: -- when in validation only mode raise the Validate_Enabled exception

Line 1243: dbms_sql.close_cursor(l_cursor);

1239: end if;
1240: -- execute the dynamic statement
1241: l_row_processed := dbms_sql.execute(l_cursor);
1242: -- close the cursor
1243: dbms_sql.close_cursor(l_cursor);
1244: --
1245: -- when in validation only mode raise the Validate_Enabled exception
1246: --
1247: if p_validate then

Line 1264: dbms_sql.close_cursor(l_cursor);

1260: when others then
1261: hr_utility.set_location('EXCEPTION: '|| l_proc,560);
1262:
1263: --close the cursor
1264: dbms_sql.close_cursor(l_cursor);
1265: raise;
1266: end process_web_api_call;
1267:
1268: -- ----------------------------------------------------------------------------