DBA Data[Home] [Help]

APPS.PA_COST_PLUS dependencies on PA_UTILS2

Line 4169: l_burden_profile := pa_utils2.IsEnhancedBurdeningEnabled;

4165: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
4166: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
4167:
4168: -- l_burden_profile := nvl(fnd_profile.value('PA_ENHANCED_BURDENING'),'N'); /*2933915 */
4169: l_burden_profile := pa_utils2.IsEnhancedBurdeningEnabled;
4170:
4171: IF gms_install.enabled THEN /*3059344 :To check if grants is installed */
4172: l_gms_enabled := 'Y' ;
4173: END IF ;

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

4222: decode(ITEM.cost_ind_compiled_set_id, cs1_row.ind_compiled_set_id,
4223: 'N',ITEM.cost_distributed_flag), ITEM.cost_distributed_flag),
4224: ITEM.revenue_distributed_flag =
4225: decode(ITEM.cost_ind_compiled_set_id, cs1_row.ind_compiled_set_id,
4226: decode(pa_utils2.get_capital_cost_type_code(ITEM.project_id),'B', 'N',ITEM.revenue_distributed_flag)
4227: ,ITEM.revenue_distributed_flag),
4228: ITEM.adjustment_type =
4229: DECODE(ITEM.cost_distributed_flag, 'Y',
4230: decode(ITEM.cost_ind_compiled_set_id, cs1_row.ind_compiled_set_id,

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

4359: , PA_COST_PLUS.CHECK_FOR_EXPLICIT_MULTIPLIER(rate_sch_rev_id ,ICS.ORGANIZATION_ID))
4360: , PA_COST_PLUS.CHECK_FOR_EXPLICIT_MULTIPLIER(rate_sch_rev_id ,ICS.ORGANIZATION_ID ))=0
4361: )
4362: )
4363: AND ((pa_utils2.Proj_Type_Burden_Disp_Method(ITEM.project_id) IN ('S','s','D','d') AND l_burden_profile ='N')
4364: OR (pa_utils2.Proj_Type_Burden_Disp_Method(ITEM.project_id) IN ('S','s') AND l_burden_profile ='Y'))
4365: 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')
4366: BULK COLLECT INTO G_EXPENDITURE_ITEM_ID_TAB,G_ADJ_TYPE_TAB;
4367:

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

4360: , PA_COST_PLUS.CHECK_FOR_EXPLICIT_MULTIPLIER(rate_sch_rev_id ,ICS.ORGANIZATION_ID ))=0
4361: )
4362: )
4363: AND ((pa_utils2.Proj_Type_Burden_Disp_Method(ITEM.project_id) IN ('S','s','D','d') AND l_burden_profile ='N')
4364: OR (pa_utils2.Proj_Type_Burden_Disp_Method(ITEM.project_id) IN ('S','s') AND l_burden_profile ='Y'))
4365: 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')
4366: BULK COLLECT INTO G_EXPENDITURE_ITEM_ID_TAB,G_ADJ_TYPE_TAB;
4367:
4368: stage := 290 ;

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

4436: ,ITEM.cost_distributed_flag),
4437: ******************/
4438: ITEM.revenue_distributed_flag =
4439: decode(ITEM.cost_ind_compiled_set_id, cs1_row.ind_compiled_set_id,
4440: decode(pa_utils2.get_capital_cost_type_code(ITEM.project_id),'B', 'N',ITEM.revenue_distributed_flag)
4441: ,ITEM.revenue_distributed_flag),
4442: ITEM.cc_bl_distributed_code =
4443: decode(ITEM.tp_ind_compiled_set_id, cs1_row.ind_compiled_set_id,
4444: decode(ITEM.cc_cross_charge_code,'B',

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

4556: AND pp.project_type =pt.project_type
4557: AND pt.burden_amt_display_method in ('D','d')
4558: AND nvl(pt.org_id,-99) =nvl(pp.org_id,-99) )
4559: *************************************************************/
4560: AND pa_utils2.Proj_Type_Burden_Disp_Method(ITEM.project_id) IN ('D','d')
4561: 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')
4562: BULK COLLECT INTO G_EXPENDITURE_ITEM_ID_TAB,G_ADJ_TYPE_TAB;
4563:
4564: stage := 300 ;

Line 5207: l_burden_profile := pa_utils2.IsEnhancedBurdeningEnabled;

5203: x_program_application_id := FND_GLOBAL.PROG_APPL_ID;
5204: x_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
5205:
5206: -- l_burden_profile := nvl(fnd_profile.value('PA_ENHANCED_BURDENING'),'N'); /*2933915*/
5207: l_burden_profile := pa_utils2.IsEnhancedBurdeningEnabled;
5208:
5209: IF gms_install.enabled THEN /*3059344 :To check if grants is installed */
5210: l_gms_enabled := 'Y' ;
5211: END IF ;

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

5287: WHERE t.project_id=p.project_id AND
5288: ei.task_id = t.task_id AND
5289: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug 2933915*/
5290: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*2933915*/
5291: AND ((pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s','D','d') AND l_burden_profile ='N') /*Added for 2933915*/
5292: OR (pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s') AND l_burden_profile ='Y'))
5293: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' );
5294:
5295:

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

5288: ei.task_id = t.task_id AND
5289: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug 2933915*/
5290: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*2933915*/
5291: AND ((pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s','D','d') AND l_burden_profile ='N') /*Added for 2933915*/
5292: OR (pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s') AND l_burden_profile ='Y'))
5293: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' );
5294:
5295:
5296: -- consider volume of expenditure items having the same compiled set id

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

5601: ei.task_id = t.task_id AND
5602: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug 2933915*/
5603: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
5604: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' )
5605: AND ((pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s','D','d') AND l_burden_profile ='N') /*Added for 2933915*/
5606: OR (pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s') AND l_burden_profile ='Y')) ;
5607:
5608: COMMIT;
5609:

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

5602: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug 2933915*/
5603: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
5604: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' )
5605: AND ((pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s','D','d') AND l_burden_profile ='N') /*Added for 2933915*/
5606: OR (pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s') AND l_burden_profile ='Y')) ;
5607:
5608: COMMIT;
5609:
5610: if l_gms_enabled = 'Y' then --Bug 5726575

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

6008: WHERE t.project_id=p.project_id AND
6009: ei.task_id = t.task_id AND
6010: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
6011: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
6012: AND ((pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s','D','d') AND l_burden_profile ='N') /*Added for 2933915*/
6013: OR (pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s') AND l_burden_profile ='Y'))
6014: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' ) ;
6015:
6016:

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

6009: ei.task_id = t.task_id AND
6010: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
6011: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
6012: AND ((pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s','D','d') AND l_burden_profile ='N') /*Added for 2933915*/
6013: OR (pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s') AND l_burden_profile ='Y'))
6014: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' ) ;
6015:
6016:
6017: /*2933915 :Added the exists clause in above update to indicate that except profile ='Y' and display_method ='D' -for all cases we will

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

6298: l_start_date AND
6299: NVL(l_end_date, ITEM.expenditure_item_date))
6300: /*E.N. Bug4560630*/
6301: AND l_burden_profile ='Y'
6302: AND pa_utils2.Proj_Type_Burden_Disp_Method(ITEM.project_id) IN ('D','d');
6303:
6304: COMMIT;
6305:
6306: FOR ei14_row IN ei14_cursor LOOP