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 3048: from pa_projects_all ppa

3044: -- Bug # 4329284.
3045:
3046: cursor cur_proj_name (c_project_id NUMBER) is
3047: select ppa.name
3048: from pa_projects_all ppa
3049: where ppa.project_id = c_project_id;
3050:
3051: l_proj_name VARCHAR2(30);
3052: l_prog_name VARCHAR2(30);

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

3443: -- p_calling_module IN VARCHAR2 :='SELF_SERVICE'
3444: -- p_commit IN VARCHAR2 :=FND_API.G_FALSE
3445: -- p_debug_mode IN VARCHAR2 :='N'
3446: -- p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3447: -- p_src_proj_id IN pa_projects_all.project_id%type
3448: -- p_task_ver_id IN pa_proj_element_versions.element_version_id%type
3449: -- p_dest_proj_id IN pa_projects_all.project_id%type
3450: -- p_dest_proj_name IN pa_projects_all.name%type
3451: -- p_comment IN pa_object_relationships.comments%type

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

3445: -- p_debug_mode IN VARCHAR2 :='N'
3446: -- p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3447: -- p_src_proj_id IN pa_projects_all.project_id%type
3448: -- p_task_ver_id IN pa_proj_element_versions.element_version_id%type
3449: -- p_dest_proj_id IN pa_projects_all.project_id%type
3450: -- p_dest_proj_name IN pa_projects_all.name%type
3451: -- p_comment IN pa_object_relationships.comments%type
3452: -- x_return_status OUT VARCHAR2
3453: -- x_msg_count OUT NUMBER

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

3446: -- p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3447: -- p_src_proj_id IN pa_projects_all.project_id%type
3448: -- p_task_ver_id IN pa_proj_element_versions.element_version_id%type
3449: -- p_dest_proj_id IN pa_projects_all.project_id%type
3450: -- p_dest_proj_name IN pa_projects_all.name%type
3451: -- p_comment IN pa_object_relationships.comments%type
3452: -- x_return_status OUT VARCHAR2
3453: -- x_msg_count OUT NUMBER
3454: -- x_msg_data OUT VARCHAR2

Line 3475: p_src_proj_id IN pa_projects_all.project_id%type,

3471: p_calling_module IN VARCHAR2 :='SELF_SERVICE',
3472: p_commit IN VARCHAR2 :=FND_API.G_FALSE,
3473: p_debug_mode IN VARCHAR2 :='N',
3474: p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
3475: p_src_proj_id IN pa_projects_all.project_id%type,
3476: p_task_ver_id IN pa_proj_element_versions.element_version_id%type,
3477: p_dest_proj_id IN pa_projects_all.project_id%type,
3478: p_dest_proj_name IN pa_projects_all.name%type,
3479: p_comment IN pa_object_relationships.comments%type,

Line 3477: p_dest_proj_id IN pa_projects_all.project_id%type,

3473: p_debug_mode IN VARCHAR2 :='N',
3474: p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
3475: p_src_proj_id IN pa_projects_all.project_id%type,
3476: p_task_ver_id IN pa_proj_element_versions.element_version_id%type,
3477: p_dest_proj_id IN pa_projects_all.project_id%type,
3478: p_dest_proj_name IN pa_projects_all.name%type,
3479: p_comment IN pa_object_relationships.comments%type,
3480: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3481: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 3478: p_dest_proj_name IN pa_projects_all.name%type,

3474: p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM,
3475: p_src_proj_id IN pa_projects_all.project_id%type,
3476: p_task_ver_id IN pa_proj_element_versions.element_version_id%type,
3477: p_dest_proj_id IN pa_projects_all.project_id%type,
3478: p_dest_proj_name IN pa_projects_all.name%type,
3479: p_comment IN pa_object_relationships.comments%type,
3480: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3481: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
3482: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 3484: l_src_proj_sharing_code pa_projects_all.structure_sharing_code%type;

3480: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3481: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
3482: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
3483: IS
3484: l_src_proj_sharing_code pa_projects_all.structure_sharing_code%type;
3485: l_dest_proj_sharing_code pa_projects_all.structure_sharing_code%type;
3486: --
3487: l_src_struc_elem_id pa_proj_elements.proj_element_id%type;
3488: l_src_struc_elem_ver_id pa_proj_element_versions.element_version_id%type;

Line 3485: l_dest_proj_sharing_code pa_projects_all.structure_sharing_code%type;

3481: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
3482: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
3483: IS
3484: l_src_proj_sharing_code pa_projects_all.structure_sharing_code%type;
3485: l_dest_proj_sharing_code pa_projects_all.structure_sharing_code%type;
3486: --
3487: l_src_struc_elem_id pa_proj_elements.proj_element_id%type;
3488: l_src_struc_elem_ver_id pa_proj_element_versions.element_version_id%type;
3489: l_src_task_elem_id pa_proj_elements.proj_element_id%type;

Line 3525: , pa_projects_all prj

3521: , sob.period_set_name gl_period_set_name
3522: , sob.accounted_period_type
3523: FROM
3524: pa_implementations_all imp
3525: , pa_projects_all prj
3526: , gl_sets_of_books sob
3527: WHERE 1=1
3528: AND prj.org_id = imp.org_id --MOAC Changes: Bug 4363092: removed nvl usage with org_id
3529: AND prj.project_id = cp_project_id

Line 3546: from pa_projects_all ppa

3542: -- Bug # 4329284.
3543:
3544: cursor cur_proj_name (c_project_id NUMBER) is
3545: select ppa.name
3546: from pa_projects_all ppa
3547: where ppa.project_id = c_project_id;
3548:
3549: cursor cur_task_name (c_task_ver_id NUMBER) is
3550: select ppe.name

Line 4463: l_src_proj_id pa_projects_all.project_id%type;

4459: -- Input parameters for this API are
4460: -- object_relationship_id= p_object_relationships_id
4461: l_src_lnk_task_ver_id pa_proj_element_versions.element_version_id%type;
4462: l_dest_str_ver_id pa_proj_element_versions.element_version_id%type;
4463: l_src_proj_id pa_projects_all.project_id%type;
4464: l_dest_proj_id pa_projects_all.project_id%type;
4465: l_src_task_ver_id pa_proj_element_versions.element_version_id%type;
4466: l_task_version_rvn NUMBER;
4467: l_upd_prog_grp_status NUMBER:=0;

Line 4464: l_dest_proj_id pa_projects_all.project_id%type;

4460: -- object_relationship_id= p_object_relationships_id
4461: l_src_lnk_task_ver_id pa_proj_element_versions.element_version_id%type;
4462: l_dest_str_ver_id pa_proj_element_versions.element_version_id%type;
4463: l_src_proj_id pa_projects_all.project_id%type;
4464: l_dest_proj_id pa_projects_all.project_id%type;
4465: l_src_task_ver_id pa_proj_element_versions.element_version_id%type;
4466: l_task_version_rvn NUMBER;
4467: l_upd_prog_grp_status NUMBER:=0;
4468: --

Line 5198: from pa_projects_all ppa

5194: -- Bug # 4329284.
5195:
5196: cursor cur_proj_name (c_project_id NUMBER) is
5197: select ppa.name
5198: from pa_projects_all ppa
5199: where ppa.project_id = c_project_id;
5200:
5201: l_proj_name VARCHAR2(30);
5202: l_prog_name VARCHAR2(30);