APPS.PA_CONTROL_API_PVT dependencies on PA_PROJECTS_ALL

Line 1239: from pa_projects_all

1235: is
1236:
1237: cursor get_project_id_frm_num(p_project_number VARCHAR2) is
1238: select project_id
1239: from pa_projects_all
1240: where segment1 = p_project_number;
1241:
1242: cursor get_project_id_frm_name(p_project_name VARCHAR2) is
1243: select project_id

Line 1244: from pa_projects_all

1240: where segment1 = p_project_number;
1241:
1242: cursor get_project_id_frm_name(p_project_name VARCHAR2) is
1243: select project_id
1244: from pa_projects_all
1245: where name = p_project_name;
1246:
1247: cursor validate_prj_id(p_project_id NUMBER) is
1248: select project_id

Line 1249: from pa_projects_all

1245: where name = p_project_name;
1246:
1247: cursor validate_prj_id(p_project_id NUMBER) is
1248: select project_id
1249: from pa_projects_all
1250: where project_id = p_project_id;
1251:
1252: cursor get_ci_type_attrs(p_ci_type_id NUMBER) is
1253: select ci_type_class_code,

Line 1281: l_project_id pa_projects_all.project_id%type;

1277: l_msg_data VARCHAR2(2000);
1278: l_msg_index_out NUMBER;
1279: l_module_name VARCHAR2(200);
1280: l_check_create_ci VARCHAR2(1);
1281: l_project_id pa_projects_all.project_id%type;
1282: l_ini_proj_id pa_projects_all.project_id%type;
1283: l_ini_ci_type_id pa_ci_types_b.ci_type_id%type;
1284: l_any_err_occured_flg VARCHAR2(1);
1285:

Line 1282: l_ini_proj_id pa_projects_all.project_id%type;

1278: l_msg_index_out NUMBER;
1279: l_module_name VARCHAR2(200);
1280: l_check_create_ci VARCHAR2(1);
1281: l_project_id pa_projects_all.project_id%type;
1282: l_ini_proj_id pa_projects_all.project_id%type;
1283: l_ini_ci_type_id pa_ci_types_b.ci_type_id%type;
1284: l_any_err_occured_flg VARCHAR2(1);
1285:
1286: begin

Line 2146: from pa_projects_all

2142: /* if currency_code is null then default it with project currency else validate the passed value*/
2143: if (p_price_currency_code is null) then
2144: select projfunc_currency_code
2145: into l_price_currency_code
2146: from pa_projects_all
2147: where project_id = p_project_id;
2148: else
2149: open validate_prj_currency(p_price_currency_code);
2150: fetch validate_prj_currency into l_price_currency_code;