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.

[Home] [Help]

APPS.PJI_FM_PLAN_MAINT_T_PVT dependencies on PA_BUDGET_VERSIONS

Line 129: FROM pa_budget_versions

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

Line 134: FROM pa_budget_versions

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

Line 387: FROM pa_budget_versions

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

Line 609: FROM pa_budget_versions

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

Line 881: pa_budget_versions bv -- @pjdev115 bv

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

Line 943: pa_budget_versions bv -- @pjdev115 bv

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

Line 1009: pa_budget_versions bv -- @pjdev115 bv

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

Line 1117: pa_budget_versions bv -- @pjdev115 bv

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

Line 1184: pa_budget_versions bv -- @pjdev115 bv

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

Line 1255: pa_budget_versions bv -- @pjdev115 bv

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

Line 4454: , pa_budget_versions bv -- @pjdev115 bv

4450: , g_default_prg_level
4451: , rl.PLAN_TYPE_CODE /* 4471527 */
4452: FROM
4453: pji_fp_xbs_accum_f rl
4454: , pa_budget_versions bv -- @pjdev115 bv
4455: , pa_proj_fp_options fpo -- @pjdev115 fpo
4456: WHERE
4457: rl.project_id = bv.project_id
4458: AND bv.version_type IS NOT NULL

Line 5105: , pa_budget_versions bv

5101: , bv.current_original_flag current_original_flag
5102: , DECODE(bv.baselined_date, NULL, 'N', 'Y') baselined_flag
5103: , 'N'
5104: FROM PJI_FM_EXTR_PLAN_LINES epl
5105: , pa_budget_versions bv
5106: , pa_proj_fp_options fpo
5107: WHERE
5108: epl.plan_version_id = bv.budget_version_id
5109: AND fpo.project_id = bv.project_id

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

5211: ) end_date
5212: , l_gl1_mau mau1
5213: , l_gl2_mau mau2
5214: FROM pa_budget_lines bl
5215: , pa_budget_versions bv -- added for bug 5842896
5216: , pji_time_cal_period_v prd
5217: , PJI_FM_EXTR_PLNVER3_T ver
5218: , pa_projects_all ppa
5219: ,PJI_ORG_EXTR_INFO inf

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

5490: PJI_FM_PLAN_CAL_RLPS_T.CREATE_FP_ENT_ROLLUP;
5491: print_time(' Enterprise calendar rollup. ');
5492:
5493: --
5494: -- Mark pji summarized flag in pa budget versions table.
5495: -- If rates are missing or GL1/GL2 definitions are missing, then mark those plans as 'P'
5496: --
5497: MARK_DANGLING_PLAN_VERSIONS;
5498:

Line 6781: FROM pa_budget_versions

6777: END IF;
6778:
6779: SELECT project_id, fin_plan_type_id
6780: INTO l_project_id, l_new_plan_type_id
6781: FROM pa_budget_versions
6782: WHERE budget_version_id = p_new_pub_version_id ;
6783:
6784: SELECT structure_sharing_code
6785: INTO l_struct_sharing_code

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

8392: PROCEDURE MARK_DANGLING_PLAN_VERSIONS IS
8393: BEGIN
8394:
8395: -- Added INDEX for bug 3828698
8396: UPDATE /*+ INDEX(bv,PA_BUDGET_VERSIONS_U1)*/ pa_budget_versions bv
8397: SET pji_summarized_flag = 'P',
8398: record_version_number = nvl(record_version_number,0)+1
8399: WHERE budget_version_id IN (
8400: SELECT plan_version_id

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

8410: ) b
8411: WHERE dangling > 2
8412: );
8413:
8414: UPDATE /*+ INDEX(bv,PA_BUDGET_VERSIONS_U1)*/ pa_budget_versions bv
8415: SET pji_summarized_flag = 'Y',
8416: record_version_number = nvl(record_version_number,0)+1
8417: WHERE budget_version_id IN (
8418: SELECT plan_version_id

Line 8462: FROM pa_budget_versions bv

8458:
8459: /*
8460: CURSOR c_dangling_vers_cur IS
8461: SELECT budget_version_id
8462: FROM pa_budget_versions bv
8463: WHERE pji_summarized_flag = 'P';
8464: */
8465:
8466: BEGIN

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

9349:
9350: BEGIN
9351:
9352: --
9353: -- On PA_BUDGET_VERSIONS, the PJI_SUMMARIZED_FLAG can have four values:
9354: -- 'N' the plan version has not been summarized
9355: -- 'P' the plan version has been partially summarized due to dangling currency or calendar records
9356: -- 'Y' the plan version has been fully summarized in Project Performance and
9357: -- NULL the plan version has been fully summarized in both PJI and Project Performance.

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

9357: -- NULL the plan version has been fully summarized in both PJI and Project Performance.
9358: --
9359: -- Note that, in PJI data extraction, data that existed before PJI was installed
9360: -- has PJI_SUMMARIZED_FLAG = null and new transactions are inserted with value 'N'.
9361: -- A similar situation does not occur in PA_BUDGET_VERSIONS. During the upgrade process
9362: -- will pull necessary data from PA_BUDGET_VERSIONS and set PJI_SUMMARIZATION_FLAG to 'P', 'N'
9363: -- or 'Y' accordingly. New versions will be inserted with value 'N'.)
9364: --
9365:

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

9358: --
9359: -- Note that, in PJI data extraction, data that existed before PJI was installed
9360: -- has PJI_SUMMARIZED_FLAG = null and new transactions are inserted with value 'N'.
9361: -- A similar situation does not occur in PA_BUDGET_VERSIONS. During the upgrade process
9362: -- will pull necessary data from PA_BUDGET_VERSIONS and set PJI_SUMMARIZATION_FLAG to 'P', 'N'
9363: -- or 'Y' accordingly. New versions will be inserted with value 'N'.)
9364: --
9365:
9366: IF (p_slice_type = 'PRI') THEN

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

9364: --
9365:
9366: IF (p_slice_type = 'PRI') THEN
9367: /* Added index for bug 3818232 */
9368: UPDATE /*+ INDEX( pa_budget_versions PA_BUDGET_VERSIONS_U1)*/
9369: pa_budget_versions
9370: SET pji_summarized_flag =
9371: DECODE(wp_version_flag
9372: , 'Y', 'Y'

Line 9369: pa_budget_versions

9365:
9366: IF (p_slice_type = 'PRI') THEN
9367: /* Added index for bug 3818232 */
9368: UPDATE /*+ INDEX( pa_budget_versions PA_BUDGET_VERSIONS_U1)*/
9369: pa_budget_versions
9370: SET pji_summarized_flag =
9371: DECODE(wp_version_flag
9372: , 'Y', 'Y'
9373: , DECODE(budget_status_code

Line 9411: UPDATE pa_budget_versions

9407: END;
9408:
9409:
9410:
9411: UPDATE pa_budget_versions
9412: SET pji_summarized_flag = decode(l_dangling_flag,'Y','P','Y'),
9413: record_version_number=nvl(record_version_number,0)+1
9414: WHERE budget_version_id IN
9415: (

Line 9423: /* UPDATE pa_budget_versions

9419:
9420: END LOOP;
9421: -- Added INDEX for bug 3828698
9422:
9423: /* UPDATE pa_budget_versions
9424: SET pji_summarized_flag = 'Y',
9425: record_version_number=nvl(record_version_number,0)+1
9426: WHERE budget_version_id IN
9427: (

Line 9446: UPDATE pa_budget_versions

9442: FROM PJI_FM_EXTR_PLNVER3_T
9443: WHERE time_dangling_flag IS NOT NULL
9444: );
9445:
9446: UPDATE pa_budget_versions
9447: SET pji_summarized_flag = 'P',
9448: record_version_number=nvl(record_version_number,0)+1
9449: WHERE budget_version_id IN
9450: (