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_OBJECT_RELATIONSHIPS

Line 103: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE

99: ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
100: ,p_proj_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
101: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
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

Line 104: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null

100: ,p_proj_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
101: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
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

Line 117: l_rel_subtype PA_OBJECT_RELATIONSHIPS.RELATIONSHIP_SUBTYPE%TYPE ;

113: )
114: IS
115: l_proj_element_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
116: l_element_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
117: l_rel_subtype PA_OBJECT_RELATIONSHIPS.RELATIONSHIP_SUBTYPE%TYPE ;
118: l_msg_count NUMBER ;
119: l_data VARCHAR2(2000);
120: l_msg_data VARCHAR2(2000);
121: l_msg_index_out NUMBER;

Line 368: pa_debug.g_err_stage := 'Bulk inserting into PA_OBJECT_RELATIONSHIPS';

364: l_rel_subtype := g_dlvr_to_action ;
365: END IF;
366:
367: IF p_debug_mode = 'Y' THEN
368: pa_debug.g_err_stage := 'Bulk inserting into PA_OBJECT_RELATIONSHIPS';
369: pa_debug.write(g_module_name,pa_debug.g_err_stage,5);
370: END IF;
371:
372: -- populate the object relationships table

Line 374: INSERT INTO PA_OBJECT_RELATIONSHIPS(

370: END IF;
371:
372: -- populate the object relationships table
373: FORALL i in l_proj_element_id_tbl.FIRST..l_proj_element_id_tbl.LAST
374: INSERT INTO PA_OBJECT_RELATIONSHIPS(
375: object_relationship_id
376: ,object_type_from
377: ,object_id_from1
378: ,object_type_to

Line 393: pa_object_relationships_s.nextval

389: ,last_update_login
390: )
391: VALUES
392: (
393: pa_object_relationships_s.nextval
394: ,p_object_type
395: ,p_object_version_id
396: ,g_actions
397: ,l_element_version_id_tbl(i)

Line 518: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null -- 3578694 added default value

514: ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
515: ,p_proj_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
516: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
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

Line 519: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null

515: ,p_proj_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
516: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
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

Line 683: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE

679: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
680: ,p_debug_mode IN VARCHAR2 :='N'
681: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
682: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
683: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE
684: ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
685: ,p_proj_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
686: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
687: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 696: FROM pa_object_relationships

692:
693: CURSOR get_element_id IS
694: SELECT object_id_to2,
695: object_relationship_id
696: FROM pa_object_relationships
697: WHERE object_id_from2 = p_object_id
698: AND object_type_from = p_object_type
699: AND object_type_to = g_actions
700: AND relationship_type = 'A';

Line 758: -- Delete from PA_OBJECT_RELATIONSHIPS table

754: DELETE FROM pa_proj_elem_ver_schedule
755: WHERE element_version_id = l_elem_version_id_tbl(i) ;
756: -- 3614361 End
757:
758: -- Delete from PA_OBJECT_RELATIONSHIPS table
759: FORALL i in l_obj_relationship_id_tbl.FIRST..l_obj_relationship_id_tbl.LAST
760: DELETE FROM PA_OBJECT_RELATIONSHIPS
761: WHERE object_relationship_id = l_obj_relationship_id_tbl(i) ;
762:

Line 760: DELETE FROM PA_OBJECT_RELATIONSHIPS

756: -- 3614361 End
757:
758: -- Delete from PA_OBJECT_RELATIONSHIPS table
759: FORALL i in l_obj_relationship_id_tbl.FIRST..l_obj_relationship_id_tbl.LAST
760: DELETE FROM PA_OBJECT_RELATIONSHIPS
761: WHERE object_relationship_id = l_obj_relationship_id_tbl(i) ;
762:
763: END IF ;
764: END IF ;

Line 766: -- Delete the entries from PA_OBJECT_RELATIONSHIPS table

762:
763: END IF ;
764: END IF ;
765:
766: -- Delete the entries from PA_OBJECT_RELATIONSHIPS table
767: IF nvl(p_proj_element_id_tbl.LAST,0)>0 THEN
768:
769: IF p_debug_mode = 'Y' THEN
770: pa_debug.g_err_stage:='Delete entries from PA_OBJECT_RELATIONSHIPS table' ;

Line 770: pa_debug.g_err_stage:='Delete entries from PA_OBJECT_RELATIONSHIPS table' ;

766: -- Delete the entries from PA_OBJECT_RELATIONSHIPS table
767: IF nvl(p_proj_element_id_tbl.LAST,0)>0 THEN
768:
769: IF p_debug_mode = 'Y' THEN
770: pa_debug.g_err_stage:='Delete entries from PA_OBJECT_RELATIONSHIPS table' ;
771: pa_debug.write('DELETE_DLV_ACTIONS_IN_BULK: ' || g_module_name,pa_debug.g_err_stage,5);
772: END IF;
773:
774: FORALL i in p_proj_element_id_tbl.FIRST..p_proj_element_id_tbl.LAST

Line 775: DELETE FROM PA_OBJECT_RELATIONSHIPS

771: pa_debug.write('DELETE_DLV_ACTIONS_IN_BULK: ' || g_module_name,pa_debug.g_err_stage,5);
772: END IF;
773:
774: FORALL i in p_proj_element_id_tbl.FIRST..p_proj_element_id_tbl.LAST
775: DELETE FROM PA_OBJECT_RELATIONSHIPS
776: WHERE OBJECT_ID_TO2 = p_proj_element_id_tbl(i)
777: AND OBJECT_ID_FROM2 = p_object_id ;
778: END IF ;
779:

Line 1074: -- Delete from PA_OBJECT_RELATIONSHIPS table

1070: -- Delete from PA_PROJ_ELEM_VER_SCHEDULE Table
1071: DELETE FROM pa_proj_elem_ver_schedule
1072: WHERE element_version_id = p_action_ver_id ;
1073:
1074: -- Delete from PA_OBJECT_RELATIONSHIPS table
1075: DELETE FROM PA_OBJECT_RELATIONSHIPS
1076: WHERE object_id_to2 = p_action_id
1077: and object_id_to1 = p_action_ver_id; -- Added condition for perf bug# 3964701
1078:

Line 1075: DELETE FROM PA_OBJECT_RELATIONSHIPS

1071: DELETE FROM pa_proj_elem_ver_schedule
1072: WHERE element_version_id = p_action_ver_id ;
1073:
1074: -- Delete from PA_OBJECT_RELATIONSHIPS table
1075: DELETE FROM PA_OBJECT_RELATIONSHIPS
1076: WHERE object_id_to2 = p_action_id
1077: and object_id_to1 = p_action_ver_id; -- Added condition for perf bug# 3964701
1078:
1079: IF p_debug_mode = 'Y' THEN

Line 1292: ,p_source_object_id IN pa_object_relationships.object_id_from2%TYPE

1288: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
1289: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
1290: ,p_debug_mode IN VARCHAR2 :='N'
1291: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1292: ,p_source_object_id IN pa_object_relationships.object_id_from2%TYPE
1293: ,p_source_object_type IN pa_object_relationships.object_type_from%TYPE
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

Line 1293: ,p_source_object_type IN pa_object_relationships.object_type_from%TYPE

1289: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
1290: ,p_debug_mode IN VARCHAR2 :='N'
1291: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1292: ,p_source_object_id IN pa_object_relationships.object_id_from2%TYPE
1293: ,p_source_object_type IN pa_object_relationships.object_type_from%TYPE
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

Line 1294: ,p_target_object_id IN pa_object_relationships.object_id_from2%TYPE

1290: ,p_debug_mode IN VARCHAR2 :='N'
1291: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1292: ,p_source_object_id IN pa_object_relationships.object_id_from2%TYPE
1293: ,p_source_object_type IN pa_object_relationships.object_type_from%TYPE
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

Line 1295: ,p_target_object_type IN pa_object_relationships.object_type_from%TYPE

1291: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1292: ,p_source_object_id IN pa_object_relationships.object_id_from2%TYPE
1293: ,p_source_object_type IN pa_object_relationships.object_type_from%TYPE
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

Line 1348: pa_object_relationships obj,

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,
1350: pa_project_types_all ppt
1351: WHERE obj.object_id_from2 = p_source_object_id
1352: AND obj.object_type_from = p_source_object_type

Line 1395: l_object_version_id PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null ; --The target Deliverable version id

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
1399: l_source_action_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ; --The Source Action Id

Line 1398: l_source_object_ver_id PA_OBJECT_RELATIONSHIPS.OBJECT_ID_FROM1%TYPE :=null ; --The source Deliverable version id

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
1399: l_source_action_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ; --The Source Action Id
1400: l_source_action_ver_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE(); --The Source Action Version Id
1401: --End --Bug # 3431156
1402: