eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PN_PROFILE_UPGRADE dependencies on FND_PROFILE_OPTION_VALUES

Line 9: profile_option_value fnd_profile_option_values.profile_option_value%TYPE,

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:
13: TYPE profile_value_type IS TABLE OF profile_value_rec_type

Line 10: level_id fnd_profile_option_values.level_id%TYPE,

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:
13: TYPE profile_value_type IS TABLE OF profile_value_rec_type
14: INDEX BY BINARY_INTEGER;

Line 11: level_value fnd_profile_option_values.level_value%TYPE);

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:
13: TYPE profile_value_type IS TABLE OF profile_value_rec_type
14: INDEX BY BINARY_INTEGER;
15:

Line 129: fnd_profile_option_values v

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
133: AND o.profile_option_name IN ('PN_ACCOUNTING_OPTION',

Line 151: fnd_profile_option_values v

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
155: AND TRIM(v.profile_option_value) = TO_CHAR(hr.organization_id)

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 262: fnd_profile_option_values v

258: COUNT(u.user_id) num_users
259: FROM fnd_user u,
260: wf_user_roles wur,
261: fnd_responsibility r,
262: fnd_profile_option_values v
263: WHERE r.application_id = 240
264: AND r.responsibility_id = wur.role_orig_system_id (+)
265: AND wur.role_orig_system (+) = 'FND_RESP'
266: AND not wur.role_name (+) like 'FND_RESP|%|ANY'

Line 283: FROM fnd_profile_option_values v

279: 0 resp_id,
280: 0 num_users
281: FROM dual
282: WHERE NOT EXISTS (SELECT NULL
283: FROM fnd_profile_option_values v
284: WHERE v.profile_option_id = g_profileid4orgid
285: AND v.profile_option_value = g_default_org_id
286: AND v.level_id = 10003
287: AND v.level_value_application_id = 240

Line 442: fnd_profile_option_values v

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
446: AND o.profile_option_name IN ('PN_GL_TRANSFER_MODE','PN_SUBMIT_JOURNAL_IMPORT')

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;

Line 525: fnd_profile_option_values v

521: COUNT(u.user_id) num_users
522: FROM fnd_user u,
523: wf_user_roles wur,
524: fnd_responsibility r,
525: fnd_profile_option_values v
526: WHERE r.application_id = 240
527: AND r.responsibility_id = wur.role_orig_system_id (+)
528: AND wur.role_orig_system (+) = 'FND_RESP'
529: AND not wur.role_name (+) like 'FND_RESP|%|ANY'

Line 546: FROM fnd_profile_option_values v

542: 0 resp_id,
543: 0 num_users
544: FROM dual
545: WHERE NOT EXISTS (SELECT NULL
546: FROM fnd_profile_option_values v
547: WHERE v.profile_option_id = g_profileid4orgid
548: AND v.profile_option_value = g_default_org_id
549: AND v.level_id = 10003
550: AND v.level_value_application_id = 240