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_ACTIONS_PVT dependencies on PA_PROJ_ELEMENTS

Line 106: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null

102: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE := null
103: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE
104: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
105: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
106: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
107: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
108: ,p_pm_source_reference_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE() -- added 3435905
109: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null
110: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 107: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null

103: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE
104: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
105: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
106: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
107: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
108: ,p_pm_source_reference_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE() -- added 3435905
109: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null
110: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
111: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 109: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null

105: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
106: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
107: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
108: ,p_pm_source_reference_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE := SYSTEM.PA_VARCHAR2_30_TBL_TYPE() -- added 3435905
109: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null
110: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
111: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
112: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
113: )

Line 159: pa_debug.g_err_stage := 'Bulk inserting into PA_PROJ_ELEMENTS';

155: IF nvl(p_name_tbl.LAST,0)> 0 THEN
156:
157: -- populate the element table
158: IF p_debug_mode = 'Y' THEN
159: pa_debug.g_err_stage := 'Bulk inserting into PA_PROJ_ELEMENTS';
160: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
161: END IF;
162:
163: -- 3574730 : not able to create deliverable, default actions copy is causing the problem

Line 192: INSERT INTO PA_PROJ_ELEMENTS(

188: -- For action level record associated to Deliverable Type
189: -- Project id is populated as null .
190:
191: FORALL i in p_name_tbl.FIRST..p_name_tbl.LAST
192: INSERT INTO PA_PROJ_ELEMENTS(
193: proj_element_id
194: ,project_id
195: ,object_type
196: ,name

Line 521: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null

517: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE := null
518: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null -- 3578694 added default value
519: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
520: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
521: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
522: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
523: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null
524: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
525: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 522: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null

518: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null -- 3578694 added default value
519: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
520: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
521: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
522: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
523: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null
524: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
525: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
526: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 523: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null

519: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
520: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
521: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
522: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
523: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null
524: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
525: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
526: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
527: )

Line 550: -- Following attributes related to PA_PROJ_ELEMENTS

546: FND_MSG_PUB.initialize;
547: END IF;
548:
549: -- Update attributes related to proj element table.
550: -- Following attributes related to PA_PROJ_ELEMENTS
551: -- are updateable from SS page
552: -- 1. Action Name
553: -- 2. Owner
554: -- 3. Function Code

Line 560: UPDATE pa_proj_elements

556: -- 5. Completed Flag , mapped to status column
557: -- 6. DFF Fields
558:
559: FORALL i in p_name_tbl.FIRST..p_name_tbl.LAST
560: UPDATE pa_proj_elements
561: SET name = p_name_tbl(i)
562: ,manager_person_id = p_manager_person_id_tbl(i)
563: ,description = p_description_tbl(i)
564: ,status_code = decode(p_completed_flag_tbl(i),'Y','DLVR_COMPLETED','DLVR_IN_PROGRESS')

Line 729: -- Delete from PA_PROJ_ELEMENTS Table

725: FETCH get_element_id BULK COLLECT INTO l_proj_element_id_tbl,l_obj_relationship_id_tbl ;
726: CLOSE get_element_id ;
727:
728: IF nvl(l_proj_element_id_tbl.LAST,0) > 0 THEN
729: -- Delete from PA_PROJ_ELEMENTS Table
730: FORALL i in l_proj_element_id_tbl.FIRST..l_proj_element_id_tbl.LAST
731: DELETE FROM pa_proj_elements
732: WHERE proj_element_id = l_proj_element_id_tbl(i) ;
733:

Line 731: DELETE FROM pa_proj_elements

727:
728: IF nvl(l_proj_element_id_tbl.LAST,0) > 0 THEN
729: -- Delete from PA_PROJ_ELEMENTS Table
730: FORALL i in l_proj_element_id_tbl.FIRST..l_proj_element_id_tbl.LAST
731: DELETE FROM pa_proj_elements
732: WHERE proj_element_id = l_proj_element_id_tbl(i) ;
733:
734: -- Delete from PA_PROJ_ELEMENT_VERSIONS Table
735: -- Bug 3614361 Including Returning Clause

Line 809: -- Delete the entries from PA_PROJ_ELEMENTS table

805:
806: END IF ;
807:
808:
809: -- Delete the entries from PA_PROJ_ELEMENTS table
810: IF nvl(p_proj_element_id_tbl.LAST,0)>0 THEN
811:
812: IF p_debug_mode = 'Y' THEN
813: pa_debug.g_err_stage:='Delete entries from PA_ELEMENT_VERSIONS table' ;

Line 818: DELETE FROM PA_PROJ_ELEMENTS

814: pa_debug.write('DELETE_DLV_ACTIONS_IN_BULK: ' || g_module_name,pa_debug.g_err_stage,5);
815: END IF;
816:
817: FORALL i in p_proj_element_id_tbl.FIRST..p_proj_element_id_tbl.LAST
818: DELETE FROM PA_PROJ_ELEMENTS
819: WHERE proj_element_id = p_proj_element_id_tbl(i) ;
820:
821: END IF ;
822:

Line 871: ,p_action_id IN pa_proj_elements.proj_element_id%TYPE

867: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
868: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
869: ,p_debug_mode IN VARCHAR2 :='N'
870: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
871: ,p_action_id IN pa_proj_elements.proj_element_id%TYPE
872: ,p_action_ver_id IN pa_proj_element_versions.element_version_id%TYPE
873: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
874: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
875: ,p_function_code IN pa_proj_elements.function_code%TYPE

Line 873: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE

869: ,p_debug_mode IN VARCHAR2 :='N'
870: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
871: ,p_action_id IN pa_proj_elements.proj_element_id%TYPE
872: ,p_action_ver_id IN pa_proj_element_versions.element_version_id%TYPE
873: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
874: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
875: ,p_function_code IN pa_proj_elements.function_code%TYPE
876: ,p_project_id IN pa_projects_all.project_id%TYPE
877: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 875: ,p_function_code IN pa_proj_elements.function_code%TYPE

871: ,p_action_id IN pa_proj_elements.proj_element_id%TYPE
872: ,p_action_ver_id IN pa_proj_element_versions.element_version_id%TYPE
873: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
874: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
875: ,p_function_code IN pa_proj_elements.function_code%TYPE
876: ,p_project_id IN pa_projects_all.project_id%TYPE
877: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
878: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
879: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 887: l_name pa_proj_elements.name%TYPE ;

883: l_msg_count NUMBER ;
884: l_data VARCHAR2(2000);
885: l_msg_data VARCHAR2(2000);
886: l_msg_index_out NUMBER;
887: l_name pa_proj_elements.name%TYPE ;
888: l_function_code pa_proj_elements.function_code%TYPE ;
889:
890: l_dlv_ship_action_rec oke_amg_grp.dlv_ship_action_rec_type;
891: l_dlv_req_action_rec oke_amg_grp.dlv_req_action_rec_type;

Line 888: l_function_code pa_proj_elements.function_code%TYPE ;

884: l_data VARCHAR2(2000);
885: l_msg_data VARCHAR2(2000);
886: l_msg_index_out NUMBER;
887: l_name pa_proj_elements.name%TYPE ;
888: l_function_code pa_proj_elements.function_code%TYPE ;
889:
890: l_dlv_ship_action_rec oke_amg_grp.dlv_ship_action_rec_type;
891: l_dlv_req_action_rec oke_amg_grp.dlv_req_action_rec_type;
892: l_dlv_ship_action_rec_b oke_amg_grp.dlv_ship_action_rec_type;

Line 899: FROM pa_proj_elements

895: CURSOR c_action_info (c_action_elt_id IN NUMBER )
896: IS
897: SELECT name
898: ,function_code
899: FROM pa_proj_elements
900: WHERE proj_element_id = c_action_elt_id
901: AND object_type = 'PA_ACTIONS';
902:
903: BEGIN

Line 1062: -- Delete from PA_PROJ_ELEMENTS Table

1058: END IF ;
1059:
1060: -- End Bug # 3431156
1061:
1062: -- Delete from PA_PROJ_ELEMENTS Table
1063: DELETE FROM pa_proj_elements
1064: WHERE proj_element_id = p_action_id ;
1065:
1066: -- Delete from PA_PROJ_ELEMENT_VERSIONS Table

Line 1063: DELETE FROM pa_proj_elements

1059:
1060: -- End Bug # 3431156
1061:
1062: -- Delete from PA_PROJ_ELEMENTS Table
1063: DELETE FROM pa_proj_elements
1064: WHERE proj_element_id = p_action_id ;
1065:
1066: -- Delete from PA_PROJ_ELEMENT_VERSIONS Table
1067: DELETE FROM pa_proj_element_versions

Line 1136: ,p_action_id IN pa_proj_elements.proj_element_id%TYPE

1132: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
1133: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
1134: ,p_debug_mode IN VARCHAR2 :='N'
1135: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1136: ,p_action_id IN pa_proj_elements.proj_element_id%TYPE
1137: ,p_action_ver_id IN pa_proj_element_versions.element_version_id%TYPE
1138: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
1139: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
1140: ,p_function_code IN pa_proj_elements.function_code%TYPE

Line 1138: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE

1134: ,p_debug_mode IN VARCHAR2 :='N'
1135: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1136: ,p_action_id IN pa_proj_elements.proj_element_id%TYPE
1137: ,p_action_ver_id IN pa_proj_element_versions.element_version_id%TYPE
1138: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
1139: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
1140: ,p_function_code IN pa_proj_elements.function_code%TYPE
1141: ,p_project_id IN pa_projects_all.project_id%TYPE
1142: ,x_action_del_allowed IN VARCHAR2

Line 1140: ,p_function_code IN pa_proj_elements.function_code%TYPE

1136: ,p_action_id IN pa_proj_elements.proj_element_id%TYPE
1137: ,p_action_ver_id IN pa_proj_element_versions.element_version_id%TYPE
1138: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
1139: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
1140: ,p_function_code IN pa_proj_elements.function_code%TYPE
1141: ,p_project_id IN pa_projects_all.project_id%TYPE
1142: ,x_action_del_allowed IN VARCHAR2
1143: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1144: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 1298: ,p_task_id IN pa_proj_elements.proj_element_id%TYPE := null

1294: ,p_target_object_id IN pa_object_relationships.object_id_from2%TYPE
1295: ,p_target_object_type IN pa_object_relationships.object_type_from%TYPE
1296: ,p_source_project_id IN pa_projects_all.project_id%TYPE
1297: ,p_target_project_id IN pa_projects_all.project_id%TYPE
1298: ,p_task_id IN pa_proj_elements.proj_element_id%TYPE := null
1299: ,p_task_ver_id IN pa_proj_element_versions.element_version_id%TYPE := null
1300: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null
1301: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
1302: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null

Line 1300: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null

1296: ,p_source_project_id IN pa_projects_all.project_id%TYPE
1297: ,p_target_project_id IN pa_projects_all.project_id%TYPE
1298: ,p_task_id IN pa_proj_elements.proj_element_id%TYPE := null
1299: ,p_task_ver_id IN pa_proj_element_versions.element_version_id%TYPE := null
1300: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null
1301: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
1302: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
1303: ,p_calling_mode IN VARCHAR2 := NULL -- Added for bug# 3911050
1304: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1301: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null

1297: ,p_target_project_id IN pa_projects_all.project_id%TYPE
1298: ,p_task_id IN pa_proj_elements.proj_element_id%TYPE := null
1299: ,p_task_ver_id IN pa_proj_element_versions.element_version_id%TYPE := null
1300: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null
1301: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
1302: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
1303: ,p_calling_mode IN VARCHAR2 := NULL -- Added for bug# 3911050
1304: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1305: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 1302: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null

1298: ,p_task_id IN pa_proj_elements.proj_element_id%TYPE := null
1299: ,p_task_ver_id IN pa_proj_element_versions.element_version_id%TYPE := null
1300: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null
1301: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null
1302: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null
1303: ,p_calling_mode IN VARCHAR2 := NULL -- Added for bug# 3911050
1304: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1305: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1306: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1345: FROM pa_proj_elements ppe,

1341: ,ppv.element_version_id --Source Action Version Id -- Included for Bug # 3431156
1342: ,pa_proj_element_versions_s.nextval -- Target Action Version Id -- Included for Bug # 3431156
1343: ,pa_tasks_s.nextval -- Target Action Proj Element Id -- Included for Bug # 3431156
1344: ,null -- record version number
1345: FROM pa_proj_elements ppe,
1346: pa_proj_element_versions ppv,
1347: pa_proj_elem_ver_schedule psc,
1348: pa_object_relationships obj,
1349: pa_projects_all pa,

Line 1394: l_carrying_out_org_id PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE ;

1390: l_attribute13_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE() ;
1391: l_attribute14_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE() ;
1392: l_attribute15_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE() ;
1393:
1394: l_carrying_out_org_id PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE ;
1395: l_object_version_id PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null ; --The target Deliverable version id
1396:
1397: --Start Bug # 3431156
1398: l_source_object_ver_id PA_OBJECT_RELATIONSHIPS.OBJECT_ID_FROM1%TYPE :=null ; --The source Deliverable version id