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 115.2 2002/12/11 11:17:12 raranjan noship $ */
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 13: insert into 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
13: insert into HR_INCOMPATIBILITY_RULES (
14: FROM_NAV_UNIT_ID,
15: TO_NAV_UNIT_ID
16: ) values (
17: X_FROM_NAV_UNIT_ID,

Line 36: from HR_INCOMPATIBILITY_RULES

32: X_TO_NAV_UNIT_ID in NUMBER
33: ) is
34: cursor c1 is select
35: TO_NAV_UNIT_ID
36: from HR_INCOMPATIBILITY_RULES
37: where FROM_NAV_UNIT_ID = X_FROM_NAV_UNIT_ID
38: and TO_NAV_UNIT_ID = X_TO_NAV_UNIT_ID
39: for update of FROM_NAV_UNIT_ID nowait;
40: begin

Line 58: update HR_INCOMPATIBILITY_RULES set

54: X_FROM_NAV_UNIT_ID in NUMBER,
55: X_TO_NAV_UNIT_ID in NUMBER
56: ) is
57: begin
58: update HR_INCOMPATIBILITY_RULES set
59: TO_NAV_UNIT_ID = X_TO_NAV_UNIT_ID
60: where FROM_NAV_UNIT_ID = X_FROM_NAV_UNIT_ID
61: and TO_NAV_UNIT_ID = X_TO_NAV_UNIT_ID;
62:

Line 73: delete from HR_INCOMPATIBILITY_RULES

69: X_FROM_NAV_UNIT_ID in NUMBER,
70: X_TO_NAV_UNIT_ID in NUMBER
71: ) is
72: begin
73: delete from HR_INCOMPATIBILITY_RULES
74: where FROM_NAV_UNIT_ID = X_FROM_NAV_UNIT_ID
75: and TO_NAV_UNIT_ID = X_TO_NAV_UNIT_ID;
76:
77: if (sql%notfound) then

Line 172: end HR_INCOMPATIBILITY_RULES_PKG;

168: end if;
169:
170: end LOAD_ROW;
171:
172: end HR_INCOMPATIBILITY_RULES_PKG;