DBA Data[Home] [Help]

APPS.PA_PROJ_ACCUM_MAIN dependencies on PA_CLIENT_EXTN_PROJ_LIMIT

Line 2144: tmp_table pa_client_extn_proj_limit.proj_list; --14090312

2140: l_project_num_from VARCHAR2(25);
2141: l_project_num_to VARCHAR2(25);
2142: l_project_id NUMBER;
2143: tmp_budget_type_code VARCHAR2(30) ;
2144: tmp_table pa_client_extn_proj_limit.proj_list; --14090312
2145: -- Declare cursor for Projects
2146:
2147: CURSOR selprjs IS
2148: SELECT

Line 2200: l_client_extn_mode := pa_client_extn_proj_limit.client_extn_enabled; --14090312

2196: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */
2197: Pa_Debug.debug('proj_refresh: ' || x_err_stack);
2198: END IF;
2199:
2200: l_client_extn_mode := pa_client_extn_proj_limit.client_extn_enabled; --14090312
2201: -- Grants Management Integrated Commitment Processing ---------------------
2202: -- added 30-MAY-2003, jwhite
2203:
2204: G_GMS_Enabled := GMS_PA_API3.grants_enabled;

Line 2222: pa_client_extn_proj_limit.populate_project_id_list(tmp_table);

2218: --added below if condition for bug 14090312
2219: if ((l_client_extn_mode='Y') and (x_project_num_from is null) and(x_project_num_to is null))
2220: then
2221:
2222: pa_client_extn_proj_limit.populate_project_id_list(tmp_table);
2223: for i in 1..tmp_table.count loop
2224: insert into PA_PROJ_REFRESH_TMP (project_id) values (tmp_table(i));
2225: end loop;
2226: else

Line 3916: l_client_extn_mode := pa_client_extn_proj_limit.client_extn_enabled ;

3912:
3913: --added below for 14090312
3914: if ( (p_project_num_from is null) and (p_project_num_to is null))
3915: then
3916: l_client_extn_mode := pa_client_extn_proj_limit.client_extn_enabled ;
3917: else
3918: l_client_extn_mode :='N';
3919: end if;
3920: