1: PACKAGE BODY pay_simulator_pkg AS
2: /* $Header: paysim.pkb 120.1.12020000.1 2013/03/20 08:41:52 kskoduri noship $
3: ------------------------------------------------------------------------------
4: +==============================================================================+
5: | Copyright (c) 2013 Oracle Corporation |
19: */
20: --
21: --
22: g_dbg BOOLEAN := TRUE; --Used for diagnosing issues by dev, more outputs
23: gv_package VARCHAR2(100) := 'pay_simulator_pkg';
24: --
25: PROCEDURE check_entry_exists
26: (
27: p_ele_typ_id IN VARCHAR2,
782:
783: preprocess_statement := 'begin pay_'||l_legislation||'_simulation.update_asg_data(
784: p_source_action_id =>:p_assact_id); end;';
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);
962: AND v_period_end_date BETWEEN paf.effective_start_date AND paf.effective_end_date
963: AND paf.business_group_id = pbg.business_group_id
964: ;
965:
966: hr_utility.set_location ('pay_simulator_pkg.archive_results',20);
967:
968: preprocess_statement := 'begin pay_'||l_legislation||'_simulation.archive_data(
969: p_source_action_id =>:p_assact_id); end;';
970:
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);
982:
983: EXCEPTION
984:
985: WHEN OTHERS THEN
1292: hr_utility.trace('Leaving '||gv_package||lv_procedure_name);
1293: END;
1294: --
1295: --
1296: END pay_simulator_pkg ;
1297: --