APPS.PN_PROFILE_UPGRADE dependencies on FND_PROFILE_OPTIONS

Line 8: (profile_option_name fnd_profile_options.profile_option_name%TYPE,

4: TYPE def_set_of_books_type IS TABLE OF hr_operating_units%ROWTYPE
5: INDEX BY BINARY_INTEGER;
6:
7: TYPE profile_value_rec_type IS RECORD
8: (profile_option_name fnd_profile_options.profile_option_name%TYPE,
9: profile_option_value fnd_profile_option_values.profile_option_value%TYPE,
10: level_id fnd_profile_option_values.level_id%TYPE,
11: level_value fnd_profile_option_values.level_value%TYPE);
12:

Line 20: g_profileid4orgid fnd_profile_options.profile_option_id%TYPE;

16: def_set_of_books_tbl def_set_of_books_type;
17: profile_value_tbl profile_value_type;
18:
19: g_default_org_id pn_system_setup_options.org_id%TYPE;
20: g_profileid4orgid fnd_profile_options.profile_option_id%TYPE;
21:
22:
23: /*-----------------------------------------------------------------------------
24: | FUNCTION : get_value

Line 128: FROM fnd_profile_options o,

124: SELECT o.profile_option_name,
125: v.profile_option_value,
126: v.level_id,
127: v.level_value
128: FROM fnd_profile_options o,
129: fnd_profile_option_values v
130: WHERE o.profile_option_id = v.profile_option_id
131: AND o.application_id = v.application_id
132: AND v.level_id <> 10004

Line 150: fnd_profile_options o,

146: CURSOR def_set_of_books_cur IS
147: SELECT hr.organization_id org_id,
148: hr.set_of_books_id set_of_books_id
149: FROM hr_operating_units hr,
150: fnd_profile_options o,
151: fnd_profile_option_values v
152: WHERE v.profile_option_id = o.profile_option_id
153: AND o.profile_option_name = 'ORG_ID'
154: AND v.level_id <> 10004

Line 161: FROM fnd_profile_option_values v, fnd_profile_options o

157: ORDER BY 1;
158:
159: CURSOR get_def_org_id IS
160: SELECT TO_NUMBER(v.profile_option_value) org_id, v.level_id
161: FROM fnd_profile_option_values v, fnd_profile_options o
162: WHERE v.profile_option_id = o.profile_option_id
163: AND o.profile_option_name = 'ORG_ID'
164: AND v.level_id IN (10002,10001)
165: ORDER BY 2;

Line 169: FROM fnd_profile_options

165: ORDER BY 2;
166:
167: CURSOR get_profileid4orgid IS
168: SELECT profile_option_id
169: FROM fnd_profile_options
170: WHERE profile_option_name = 'ORG_ID';
171:
172: l_counter NUMBER := 0;
173: l_info_text VARCHAR2(200);

Line 441: FROM fnd_profile_options o,

437: SELECT o.profile_option_name,
438: v.profile_option_value,
439: v.level_id,
440: v.level_value
441: FROM fnd_profile_options o,
442: fnd_profile_option_values v
443: WHERE o.profile_option_id = v.profile_option_id
444: AND o.application_id = v.application_id
445: AND v.level_id <> 10004

Line 451: FROM fnd_profile_options

447: ORDER BY 1, 3 DESC;
448:
449: CURSOR get_profileid4orgid IS
450: SELECT profile_option_id
451: FROM fnd_profile_options
452: WHERE profile_option_name = 'ORG_ID';
453:
454: CURSOR get_def_org_id IS
455: SELECT TO_NUMBER(v.profile_option_value) org_id, v.level_id

Line 456: FROM fnd_profile_option_values v, fnd_profile_options o

452: WHERE profile_option_name = 'ORG_ID';
453:
454: CURSOR get_def_org_id IS
455: SELECT TO_NUMBER(v.profile_option_value) org_id, v.level_id
456: FROM fnd_profile_option_values v, fnd_profile_options o
457: WHERE v.profile_option_id = o.profile_option_id
458: AND o.profile_option_name = 'ORG_ID'
459: AND v.level_id IN (10002,10001)
460: ORDER BY 2;