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_FM_PLAN_MAINT_T_PVT dependencies on PA_BUDGET_VERSIONS

Line 127: FROM pa_budget_versions

123:
124: SELECT fin_plan_type_id, project_id
125: INTO l_dest_plan_type_ids(i)
126: ,l_dest_project_ids(i)
127: FROM pa_budget_versions
128: WHERE budget_version_id = p_dest_fp_version_ids(i);
129:
130: SELECT project_id
131: INTO l_src_project_ids(i)

Line 132: FROM pa_budget_versions

128: WHERE budget_version_id = p_dest_fp_version_ids(i);
129:
130: SELECT project_id
131: INTO l_src_project_ids(i)
132: FROM pa_budget_versions
133: WHERE budget_version_id = p_source_fp_version_ids(i);
134:
135: print_time ( ' i = ' || i ) ;
136: print_time ( 'Spvi= ' || p_source_fp_version_ids(i));

Line 385: FROM pa_budget_versions

381: FOR i IN 1..p_source_fp_version_ids.COUNT LOOP
382: SELECT fin_plan_type_id, project_id
383: INTO l_dest_plan_type_ids(i)
384: , l_dest_project_ids(i)
385: FROM pa_budget_versions
386: WHERE budget_version_id = p_dest_fp_version_ids(i);
387:
388: print_time ( ' i = ' || i ) ;
389: print_time ( 'Spvi= ' || p_source_fp_version_ids(i));

Line 607: FROM pa_budget_versions

603: print_time ( ' COPY_PRIMARY_SINGLE api 001 ' || p_source_plan_ver_id || ' ' || p_target_plan_ver_id );
604:
605: SELECT fin_plan_type_id, project_id
606: INTO l_dest_plan_type_id, l_dest_project_id
607: FROM pa_budget_versions
608: WHERE budget_version_id = p_target_plan_ver_id;
609:
610: DELETE FROM PJI_FP_XBS_ACCUM_F
611: WHERE plan_version_id = p_target_plan_ver_id

Line 879: pa_budget_versions bv -- @pjdev115 bv

875: , bv.current_original_flag current_original_flag
876: , DECODE(bv.baselined_date, NULL, 'N', 'Y') baselined_flag
877: , 'N' SECONDARY_RBS_FLAG
878: FROM
879: pa_budget_versions bv -- @pjdev115 bv
880: , pa_proj_fp_options fpo -- @pjdev115 fpo
881: , pa_projects_all ppa -- @pjdev115 ppa
882: WHERE 1=1
883: AND ppa.project_id = bv.project_id

Line 941: pa_budget_versions bv -- @pjdev115 bv

937: , bv.current_original_flag current_original_flag
938: , DECODE(bv.baselined_date, NULL, 'N', 'Y') baselined_flag
939: , 'N' SECONDARY_RBS_FLAG
940: FROM
941: pa_budget_versions bv -- @pjdev115 bv
942: , pa_proj_fp_options fpo -- @pjdev115 fpo -- is there a work plan options table?
943: , pa_projects_all ppa -- @pjdev115 ppa
944: WHERE 1=1
945: AND ppa.project_id = bv.project_id

Line 1007: pa_budget_versions bv -- @pjdev115 bv

1003: , bv.current_original_flag current_original_flag
1004: , DECODE(bv.baselined_date, NULL, 'N', 'Y') baselined_flag
1005: , 'Y' SECONDARY_RBS_FLAG
1006: FROM
1007: pa_budget_versions bv -- @pjdev115 bv
1008: , pa_proj_fp_options fpo -- @pjdev115 fpo -- is there a work plan options table?
1009: , pa_projects_all ppa -- @pjdev115 ppa
1010: , PA_RBS_PRJ_ASSIGNMENTS rpa
1011: WHERE 1=1

Line 1115: pa_budget_versions bv -- @pjdev115 bv

1111: , bv.current_original_flag current_original_flag
1112: , DECODE(bv.baselined_date, NULL, 'N', 'Y') baselined_flag
1113: , 'N' SECONDARY_RBS_FLAG
1114: FROM
1115: pa_budget_versions bv -- @pjdev115 bv
1116: , pa_proj_fp_options fpo -- @pjdev115 fpo
1117: , pa_projects_all ppa -- @pjdev115 ppa
1118: WHERE 1=1
1119: AND ppa.project_id = bv.project_id

Line 1182: pa_budget_versions bv -- @pjdev115 bv

1178: , bv.current_original_flag current_original_flag
1179: , DECODE(bv.baselined_date, NULL, 'N', 'Y') baselined_flag
1180: , 'N' SECONDARY_RBS_FLAG
1181: FROM
1182: pa_budget_versions bv -- @pjdev115 bv
1183: , pa_proj_fp_options fpo -- @pjdev115 fpo
1184: , pa_projects_all ppa -- @pjdev115 ppa
1185: WHERE 1=1
1186: AND ppa.project_id = bv.project_id

Line 1253: pa_budget_versions bv -- @pjdev115 bv

1249: , bv.current_original_flag current_original_flag
1250: , DECODE(bv.baselined_date, NULL, 'N', 'Y') baselined_flag
1251: , 'Y' SECONDARY_RBS_FLAG
1252: FROM
1253: pa_budget_versions bv -- @pjdev115 bv
1254: , pa_proj_fp_options fpo -- @pjdev115 fpo
1255: , pa_projects_all ppa -- @pjdev115 ppa
1256: , PA_RBS_PRJ_ASSIGNMENTS rpa
1257: WHERE 1=1

Line 4367: , pa_budget_versions bv -- @pjdev115 bv

4363: , g_default_prg_level
4364: , rl.PLAN_TYPE_CODE /* 4471527 */
4365: FROM
4366: pji_fp_xbs_accum_f rl
4367: , pa_budget_versions bv -- @pjdev115 bv
4368: , pa_proj_fp_options fpo -- @pjdev115 fpo
4369: WHERE
4370: rl.project_id = bv.project_id
4371: AND bv.version_type IS NOT NULL

Line 5005: , pa_budget_versions bv

5001: , bv.current_original_flag current_original_flag
5002: , DECODE(bv.baselined_date, NULL, 'N', 'Y') baselined_flag
5003: , 'N'
5004: FROM PJI_FM_EXTR_PLAN_LINES epl
5005: , pa_budget_versions bv
5006: , pa_proj_fp_options fpo
5007: WHERE
5008: epl.plan_version_id = bv.budget_version_id
5009: AND fpo.project_id = bv.project_id

Line 5115: , pa_budget_versions bv -- added for bug 5842896

5111: ) end_date
5112: , l_gl1_mau mau1
5113: , l_gl2_mau mau2
5114: FROM pa_budget_lines bl
5115: , pa_budget_versions bv -- added for bug 5842896
5116: , pji_time_cal_period_v prd
5117: , PJI_FM_EXTR_PLNVER3_T ver
5118: , pa_projects_all ppa
5119: ,PJI_ORG_EXTR_INFO inf

Line 5393: -- Mark pji summarized flag in pa budget versions table.

5389: PJI_FM_PLAN_CAL_RLPS_T.CREATE_FP_ENT_ROLLUP;
5390: print_time(' Enterprise calendar rollup. ');
5391:
5392: --
5393: -- Mark pji summarized flag in pa budget versions table.
5394: -- If rates are missing or GL1/GL2 definitions are missing, then mark those plans as 'P'
5395: --
5396: MARK_DANGLING_PLAN_VERSIONS;
5397:

Line 6658: FROM pa_budget_versions

6654: END IF;
6655:
6656: SELECT project_id, fin_plan_type_id
6657: INTO l_project_id, l_new_plan_type_id
6658: FROM pa_budget_versions
6659: WHERE budget_version_id = p_new_pub_version_id ;
6660:
6661: SELECT structure_sharing_code
6662: INTO l_struct_sharing_code

Line 8248: UPDATE /+ INDEX(bv,PA_BUDGET_VERSIONS_U1)/ pa_budget_versions bv

8244: PROCEDURE MARK_DANGLING_PLAN_VERSIONS IS
8245: BEGIN
8246:
8247: -- Added INDEX for bug 3828698
8248: UPDATE /*+ INDEX(bv,PA_BUDGET_VERSIONS_U1)*/ pa_budget_versions bv
8249: SET pji_summarized_flag = 'P',
8250: record_version_number = nvl(record_version_number,0)+1
8251: WHERE budget_version_id IN (
8252: SELECT plan_version_id

Line 8266: UPDATE /+ INDEX(bv,PA_BUDGET_VERSIONS_U1)/ pa_budget_versions bv

8262: ) b
8263: WHERE dangling > 2
8264: );
8265:
8266: UPDATE /*+ INDEX(bv,PA_BUDGET_VERSIONS_U1)*/ pa_budget_versions bv
8267: SET pji_summarized_flag = 'Y',
8268: record_version_number = nvl(record_version_number,0)+1
8269: WHERE budget_version_id IN (
8270: SELECT plan_version_id

Line 8314: FROM pa_budget_versions bv

8310:
8311: /*
8312: CURSOR c_dangling_vers_cur IS
8313: SELECT budget_version_id
8314: FROM pa_budget_versions bv
8315: WHERE pji_summarized_flag = 'P';
8316: */
8317:
8318: BEGIN

Line 9198: -- On PA_BUDGET_VERSIONS, the PJI_SUMMARIZED_FLAG can have four values:

9194:
9195: BEGIN
9196:
9197: --
9198: -- On PA_BUDGET_VERSIONS, the PJI_SUMMARIZED_FLAG can have four values:
9199: -- 'N' the plan version has not been summarized
9200: -- 'P' the plan version has been partially summarized due to dangling currency or calendar records
9201: -- 'Y' the plan version has been fully summarized in Project Performance and
9202: -- NULL the plan version has been fully summarized in both PJI and Project Performance.

Line 9206: -- A similar situation does not occur in PA_BUDGET_VERSIONS. During the upgrade process

9202: -- NULL the plan version has been fully summarized in both PJI and Project Performance.
9203: --
9204: -- Note that, in PJI data extraction, data that existed before PJI was installed
9205: -- has PJI_SUMMARIZED_FLAG = null and new transactions are inserted with value 'N'.
9206: -- A similar situation does not occur in PA_BUDGET_VERSIONS. During the upgrade process
9207: -- will pull necessary data from PA_BUDGET_VERSIONS and set PJI_SUMMARIZATION_FLAG to 'P', 'N'
9208: -- or 'Y' accordingly. New versions will be inserted with value 'N'.)
9209: --
9210:

Line 9207: -- will pull necessary data from PA_BUDGET_VERSIONS and set PJI_SUMMARIZATION_FLAG to 'P', 'N'

9203: --
9204: -- Note that, in PJI data extraction, data that existed before PJI was installed
9205: -- has PJI_SUMMARIZED_FLAG = null and new transactions are inserted with value 'N'.
9206: -- A similar situation does not occur in PA_BUDGET_VERSIONS. During the upgrade process
9207: -- will pull necessary data from PA_BUDGET_VERSIONS and set PJI_SUMMARIZATION_FLAG to 'P', 'N'
9208: -- or 'Y' accordingly. New versions will be inserted with value 'N'.)
9209: --
9210:
9211: IF (p_slice_type = 'PRI') THEN

Line 9213: UPDATE /+ INDEX( pa_budget_versions PA_BUDGET_VERSIONS_U1)/

9209: --
9210:
9211: IF (p_slice_type = 'PRI') THEN
9212: /* Added index for bug 3818232 */
9213: UPDATE /*+ INDEX( pa_budget_versions PA_BUDGET_VERSIONS_U1)*/
9214: pa_budget_versions
9215: SET pji_summarized_flag =
9216: DECODE(wp_version_flag
9217: , 'Y', 'Y'

Line 9214: pa_budget_versions

9210:
9211: IF (p_slice_type = 'PRI') THEN
9212: /* Added index for bug 3818232 */
9213: UPDATE /*+ INDEX( pa_budget_versions PA_BUDGET_VERSIONS_U1)*/
9214: pa_budget_versions
9215: SET pji_summarized_flag =
9216: DECODE(wp_version_flag
9217: , 'Y', 'Y'
9218: , DECODE(budget_status_code

Line 9256: UPDATE pa_budget_versions

9252: END;
9253:
9254:
9255:
9256: UPDATE pa_budget_versions
9257: SET pji_summarized_flag = decode(l_dangling_flag,'Y','P','Y'),
9258: record_version_number=nvl(record_version_number,0)+1
9259: WHERE budget_version_id IN
9260: (

Line 9268: /* UPDATE pa_budget_versions

9264:
9265: END LOOP;
9266: -- Added INDEX for bug 3828698
9267:
9268: /* UPDATE pa_budget_versions
9269: SET pji_summarized_flag = 'Y',
9270: record_version_number=nvl(record_version_number,0)+1
9271: WHERE budget_version_id IN
9272: (

Line 9291: UPDATE pa_budget_versions

9287: FROM PJI_FM_EXTR_PLNVER3_T
9288: WHERE time_dangling_flag IS NOT NULL
9289: );
9290:
9291: UPDATE pa_budget_versions
9292: SET pji_summarized_flag = 'P',
9293: record_version_number=nvl(record_version_number,0)+1
9294: WHERE budget_version_id IN
9295: (