DBA Data[Home] [Help]

APPS.HRDYNDBI dependencies on HRDYNDBI

Line 1: package body hrdyndbi as

1: package body hrdyndbi as
2: /* $Header: pydyndbi.pkb 120.27.12010000.4 2009/08/22 07:13:16 pgongada ship $ */
3: --
4: /*
5: --

Line 280: set boolean hrdyndbi.g_triggers_altered true

276: RELE:element_type_id.date
277: RELI:input_value_id.date
278: To rerun hrrbdeib for just one piece of data call the following
279: call disable trigger procs
280: set boolean hrdyndbi.g_triggers_altered true
281: for RDB: hrdyndbi.refresh_defined_balances(defbalid, 1);
282: for RELE: hrdyndbi.create_element_type_dict(element_type_id,dt);
283: for RELI: hrdyndbi.create_input_value_dict(input_value_id,dt);
284:

,'DD-MM-YYYY')> or null

Line 281: for RDB: hrdyndbi.refresh_defined_balances(defbalid, 1);

277: RELI:input_value_id.date
278: To rerun hrrbdeib for just one piece of data call the following
279: call disable trigger procs
280: set boolean hrdyndbi.g_triggers_altered true
281: for RDB: hrdyndbi.refresh_defined_balances(defbalid, 1);
282: for RELE: hrdyndbi.create_element_type_dict(element_type_id,dt);
283: for RELI: hrdyndbi.create_input_value_dict(input_value_id,dt);
284:

,'DD-MM-YYYY')> or null
285: divicker 115.105 23-FEB-2005 deliver better restricted tracing data

Line 282: for RELE: hrdyndbi.create_element_type_dict(element_type_id,dt);

278: To rerun hrrbdeib for just one piece of data call the following
279: call disable trigger procs
280: set boolean hrdyndbi.g_triggers_altered true
281: for RDB: hrdyndbi.refresh_defined_balances(defbalid, 1);
282: for RELE: hrdyndbi.create_element_type_dict(element_type_id,dt);
283: for RELI: hrdyndbi.create_input_value_dict(input_value_id,dt);
284:

,'DD-MM-YYYY')> or null
285: divicker 115.105 23-FEB-2005 deliver better restricted tracing data
286: divicker 115.104 17-FEB-2005 mod to dcf

Line 283: for RELI: hrdyndbi.create_input_value_dict(input_value_id,dt);

279: call disable trigger procs
280: set boolean hrdyndbi.g_triggers_altered true
281: for RDB: hrdyndbi.refresh_defined_balances(defbalid, 1);
282: for RELE: hrdyndbi.create_element_type_dict(element_type_id,dt);
283: for RELI: hrdyndbi.create_input_value_dict(input_value_id,dt);
284:

,'DD-MM-YYYY')> or null
285: divicker 115.105 23-FEB-2005 deliver better restricted tracing data
286: divicker 115.104 17-FEB-2005 mod to dcf
287: divicker 115.103 15-FEB-2005 decompile formula on leg code

Line 309: PYUPIP apps/apps HRDYNDBI

305: divicker 115.87 24-JUN-2004 More mods to debug for insert route param
306: divicker 115.86 12-MAY-2004 Fix for 8i
307: divicker 115.84 06-MAY-2004 More debug info for input value
308: divicker 115.83 Add a load of additional debug info.
309: PYUPIP apps/apps HRDYNDBI
310: divicker 115.81 09-DEC-2003 No multi-thread
311: Merge changes in 115.79
312: Merge changes in 115.80
313: divicker 115.76 24-SEP-2003 Same as 115.74 (back out mthread routines)

Line 1887: hrdyndbi.new_defined_balance

1883: delete from ff_user_entities
1884: where creator_id = p_defined_balance_id
1885: and creator_type = 'RB';
1886: --
1887: hrdyndbi.new_defined_balance
1888: (p_defined_balance_id => p_defined_balance_id,
1889: p_balance_dimension_id => p_balance_dimension_id,
1890: p_balance_type_id => p_balance_type_id,
1891: p_business_group_id => p_business_group_id,

Line 5260: hrdyndbi.refresh_defined_balances(p_worker_id,

5256: dbms_lock.sleep(5);
5257: end if;
5258:
5259: --
5260: hrdyndbi.refresh_defined_balances(p_worker_id,
5261: p_maxworkers);
5262:
5263: --
5264: -- INSERT A COMPLETION STEP AND

Line 5372: hrdyndbi.refresh_element_types(p_worker_id,

5368: dbms_lock.sleep(5);
5369: end if;
5370:
5371: --
5372: hrdyndbi.refresh_element_types(p_worker_id,
5373: p_maxworkers);
5374: -- INSERT A COMPLETION STEP AND
5375: -- LOOP HERE UNTIL ALL WORKERS HAVE COMPLETED INITIAL SET UP
5376: -- SO THAT WORKER 2 WONT BE DELETING WHILST WORKER 1 IS CREATING

Line 5685: hrdyndbi.refresh_defined_balances(p_leg_code,

5681: dbms_lock.sleep(5);
5682: end if;
5683:
5684: --
5685: hrdyndbi.refresh_defined_balances(p_leg_code,
5686: p_worker_id,
5687: p_maxworkers);
5688: --
5689: -- INSERT A COMPLETION STEP AND

Line 5798: hrdyndbi.refresh_element_types(p_leg_code,

5794: dbms_lock.sleep(5);
5795: end if;
5796:
5797: --
5798: hrdyndbi.refresh_element_types(p_leg_code,
5799: p_worker_id,
5800: p_maxworkers);
5801: --
5802: --

Line 8028: hrdyndbi.refresh_defined_balances(0, 1);

8024: --
8025: enable_ffue_cascade_trig;
8026: disable_refbal_trig;
8027: --
8028: hrdyndbi.refresh_defined_balances(0, 1);
8029: --
8030: commit;
8031: --
8032: enable_refbal_trig;

Line 8035: hrdyndbi.delete_element_types(0,1);

8031: --
8032: enable_refbal_trig;
8033: disable_ffue_cascade_trig;
8034: --
8035: hrdyndbi.delete_element_types(0,1);
8036: --
8037: enable_ffue_cascade_trig;
8038: disable_refbal_trig;
8039: --

Line 8040: hrdyndbi.refresh_element_types(0, 1);

8036: --
8037: enable_ffue_cascade_trig;
8038: disable_refbal_trig;
8039: --
8040: hrdyndbi.refresh_element_types(0, 1);
8041: --
8042: delete pay_patch_status
8043: where patch_name like 'HRRBDEIB%';
8044: --

Line 8977: -- element, and input value names in HRDYNDBI. The validation assumes

8973: l_got_error boolean;
8974: begin
8975: --
8976: -- G_TRIGGERS_ALTERED is true for the bulk generation of balance,
8977: -- element, and input value names in HRDYNDBI. The validation assumes
8978: -- that FF_FDI_USAGES_F rows have been deleted.
8979: --
8980: if g_triggers_altered then
8981: --

Line 10808: end hrdyndbi;

10804: hr_utility.set_location('process_pay_dyndbi_changes', 300);
10805: end if;
10806: end process_pay_dyndbi_changes;
10807:
10808: end hrdyndbi;