APPS.PA_CONTROL_API_PVT dependencies on PA_PROJECTS_ALL

Line 1256: from pa_projects_all

1252: is
1253:
1254: cursor get_project_id_frm_num(p_project_number VARCHAR2) is
1255: select project_id
1256: from pa_projects_all
1257: where segment1 = p_project_number;
1258:
1259: cursor get_project_id_frm_name(p_project_name VARCHAR2) is
1260: select project_id

Line 1261: from pa_projects_all

1257: where segment1 = p_project_number;
1258:
1259: cursor get_project_id_frm_name(p_project_name VARCHAR2) is
1260: select project_id
1261: from pa_projects_all
1262: where name = p_project_name;
1263:
1264: cursor validate_prj_id(p_project_id NUMBER) is
1265: select project_id

Line 1266: from pa_projects_all

1262: where name = p_project_name;
1263:
1264: cursor validate_prj_id(p_project_id NUMBER) is
1265: select project_id
1266: from pa_projects_all
1267: where project_id = p_project_id;
1268:
1269: cursor get_ci_type_attrs(p_ci_type_id NUMBER) is
1270: select ci_type_class_code,

Line 1298: l_project_id pa_projects_all.project_id%type;

1294: l_msg_data VARCHAR2(2000);
1295: l_msg_index_out NUMBER;
1296: l_module_name VARCHAR2(200);
1297: l_check_create_ci VARCHAR2(1);
1298: l_project_id pa_projects_all.project_id%type;
1299: l_ini_proj_id pa_projects_all.project_id%type;
1300: l_ini_ci_type_id pa_ci_types_b.ci_type_id%type;
1301: l_any_err_occured_flg VARCHAR2(1);
1302:

Line 1299: l_ini_proj_id pa_projects_all.project_id%type;

1295: l_msg_index_out NUMBER;
1296: l_module_name VARCHAR2(200);
1297: l_check_create_ci VARCHAR2(1);
1298: l_project_id pa_projects_all.project_id%type;
1299: l_ini_proj_id pa_projects_all.project_id%type;
1300: l_ini_ci_type_id pa_ci_types_b.ci_type_id%type;
1301: l_any_err_occured_flg VARCHAR2(1);
1302:
1303: begin

Line 2163: from pa_projects_all

2159: /* if currency_code is null then default it with project currency else validate the passed value*/
2160: if (p_price_currency_code is null) then
2161: select projfunc_currency_code
2162: into l_price_currency_code
2163: from pa_projects_all
2164: where project_id = p_project_id;
2165: else
2166: open validate_prj_currency(p_price_currency_code);
2167: fetch validate_prj_currency into l_price_currency_code;