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 PJI_FM_PLAN_MAINT

Line 1: PACKAGE BODY PJI_FM_PLAN_MAINT_T_PVT AS

1: PACKAGE BODY PJI_FM_PLAN_MAINT_T_PVT AS
2: /* $Header: PJIPP03B.pls 120.30.12020000.2 2012/08/07 06:33:32 udshanmu ship $ */
3:
4:
5: g_package_name VARCHAR2(100) := 'PJI_FM_PLAN_MAINT_T_PVT';

Line 5: g_package_name VARCHAR2(100) := 'PJI_FM_PLAN_MAINT_T_PVT';

1: PACKAGE BODY PJI_FM_PLAN_MAINT_T_PVT AS
2: /* $Header: PJIPP03B.pls 120.30.12020000.2 2012/08/07 06:33:32 udshanmu ship $ */
3:
4:
5: g_package_name VARCHAR2(100) := 'PJI_FM_PLAN_MAINT_T_PVT';
6: g_module_name VARCHAR2(100) := 'pji.plsql.PJI_FM_PLAN_MAINT_PVT';
7: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
8:
9: g_prorating_format VARCHAR2(30) := 'S';

Line 6: g_module_name VARCHAR2(100) := 'pji.plsql.PJI_FM_PLAN_MAINT_PVT';

2: /* $Header: PJIPP03B.pls 120.30.12020000.2 2012/08/07 06:33:32 udshanmu ship $ */
3:
4:
5: g_package_name VARCHAR2(100) := 'PJI_FM_PLAN_MAINT_T_PVT';
6: g_module_name VARCHAR2(100) := 'pji.plsql.PJI_FM_PLAN_MAINT_PVT';
7: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
8:
9: g_prorating_format VARCHAR2(30) := 'S';
10: -- S Start date, E End date, D (daily) Period.

Line 146: PJI_FM_PLAN_MAINT.DELETE_ALL_PVT (

142:
143: END LOOP;
144:
145:
146: PJI_FM_PLAN_MAINT.DELETE_ALL_PVT (
147: p_fp_version_ids => p_dest_fp_version_ids
148: , p_commit => 'F');
149: print_time('Deleted the fact data and related metadata for destination plan versions.');
150:

Line 1985: PJI_FM_PLAN_MAINT_PVT.SET_RES_CLASS_FLAG;

1981: IF P_PA_DEBUG_MODE = 'Y' THEN
1982: pa_debug.write('EXTRACT_PLAN_AMTS_SECRBS_GLC12: ' || g_module_name,'Before calling SET_RES_CLASS_FLAG' ,1);
1983: END IF;
1984:
1985: PJI_FM_PLAN_MAINT_PVT.SET_RES_CLASS_FLAG;
1986:
1987: IF P_PA_DEBUG_MODE = 'Y' THEN
1988: pa_debug.write('EXTRACT_PLAN_AMTS_SECRBS_GLC12: ' || g_module_name,'After calling SET_RES_CLASS_FLAG' ,1);
1989: END IF;

Line 2350: , decode(PJI_FM_PLAN_MAINT_PVT.g_res_class_flag,'N',decode(PJI_FM_PLAN_MAINT_PVT.get_res_class_flag(ra.budget_version_id), 'N',

2346: , NVL(ver.rbs_struct_version_id, -1) rbs_struct_version_id -- !! changed.
2347: , ver.plan_type_id plan_type_id
2348: , ra.rate_based_flag billable_flag
2349: -- cbs change -- Bug 13736073
2350: , decode(PJI_FM_PLAN_MAINT_PVT.g_res_class_flag,'N',decode(PJI_FM_PLAN_MAINT_PVT.get_res_class_flag(ra.budget_version_id), 'N',
2351: '1'||ra.resource_class_code, ra.resource_class_code),ra.resource_class_code) resource_class
2352: -- End cbs change
2353: , DECODE(ver.time_phased_type_code
2354: , g_pa_cal_str, 32

Line 2656: , decode(PJI_FM_PLAN_MAINT_PVT.g_res_class_flag,'N',decode(PJI_FM_PLAN_MAINT_PVT.get_res_class_flag(ra.budget_version_id), 'N',

2652: , NVL(ver.rbs_struct_version_id, -1) rbs_struct_version_id -- !! changed.
2653: , ver.plan_type_id plan_type_id
2654: , ra.rate_based_flag billable_flag
2655: -- cbs change -- Bug 13736073
2656: , decode(PJI_FM_PLAN_MAINT_PVT.g_res_class_flag,'N',decode(PJI_FM_PLAN_MAINT_PVT.get_res_class_flag(ra.budget_version_id), 'N',
2657: '1'||ra.resource_class_code, ra.resource_class_code),ra.resource_class_code) resource_class
2658: -- End cbs change
2659: , DECODE(ver.time_phased_type_code
2660: , g_pa_cal_str, 32

Line 3050: PJI_FM_PLAN_MAINT_PVT.SET_RES_CLASS_FLAG;

3046: IF P_PA_DEBUG_MODE = 'Y' THEN
3047: pa_debug.write('EXTRACT_PLAN_AMTS_PRIRBS_GLC12: ' || g_module_name,'Before calling SET_RES_CLASS_FLAG' ,1);
3048: END IF;
3049:
3050: PJI_FM_PLAN_MAINT_PVT.SET_RES_CLASS_FLAG;
3051:
3052: IF P_PA_DEBUG_MODE = 'Y' THEN
3053: pa_debug.write('EXTRACT_PLAN_AMTS_PRIRBS_GLC12: ' || g_module_name,'After calling SET_RES_CLASS_FLAG' ,1);
3054: END IF;

Line 3411: , decode(PJI_FM_PLAN_MAINT_PVT.g_res_class_flag,'N',decode(PJI_FM_PLAN_MAINT_PVT.get_res_class_flag(ra.budget_version_id), 'N',

3407: , NVL(ver.rbs_struct_version_id, -1) rbs_struct_version_id
3408: , ver.plan_type_id plan_type_id
3409: , ra.rate_based_flag billable_flag
3410: -- cbs change --Bug 13736073
3411: , decode(PJI_FM_PLAN_MAINT_PVT.g_res_class_flag,'N',decode(PJI_FM_PLAN_MAINT_PVT.get_res_class_flag(ra.budget_version_id), 'N',
3412: '1'||ra.resource_class_code, ra.resource_class_code),ra.resource_class_code) resource_class
3413: -- End cbs change
3414: , DECODE(ver.time_phased_type_code
3415: , g_pa_cal_str, 32

Line 3711: , decode(PJI_FM_PLAN_MAINT_PVT.g_res_class_flag,'N',decode(PJI_FM_PLAN_MAINT_PVT.get_res_class_flag(ra.budget_version_id), 'N',

3707: , NVL(ver.rbs_struct_version_id, -1) rbs_struct_version_id
3708: , ver.plan_type_id plan_type_id
3709: , ra.rate_based_flag billable_flag
3710: -- cbs change -- Bug 13736073
3711: , decode(PJI_FM_PLAN_MAINT_PVT.g_res_class_flag,'N',decode(PJI_FM_PLAN_MAINT_PVT.get_res_class_flag(ra.budget_version_id), 'N',
3712: '1'||ra.resource_class_code, ra.resource_class_code),ra.resource_class_code) resource_class
3713: -- End cbs change
3714: , 2048 period_type_id
3715: , g_all CALENDAR_TYPE

Line 5345: PJI_FM_PLAN_MAINT_T_PVT.GET_GLOBAL_EXCHANGE_RATES;

5341: -- SQL 5: Update existing rcds for GL1 if GL2 is equal to GL1, etc.
5342: -- SQL 6: Create new rcds using existing records for TXN if GL2 is not in (TXN, PRJ, FUNC, GL1).
5343: --3. Merge the new records into rpting lines.
5344:
5345: PJI_FM_PLAN_MAINT_T_PVT.GET_GLOBAL_EXCHANGE_RATES;
5346:
5347: PJI_FM_PLAN_MAINT_T_PVT.CONV_TO_GLOBAL_CURRENCIES;
5348:
5349: -- This wont work!!!

Line 5347: PJI_FM_PLAN_MAINT_T_PVT.CONV_TO_GLOBAL_CURRENCIES;

5343: --3. Merge the new records into rpting lines.
5344:
5345: PJI_FM_PLAN_MAINT_T_PVT.GET_GLOBAL_EXCHANGE_RATES;
5346:
5347: PJI_FM_PLAN_MAINT_T_PVT.CONV_TO_GLOBAL_CURRENCIES;
5348:
5349: -- This wont work!!!
5350: -- PJI_FM_PLAN_MAINT.MERGE_INTO_REPORTING_LNS_FACT;
5351: -- This wont work!!!

Line 5350: -- PJI_FM_PLAN_MAINT.MERGE_INTO_REPORTING_LNS_FACT;

5346:
5347: PJI_FM_PLAN_MAINT_T_PVT.CONV_TO_GLOBAL_CURRENCIES;
5348:
5349: -- This wont work!!!
5350: -- PJI_FM_PLAN_MAINT.MERGE_INTO_REPORTING_LNS_FACT;
5351: -- This wont work!!!
5352:
5353: EXCEPTION
5354: WHEN OTHERS THEN

Line 5376: l_ver3_is_empty := PJI_FM_PLAN_MAINT.CHECK_VER3_NOT_EMPTY ( p_online => 'T');

5372:
5373: --
5374: -- IF ver3 is empty, return.
5375: --
5376: l_ver3_is_empty := PJI_FM_PLAN_MAINT.CHECK_VER3_NOT_EMPTY ( p_online => 'T');
5377: IF (l_ver3_is_empty = 'T') THEN
5378: print_time ( ' ver3 is empty, nothing to process. Returning. ');
5379: RETURN;
5380: END IF;

Line 5467: PJI_FM_PLAN_MAINT_T_PVT.ROLLUP_FPR_RBS_T_SLICE;

5463:
5464: --
5465: -- RBS rollup.
5466: --
5467: PJI_FM_PLAN_MAINT_T_PVT.ROLLUP_FPR_RBS_T_SLICE;
5468: print_time(' Created RBS rollup slice. ');
5469:
5470:
5471: --

Line 5474: PJI_FM_PLAN_MAINT_T_PVT.CREATE_WBSRLP;

5470:
5471: --
5472: -- WBS rollup.
5473: --
5474: PJI_FM_PLAN_MAINT_T_PVT.CREATE_WBSRLP;
5475: print_time(' Created WBS rollup slice. ');
5476:
5477:
5478: --

Line 6809: PJI_FM_PLAN_MAINT_PVT.set_res_class_flag;

6805:
6806: print_time ( ' REVERSE_ETC l_prev_pub_version_id ' || l_prev_pub_version_id || ' l_actual_plan_version_id ' || l_actual_plan_version_id || ' l_project_id ' || l_project_id ) ;
6807:
6808:
6809: PJI_FM_PLAN_MAINT_PVT.set_res_class_flag;
6810:
6811: INSERT INTO PJI_FP_AGGR_PJP1_T
6812: (
6813: WORKER_ID

Line 7162: , decode(PJI_FM_PLAN_MAINT_PVT.g_res_class_flag,'N',decode(PJI_FM_PLAN_MAINT_PVT.get_res_class_flag(bl.plan_version_id), 'N',

7158: , bl.plan_type_id plan_type_id -- ver.plan_type_id
7159: , bl.rate_based_flag billable_flag -- ra.rate_based_flag billable_flag
7160: -- cbs change
7161: --, bl.resource_class_code resource_class -- ra.resource_class_code resource_class
7162: , decode(PJI_FM_PLAN_MAINT_PVT.g_res_class_flag,'N',decode(PJI_FM_PLAN_MAINT_PVT.get_res_class_flag(bl.plan_version_id), 'N',
7163: '1'||bl.resource_class_code, bl.resource_class_code),bl.resource_class_code) resource_class
7164: -- End cbs change
7165: , bl.txn_currency_code txn_currency_code
7166: , bl.txn_raw_cost txn_raw_cost

Line 7231: , decode(PJI_FM_PLAN_MAINT_PVT.g_res_class_flag,'N',decode(PJI_FM_PLAN_MAINT_PVT.get_res_class_flag(ra.budget_version_id), 'N',

7227: , ver.plan_type_id plan_type_id
7228: , ra.rate_based_flag billable_flag
7229: -- cbs change
7230: --, ra.resource_class_code resource_class
7231: , decode(PJI_FM_PLAN_MAINT_PVT.g_res_class_flag,'N',decode(PJI_FM_PLAN_MAINT_PVT.get_res_class_flag(ra.budget_version_id), 'N',
7232: '1'||ra.resource_class_code, ra.resource_class_code),ra.resource_class_code) resource_class
7233: -- End cbs change
7234: , bl.txn_currency_code txn_currency_code
7235: , TO_NUMBER(NULL) txn_raw_cost

Line 8475: PJI_FM_PLAN_MAINT.CREATE_SECONDARY_T_PVT(

8471:
8472: -- print_time ( ' plan version id is ... ' || c_dangling.budget_version_id ) ;
8473: -- l_fp_wp_version_ids := SYSTEM.pa_num_tbl_type (c_dangling.budget_version_id);
8474:
8475: PJI_FM_PLAN_MAINT.CREATE_SECONDARY_T_PVT(
8476: p_fp_version_ids => l_fp_wp_version_ids
8477: , p_process_all => 'T'
8478: , p_commit => 'F');
8479:

Line 9814: END PJI_FM_PLAN_MAINT_T_PVT;

9810:
9811: g_worker_id := 1; -- PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
9812:
9813:
9814: END PJI_FM_PLAN_MAINT_T_PVT;