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.PJI_PJP_SUM_ROLLUP dependencies on PJI_UTILS

Line 4374: PJI_UTILS.WRITE2LOG('CREATE_MAPPING_RULES:' ||

4370: l_return_status,
4371: l_msg_count,
4372: l_msg_data);
4373: exception when others then
4374: PJI_UTILS.WRITE2LOG('CREATE_MAPPING_RULES:' ||
4375: c.RBS_VERSION_ID || ' : ' || SQLERRM);
4376: end;
4377:
4378: end loop;

Line 4423: PJI_UTILS.WRITE2LOG('MAP_RBS_HEADERS:' || SQLERRM);

4419: l_return_status,
4420: l_msg_count,
4421: l_msg_data);
4422: exception when others then
4423: PJI_UTILS.WRITE2LOG('MAP_RBS_HEADERS:' || SQLERRM);
4424: end;
4425:
4426: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_PJP_SUM_ROLLUP.MAP_RBS_HEADERS(p_worker_id);');
4427:

Line 6520: l_g1_currency_code := PJI_UTILS.GET_GLOBAL_PRIMARY_CURRENCY;

6516: l_g1_currency_flag /* Added for Bug 8708651 */
6517: from
6518: PJI_SYSTEM_SETTINGS;
6519:
6520: l_g1_currency_code := PJI_UTILS.GET_GLOBAL_PRIMARY_CURRENCY;
6521: l_g2_currency_code := PJI_UTILS.GET_GLOBAL_SECONDARY_CURRENCY;
6522:
6523: insert /*+ parallel(pjp0_i) */ into PJI_FP_AGGR_PJP0 pjp0_i /* Added for bug 13030627 */
6524: (

Line 6521: l_g2_currency_code := PJI_UTILS.GET_GLOBAL_SECONDARY_CURRENCY;

6517: from
6518: PJI_SYSTEM_SETTINGS;
6519:
6520: l_g1_currency_code := PJI_UTILS.GET_GLOBAL_PRIMARY_CURRENCY;
6521: l_g2_currency_code := PJI_UTILS.GET_GLOBAL_SECONDARY_CURRENCY;
6522:
6523: insert /*+ parallel(pjp0_i) */ into PJI_FP_AGGR_PJP0 pjp0_i /* Added for bug 13030627 */
6524: (
6525: WORKER_ID,

Line 7677: l_g1_currency_code := PJI_UTILS.GET_GLOBAL_PRIMARY_CURRENCY;

7673: l_g1_currency_flag /* Added for Bug 8708651 */
7674: from
7675: PJI_SYSTEM_SETTINGS;
7676:
7677: l_g1_currency_code := PJI_UTILS.GET_GLOBAL_PRIMARY_CURRENCY;
7678: l_g2_currency_code := PJI_UTILS.GET_GLOBAL_SECONDARY_CURRENCY;
7679:
7680: insert into PJI_AC_AGGR_PJP0 pjp0_i
7681: (

Line 7678: l_g2_currency_code := PJI_UTILS.GET_GLOBAL_SECONDARY_CURRENCY;

7674: from
7675: PJI_SYSTEM_SETTINGS;
7676:
7677: l_g1_currency_code := PJI_UTILS.GET_GLOBAL_PRIMARY_CURRENCY;
7678: l_g2_currency_code := PJI_UTILS.GET_GLOBAL_SECONDARY_CURRENCY;
7679:
7680: insert into PJI_AC_AGGR_PJP0 pjp0_i
7681: (
7682: WORKER_ID,

Line 8443: if PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then

8439: begin
8440:
8441: /* Added for bug 13030627 */
8442: l_worker_id := p_worker_id;
8443: if PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then
8444:
8445: PJI_PJP_PRG_PERF_ALL.AGGREGATE_FP_CUST_SLICES(
8446: p_worker_id => l_worker_id);
8447:

Line 10994: if PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then

10990: if (p_worker_id is not null) then
10991:
10992: /* Added for bug 13030627 */
10993: l_worker_id := p_worker_id;
10994: if PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then
10995:
10996: PJI_PJP_PRG_PERF_ALL.ROLLUP_FPR_WBS(
10997: p_worker_id => l_worker_id);
10998:

Line 11010: l_fpm_upgrade := nvl(PJI_UTILS.GET_PARAMETER('PJI_FPM_UPGRADE'), 'C');

11006: end if;
11007:
11008: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
11009:
11010: l_fpm_upgrade := nvl(PJI_UTILS.GET_PARAMETER('PJI_FPM_UPGRADE'), 'C');
11011:
11012: select decode(l_extraction_type,'PARTIAL','PARTIAL',NULL)
11013: into l_partial_mode
11014: from dual;

Line 18094: if PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then

18090: begin
18091:
18092: /* Added for bug 13030627 */
18093: l_worker_id := p_worker_id;
18094: if PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then
18095:
18096: PJI_PJP_PRG_PERF_ALL.PURGE_PLAN_DATA(
18097: p_worker_id => l_worker_id);
18098:

Line 19007: l_fpm_upgrade := PJI_UTILS.GET_PARAMETER('PJI_FPM_UPGRADE');

19003: l_creation_date := sysdate;
19004: l_created_by := FND_GLOBAL.USER_ID;
19005: l_last_update_login := FND_GLOBAL.LOGIN_ID;
19006:
19007: l_fpm_upgrade := PJI_UTILS.GET_PARAMETER('PJI_FPM_UPGRADE');
19008:
19009: if (p_worker_id is not null) then
19010:
19011: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

Line 19354: PJI_UTILS.WRITE2LOG('PROCESS_PENDING_EVENTS:' || SQLERRM);

19350: begin
19351: PJI_FM_XBS_ACCUM_MAINT.PROCESS_PENDING_EVENTS(l_return_status,
19352: l_msg_data);
19353: exception when others then
19354: PJI_UTILS.WRITE2LOG('PROCESS_PENDING_EVENTS:' || SQLERRM);
19355: end;
19356:
19357: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_PJP_SUM_ROLLUP.PROCESS_PENDING_EVENTS(p_worker_id);');
19358:

Line 19386: l_pji_schema := pji_utils.get_pji_schema_name; -- Added for bug 13897252

19382:
19383: begin
19384:
19385: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
19386: l_pji_schema := pji_utils.get_pji_schema_name; -- Added for bug 13897252
19387:
19388: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.PROCESS_PENDING_PLAN_UPDATES(p_worker_id);')) then
19389: return;
19390: end if;

Line 19399: IF PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then

19395: l_return_status,
19396: l_msg_data);
19397:
19398: /* Added for bug 13897252 starts */
19399: IF PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then
19400: PJI_PJP_PRG_PERF_ALL.GATHER_TEMP_STATS(p_ownname => l_pji_schema
19401: ,p_tabname => 'PJI_FP_AGGR_PJP1'
19402: ,p_partname => 'P'||p_worker_id
19403: ,p_percent => 10);

Line 20292: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;

20288: return;
20289: end if;
20290: 5755229 */
20291:
20292: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
20293:
20294: /* Modified for bug#11789673 , starts here */
20295: FOR i IN 1..100 LOOP
20296: l_ctr := i;