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_MAIN dependencies on PJI_FP_XBS_ACCUM_F

Line 1126: -- Delete all the -3,-4 lines from the pji_fp_xbs_accum_f for Cost and Rev plan type having plan type code is null

1122: AND den.sub_id = bv.wbs_struct_version_id
1123: AND NVL(den.relationship_type, 'WF') IN ('LF', 'WF');
1124:
1125: -- pji_utils.write2log('Inserted -3,-4 records into ver4'||sql%rowcount);
1126: -- Delete all the -3,-4 lines from the pji_fp_xbs_accum_f for Cost and Rev plan type having plan type code is null
1127: -- l_Stage := ' Delete all the -3,-4 lines from the pji_fp_xbs_accum_f for Cost and Rev plan type';
1128:
1129: DELETE pji_rollup_level_status hdr
1130: where hdr.plan_version_id < -1

Line 1127: -- l_Stage := ' Delete all the -3,-4 lines from the pji_fp_xbs_accum_f for Cost and Rev plan type';

1123: AND NVL(den.relationship_type, 'WF') IN ('LF', 'WF');
1124:
1125: -- pji_utils.write2log('Inserted -3,-4 records into ver4'||sql%rowcount);
1126: -- Delete all the -3,-4 lines from the pji_fp_xbs_accum_f for Cost and Rev plan type having plan type code is null
1127: -- l_Stage := ' Delete all the -3,-4 lines from the pji_fp_xbs_accum_f for Cost and Rev plan type';
1128:
1129: DELETE pji_rollup_level_status hdr
1130: where hdr.plan_version_id < -1
1131: and exists (select 1 from pji_fm_extr_plnver4 ver3

Line 1138: DELETE FROM pji_fp_xbs_accum_f fact

1134: and ver3.plan_version_id = hdr.plan_version_id
1135: and ver3.plan_version_id < -1);
1136:
1137:
1138: DELETE FROM pji_fp_xbs_accum_f fact
1139: WHERE fact.plan_version_id < -1
1140: and exists (select 1 from pji_fm_extr_plnver4 ver3
1141: where ver3.worker_id = p_worker_id
1142: and ver3.project_id = fact.project_id

Line 1313: FROM pji_fp_xbs_accum_f f

1309: , SYSDATE
1310: , SYSDATE
1311: , 0
1312: ,ver.PLAN_TYPE_CODE
1313: FROM pji_fp_xbs_accum_f f
1314: , pji_fm_extr_plnver4 ver
1315: WHERE 1 = 1
1316: AND ver.project_id = f.project_id
1317: AND ver.plan_version_id = f.plan_version_id

Line 2449: INSERT INTO pji_fp_xbs_accum_f fact

2445:
2446: -- pji_utils.write2log('Updated records in wbs_header'||sql%rowcount);
2447:
2448:
2449: INSERT INTO pji_fp_xbs_accum_f fact
2450: (
2451: PROJECT_ID
2452: , PROJECT_ORG_ID
2453: , PROJECT_ORGANIZATION_ID