APPS.PJI_PJP_SUM_ROLLUP dependencies on PJI_UTILS

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

1220: l_return_status,
1221: l_msg_count,
1222: l_msg_data);
1223: exception when others then
1224: PJI_UTILS.WRITE2LOG('CREATE_MAPPING_RULES:' ||
1225: c.RBS_VERSION_ID || ' : ' || SQLERRM);
1226: end;
1227:
1228: end loop;

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

1269: l_return_status,
1270: l_msg_count,
1271: l_msg_data);
1272: exception when others then
1273: PJI_UTILS.WRITE2LOG('MAP_RBS_HEADERS:' || SQLERRM);
1274: end;
1275:
1276: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_PJP_SUM_ROLLUP.MAP_RBS_HEADERS(p_worker_id);');
1277:

Line 3263: l_g1_currency_code := PJI_UTILS.GET_GLOBAL_PRIMARY_CURRENCY;

3259: l_g2_currency_flag
3260: from
3261: PJI_SYSTEM_SETTINGS;
3262:
3263: l_g1_currency_code := PJI_UTILS.GET_GLOBAL_PRIMARY_CURRENCY;
3264: l_g2_currency_code := PJI_UTILS.GET_GLOBAL_SECONDARY_CURRENCY;
3265:
3266: insert into PJI_FP_AGGR_PJP0 pjp0_i
3267: (

Line 3264: l_g2_currency_code := PJI_UTILS.GET_GLOBAL_SECONDARY_CURRENCY;

3260: from
3261: PJI_SYSTEM_SETTINGS;
3262:
3263: l_g1_currency_code := PJI_UTILS.GET_GLOBAL_PRIMARY_CURRENCY;
3264: l_g2_currency_code := PJI_UTILS.GET_GLOBAL_SECONDARY_CURRENCY;
3265:
3266: insert into PJI_FP_AGGR_PJP0 pjp0_i
3267: (
3268: WORKER_ID,

Line 4411: l_g1_currency_code := PJI_UTILS.GET_GLOBAL_PRIMARY_CURRENCY;

4407: l_g2_currency_flag
4408: from
4409: PJI_SYSTEM_SETTINGS;
4410:
4411: l_g1_currency_code := PJI_UTILS.GET_GLOBAL_PRIMARY_CURRENCY;
4412: l_g2_currency_code := PJI_UTILS.GET_GLOBAL_SECONDARY_CURRENCY;
4413:
4414: insert into PJI_AC_AGGR_PJP0 pjp0_i
4415: (

Line 4412: l_g2_currency_code := PJI_UTILS.GET_GLOBAL_SECONDARY_CURRENCY;

4408: from
4409: PJI_SYSTEM_SETTINGS;
4410:
4411: l_g1_currency_code := PJI_UTILS.GET_GLOBAL_PRIMARY_CURRENCY;
4412: l_g2_currency_code := PJI_UTILS.GET_GLOBAL_SECONDARY_CURRENCY;
4413:
4414: insert into PJI_AC_AGGR_PJP0 pjp0_i
4415: (
4416: WORKER_ID,

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

7581: end if;
7582:
7583: l_extraction_type := PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process, 'EXTRACTION_TYPE');
7584:
7585: l_fpm_upgrade := nvl(PJI_UTILS.GET_PARAMETER('PJI_FPM_UPGRADE'), 'C');
7586:
7587: select decode(l_extraction_type,'PARTIAL','PARTIAL',NULL)
7588: into l_partial_mode
7589: from dual;

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

16821: l_creation_date := sysdate;
16822: l_created_by := FND_GLOBAL.USER_ID;
16823: l_last_update_login := FND_GLOBAL.LOGIN_ID;
16824:
16825: l_fpm_upgrade := PJI_UTILS.GET_PARAMETER('PJI_FPM_UPGRADE');
16826:
16827: if (p_worker_id is not null) then
16828:
16829: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);

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

17080: begin
17081: PJI_FM_XBS_ACCUM_MAINT.PROCESS_PENDING_EVENTS(l_return_status,
17082: l_msg_data);
17083: exception when others then
17084: PJI_UTILS.WRITE2LOG('PROCESS_PENDING_EVENTS:' || SQLERRM);
17085: end;
17086:
17087: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION(l_process, 'PJI_PJP_SUM_ROLLUP.PROCESS_PENDING_EVENTS(p_worker_id);');
17088:

Line 17982: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;

17978: return;
17979: end if;
17980: 5755229 */
17981:
17982: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
17983:
17984: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_schema,
17985: 'PJI_PJP_RMAP_FPR',
17986: 'PARTITION',