APPS.HR_TRANSACTION_SS dependencies on DBMS_SQL

Line 1316: l_cursor := dbms_sql.open_cursor;

1312: 'begin '||p_api_name||
1313: '(p_transaction_step_id => '||':transaction_step_id'||
1314: l_extra_parameter_text||'); end;';
1315: -- open the dynamic cursor
1316: l_cursor := dbms_sql.open_cursor;
1317: -- parse the dynamic cursor
1318: dbms_sql.parse(l_cursor, l_sqlbuf, dbms_sql.v7);
1319: -- bind the transaction step identifier
1320: dbms_sql.bind_variable

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

1314: l_extra_parameter_text||'); end;';
1315: -- open the dynamic cursor
1316: l_cursor := dbms_sql.open_cursor;
1317: -- parse the dynamic cursor
1318: dbms_sql.parse(l_cursor, l_sqlbuf, dbms_sql.v7);
1319: -- bind the transaction step identifier
1320: dbms_sql.bind_variable
1321: (l_cursor, ':transaction_step_id', p_transaction_step_id);
1322: if l_extra_parameter_text is not null then

Line 1320: dbms_sql.bind_variable

1316: l_cursor := dbms_sql.open_cursor;
1317: -- parse the dynamic cursor
1318: dbms_sql.parse(l_cursor, l_sqlbuf, dbms_sql.v7);
1319: -- bind the transaction step identifier
1320: dbms_sql.bind_variable
1321: (l_cursor, ':transaction_step_id', p_transaction_step_id);
1322: if l_extra_parameter_text is not null then
1323: dbms_sql.bind_variable
1324: (l_cursor, ':'||p_extra_parameter_name, p_extra_parameter_value);

Line 1323: dbms_sql.bind_variable

1319: -- bind the transaction step identifier
1320: dbms_sql.bind_variable
1321: (l_cursor, ':transaction_step_id', p_transaction_step_id);
1322: if l_extra_parameter_text is not null then
1323: dbms_sql.bind_variable
1324: (l_cursor, ':'||p_extra_parameter_name, p_extra_parameter_value);
1325: end if;
1326: -- execute the dynamic statement
1327: l_row_processed := dbms_sql.execute(l_cursor);

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

1323: dbms_sql.bind_variable
1324: (l_cursor, ':'||p_extra_parameter_name, p_extra_parameter_value);
1325: end if;
1326: -- execute the dynamic statement
1327: l_row_processed := dbms_sql.execute(l_cursor);
1328: -- close the cursor
1329: dbms_sql.close_cursor(l_cursor);
1330: --
1331: -- when in validation only mode raise the Validate_Enabled exception

Line 1329: dbms_sql.close_cursor(l_cursor);

1325: end if;
1326: -- execute the dynamic statement
1327: l_row_processed := dbms_sql.execute(l_cursor);
1328: -- close the cursor
1329: dbms_sql.close_cursor(l_cursor);
1330: --
1331: -- when in validation only mode raise the Validate_Enabled exception
1332: --
1333: if p_validate then

Line 1350: dbms_sql.close_cursor(l_cursor);

1346: when others then
1347: hr_utility.set_location('EXCEPTION: '|| l_proc,560);
1348:
1349: --close the cursor
1350: dbms_sql.close_cursor(l_cursor);
1351: raise;
1352: end process_web_api_call;
1353:
1354: -- ----------------------------------------------------------------------------