DBA Data[Home] [Help]

APPS.PAY_SIMULATOR_PKG dependencies on DBMS_SQL

Line 789: sql_cursor := dbms_sql.open_cursor;

785:
786: hr_utility.set_location ('pay_simulator_pkg.simulator_preprocessing',20);
787: hr_utility.trace(preprocess_statement);
788:
789: sql_cursor := dbms_sql.open_cursor;
790: dbms_sql.parse(sql_cursor,preprocess_statement,dbms_sql.v7);
791: dbms_sql.bind_variable(sql_cursor, ':p_assact_id',p_assact_id);
792: l_rows := dbms_sql.execute(sql_cursor);
793: dbms_sql.close_cursor(sql_cursor);

Line 790: dbms_sql.parse(sql_cursor,preprocess_statement,dbms_sql.v7);

786: hr_utility.set_location ('pay_simulator_pkg.simulator_preprocessing',20);
787: hr_utility.trace(preprocess_statement);
788:
789: sql_cursor := dbms_sql.open_cursor;
790: dbms_sql.parse(sql_cursor,preprocess_statement,dbms_sql.v7);
791: dbms_sql.bind_variable(sql_cursor, ':p_assact_id',p_assact_id);
792: l_rows := dbms_sql.execute(sql_cursor);
793: dbms_sql.close_cursor(sql_cursor);
794:

Line 791: dbms_sql.bind_variable(sql_cursor, ':p_assact_id',p_assact_id);

787: hr_utility.trace(preprocess_statement);
788:
789: sql_cursor := dbms_sql.open_cursor;
790: dbms_sql.parse(sql_cursor,preprocess_statement,dbms_sql.v7);
791: dbms_sql.bind_variable(sql_cursor, ':p_assact_id',p_assact_id);
792: l_rows := dbms_sql.execute(sql_cursor);
793: dbms_sql.close_cursor(sql_cursor);
794:
795: hr_utility.set_location('After executing localization preprocessing',30);

Line 792: l_rows := dbms_sql.execute(sql_cursor);

788:
789: sql_cursor := dbms_sql.open_cursor;
790: dbms_sql.parse(sql_cursor,preprocess_statement,dbms_sql.v7);
791: dbms_sql.bind_variable(sql_cursor, ':p_assact_id',p_assact_id);
792: l_rows := dbms_sql.execute(sql_cursor);
793: dbms_sql.close_cursor(sql_cursor);
794:
795: hr_utility.set_location('After executing localization preprocessing',30);
796:

Line 793: dbms_sql.close_cursor(sql_cursor);

789: sql_cursor := dbms_sql.open_cursor;
790: dbms_sql.parse(sql_cursor,preprocess_statement,dbms_sql.v7);
791: dbms_sql.bind_variable(sql_cursor, ':p_assact_id',p_assact_id);
792: l_rows := dbms_sql.execute(sql_cursor);
793: dbms_sql.close_cursor(sql_cursor);
794:
795: hr_utility.set_location('After executing localization preprocessing',30);
796:
797: update_element_entries(v_ass_id,v_period_start_date,v_period_end_date);

Line 973: sql_cursor := dbms_sql.open_cursor;

969: p_source_action_id =>:p_assact_id); end;';
970:
971: hr_utility.trace(preprocess_statement);
972:
973: sql_cursor := dbms_sql.open_cursor;
974: dbms_sql.parse(sql_cursor,preprocess_statement,dbms_sql.v7);
975: dbms_sql.bind_variable(sql_cursor, ':p_assact_id',p_assact_id);
976: l_rows := dbms_sql.execute(sql_cursor);
977: dbms_sql.close_cursor(sql_cursor);

Line 974: dbms_sql.parse(sql_cursor,preprocess_statement,dbms_sql.v7);

970:
971: hr_utility.trace(preprocess_statement);
972:
973: sql_cursor := dbms_sql.open_cursor;
974: dbms_sql.parse(sql_cursor,preprocess_statement,dbms_sql.v7);
975: dbms_sql.bind_variable(sql_cursor, ':p_assact_id',p_assact_id);
976: l_rows := dbms_sql.execute(sql_cursor);
977: dbms_sql.close_cursor(sql_cursor);
978:

Line 975: dbms_sql.bind_variable(sql_cursor, ':p_assact_id',p_assact_id);

971: hr_utility.trace(preprocess_statement);
972:
973: sql_cursor := dbms_sql.open_cursor;
974: dbms_sql.parse(sql_cursor,preprocess_statement,dbms_sql.v7);
975: dbms_sql.bind_variable(sql_cursor, ':p_assact_id',p_assact_id);
976: l_rows := dbms_sql.execute(sql_cursor);
977: dbms_sql.close_cursor(sql_cursor);
978:
979: hr_utility.set_location('After executing localization archive data',30);

Line 976: l_rows := dbms_sql.execute(sql_cursor);

972:
973: sql_cursor := dbms_sql.open_cursor;
974: dbms_sql.parse(sql_cursor,preprocess_statement,dbms_sql.v7);
975: dbms_sql.bind_variable(sql_cursor, ':p_assact_id',p_assact_id);
976: l_rows := dbms_sql.execute(sql_cursor);
977: dbms_sql.close_cursor(sql_cursor);
978:
979: hr_utility.set_location('After executing localization archive data',30);
980:

Line 977: dbms_sql.close_cursor(sql_cursor);

973: sql_cursor := dbms_sql.open_cursor;
974: dbms_sql.parse(sql_cursor,preprocess_statement,dbms_sql.v7);
975: dbms_sql.bind_variable(sql_cursor, ':p_assact_id',p_assact_id);
976: l_rows := dbms_sql.execute(sql_cursor);
977: dbms_sql.close_cursor(sql_cursor);
978:
979: hr_utility.set_location('After executing localization archive data',30);
980:
981: hr_utility.set_location('pay_simulator_pkg.archive_run_results }',90);