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_DELIVERABLE_UTILS dependencies on PA_OBJECT_RELATIONSHIPS

Line 105: -- then that relationship will be present in the PA_OBJECT_RELATIONSHIPS table

101: -- SubProgram : IS_DLV_TYPE_ACTIONS_EXISTS
102: -- Type : UTIL FUNCTION
103: -- Purpose : This function will check whether actions exist for the Deliverable Type
104: -- Note : If there are any actions by defaultly defined for a deliverable type,
105: -- then that relationship will be present in the PA_OBJECT_RELATIONSHIPS table
106: -- The relationship is defined by the relationship_type 'A'
107: -- and the subtype is 'DLVR_TYPE_TO_ACTION'
108: -- Assumptions : None
109: -- Parameter IN/OUT Type Required Description and Purpose

Line 126: --TO any of the deliverable actions of object_type 'PA_ACTIONS' in the PA_OBJECT_RELATIONSHIPS table

122:
123: --The cursor c_dlv_type_action_exists returns 'X' at the first hit
124: --If there exists a relationship 'DLVR_TYPE_TO_ACTION'
125: --FROM the passed p_deliverable_type_id of object_type 'PA_DLVR_TYPES'
126: --TO any of the deliverable actions of object_type 'PA_ACTIONS' in the PA_OBJECT_RELATIONSHIPS table
127: --Note : The relationship is defined by the relationship_type 'A'
128:
129: CURSOR c_dlv_type_action_exists IS
130: SELECT 'X'

Line 133: FROM PA_OBJECT_RELATIONSHIPS obj

129: CURSOR c_dlv_type_action_exists IS
130: SELECT 'X'
131: FROM DUAL
132: WHERE EXISTS (SELECT 'X'
133: FROM PA_OBJECT_RELATIONSHIPS obj
134: WHERE obj.object_id_from2 = p_deliverable_type_id
135: AND obj.object_type_from = 'PA_DLVR_TYPES'
136: AND obj.relationship_subtype = 'DLVR_TYPE_TO_ACTION'
137: AND obj.relationship_type = 'A'

Line 160: -- then that relationship will be present in the PA_OBJECT_RELATIONSHIPS table

156: -- Purpose : This function will check whether
157: -- there exists a deliverable of type p_deliverable_type_id
158: -- which is associated with actions
159: -- Note : If there are any actions are defined for a deliverable,
160: -- then that relationship will be present in the PA_OBJECT_RELATIONSHIPS table
161: -- The relationship is defined by the relationship_type 'A'
162: -- and the subtype is 'DELIVERABLE_TO_ACTION'
163: -- Assumptions : None
164: -- Parameter IN/OUT Type Required Description and Purpose

Line 190: FROM PA_OBJECT_RELATIONSHIPS obj,

186: CURSOR c_dlv_action_exists IS
187: SELECT 'X'
188: FROM DUAL
189: WHERE EXISTS (SELECT 'X'
190: FROM PA_OBJECT_RELATIONSHIPS obj,
191: PA_PROJ_ELEMENTS ppe
192: where ppe.type_id = p_deliverable_type_id
193: and ppe.object_type='PA_DELIVERABLES'
194: and ppe.proj_element_id = obj.object_id_from2

Line 222: -- in the PA_OBJECT_RELATIONSHIPS table with the relationship_type defined by 'A'

218: -- there exists a deliverable of type p_deliverable_type_id
219: -- has been associated with a Deliverable-based task
220: -- Note : 1) If a deliverable has been associated with a task
221: -- then an entry corresponding to its association with the task can be found
222: -- in the PA_OBJECT_RELATIONSHIPS table with the relationship_type defined by 'A'
223: -- and relationship_sub_type 'TASK_TO_DELIVERABLE'
224: -- 2)If a task is deliverable then
225: -- the progress rollup method of the task is "Deliverable-based" .This can be found
226: -- from the PA_PROJ_ELEMENTS table.

Line 254: FROM PA_OBJECT_RELATIONSHIPS obj,

250: CURSOR c_dlv_based_task_exists IS
251: SELECT 'X'
252: FROM DUAL
253: WHERE EXISTS (SELECT 'X'
254: FROM PA_OBJECT_RELATIONSHIPS obj,
255: PA_PROJ_ELEMENTS ppe1,
256: PA_PROJ_ELEMENTS ppe2
257: where ppe1.type_id = p_deliverable_type_id
258: and ppe1.object_type= 'PA_DELIVERABLES'

Line 341: PA_OBJECT_RELATIONSHIPS obj

337:
338: CURSOR c_associated_tasks IS
339: SELECT ppe. name||'('|| ppe.element_number||')' name_number
340: FROM PA_PROJ_ELEMENTS ppe ,
341: PA_OBJECT_RELATIONSHIPS obj
342: WHERE ppe.object_type='PA_TASKS'
343: AND ppe.proj_element_id = OBJ.object_id_from2
344: AND OBJ.object_id_to2 =p_deliverable_id
345: AND OBJ.object_type_to = 'PA_DELIVERABLES'

Line 440: FROM pa_object_relationships obj

436: CURSOR ship_procure_flag_dlv IS
437: SELECT 'Y'
438: FROM dual
439: WHERE EXISTS ( SELECT 'Y'
440: FROM pa_object_relationships obj
441: ,pa_proj_element_versions ver
442: WHERE obj.object_id_from2 = p_dlvr_item_id
443: AND obj.object_type_to = 'PA_ACTIONS'
444: AND obj.object_type_from = 'PA_DELIVERABLES'

Line 551: from pa_object_relationships

547: CURSOR C IS
548: SELECT 'Y'
549: FROM dual
550: WHERE EXISTS (SELECT 'X'
551: from pa_object_relationships
552: where object_id_to2 = p_dlvr_item_id
553: and object_type_from = 'PA_ASSIGNMENTS'
554: and object_type_to = 'PA_DELIVERABELS'
555: and relationship_type = 'A'

Line 604: FROM pa_object_relationships obj

600: CURSOR c_ship_procure_flag_dlv IS
601: SELECT 'Y'
602: FROM dual
603: WHERE EXISTS ( SELECT 'Y'
604: FROM pa_object_relationships obj
605: ,pa_proj_element_versions ver
606: WHERE obj.object_id_from2 = p_dlvr_item_id
607: AND obj.object_type_to = 'PA_ACTIONS'
608: AND obj.object_type_from = 'PA_DELIVERABLES'

Line 634: FROM pa_object_relationships obj

630: CURSOR c_complete_dlv_check IS
631: SELECT 'Y'
632: FROM dual
633: WHERE EXISTS ( SELECT 'Y'
634: FROM pa_object_relationships obj
635: ,pa_proj_element_versions ver
636: WHERE
637: obj.object_id_from2 = p_dlvr_item_id
638: AND obj.object_type_to = 'PA_ACTIONS'

Line 663: FROM pa_object_relationships obj

659: CURSOR c_complete_dlv_bill_check IS
660: SELECT 'Y'
661: FROM dual
662: WHERE EXISTS ( SELECT 'Y'
663: FROM pa_object_relationships obj
664: ,pa_proj_element_versions ver
665: WHERE
666: obj.object_id_from2 = p_dlvr_item_id
667: AND obj.object_type_to = 'PA_ACTIONS'

Line 1245: PA_OBJECT_RELATIONSHIPS

1241: (
1242: SELECT
1243: OBJECT_RELATIONSHIP_ID
1244: FROM
1245: PA_OBJECT_RELATIONSHIPS
1246: WHERE
1247: OBJECT_ID_FROM2 = p_proj_element_id
1248: AND RELATIONSHIP_SUBTYPE = l_relationship_type
1249: AND RELATIONSHIP_TYPE = 'A'

Line 1305: PA_OBJECT_RELATIONSHIPS POR

1301: (
1302: SELECT
1303: PPE.PROJ_ELEMENT_ID
1304: FROM
1305: PA_OBJECT_RELATIONSHIPS POR
1306: ,PA_PROJ_ELEMENTS PPE
1307: WHERE
1308: POR.OBJECT_ID_FROM2 = p_proj_element_id
1309: AND PPE.PROJ_ELEMENT_ID = POR.OBJECT_ID_TO2

Line 2189: FROM PA_OBJECT_RELATIONSHIPS obj,

2185: /*CURSOR c_dlv_based_task_exists IS
2186: SELECT 'X'
2187: FROM DUAL
2188: WHERE EXISTS (SELECT 'X'
2189: FROM PA_OBJECT_RELATIONSHIPS obj,
2190: PA_PROJ_ELEMENTS ppe
2191: where ppe.proj_element_id = p_dlv_element_id
2192: and ppe.object_type= 'PA_DELIVERABLES'
2193: and obj.object_id_to2 = ppe.proj_element_id

Line 2205: FROM PA_OBJECT_RELATIONSHIPS obj,

2201: CURSOR c_dlv_based_task_exists IS
2202: SELECT 'X'
2203: FROM DUAL
2204: WHERE EXISTS (SELECT 'X'
2205: FROM PA_OBJECT_RELATIONSHIPS obj,
2206: pa_proj_elements ppe,
2207: pa_task_types ptt
2208: where obj.object_id_to2 = p_dlv_element_id
2209: and obj.object_type_from = 'PA_TASKS'

Line 2243: FROM pa_object_relationships obj

2239: CURSOR ship_flag_dlv IS
2240: SELECT 'Y'
2241: FROM dual
2242: WHERE EXISTS ( SELECT 'Y'
2243: FROM pa_object_relationships obj
2244: ,pa_proj_element_versions ver
2245: WHERE obj.object_id_from2 = p_dlv_element_id
2246: AND obj.object_type_to = 'PA_ACTIONS'
2247: AND obj.object_type_from = 'PA_DELIVERABLES'

Line 2277: FROM pa_object_relationships obj

2273: CURSOR proc_flag_dlv IS
2274: SELECT 'Y'
2275: FROM dual
2276: WHERE EXISTS ( SELECT 'Y'
2277: FROM pa_object_relationships obj
2278: ,pa_proj_element_versions ver
2279: WHERE obj.object_id_from2 = p_dlv_element_id
2280: AND obj.object_type_to = 'PA_ACTIONS'
2281: AND obj.object_type_from = 'PA_DELIVERABLES'

Line 2313: FROM pa_object_relationships obj

2309: CURSOR c_prog_enabled_dlv_exists IS
2310: SELECT 'Y'
2311: FROM dual
2312: WHERE EXISTS ( SELECT 'Y'
2313: FROM pa_object_relationships obj
2314: ,pa_proj_elements ppe
2315: ,pa_task_types ptt
2316: WHERE obj.object_id_from2 = p_proj_element_id
2317: AND obj.object_type_to = 'PA_DELIVERABLES'

Line 2448: ,pa_object_relationships obj

2444: IS
2445: CURSOR c_dlv_desc IS
2446: SELECT ppe.description
2447: FROM pa_proj_elements ppe
2448: ,pa_object_relationships obj
2449: ,pa_proj_element_versions pev
2450: WHERE pev.element_version_id = p_action_ver_id
2451: AND pev.object_type = 'PA_ACTIONS' /*Included this clause for Performance fix Bug # 3614361 */
2452: AND pev.proj_element_id = obj.object_id_to2

Line 2512: ,pa_object_relationships obj

2508: SELECT 'Y'
2509: FROM dual
2510: WHERE EXISTS (SELECT 'Y'
2511: FROM pa_proj_elements ppe
2512: ,pa_object_relationships obj
2513: ,pa_proj_element_versions pev
2514: ,pa_task_types ptt
2515: WHERE pev.element_version_id = p_action_ver_id
2516: AND pev.proj_element_id = obj.object_id_to2

Line 2878: pa_object_relationships obj1,

2874: WHERE EXISTS(
2875: SELECT 1
2876: FROM pa_proj_elements ppe,
2877: pa_proj_element_versions ppv,
2878: pa_object_relationships obj1,
2879: pa_object_relationships obj2
2880: WHERE ppe.proj_element_id=p_task_id
2881: AND ppe.object_type='PA_TASKS'
2882: AND obj1.relationship_type='A'

Line 2879: pa_object_relationships obj2

2875: SELECT 1
2876: FROM pa_proj_elements ppe,
2877: pa_proj_element_versions ppv,
2878: pa_object_relationships obj1,
2879: pa_object_relationships obj2
2880: WHERE ppe.proj_element_id=p_task_id
2881: AND ppe.object_type='PA_TASKS'
2882: AND obj1.relationship_type='A'
2883: AND obj1.relationship_subtype='TASK_TO_DELIVERABLE'

Line 2901: pa_object_relationships obj

2897: );
2898: CURSOR cur_get_assoc_dlvr IS
2899: SELECT proj_element_id
2900: FROM pa_proj_elements ppe,
2901: pa_object_relationships obj
2902: WHERE obj.relationship_type='A'
2903: AND obj.relationship_subtype='TASK_TO_DELIVERABLE'
2904: AND obj.object_id_from2=p_task_id
2905: AND obj.object_type_from='PA_TASKS'

Line 3012: pa_object_relationships obj1,

3008: WHERE EXISTS(
3009: SELECT 1
3010: FROM pa_proj_elements ppe,
3011: pa_proj_element_versions ppv,
3012: pa_object_relationships obj1,
3013: pa_object_relationships obj2
3014: WHERE ppe.proj_element_id=p_wp_task_version_id
3015: AND ppe.object_type='PA_TASKS'
3016: AND obj1.relationship_type='A'

Line 3013: pa_object_relationships obj2

3009: SELECT 1
3010: FROM pa_proj_elements ppe,
3011: pa_proj_element_versions ppv,
3012: pa_object_relationships obj1,
3013: pa_object_relationships obj2
3014: WHERE ppe.proj_element_id=p_wp_task_version_id
3015: AND ppe.object_type='PA_TASKS'
3016: AND obj1.relationship_type='A'
3017: AND obj1.relationship_subtype='TASK_TO_DELIVERABLE'

Line 3117: pa_object_relationships obj

3113: SELECT 1 FROM dual
3114: WHERE EXISTS(
3115: SELECT ppe.proj_element_id
3116: FROM pa_proj_elements ppe,
3117: pa_object_relationships obj
3118: WHERE obj.relationship_type='A'
3119: AND obj.relationship_subtype='TASK_TO_DELIVERABLE'
3120: AND obj.object_id_from2=p_task_id
3121: AND obj.object_type_from='PA_TASKS'

Line 3133: pa_object_relationships obj,

3129: SELECT 1 FROM dual
3130: WHERE EXISTS(
3131: SELECT 1
3132: FROM pa_proj_elements ppe,
3133: pa_object_relationships obj,
3134: pa_proj_element_versions ppev
3135: WHERE ppe.proj_element_id=p_task_id
3136: AND ppe.object_type='PA_TASKS'
3137: AND obj.relationship_type='A'

Line 3238: pa_object_relationships obj1,

3234: SELECT 1
3235: FROM pa_proj_elements ppe,
3236: pa_proj_elements ppe2,
3237: pa_proj_element_versions ppev,
3238: pa_object_relationships obj1,
3239: pa_object_relationships obj2
3240: WHERE ppe.project_id = p_project_id
3241: AND ppe.object_type = 'PA_ACTIONS'
3242: AND ppev.project_id = p_project_id

Line 3239: pa_object_relationships obj2

3235: FROM pa_proj_elements ppe,
3236: pa_proj_elements ppe2,
3237: pa_proj_element_versions ppev,
3238: pa_object_relationships obj1,
3239: pa_object_relationships obj2
3240: WHERE ppe.project_id = p_project_id
3241: AND ppe.object_type = 'PA_ACTIONS'
3242: AND ppev.project_id = p_project_id
3243: AND ppe.proj_element_id = ppev.proj_element_id

Line 3338: PA_OBJECT_RELATIONSHIPS obj

3334:
3335: CURSOR c_associated_deliverables IS
3336: SELECT ppe. name||'('|| ppe.element_number||')' name_number
3337: FROM PA_PROJ_ELEMENTS ppe ,
3338: PA_OBJECT_RELATIONSHIPS obj
3339: WHERE ppe.object_type='PA_DELIVERABLES'
3340: AND ppe.proj_element_id = OBJ.object_id_to2
3341: AND OBJ.object_id_from2 =p_task_id
3342: AND OBJ.object_type_to = 'PA_DELIVERABLES'

Line 4239: l_dummy pa_object_relationships.object_relationship_Id%TYPE;

4235: p_task_id IN NUMBER
4236: ) RETURN NUMBER
4237: IS
4238:
4239: l_dummy pa_object_relationships.object_relationship_Id%TYPE;
4240:
4241: CURSOR c_dlvr_task_asscn IS
4242: SELECT obj.object_relationship_id
4243: FROM PA_OBJECT_RELATIONSHIPS obj

Line 4243: FROM PA_OBJECT_RELATIONSHIPS obj

4239: l_dummy pa_object_relationships.object_relationship_Id%TYPE;
4240:
4241: CURSOR c_dlvr_task_asscn IS
4242: SELECT obj.object_relationship_id
4243: FROM PA_OBJECT_RELATIONSHIPS obj
4244: WHERE OBJ.object_id_from2 = p_task_id
4245: AND OBJ.object_id_to2 =p_deliverable_id
4246: AND OBJ.object_type_to = 'PA_DELIVERABLES'
4247: AND OBJ.object_type_from = 'PA_TASKS'

Line 4634: pa_object_relationships por

4630: CURSOR l_action_ref_csr
4631: IS
4632: SELECT 'X'
4633: FROM pa_proj_elements ppe,
4634: pa_object_relationships por
4635: WHERE por.object_id_from2 = p_deliverable_id
4636: AND object_id_to2 =ppe.proj_element_id
4637: AND ppe.pm_source_reference = p_action_reference
4638: and project_id = p_project_id

Line 4792: pa_object_relationships por

4788: CURSOR l_action_id_csr
4789: IS
4790: SELECT ppe.proj_element_id
4791: FROM pa_proj_elements ppe,
4792: pa_object_relationships por
4793: WHERE por.object_id_from2 = p_deliverable_id
4794: AND object_id_to2 = ppe.proj_element_id
4795: AND ppe.proj_element_id = p_action_id
4796: and ppe.project_id = p_project_id

Line 4804: pa_object_relationships por

4800: CURSOR l_action_ref_csr
4801: IS
4802: SELECT ppe.proj_element_id
4803: FROM pa_proj_elements ppe,
4804: pa_object_relationships por
4805: WHERE por.object_id_from2 = p_deliverable_id
4806: AND object_id_to2 = ppe.proj_element_id
4807: AND ppe.pm_source_reference = p_action_reference
4808: and ppe.project_id = p_project_id

Line 5307: from pa_object_relationships

5303: SELECT 'Y'
5304: FROM dual
5305: WHERE exists
5306: (Select 'xyz'
5307: from pa_object_relationships
5308: where object_id_from2 = p_str_task_id
5309: and relationship_type = 'A'
5310: and relationship_subtype IN ('STRUCTURE_TO_DELIVERABLE', 'TASK_TO_DELIVERABLE')
5311: );

Line 5359: -- PA_OBJECT_RELATIONSHIPS POR

5355: --cursor c_task_exists(l_struct_ver_id IN NUMBER) IS
5356: -- SELECT
5357: -- PEV.ELEMENT_VERSION_ID
5358: -- FROM
5359: -- PA_OBJECT_RELATIONSHIPS POR
5360: -- ,PA_PROJ_ELEMENT_VERSIONS PEV
5361: -- WHERE
5362: -- POR.OBJECT_ID_FROM1 = l_struct_ver_id
5363: -- AND PEV.PROJ_ELEMENT_ID = p_task_id

Line 5583: ,pa_object_relationships obj1

5579: ,pt.task_number
5580: FROM pa_tasks pt
5581: ,pa_proj_element_versions pev1
5582: ,pa_proj_element_versions pev2
5583: ,pa_object_relationships obj1
5584: ,pa_object_relationships obj2
5585: WHERE obj1.object_id_to2 = p_dlv_element_id
5586: AND obj1.relationship_type = 'A'
5587: AND obj1.relationship_subtype = 'TASK_TO_DELIVERABLE'

Line 5584: ,pa_object_relationships obj2

5580: FROM pa_tasks pt
5581: ,pa_proj_element_versions pev1
5582: ,pa_proj_element_versions pev2
5583: ,pa_object_relationships obj1
5584: ,pa_object_relationships obj2
5585: WHERE obj1.object_id_to2 = p_dlv_element_id
5586: AND obj1.relationship_type = 'A'
5587: AND obj1.relationship_subtype = 'TASK_TO_DELIVERABLE'
5588: AND obj1.object_type_from = 'PA_TASKS'

Line 5608: ,pa_object_relationships obj

5604: ,pt.task_name
5605: ,pt.task_number
5606: FROM pa_tasks pt
5607: ,pa_proj_element_versions pev
5608: ,pa_object_relationships obj
5609: WHERE obj.object_id_to2 = p_dlv_element_id
5610: AND obj.relationship_type = 'A'
5611: AND obj.relationship_subtype = 'TASK_TO_DELIVERABLE'
5612: AND obj.object_type_from = 'PA_TASKS'

Line 5632: ,pa_object_relationships obj1

5628: ,pt1.task_number
5629: FROM pa_tasks pt
5630: ,pa_proj_element_versions pev1
5631: ,pa_proj_element_versions pev2
5632: ,pa_object_relationships obj1
5633: ,pa_object_relationships obj2
5634: ,pa_tasks pt1
5635: WHERE obj1.object_id_to2 = p_dlv_element_id
5636: AND obj1.relationship_type = 'A'

Line 5633: ,pa_object_relationships obj2

5629: FROM pa_tasks pt
5630: ,pa_proj_element_versions pev1
5631: ,pa_proj_element_versions pev2
5632: ,pa_object_relationships obj1
5633: ,pa_object_relationships obj2
5634: ,pa_tasks pt1
5635: WHERE obj1.object_id_to2 = p_dlv_element_id
5636: AND obj1.relationship_type = 'A'
5637: AND obj1.relationship_subtype = 'TASK_TO_DELIVERABLE'

Line 5659: ,pa_object_relationships obj

5655: ,pt1.task_name
5656: ,pt1.task_number
5657: FROM pa_tasks pt
5658: ,pa_proj_element_versions pev
5659: ,pa_object_relationships obj
5660: ,pa_tasks pt1
5661: WHERE obj.object_id_to2 = p_dlv_element_id
5662: AND obj.relationship_type = 'A'
5663: AND obj.relationship_subtype = 'TASK_TO_DELIVERABLE'

Line 5856: FROM pa_object_relationships obj

5852: CURSOR ship_flag_dlv IS
5853: SELECT 'Y'
5854: FROM dual
5855: WHERE EXISTS ( SELECT 'Y'
5856: FROM pa_object_relationships obj
5857: ,pa_proj_element_versions ver
5858: WHERE obj.object_id_from2 = p_dlv_element_id
5859: AND obj.object_type_to = 'PA_ACTIONS'
5860: AND obj.object_type_from = 'PA_DELIVERABLES'

Line 5902: FROM pa_object_relationships obj

5898: CURSOR proc_flag_dlv IS
5899: SELECT 'Y'
5900: FROM dual
5901: WHERE EXISTS ( SELECT 'Y'
5902: FROM pa_object_relationships obj
5903: ,pa_proj_element_versions ver
5904: WHERE obj.object_id_from2 = p_dlv_element_id
5905: AND obj.object_type_to = 'PA_ACTIONS'
5906: AND obj.object_type_from = 'PA_DELIVERABLES'

Line 5948: FROM pa_object_relationships obj

5944: CURSOR bill_flag_dlv IS
5945: SELECT 'Y'
5946: FROM dual
5947: WHERE EXISTS ( SELECT 'Y'
5948: FROM pa_object_relationships obj
5949: ,pa_proj_element_versions ver
5950: WHERE obj.object_id_from2 = p_dlv_element_id
5951: AND obj.object_type_to = 'PA_ACTIONS'
5952: AND obj.object_type_from = 'PA_DELIVERABLES'

Line 6198: pa_object_relationships obj

6194: obj.object_id_to1
6195: ,ppe.name
6196: ,ppevs.scheduled_finish_date
6197: from
6198: pa_object_relationships obj
6199: ,pa_proj_elements ppe
6200: ,pa_proj_elem_ver_schedule ppevs
6201: ,pa_proj_element_versions pev
6202: where

Line 6222: pa_object_relationships obj

6218: obj.object_id_to1
6219: ,ppe.name
6220: ,ppevs.scheduled_finish_date
6221: from
6222: pa_object_relationships obj
6223: ,pa_proj_elements ppe
6224: ,pa_proj_elem_ver_schedule ppevs
6225: ,pa_proj_element_versions pev
6226: where