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 PN_SYSTEM_SETUP_OPTIONS

Line 19: g_default_org_id pn_system_setup_options.org_id%TYPE;

15:
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: /*-----------------------------------------------------------------------------

Line 222: | PURPOSE : inserts data into the pn_system_setup_options table

218:
219:
220: /*-----------------------------------------------------------------------------
221: | PROCEDURE : populate_profile_tbl
222: | PURPOSE : inserts data into the pn_system_setup_options table
223: | NOTE : o assumes -1 is not a valid level_value
224: | o optimization note:
225: | oo the search algorithm assumes the tables are structured in a
226: | specific order

Line 244: | mandatory columns of pn_system_setup_options are NULL.

240: | 28-OCT-04 atuppad o Added code for 4 columns of Retro.
241: | 30-DEC-04 kkhegde o Added calc_annualized_basis_code column.
242: | 15-DEC-05 kkhegde o Added recalc_ir_on_acc_chg_flag column default 'Y'
243: | 23-MAR-06 Hareesha o Bug 5106419 Modified to handle case when
244: | mandatory columns of pn_system_setup_options are NULL.
245: | 24-MAR-06 Hareesha o Bug 5106419 Needed to update the default value of
246: | ACCOUNTING_OPTION
247: | 03-APR-06 Kiran o Bug 5135571 changed OrgId, RespId, Count to tables
248: | INDEX BY BINARY_INTEGER

Line 273: FROM pn_system_setup_options)

269: AND NVL(r.end_date, SYSDATE) >= SYSDATE
270: AND v.profile_option_id = g_profileid4orgid
271: AND v.level_value = r.responsibility_id
272: AND v.profile_option_value NOT IN (SELECT org_id
273: FROM pn_system_setup_options)
274: AND v.level_value_application_id = 240
275: AND v.level_id = 10003
276: GROUP BY r.responsibility_id, v.profile_option_value
277: UNION

Line 289: FROM pn_system_setup_options

285: AND v.profile_option_value = g_default_org_id
286: AND v.level_id = 10003
287: AND v.level_value_application_id = 240
288: AND EXISTS (SELECT null
289: FROM pn_system_setup_options
290: WHERE org_id = g_default_org_id))
291: ORDER BY 1,3 DESC;
292:
293: -- Get multiorg flag

Line 303: TYPE OrgId IS TABLE OF pn_system_setup_options.org_id%TYPE INDEX BY BINARY_INTEGER;

299: l_multi_org VARCHAR2(1) := 'N';
300: l_exists VARCHAR2(1);
301: l_info_text VARCHAR2(200);
302:
303: TYPE OrgId IS TABLE OF pn_system_setup_options.org_id%TYPE INDEX BY BINARY_INTEGER;
304: TYPE RespId IS TABLE OF fnd_responsibility.responsibility_id%TYPE INDEX BY BINARY_INTEGER;
305: TYPE Count IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
306:
307: orgids OrgId;

Line 338: INSERT INTO pn_system_setup_options

334: get_def_set_of_books_id(orgids(i)));
335:
336: IF l_set_of_books_id IS NOT NULL THEN
337:
338: INSERT INTO pn_system_setup_options
339: (profile_id,
340: org_id,
341: accounting_option,
342: set_of_books_id,

Line 371: VALUES(pn_system_setup_options_s.nextval,

367: last_update_login,
368: last_updated_by,
369: creation_date,
370: last_update_date)
371: VALUES(pn_system_setup_options_s.nextval,
372: orgids(i),
373: NVL(get_value(respids(i), 'PN_ACCOUNTING_OPTION'),'Y'),
374: l_set_of_books_id,
375: get_value(respids(i), 'PN_CURRENCY_CONV_RATE_TYPE'),

Line 504: | PURPOSE : updates data into the pn_system_setup_options table for migration

500:
501:
502: /*-----------------------------------------------------------------------------
503: | PROCEDURE : update_profile_tbl
504: | PURPOSE : updates data into the pn_system_setup_options table for migration
505: | DESCRIPTION: This procedure will update the pn_system_setup_option table for
506: | migration of GL_TRANSFER_MODE and SUBMIT_JOURNAL_IMPORT
507: | NOTE : Please refer to populate_profile_tbl procedure.
508: | HISTORY :

Line 536: FROM pn_system_setup_options)

532: AND NVL(r.end_date, SYSDATE) >= SYSDATE
533: AND v.profile_option_id = g_profileid4orgid
534: AND v.level_value = r.responsibility_id
535: AND v.profile_option_value IN (SELECT org_id
536: FROM pn_system_setup_options)
537: AND v.level_value_application_id = 240
538: AND v.level_id = 10003
539: GROUP BY r.responsibility_id, v.profile_option_value
540: UNION

Line 552: FROM pn_system_setup_options

548: AND v.profile_option_value = g_default_org_id
549: AND v.level_id = 10003
550: AND v.level_value_application_id = 240
551: AND EXISTS (SELECT null
552: FROM pn_system_setup_options
553: WHERE org_id = g_default_org_id))
554: ORDER BY 1,3 DESC;
555:
556: -- Get multiorg flag

Line 565: TYPE OrgId IS TABLE OF pn_system_setup_options.org_id%TYPE;

561: l_prev NUMBER := -1;
562: l_multi_org VARCHAR2(1) := 'N';
563: l_exists VARCHAR2(1);
564: l_info_text VARCHAR2(200);
565: TYPE OrgId IS TABLE OF pn_system_setup_options.org_id%TYPE;
566: TYPE RespId IS TABLE OF fnd_responsibility.responsibility_id%TYPE;
567: TYPE Count IS TABLE OF NUMBER;
568:
569: orgids OrgId;

Line 586: UPDATE PN_SYSTEM_SETUP_OPTIONS

582: LOOP
583: FETCH active_pn_resp_cur BULK COLLECT INTO orgids, respids, counts LIMIT 1000;
584:
585: FORALL i IN 1..orgids.COUNT
586: UPDATE PN_SYSTEM_SETUP_OPTIONS
587: SET gl_transfer_mode = get_value(respids(i),'PN_GL_TRANSFER_MODE'),
588: submit_journal_import_flag = get_value(respids(i),'PN_SUBMIT_JOURNAL_IMPORT'),
589: last_update_login = NVL(fnd_global.user_id, -1),
590: last_updated_by = NVL(fnd_global.user_id, -1),