APPS.PA_PROJECT_INTEGRATION_PUB dependencies on PA_PROJECTS_ALL

Line 199: select org_id from pa_projects_all where project_id = c_project_id;

195: l_msg_count number;
196: l_ou_id number;
197: CURSOR proj_ou_id_csr (c_project_id NUMBER)
198: IS
199: select org_id from pa_projects_all where project_id = c_project_id;
200:
201: -- Added for CBS, it is just a place holder , as Primavera does not support CBS 16598322
202: o_cbs_element_id pa_num_1000_num := PA_num_1000_num(PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM);
203: BEGIN

Line 771: Select 'x' INTO l_plan_in_multi_curr_flag from pa_projects_all where project_id = L_PROJECT_OUT_OBJ.PA_PROJECT_ID

767:
768: if (l_plan_in_multi_curr_flag = 'N') then
769: begin
770:
771: Select 'x' INTO l_plan_in_multi_curr_flag from pa_projects_all where project_id = L_PROJECT_OUT_OBJ.PA_PROJECT_ID
772: and PROJECT_CURRENCY_CODE = gl_currency_code ;
773: log_pvt('MAIN','plan_in_multi_curr_flag 2nd = '||l_plan_in_multi_curr_flag);
774:
775: exception

Line 1718: from pa_projects_all

1714: = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) then
1715:
1716: begin
1717: select project_id into l_create_from_project_id
1718: from pa_projects_all
1719: where segment1 = l_PROJECT_IN_OBJ.created_from_project_number;
1720: exception
1721: when others then
1722: log_pvt('MAIN','raise 5000');

Line 2434: update pa_projects_all a

2430: -- must be updated before calling the update API. Otherwise the API will error out with
2431: -- since it will treat this as new task.
2432:
2433:
2434: update pa_projects_all a
2435: set pm_project_reference = P_PROJECT_IN_REC.pm_project_reference ,
2436: pm_product_code = 'PRIMAVERA'
2437: where project_id = P_PROJECT_IN_REC.pa_project_id;
2438:

Line 2958: from hr_operating_units a , pa_projects_all b

2954: end if;
2955:
2956: select a.name
2957: into X_org_name
2958: from hr_operating_units a , pa_projects_all b
2959: where (
2960: ( ( l_project_id is not null ) and ( l_project_id = b.project_id ) )
2961: or
2962: ( ( l_project_id is null ) and (l_from_project_number = b.segment1 ) )

Line 3175: from pa_integration_settings i1, pa_projects_all p1

3171: l_fin_plan_type_id := null;
3172: l_budget_type := null;
3173: select i1.fin_plan_type_id , i1.budget_type, p1.start_date , p1.completion_date
3174: into l_fin_plan_type_id , l_budget_type, l_start_date , l_end_date
3175: from pa_integration_settings i1, pa_projects_all p1
3176: where i1.project_id = l_budget_in_obj.project_id
3177: and i1.project_id = p1.project_id
3178: and i1.enable_integration = 'Y';
3179: