DBA Data[Home] [Help]

APPS.PJI_FM_PLAN_MAINT_T_PVT dependencies on PJI_FM_PLAN_MAINT_PVT

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 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 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