APPS.HR_NAV_CONTEXT_RULES_PKG dependencies on HR_NAVIGATION_CONTEXT_RULES

Line 10: cursor C is select ROWID from HR_NAVIGATION_CONTEXT_RULES

6: X_GLOBAL_USAGE_ID in NUMBER,
7: X_EVALUATION_TYPE_CODE in VARCHAR2,
8: X_VALUE in VARCHAR2
9: ) is
10: cursor C is select ROWID from HR_NAVIGATION_CONTEXT_RULES
11: where NAV_CONTEXT_RULE_ID = X_NAV_CONTEXT_RULE_ID
12: ;
13: begin
14: insert into HR_NAVIGATION_CONTEXT_RULES (

Line 14: insert into HR_NAVIGATION_CONTEXT_RULES (

10: cursor C is select ROWID from HR_NAVIGATION_CONTEXT_RULES
11: where NAV_CONTEXT_RULE_ID = X_NAV_CONTEXT_RULE_ID
12: ;
13: begin
14: insert into HR_NAVIGATION_CONTEXT_RULES (
15: NAV_CONTEXT_RULE_ID,
16: GLOBAL_USAGE_ID,
17: EVALUATION_TYPE_CODE,
18: VALUE

Line 45: from HR_NAVIGATION_CONTEXT_RULES

41: cursor c1 is select
42: GLOBAL_USAGE_ID,
43: EVALUATION_TYPE_CODE,
44: VALUE
45: from HR_NAVIGATION_CONTEXT_RULES
46: where NAV_CONTEXT_RULE_ID = X_NAV_CONTEXT_RULE_ID
47: for update of NAV_CONTEXT_RULE_ID nowait;
48: begin
49: for tlinfo in c1 loop

Line 71: update HR_NAVIGATION_CONTEXT_RULES set

67: X_EVALUATION_TYPE_CODE in VARCHAR2,
68: X_VALUE in VARCHAR2
69: ) is
70: begin
71: update HR_NAVIGATION_CONTEXT_RULES set
72: GLOBAL_USAGE_ID = X_GLOBAL_USAGE_ID,
73: EVALUATION_TYPE_CODE = X_EVALUATION_TYPE_CODE,
74: VALUE = X_VALUE
75: where NAV_CONTEXT_RULE_ID = X_NAV_CONTEXT_RULE_ID;

Line 86: delete from HR_NAVIGATION_CONTEXT_RULES

82: procedure DELETE_ROW (
83: X_NAV_CONTEXT_RULE_ID in NUMBER
84: ) is
85: begin
86: delete from HR_NAVIGATION_CONTEXT_RULES
87: where NAV_CONTEXT_RULE_ID = X_NAV_CONTEXT_RULE_ID;
88:
89: if (sql%notfound) then
90: raise no_data_found;

Line 135: from HR_NAVIGATION_CONTEXT_RULES NCR

131: --
132: begin
133: select NCR.NAV_CONTEXT_RULE_ID
134: into X_NAV_CONTEXT_RULE_ID
135: from HR_NAVIGATION_CONTEXT_RULES NCR
136: where NCR.EVALUATION_TYPE_CODE = X_EVALUATION_TYPE_CODE
137: and nvl(NCR.VALUE,hr_api.g_varchar2) = nvl(X_VALUE,hr_api.g_varchar2)
138: and NCR.GLOBAL_USAGE_ID = X_GLOBAL_USAGE_ID;
139: exception

Line 141: select HR_NAVIGATION_CONTEXT_RULES_S.NEXTVAL

137: and nvl(NCR.VALUE,hr_api.g_varchar2) = nvl(X_VALUE,hr_api.g_varchar2)
138: and NCR.GLOBAL_USAGE_ID = X_GLOBAL_USAGE_ID;
139: exception
140: when no_data_found then
141: select HR_NAVIGATION_CONTEXT_RULES_S.NEXTVAL
142: into X_NAV_CONTEXT_RULE_ID
143: from DUAL;
144:
145: INSERT_ROW(