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.PA_ALLOC_RUN dependencies on PA_PROJECT_STUS_UTILS

Line 791: AND (pa_project_stus_utils.is_project_closed( p_project_id )= 'N');

787: AND nvl(pt.chargeable_flag, 'N') = 'Y'
788: AND ( trunc(p_expnd_item_date) BETWEEN trunc(nvl(pt.start_date,p_expnd_item_date))
789: AND trunc(NVL(pt.completion_date, p_expnd_item_date)) )
790: AND ( pa_project_utils.check_project_action_allowed( p_project_id, 'NEW_TXNS') = 'Y')
791: AND (pa_project_stus_utils.is_project_closed( p_project_id )= 'N');
792: CURSOR C_exptype_exists(p_exp_type IN VARCHAR2) IS
793: SELECT 1
794: FROM pa_expenditure_types
795: WHERE expenditure_type = p_exp_type

Line 1225: --l_where_str1 := ' pa_project_stus_utils.is_project_status_closed(pp.project_status_code)=''N''' ; commented as part of the bug 13949738

1221: l_from_str1 := ' From pa_project_classes pc, pa_tasks pt, pa_projects pp' ;
1222: l_from_str2 := ' From pa_tasks pt, pa_projects pp' ;
1223: l_pc_pp_str := ' pp.project_id = pc.project_id ' ;
1224: l_where_str0 := ' where pp.project_id = pt.project_id AND ' ;
1225: --l_where_str1 := ' pa_project_stus_utils.is_project_status_closed(pp.project_status_code)=''N''' ; commented as part of the bug 13949738
1226: l_where_str2 := ' pa_task_utils.check_child_exists(pt.task_id)=0' ;
1227: IF p_project_org_id is NOT NULL THEN
1228: l_where_str0 := l_where_str0 || l_proj_org_str || ' AND ' ;
1229: -- l_where_str0 := l_where_str0 || l_proj_org_str ;

Line 1978: l_where_str1 := ' pa_project_stus_utils.is_project_status_closed(pp.project_status_code)=''N'' '||

1974: l_where_str0 := l_where_str0 || 'pcou.business_group_id = pcou.recvr_business_group_id AND ' ;
1975: end if ;
1976: end if ;
1977: l_pc_pp_str := ' pp.project_id = pc.project_id ' ;
1978: l_where_str1 := ' pa_project_stus_utils.is_project_status_closed(pp.project_status_code)=''N'' '||
1979: ' AND pa_project_utils.check_project_action_allowed( pp.project_id, ''NEW_TXNS'') = ''Y'' ' ;
1980: l_where_str2 := ' pt.chargeable_flag= ''Y'' ' ;
1981: IF p_project_org_id is NOT NULL THEN
1982: l_where_str0 := l_where_str0 || l_proj_org_str || ' AND ' ;

Line 7413: AND (pa_project_stus_utils.is_project_closed(project_id ))= 'N'; -- added as part of the bug 13949738

7409: cursor C_get_pool_amount is
7410: select nvl(sum(nvl(eligible_amount,0)),0)
7411: from pa_alloc_run_source_det
7412: where run_id = p_run_id
7413: AND (pa_project_stus_utils.is_project_closed(project_id ))= 'N'; -- added as part of the bug 13949738
7414:
7415: -- Start: added as part of the bug 13949738
7416: cursor C_get_missing_source_amount is
7417: Select * from pa_alloc_run_source_det

Line 7419: AND (pa_project_stus_utils.is_project_closed(project_id ))= 'Y';

7415: -- Start: added as part of the bug 13949738
7416: cursor C_get_missing_source_amount is
7417: Select * from pa_alloc_run_source_det
7418: where run_id = p_run_id
7419: AND (pa_project_stus_utils.is_project_closed(project_id ))= 'Y';
7420:
7421: CURSOR C_get_previous_run_amount
7422: ( p_Fscl_Year IN NUMBER
7423: , p_Qrtr_Num IN NUMBER