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:

Line 22: p_entity_name => 'HR_NAVIGATION_CONTEXT_RULES',

18: --
19:
20: BEGIN
21: PER_RIC_PKG.chk_integrity (
22: p_entity_name => 'HR_NAVIGATION_CONTEXT_RULES',
23: p_ref_entity => 'HR_NAV_UNIT_GLOBAL_USAGES',
24: p_ref_column_name => 'GLOBAL_USAGE_ID',
25: p_ref_col_value_number => X_GLOBAL_USAGE_ID,
26: p_ref_col_value_varchar => NULL,

Line 34: insert into HR_NAVIGATION_CONTEXT_RULES (

30: END;
31: --
32: -- Code Ends Here.
33: --
34: insert into HR_NAVIGATION_CONTEXT_RULES (
35: NAV_CONTEXT_RULE_ID,
36: GLOBAL_USAGE_ID,
37: EVALUATION_TYPE_CODE,
38: VALUE

Line 65: from HR_NAVIGATION_CONTEXT_RULES

61: cursor c1 is select
62: GLOBAL_USAGE_ID,
63: EVALUATION_TYPE_CODE,
64: VALUE
65: from HR_NAVIGATION_CONTEXT_RULES
66: where NAV_CONTEXT_RULE_ID = X_NAV_CONTEXT_RULE_ID
67: for update of NAV_CONTEXT_RULE_ID nowait;
68: begin
69: for tlinfo in c1 loop

Line 91: update HR_NAVIGATION_CONTEXT_RULES set

87: X_EVALUATION_TYPE_CODE in VARCHAR2,
88: X_VALUE in VARCHAR2
89: ) is
90: begin
91: update HR_NAVIGATION_CONTEXT_RULES set
92: GLOBAL_USAGE_ID = X_GLOBAL_USAGE_ID,
93: EVALUATION_TYPE_CODE = X_EVALUATION_TYPE_CODE,
94: VALUE = X_VALUE
95: where NAV_CONTEXT_RULE_ID = X_NAV_CONTEXT_RULE_ID;

Line 106: delete from HR_NAVIGATION_CONTEXT_RULES

102: procedure DELETE_ROW (
103: X_NAV_CONTEXT_RULE_ID in NUMBER
104: ) is
105: begin
106: delete from HR_NAVIGATION_CONTEXT_RULES
107: where NAV_CONTEXT_RULE_ID = X_NAV_CONTEXT_RULE_ID;
108:
109: if (sql%notfound) then
110: raise no_data_found;

Line 155: from HR_NAVIGATION_CONTEXT_RULES NCR

151: --
152: begin
153: select NCR.NAV_CONTEXT_RULE_ID
154: into X_NAV_CONTEXT_RULE_ID
155: from HR_NAVIGATION_CONTEXT_RULES NCR
156: where NCR.EVALUATION_TYPE_CODE = X_EVALUATION_TYPE_CODE
157: and nvl(NCR.VALUE,hr_api.g_varchar2) = nvl(X_VALUE,hr_api.g_varchar2)
158: and NCR.GLOBAL_USAGE_ID = X_GLOBAL_USAGE_ID;
159: exception

Line 161: select HR_NAVIGATION_CONTEXT_RULES_S.NEXTVAL

157: and nvl(NCR.VALUE,hr_api.g_varchar2) = nvl(X_VALUE,hr_api.g_varchar2)
158: and NCR.GLOBAL_USAGE_ID = X_GLOBAL_USAGE_ID;
159: exception
160: when no_data_found then
161: select HR_NAVIGATION_CONTEXT_RULES_S.NEXTVAL
162: into X_NAV_CONTEXT_RULE_ID
163: from DUAL;
164:
165: INSERT_ROW(