DBA Data[Home] [Help]

APPS.PA_COST_PLUS dependencies on PA_UTILS2

Line 4199: l_burden_profile := pa_utils2.IsEnhancedBurdeningEnabled;

4195: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
4196: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
4197:
4198: -- l_burden_profile := nvl(fnd_profile.value('PA_ENHANCED_BURDENING'),'N'); /*2933915 */
4199: l_burden_profile := pa_utils2.IsEnhancedBurdeningEnabled;
4200:
4201: IF gms_install.enabled THEN /*3059344 :To check if grants is installed */
4202: l_gms_enabled := 'Y' ;
4203: END IF ;

Line 4256: decode(pa_utils2.get_capital_cost_type_code(ITEM.project_id),'B', 'N',ITEM.revenue_distributed_flag)

4252: decode(ITEM.cost_ind_compiled_set_id, cs1_row.ind_compiled_set_id,
4253: 'N',ITEM.cost_distributed_flag), ITEM.cost_distributed_flag),
4254: ITEM.revenue_distributed_flag =
4255: decode(ITEM.cost_ind_compiled_set_id, cs1_row.ind_compiled_set_id,
4256: decode(pa_utils2.get_capital_cost_type_code(ITEM.project_id),'B', 'N',ITEM.revenue_distributed_flag)
4257: ,ITEM.revenue_distributed_flag),
4258: ITEM.adjustment_type =
4259: DECODE(ITEM.cost_distributed_flag, 'Y',
4260: decode(ITEM.cost_ind_compiled_set_id, cs1_row.ind_compiled_set_id,

Line 4393: AND ((pa_utils2.Proj_Type_Burden_Disp_Method(ITEM.project_id) IN ('S','s','D','d') AND l_burden_profile ='N')

4389: , PA_COST_PLUS.CHECK_FOR_EXPLICIT_MULTIPLIER(rate_sch_rev_id ,ICS.ORGANIZATION_ID))
4390: , PA_COST_PLUS.CHECK_FOR_EXPLICIT_MULTIPLIER(rate_sch_rev_id ,ICS.ORGANIZATION_ID ))=0
4391: )
4392: )
4393: AND ((pa_utils2.Proj_Type_Burden_Disp_Method(ITEM.project_id) IN ('S','s','D','d') AND l_burden_profile ='N')
4394: OR (pa_utils2.Proj_Type_Burden_Disp_Method(ITEM.project_id) IN ('S','s') AND l_burden_profile ='Y'))
4395: RETURNING expenditure_item_id, decode(cs1_row.ind_compiled_set_id,ITEM.tp_ind_compiled_set_id,'UPDATE TP SCHEDULE REVISION','UPDATE COST SCHEDULE REVISION')
4396: BULK COLLECT INTO G_EXPENDITURE_ITEM_ID_TAB,G_ADJ_TYPE_TAB;
4397:

Line 4394: OR (pa_utils2.Proj_Type_Burden_Disp_Method(ITEM.project_id) IN ('S','s') AND l_burden_profile ='Y'))

4390: , PA_COST_PLUS.CHECK_FOR_EXPLICIT_MULTIPLIER(rate_sch_rev_id ,ICS.ORGANIZATION_ID ))=0
4391: )
4392: )
4393: AND ((pa_utils2.Proj_Type_Burden_Disp_Method(ITEM.project_id) IN ('S','s','D','d') AND l_burden_profile ='N')
4394: OR (pa_utils2.Proj_Type_Burden_Disp_Method(ITEM.project_id) IN ('S','s') AND l_burden_profile ='Y'))
4395: RETURNING expenditure_item_id, decode(cs1_row.ind_compiled_set_id,ITEM.tp_ind_compiled_set_id,'UPDATE TP SCHEDULE REVISION','UPDATE COST SCHEDULE REVISION')
4396: BULK COLLECT INTO G_EXPENDITURE_ITEM_ID_TAB,G_ADJ_TYPE_TAB;
4397:
4398: stage := 290 ;

Line 4470: decode(pa_utils2.get_capital_cost_type_code(ITEM.project_id),'B', 'N',ITEM.revenue_distributed_flag)

4466: ,ITEM.cost_distributed_flag),
4467: ******************/
4468: ITEM.revenue_distributed_flag =
4469: decode(ITEM.cost_ind_compiled_set_id, cs1_row.ind_compiled_set_id,
4470: decode(pa_utils2.get_capital_cost_type_code(ITEM.project_id),'B', 'N',ITEM.revenue_distributed_flag)
4471: ,ITEM.revenue_distributed_flag),
4472: ITEM.cc_bl_distributed_code =
4473: decode(ITEM.tp_ind_compiled_set_id, cs1_row.ind_compiled_set_id,
4474: decode(ITEM.cc_cross_charge_code,'B',

Line 4590: AND pa_utils2.Proj_Type_Burden_Disp_Method(ITEM.project_id) IN ('D','d')

4586: AND pp.project_type =pt.project_type
4587: AND pt.burden_amt_display_method in ('D','d')
4588: AND nvl(pt.org_id,-99) =nvl(pp.org_id,-99) )
4589: *************************************************************/
4590: AND pa_utils2.Proj_Type_Burden_Disp_Method(ITEM.project_id) IN ('D','d')
4591: RETURNING expenditure_item_id, decode(cs1_row.ind_compiled_set_id,ITEM.tp_ind_compiled_set_id,'UPDATE TP SCHEDULE REVISION','UPDATE COST SCHEDULE REVISION')
4592: BULK COLLECT INTO G_EXPENDITURE_ITEM_ID_TAB,G_ADJ_TYPE_TAB;
4593:
4594: stage := 300 ;

Line 5237: l_burden_profile := pa_utils2.IsEnhancedBurdeningEnabled;

5233: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
5234: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
5235:
5236: -- l_burden_profile := nvl(fnd_profile.value('PA_ENHANCED_BURDENING'),'N'); /*2933915*/
5237: l_burden_profile := pa_utils2.IsEnhancedBurdeningEnabled;
5238:
5239: IF gms_install.enabled THEN /*3059344 :To check if grants is installed */
5240: l_gms_enabled := 'Y' ;
5241: END IF ;

Line 5321: AND ((pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s','D','d') AND l_burden_profile ='N') /*Added for 2933915*/

5317: WHERE t.project_id=p.project_id AND
5318: ei.task_id = t.task_id AND
5319: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug 2933915*/
5320: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*2933915*/
5321: AND ((pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s','D','d') AND l_burden_profile ='N') /*Added for 2933915*/
5322: OR (pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s') AND l_burden_profile ='Y'))
5323: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' );
5324:
5325:

Line 5322: OR (pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s') AND l_burden_profile ='Y'))

5318: ei.task_id = t.task_id AND
5319: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug 2933915*/
5320: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*2933915*/
5321: AND ((pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s','D','d') AND l_burden_profile ='N') /*Added for 2933915*/
5322: OR (pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s') AND l_burden_profile ='Y'))
5323: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' );
5324:
5325:
5326: -- consider volume of expenditure items having the same compiled set id

Line 5635: AND ((pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s','D','d') AND l_burden_profile ='N') /*Added for 2933915*/

5631: ei.task_id = t.task_id AND
5632: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug 2933915*/
5633: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
5634: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' )
5635: AND ((pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s','D','d') AND l_burden_profile ='N') /*Added for 2933915*/
5636: OR (pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s') AND l_burden_profile ='Y')) ;
5637:
5638: COMMIT;
5639:

Line 5636: OR (pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s') AND l_burden_profile ='Y')) ;

5632: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug 2933915*/
5633: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
5634: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' )
5635: AND ((pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s','D','d') AND l_burden_profile ='N') /*Added for 2933915*/
5636: OR (pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s') AND l_burden_profile ='Y')) ;
5637:
5638: COMMIT;
5639:
5640: if l_gms_enabled = 'Y' then --Bug 5726575

Line 6065: AND pa_utils2.Proj_Type_Burden_Disp_Method(ITEM.project_id) IN ('D','d');

6061: WHERE task.task_id = ITEM.task_id
6062: AND task.cost_ind_sch_fixed_date IS NULL)
6063: /*E.N. Bug4560630*/
6064: AND l_burden_profile ='Y'
6065: AND pa_utils2.Proj_Type_Burden_Disp_Method(ITEM.project_id) IN ('D','d');
6066:
6067: COMMIT;
6068:
6069: /* When fixed date is NOT NULL */

Line 6092: AND pa_utils2.Proj_Type_Burden_Disp_Method(ITEM.project_id) IN ('D','d');

6088: l_start_date AND
6089: NVL(l_end_date, cost_ind_sch_fixed_date))
6090: /*E.N. Bug4560630*/
6091: AND l_burden_profile ='Y'
6092: AND pa_utils2.Proj_Type_Burden_Disp_Method(ITEM.project_id) IN ('D','d');
6093:
6094: COMMIT;
6095:
6096: /* Changes for bug 8282545 end here */

Line 6145: AND ((pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s','D','d') AND l_burden_profile ='N') /*Added for 2933915*/

6141: WHERE t.project_id=p.project_id AND
6142: ei.task_id = t.task_id AND
6143: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
6144: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
6145: AND ((pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s','D','d') AND l_burden_profile ='N') /*Added for 2933915*/
6146: OR (pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s') AND l_burden_profile ='Y'))
6147: AND ( l_gms_enabled = 'N' OR gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' ) ;
6148:
6149: else

Line 6146: OR (pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s') AND l_burden_profile ='Y'))

6142: ei.task_id = t.task_id AND
6143: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
6144: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
6145: AND ((pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s','D','d') AND l_burden_profile ='N') /*Added for 2933915*/
6146: OR (pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s') AND l_burden_profile ='Y'))
6147: AND ( l_gms_enabled = 'N' OR gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' ) ;
6148:
6149: else
6150: UPDATE pa_expenditure_items_all ei

Line 6176: AND ((pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s','D','d') AND l_burden_profile ='N') /*Added for 2933915*/

6172: WHERE t.project_id=p.project_id AND
6173: ei.task_id = t.task_id AND
6174: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
6175: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
6176: AND ((pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s','D','d') AND l_burden_profile ='N') /*Added for 2933915*/
6177: OR (pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s') AND l_burden_profile ='Y'))
6178: AND ( l_gms_enabled = 'N' OR gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' ) ;
6179:
6180: end if;

Line 6177: OR (pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s') AND l_burden_profile ='Y'))

6173: ei.task_id = t.task_id AND
6174: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
6175: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
6176: AND ((pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s','D','d') AND l_burden_profile ='N') /*Added for 2933915*/
6177: OR (pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s') AND l_burden_profile ='Y'))
6178: AND ( l_gms_enabled = 'N' OR gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' ) ;
6179:
6180: end if;
6181:

Line 6529: AND pa_utils2.Proj_Type_Burden_Disp_Method(ITEM.project_id) IN ('D','d');

6525: l_start_date AND
6526: NVL(l_end_date, ITEM.expenditure_item_date))
6527: /*E.N. Bug4560630*/
6528: AND l_burden_profile ='Y'
6529: AND pa_utils2.Proj_Type_Burden_Disp_Method(ITEM.project_id) IN ('D','d');
6530:
6531: COMMIT;
6532:
6533: FOR ei14_row IN ei14_cursor LOOP