DBA Data[Home] [Help]

APPS.PA_PROJ_ACCUM_MAIN dependencies on PA_UTILS

Line 223: Pa_Utils.Set_business_group_id ;

219: x_err_code);
220: -- Setting the package variables and global variables so that
221: -- the values can be cached - Performance Phase II changes 594289
222:
223: Pa_Utils.Set_business_group_id ;
224: Pa_Currency.Set_currency_info ;
225:
226:
227: -- Get the information pertaining to the Current PA PERIOD

Line 310: Pa_Proj_Accum_Main.G_PA_Enhanced_Burdening := pa_utils2.IsEnhancedBurdeningEnabled; /*4278940 */

306: -- for incremental burden rows.
307:
308:
309: --Pa_Proj_Accum_Main.G_PA_Enhanced_Burdening := NVL(FND_PROFILE.value('PA_ENHANCED_BURDENING'), 'N');
310: Pa_Proj_Accum_Main.G_PA_Enhanced_Burdening := pa_utils2.IsEnhancedBurdeningEnabled; /*4278940 */
311:
312: IF ( P_DEBUG_MODE = 'Y' )
313: THEN
314: Pa_Debug.debug('proj_accum, Initialize: G_PA_Enhanced_Burdening - '|| Pa_Proj_Accum_Main.G_PA_Enhanced_Burdening );

Line 2164: AND Pa_Utils2.IsProjectInPurgeStatus(ppr.project_status_code) = 'N';

2160: OR
2161: (l_client_extn_mode = 'Y' and exists (Select 1 from PA_PROJ_REFRESH_TMP tmp where tmp.project_id=ppr.project_id))
2162: ) --14090312
2163: AND ppr.project_type = NVL(x_project_type, project_type) -- for bug 2543021
2164: AND Pa_Utils2.IsProjectInPurgeStatus(ppr.project_status_code) = 'N';
2165:
2166: -- cursor for getting the budget_type_code for the given project_id
2167:
2168: CURSOR Get_all_Budget_Types_cur(x_project_id NUMBER) IS

Line 2846: AND Pa_Utils2.IsProjectInPurgeStatus(ppr.project_status_code)= 'N';

2842: pa_projects ppr
2843: WHERE
2844: NVL(ppr.template_flag,'N') <> 'Y'
2845: AND ppr.segment1 BETWEEN l_project_num_from AND l_project_num_to
2846: AND Pa_Utils2.IsProjectInPurgeStatus(ppr.project_status_code)= 'N';
2847:
2848: projrec selprjs%ROWTYPE;
2849: x_tasks_restructured_flag VARCHAR2(1);
2850:

Line 3200: AND Pa_Utils2.IsProjectInPurgeStatus(ppr.project_status_code)= 'N';

3196: pa_projects ppr
3197: WHERE
3198: NVL(ppr.template_flag,'N') <> 'Y'
3199: AND ppr.segment1 BETWEEN l_project_num_from AND l_project_num_to
3200: AND Pa_Utils2.IsProjectInPurgeStatus(ppr.project_status_code)= 'N';
3201:
3202: projrec selprjs%ROWTYPE;
3203: x_mode VARCHAR2(1);
3204: table_index BINARY_INTEGER; -- index for the table for reporting

Line 3950: AND Pa_Utils2.IsProjectInPurgeStatus(ppr.project_status_code) = 'N');

3946: ((ppr.segment1 BETWEEN p_project_num_from AND p_project_num_to) and l_client_extn_mode='N') OR
3947: (l_client_extn_mode = 'Y' and exists (Select 1 from PA_PROJ_REFRESH_TMP tmp where tmp.project_id=ppr.project_id))
3948: ) --14090312
3949: AND ppr.project_type = NVL(p_project_type, project_type)
3950: AND Pa_Utils2.IsProjectInPurgeStatus(ppr.project_status_code) = 'N');
3951: END IF;
3952: -- End for Bug# 7175975
3953:
3954: /* Bug 6408874 */