APPS.HR_INCOMPATIBILITY_RULES_PKG dependencies on HR_INCOMPATIBILITY_RULES

Line 1: package body HR_INCOMPATIBILITY_RULES_PKG as

1: package body HR_INCOMPATIBILITY_RULES_PKG as
2: /* $Header: hrwirlct.pkb 120.1 2011/04/28 10:22:36 sidsaxen ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_FROM_NAV_UNIT_ID in NUMBER,

Line 8: cursor C is select ROWID from HR_INCOMPATIBILITY_RULES

4: X_ROWID in out nocopy VARCHAR2,
5: X_FROM_NAV_UNIT_ID in NUMBER,
6: X_TO_NAV_UNIT_ID in NUMBER
7: ) is
8: cursor C is select ROWID from HR_INCOMPATIBILITY_RULES
9: where FROM_NAV_UNIT_ID = X_FROM_NAV_UNIT_ID
10: and TO_NAV_UNIT_ID = X_TO_NAV_UNIT_ID
11: ;
12: begin

Line 19: p_entity_name => 'HR_INCOMPATIBILITY_RULES',

15: -- Code Starts Here.
16: --
17: BEGIN
18: PER_RIC_PKG.chk_integrity (
19: p_entity_name => 'HR_INCOMPATIBILITY_RULES',
20: p_ref_entity => 'HR_NAVIGATION_UNITS',
21: p_ref_column_info => PER_RIC_PKG.column_info_tbl(
22: PER_RIC_PKG.col_info_rec('NAV_UNIT_ID',NULL,X_FROM_NAV_UNIT_ID,NULL),
23: PER_RIC_PKG.col_info_rec('NAV_UNIT_ID',NULL,X_TO_NAV_UNIT_ID,NULL)

Line 31: insert into HR_INCOMPATIBILITY_RULES (

27: END;
28: --
29: -- Code Ends Here
30: --
31: insert into HR_INCOMPATIBILITY_RULES (
32: FROM_NAV_UNIT_ID,
33: TO_NAV_UNIT_ID
34: ) values (
35: X_FROM_NAV_UNIT_ID,

Line 54: from HR_INCOMPATIBILITY_RULES

50: X_TO_NAV_UNIT_ID in NUMBER
51: ) is
52: cursor c1 is select
53: TO_NAV_UNIT_ID
54: from HR_INCOMPATIBILITY_RULES
55: where FROM_NAV_UNIT_ID = X_FROM_NAV_UNIT_ID
56: and TO_NAV_UNIT_ID = X_TO_NAV_UNIT_ID
57: for update of FROM_NAV_UNIT_ID nowait;
58: begin

Line 76: update HR_INCOMPATIBILITY_RULES set

72: X_FROM_NAV_UNIT_ID in NUMBER,
73: X_TO_NAV_UNIT_ID in NUMBER
74: ) is
75: begin
76: update HR_INCOMPATIBILITY_RULES set
77: TO_NAV_UNIT_ID = X_TO_NAV_UNIT_ID
78: where FROM_NAV_UNIT_ID = X_FROM_NAV_UNIT_ID
79: and TO_NAV_UNIT_ID = X_TO_NAV_UNIT_ID;
80:

Line 91: delete from HR_INCOMPATIBILITY_RULES

87: X_FROM_NAV_UNIT_ID in NUMBER,
88: X_TO_NAV_UNIT_ID in NUMBER
89: ) is
90: begin
91: delete from HR_INCOMPATIBILITY_RULES
92: where FROM_NAV_UNIT_ID = X_FROM_NAV_UNIT_ID
93: and TO_NAV_UNIT_ID = X_TO_NAV_UNIT_ID;
94:
95: if (sql%notfound) then

Line 190: end HR_INCOMPATIBILITY_RULES_PKG;

186: end if;
187:
188: end LOAD_ROW;
189:
190: end HR_INCOMPATIBILITY_RULES_PKG;