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_PVT dependencies on PJI_FM_PLAN_MAINT_PVT

Line 1: PACKAGE BODY PJI_FM_PLAN_MAINT_PVT AS

1: PACKAGE BODY PJI_FM_PLAN_MAINT_PVT AS
2: /* $Header: PJIPP02B.pls 120.86.12020000.6 2013/04/18 12:38:04 udshanmu ship $ */
3:
4:
5: g_package_name VARCHAR2(100) := 'PJI_FM_PLAN_MAINT_PVT';

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

1: PACKAGE BODY PJI_FM_PLAN_MAINT_PVT AS
2: /* $Header: PJIPP02B.pls 120.86.12020000.6 2013/04/18 12:38:04 udshanmu ship $ */
3:
4:
5: g_package_name VARCHAR2(100) := 'PJI_FM_PLAN_MAINT_PVT';
6:
7: g_prorating_format VARCHAR2(30) := 'S';
8: -- S Start date, E End date, D (daily) Period.
9: -- Based on plan version.

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

69: g_plan_ver_id_res_class_tbl varchar2_tbl;
70:
71: -- End cbs change
72: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
73: g_module_name VARCHAR2(100) := 'pji.plsql.PJI_FM_PLAN_MAINT_PVT';
74:
75:
76: -- 'P' VARCHAR2(15) := 'P';
77: -- 'G' VARCHAR2(15) := 'G';

Line 171: PJI_FM_PLAN_MAINT_PVT.g_res_class_flag := 'N';

167: FOR i IN l_tmp_plan_version_id.FIRST..l_tmp_plan_version_id.LAST LOOP
168: g_plan_ver_id_res_class_tbl(l_tmp_plan_version_id(i)) := 'N';
169:
170: end loop;
171: PJI_FM_PLAN_MAINT_PVT.g_res_class_flag := 'N';
172: else
173: PJI_FM_PLAN_MAINT_PVT.g_res_class_flag := 'Y';
174: end if;
175:

Line 173: PJI_FM_PLAN_MAINT_PVT.g_res_class_flag := 'Y';

169:
170: end loop;
171: PJI_FM_PLAN_MAINT_PVT.g_res_class_flag := 'N';
172: else
173: PJI_FM_PLAN_MAINT_PVT.g_res_class_flag := 'Y';
174: end if;
175:
176: IF P_PA_DEBUG_MODE = 'Y' THEN
177: pa_debug.write('SET_RES_CLASS_FLAG: ' || g_module_name,'g_res_class_flag '||PJI_FM_PLAN_MAINT_PVT.g_res_class_flag ,1);

Line 177: pa_debug.write('SET_RES_CLASS_FLAG: ' || g_module_name,'g_res_class_flag '||PJI_FM_PLAN_MAINT_PVT.g_res_class_flag ,1);

173: PJI_FM_PLAN_MAINT_PVT.g_res_class_flag := 'Y';
174: end if;
175:
176: IF P_PA_DEBUG_MODE = 'Y' THEN
177: pa_debug.write('SET_RES_CLASS_FLAG: ' || g_module_name,'g_res_class_flag '||PJI_FM_PLAN_MAINT_PVT.g_res_class_flag ,1);
178: END IF;
179: END;
180:
181: function GET_RES_CLASS_FLAG

Line 4610: , 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',

4606: , NVL(ver.rbs_struct_version_id, -1) rbs_struct_version_id
4607: , ver.plan_type_id plan_type_id
4608: , ra.rate_based_flag billable_flag
4609: -- cbs change
4610: , 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',
4611: '1'||ra.resource_class_code, ra.resource_class_code),ra.resource_class_code) resource_class
4612: -- End cbs change
4613: , bl.txn_currency_code txn_currency_code
4614: , bl.txn_raw_cost txn_raw_cost

Line 5213: , 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',

5209: , NVL(ver.rbs_struct_version_id, -1) rbs_struct_version_id
5210: , ver.plan_type_id plan_type_id
5211: , ra.rate_based_flag billable_flag
5212: -- cbs change
5213: , 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',
5214: '1'||ra.resource_class_code, ra.resource_class_code),ra.resource_class_code) resource_class
5215: -- End cbs change
5216: , bl.txn_currency_code txn_currency_code
5217: , bl.txn_raw_cost txn_raw_cost

Line 9351: , 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',

9347: , NVL(ver.rbs_struct_version_id, -1) rbs_struct_version_id -- !! changed.
9348: , ver.plan_type_id plan_type_id
9349: , ra.rate_based_flag billable_flag
9350: -- cbs change
9351: , 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',
9352: '1'||ra.resource_class_code, ra.resource_class_code),ra.resource_class_code) resource_class
9353: -- End cbs change
9354: , DECODE(ver.time_phased_type_code
9355: , g_pa_cal_str, 32

Line 9663: , 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',

9659: , NVL(ver.rbs_struct_version_id, -1) rbs_struct_version_id -- !! changed.
9660: , ver.plan_type_id plan_type_id
9661: , ra.rate_based_flag billable_flag
9662: -- cbs change
9663: , 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',
9664: '1'||ra.resource_class_code, ra.resource_class_code),ra.resource_class_code) resource_class
9665: -- End cbs change
9666: , DECODE(ver.time_phased_type_code
9667: , g_pa_cal_str, 32

Line 10540: , 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',

10536: , NVL(ver.rbs_struct_version_id, -1) rbs_struct_version_id
10537: , ver.plan_type_id plan_type_id
10538: , ra.rate_based_flag billable_flag
10539: -- cbs change
10540: , 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',
10541: '1'||ra.resource_class_code, ra.resource_class_code),ra.resource_class_code) resource_class
10542: -- End cbs change
10543: , DECODE(ver.time_phased_type_code
10544: , g_pa_cal_str, 32

Line 10842: , 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',

10838: , NVL(ver.rbs_struct_version_id, -1) rbs_struct_version_id
10839: , ver.plan_type_id plan_type_id
10840: , ra.rate_based_flag billable_flag
10841: -- cbs change
10842: , 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',
10843: '1'||ra.resource_class_code, ra.resource_class_code),ra.resource_class_code) resource_class
10844: -- End cbs change
10845: , 2048 period_type_id
10846: , g_all CALENDAR_TYPE

Line 11732: , 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',

11728: , NVL(ver.rbs_struct_version_id, -1) rbs_struct_version_id
11729: , ver.plan_type_id plan_type_id
11730: , ra.rate_based_flag billable_flag
11731: -- cbs change
11732: , 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',
11733: '1'||ra.resource_class_code, ra.resource_class_code),ra.resource_class_code) resource_class
11734: -- End cbs change
11735: , bl.txn_currency_code txn_currency_code
11736: , TO_NUMBER(NULL) txn_raw_cost

Line 12324: , 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',

12320: , NVL(ver.rbs_struct_version_id, -1) rbs_struct_version_id
12321: , bl.plan_type_id plan_type_id -- ver.plan_type_id
12322: , bl.rate_based_flag billable_flag -- ra.rate_based_flag billable_flag
12323: -- cbs change
12324: , 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',
12325: '1'||bl.resource_class_code, bl.resource_class_code),bl.resource_class_code) resource_class
12326: -- End cbs change
12327: , bl.txn_currency_code txn_currency_code
12328: , TO_NUMBER(NULL) txn_raw_cost -- bl.txn_raw_cost

Line 13176: PJI_FM_PLAN_MAINT_PVT.INSERT_INTO_FP_FACTS;

13172: END IF;
13173:
13174: END LOOP;
13175:
13176: PJI_FM_PLAN_MAINT_PVT.INSERT_INTO_FP_FACTS;
13177:
13178: -- Put the indexes back
13179: FOR ind_lp IN (SELECT table_owner||'.'||index_name ind_name
13180: , partitioned

Line 14026: END PJI_FM_PLAN_MAINT_PVT;

14022: BEGIN -- this portion is executed WHENever the package is initialized
14023:
14024: g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
14025:
14026: END PJI_FM_PLAN_MAINT_PVT;