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);
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:
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);
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:
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);
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);
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:
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);
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:
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);