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_RELATIONSHIP_PVT dependencies on PA_PROJECTS_ALL

Line 3036: from pa_projects_all ppa

3032: -- Bug # 4329284.
3033:
3034: cursor cur_proj_name (c_project_id NUMBER) is
3035: select ppa.name
3036: from pa_projects_all ppa
3037: where ppa.project_id = c_project_id;
3038:
3039: l_proj_name VARCHAR2(30);
3040: l_prog_name VARCHAR2(30);

Line 3434: -- p_src_proj_id IN pa_projects_all.project_id%type

3430: -- p_calling_module IN VARCHAR2 :='SELF_SERVICE'
3431: -- p_commit IN VARCHAR2 :=FND_API.G_FALSE
3432: -- p_debug_mode IN VARCHAR2 :='N'
3433: -- p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3434: -- p_src_proj_id IN pa_projects_all.project_id%type
3435: -- p_task_ver_id IN pa_proj_element_versions.element_version_id%type
3436: -- p_dest_proj_id IN pa_projects_all.project_id%type
3437: -- p_dest_proj_name IN pa_projects_all.name%type
3438: -- p_comment IN pa_object_relationships.comments%type

Line 3436: -- p_dest_proj_id IN pa_projects_all.project_id%type

3432: -- p_debug_mode IN VARCHAR2 :='N'
3433: -- p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3434: -- p_src_proj_id IN pa_projects_all.project_id%type
3435: -- p_task_ver_id IN pa_proj_element_versions.element_version_id%type
3436: -- p_dest_proj_id IN pa_projects_all.project_id%type
3437: -- p_dest_proj_name IN pa_projects_all.name%type
3438: -- p_comment IN pa_object_relationships.comments%type
3439: -- x_return_status OUT VARCHAR2
3440: -- x_msg_count OUT NUMBER

Line 3437: -- p_dest_proj_name IN pa_projects_all.name%type

3433: -- p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3434: -- p_src_proj_id IN pa_projects_all.project_id%type
3435: -- p_task_ver_id IN pa_proj_element_versions.element_version_id%type
3436: -- p_dest_proj_id IN pa_projects_all.project_id%type
3437: -- p_dest_proj_name IN pa_projects_all.name%type
3438: -- p_comment IN pa_object_relationships.comments%type
3439: -- x_return_status OUT VARCHAR2
3440: -- x_msg_count OUT NUMBER
3441: -- x_msg_data OUT VARCHAR2

Line 3462: p_src_proj_id IN pa_projects_all.project_id%type,

3458: p_calling_module IN VARCHAR2 :='SELF_SERVICE',
3459: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
3460: p_debug_mode IN VARCHAR2 :='N',
3461: p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
3462: p_src_proj_id IN pa_projects_all.project_id%type,
3463: p_task_ver_id IN pa_proj_element_versions.element_version_id%type,
3464: p_dest_proj_id IN pa_projects_all.project_id%type,
3465: p_dest_proj_name IN pa_projects_all.name%type,
3466: p_comment IN pa_object_relationships.comments%type,

Line 3464: p_dest_proj_id IN pa_projects_all.project_id%type,

3460: p_debug_mode IN VARCHAR2 :='N',
3461: p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
3462: p_src_proj_id IN pa_projects_all.project_id%type,
3463: p_task_ver_id IN pa_proj_element_versions.element_version_id%type,
3464: p_dest_proj_id IN pa_projects_all.project_id%type,
3465: p_dest_proj_name IN pa_projects_all.name%type,
3466: p_comment IN pa_object_relationships.comments%type,
3467: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3468: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 3465: p_dest_proj_name IN pa_projects_all.name%type,

3461: p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
3462: p_src_proj_id IN pa_projects_all.project_id%type,
3463: p_task_ver_id IN pa_proj_element_versions.element_version_id%type,
3464: p_dest_proj_id IN pa_projects_all.project_id%type,
3465: p_dest_proj_name IN pa_projects_all.name%type,
3466: p_comment IN pa_object_relationships.comments%type,
3467: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3468: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
3469: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 3471: l_src_proj_sharing_code pa_projects_all.structure_sharing_code%type;

3467: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3468: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
3469: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
3470: IS
3471: l_src_proj_sharing_code pa_projects_all.structure_sharing_code%type;
3472: l_dest_proj_sharing_code pa_projects_all.structure_sharing_code%type;
3473: --
3474: l_src_struc_elem_id pa_proj_elements.proj_element_id%type;
3475: l_src_struc_elem_ver_id pa_proj_element_versions.element_version_id%type;

Line 3472: l_dest_proj_sharing_code pa_projects_all.structure_sharing_code%type;

3468: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
3469: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
3470: IS
3471: l_src_proj_sharing_code pa_projects_all.structure_sharing_code%type;
3472: l_dest_proj_sharing_code pa_projects_all.structure_sharing_code%type;
3473: --
3474: l_src_struc_elem_id pa_proj_elements.proj_element_id%type;
3475: l_src_struc_elem_ver_id pa_proj_element_versions.element_version_id%type;
3476: l_src_task_elem_id pa_proj_elements.proj_element_id%type;

Line 3512: , pa_projects_all prj

3508: , sob.period_set_name gl_period_set_name
3509: , sob.accounted_period_type
3510: FROM
3511: pa_implementations_all imp
3512: , pa_projects_all prj
3513: , gl_sets_of_books sob
3514: WHERE 1=1
3515: AND prj.org_id = imp.org_id --MOAC Changes: Bug 4363092: removed nvl usage with org_id
3516: AND prj.project_id = cp_project_id

Line 3533: from pa_projects_all ppa

3529: -- Bug # 4329284.
3530:
3531: cursor cur_proj_name (c_project_id NUMBER) is
3532: select ppa.name
3533: from pa_projects_all ppa
3534: where ppa.project_id = c_project_id;
3535:
3536: cursor cur_task_name (c_task_ver_id NUMBER) is
3537: select ppe.name

Line 4445: l_src_proj_id pa_projects_all.project_id%type;

4441: -- Input parameters for this API are
4442: -- object_relationship_id= p_object_relationships_id
4443: l_src_lnk_task_ver_id pa_proj_element_versions.element_version_id%type;
4444: l_dest_str_ver_id pa_proj_element_versions.element_version_id%type;
4445: l_src_proj_id pa_projects_all.project_id%type;
4446: l_dest_proj_id pa_projects_all.project_id%type;
4447: l_src_task_ver_id pa_proj_element_versions.element_version_id%type;
4448: l_task_version_rvn NUMBER;
4449: l_upd_prog_grp_status NUMBER:=0;

Line 4446: l_dest_proj_id pa_projects_all.project_id%type;

4442: -- object_relationship_id= p_object_relationships_id
4443: l_src_lnk_task_ver_id pa_proj_element_versions.element_version_id%type;
4444: l_dest_str_ver_id pa_proj_element_versions.element_version_id%type;
4445: l_src_proj_id pa_projects_all.project_id%type;
4446: l_dest_proj_id pa_projects_all.project_id%type;
4447: l_src_task_ver_id pa_proj_element_versions.element_version_id%type;
4448: l_task_version_rvn NUMBER;
4449: l_upd_prog_grp_status NUMBER:=0;
4450: --

Line 5176: from pa_projects_all ppa

5172: -- Bug # 4329284.
5173:
5174: cursor cur_proj_name (c_project_id NUMBER) is
5175: select ppa.name
5176: from pa_projects_all ppa
5177: where ppa.project_id = c_project_id;
5178:
5179: l_proj_name VARCHAR2(30);
5180: l_prog_name VARCHAR2(30);