APPS.WIP_PREFERENCES_PKG dependencies on WIP_PREFERENCE_VALUES

Line 5: -- This function returns attribute_code from wip_preference_values

1: PACKAGE BODY WIP_PREFERENCES_PKG AS
2: /* $Header: wipprefb.pls 120.3 2006/01/04 17:34 yulin noship $ */
3:
4: --
5: -- This function returns attribute_code from wip_preference_values
6: -- for single value preferences based on resp_key, org_id, dept_id.
7: -- For multiple value preferences, it returns "ENTERED" or "INHERIT" based on setup.
8: --
9: function get_preference_value_code

Line 30: from wip_preference_values v,

26: cursor single_value (cl_resp_key VARCHAR2,
27: cl_org_id NUMBER,
28: cl_dept_id NUMBER) is
29: select decode( (select count(v.attribute_value_code)
30: from wip_preference_values v,
31: wip_preference_levels l
32: where v.PREFERENCE_ID = p_preference_id
33: and v.LEVEL_ID = l.LEVEL_ID
34: and nvl(l.resp_key,'NULL') = nvl(cl_resp_key, 'NULL')

Line 40: from wip_preference_values v,

36: and nvl(l.department_id, -99) = nvl(cl_dept_id, -99)
37: ),
38: 0, 'INHERIT',
39: 1, (select v.attribute_value_code
40: from wip_preference_values v,
41: wip_preference_levels l
42: where v.PREFERENCE_ID = p_preference_id
43: and v.LEVEL_ID = l.LEVEL_ID
44: and nvl(l.resp_key,'NULL') = nvl(cl_resp_key, 'NULL')

Line 53: from wip_preference_values v,

49: cursor multi_value (cl_resp_key VARCHAR2,
50: cl_org_id NUMBER,
51: cl_dept_id NUMBER) is
52: select count(v.attribute_value_code) as multi_value_count
53: from wip_preference_values v,
54: wip_preference_levels l
55: where v.PREFERENCE_ID = p_preference_id
56: and v.LEVEL_ID = l.LEVEL_ID
57: and nvl(l.resp_key,'NULL') = nvl(cl_resp_key, 'NULL')

Line 119: from wip_preference_values v;

115: v.attribute_value_code,
116: 0, -- no setup at this level
117: decode(cl_level_code, 0, null, 'INHERIT'),
118: 'ENTERED')
119: from wip_preference_values v;
120:
121: l_val_code varchar2(30);
122: l_return_val varchar2(240);
123:

Line 199: from wip_preference_values v,

195: p_dept_id number) return number is
196:
197: cursor default_level_ct is
198: select count(v.preference_value_id)
199: from wip_preference_values v,
200: wip_preference_levels l
201: where l.level_id = v.level_id and
202: l.level_code = 0 and
203: v.preference_id = p_pref_id;

Line 207: from wip_preference_values v,

203: v.preference_id = p_pref_id;
204:
205: cursor resp_level_ct is
206: select count(v.preference_value_id)
207: from wip_preference_values v,
208: wip_preference_levels l
209: where l.level_id = v.level_id and
210: l.level_code = 1 and
211: l.resp_key = p_resp_key and

Line 216: from wip_preference_values v,

212: v.preference_id = p_pref_id;
213:
214: cursor org_level_ct is
215: select count(v.preference_value_id)
216: from wip_preference_values v,
217: wip_preference_levels l
218: where l.level_id = v.level_id and
219: l.level_code = 2 and
220: l.resp_key = p_resp_key and

Line 226: from wip_preference_values v,

222: v.preference_id = p_pref_id;
223:
224: cursor dept_level_ct is
225: select count(v.preference_value_id)
226: from wip_preference_values v,
227: wip_preference_levels l
228: where l.level_id = v.level_id and
229: l.level_code = 3 and
230: l.resp_key = p_resp_key and