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_TASK_TYPES

Line 32: FROM PA_TASK_TYPES

28:
29:
30: CURSOR c_deliverable_type_name_exists IS
31: SELECT 'X'
32: FROM PA_TASK_TYPES
33: WHERE TASK_TYPE = p_deliverable_type_name -- 3946664 removed upper from both the sides
34: AND OBJECT_TYPE='PA_DLVR_TYPES';
35:
36: --The cursor c_deliverable_type_name_exists returns 'X'

Line 62: -- p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE N Deliverable Type Id

58: -- Assumptions : None
59: -- Parameter IN/OUT Type Required Description and Purpose
60: -- --------------------------- ------------ ---------- --------- ---------------------------
61:
62: -- p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE N Deliverable Type Id
63:
64:
65: FUNCTION IS_DLV_TYPE_IN_USE
66: (

Line 67: p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE

63:
64:
65: FUNCTION IS_DLV_TYPE_IN_USE
66: (
67: p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE
68: ) RETURN VARCHAR2
69: IS
70:
71: l_return_status varchar2(1);

Line 112: -- p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE N Deliverable Type Id

108: -- Assumptions : None
109: -- Parameter IN/OUT Type Required Description and Purpose
110: -- --------------------------- ------------ ----------- --------- ---------------------------
111:
112: -- p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE N Deliverable Type Id
113:
114: FUNCTION IS_DLV_TYPE_ACTIONS_EXISTS
115: (
116: p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE

Line 116: p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE

112: -- p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE N Deliverable Type Id
113:
114: FUNCTION IS_DLV_TYPE_ACTIONS_EXISTS
115: (
116: p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE
117: ) RETURN VARCHAR2
118: IS
119:
120: l_return_status varchar2(1);

Line 167: -- p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE N Deliverable Type Id

163: -- Assumptions : None
164: -- Parameter IN/OUT Type Required Description and Purpose
165: -- --------------------------- ------------ ---------- --------- ---------------------------
166:
167: -- p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE N Deliverable Type Id
168:
169: FUNCTION IS_DLV_ACTIONS_EXISTS
170: (
171: p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE

Line 171: p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE

167: -- p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE N Deliverable Type Id
168:
169: FUNCTION IS_DLV_ACTIONS_EXISTS
170: (
171: p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE
172: ) RETURN VARCHAR2
173: IS
174:
175: l_return_status varchar2(1);

Line 231: -- p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE N Deliverable Type Id

227: -- Assumptions : None
228: -- Parameter IN/OUT Type Required Description and Purpose
229: -- --------------------------- ------------ ---------- --------- ---------------------------
230:
231: -- p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE N Deliverable Type Id
232:
233:
234: FUNCTION IS_DLV_BASED_ASSCN_EXISTS
235: (

Line 236: p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE

232:
233:
234: FUNCTION IS_DLV_BASED_ASSCN_EXISTS
235: (
236: p_deliverable_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE
237: ) RETURN VARCHAR2
238: IS
239: l_return_status varchar2(1);
240: l_dummy varchar2(1);

Line 587: ,p_dlv_type_id IN pa_task_types.task_type_id%TYPE

583: PROCEDURE IS_DLV_STATUS_CHANGE_ALLOWED
584: ( p_project_id IN pa_projects_all.project_id%TYPE
585: ,p_dlvr_item_id IN pa_proj_elements.proj_element_id%TYPE
586: ,p_dlvr_version_id IN pa_proj_element_versions.element_version_id%TYPE
587: ,p_dlv_type_id IN pa_task_types.task_type_id%TYPE
588: ,p_dlvr_status_code IN PA_PROJ_ELEMENTS.STATUS_CODE%TYPE
589: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
590: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
591: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 818: p_dlvr_type_id IN pa_task_types.task_type_id%TYPE

814: -- p_dlv_type_id IN NUMBER Y Deliverable type id
815:
816: FUNCTION GET_DLV_TYPE_CLASS_CODE
817: (
818: p_dlvr_type_id IN pa_task_types.task_type_id%TYPE
819: )
820: RETURN VARCHAR2
821: IS
822: CURSOR c_dlv_type_class IS

Line 824: FROM pa_task_types

820: RETURN VARCHAR2
821: IS
822: CURSOR c_dlv_type_class IS
823: SELECT task_type_class_code
824: FROM pa_task_types
825: WHERE task_type_id = p_dlvr_type_id ;
826: l_task_type_class_code pa_task_types.task_type_class_code%TYPE ;
827: BEGIN
828: OPEN c_dlv_type_class ;

Line 826: l_task_type_class_code pa_task_types.task_type_class_code%TYPE ;

822: CURSOR c_dlv_type_class IS
823: SELECT task_type_class_code
824: FROM pa_task_types
825: WHERE task_type_id = p_dlvr_type_id ;
826: l_task_type_class_code pa_task_types.task_type_class_code%TYPE ;
827: BEGIN
828: OPEN c_dlv_type_class ;
829: FETCH c_dlv_type_class INTO l_task_type_class_code ;
830: IF c_dlv_type_class%NOTFOUND THEN

Line 1186: from pa_task_types ptt,

1182:
1183: IF x_base_percent_comp_deriv_code IS NULL THEN
1184: select ptt.base_percent_comp_deriv_code
1185: INTO x_base_percent_comp_deriv_code
1186: from pa_task_types ptt,
1187: pa_proj_elements ppe
1188: where ppe.proj_element_id = p_task_id
1189: and ptt.task_type_id = ppe.type_id ;
1190: END IF;

Line 1399: p_dlvr_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE

1395:
1396:
1397: PROCEDURE GET_DLVR_TYPE_INFO
1398: (
1399: p_dlvr_type_id IN PA_TASK_TYPES.TASK_TYPE_ID%TYPE
1400: ,x_dlvr_prg_enabled OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1401: ,x_dlvr_action_enabled OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1402: ,x_dlvr_default_status_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1403: )

Line 1412: PA_TASK_TYPES ptt

1408: ptt.prog_entry_enable_flag
1409: ,ptt.enable_dlvr_actions_flag
1410: ,ptt.initial_status_code
1411: FROM
1412: PA_TASK_TYPES ptt
1413: WHERE
1414: ptt.task_type_id = p_dlvr_type_id
1415: AND ptt.object_type = 'PA_DLVR_TYPES';
1416:

Line 2207: pa_task_types ptt

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'
2210: and obj.object_type_to = 'PA_DELIVERABLES'
2211: and obj.relationship_subtype = 'TASK_TO_DELIVERABLE'

Line 2315: ,pa_task_types ptt

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'
2318: AND obj.object_type_from = 'PA_TASKS'
2319: AND obj.relationship_type = 'A'

Line 2350: ,pa_task_types ptt

2346: IS
2347: CURSOR c_is_prog_enabled_dlv IS
2348: SELECT 'Y'
2349: FROM pa_proj_elements ppe
2350: ,pa_task_types ptt
2351: WHERE ppe.proj_element_id = p_proj_element_id
2352: AND ppe.object_type = 'PA_DELIVERABLES'
2353: AND ptt.task_type_id = ppe.type_id
2354: AND nvl(ptt.prog_entry_enable_flag,'N') = 'Y'

Line 2514: ,pa_task_types ptt

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
2517: AND obj.relationship_type = 'A'
2518: AND obj.relationship_subtype = 'DELIVERABLE_TO_ACTION'

Line 3566: pa_task_types ptt

3562: CURSOR C IS
3563: SELECT 'Y' FROM DUAL
3564: WHERE EXISTS(SELECT 'Y'
3565: FROM pa_proj_elements ppe,
3566: pa_task_types ptt
3567: WHERE ppe.object_type = 'PA_DELIVERABLES'
3568: AND ppe.type_id = ptt.task_type_id
3569: AND ptt.task_type_class_code = 'ITEM'
3570: AND ptt.object_type = 'PA_DLVR_TYPES'

Line 3654: FROM PA_TASK_TYPES

3650: ) RETURN VARCHAR2
3651: IS
3652: CURSOR c_is_dlvr_item_based IS
3653: SELECT 'Y'
3654: FROM PA_TASK_TYPES
3655: WHERE TASK_TYPE_ID=(SELECT TYPE_ID
3656: FROM PA_PROJ_ELEMENTS PPE,
3657: PA_PROJ_ELEMENT_VERSIONS PEV
3658: WHERE PPE.PROJ_ELEMENT_ID= PEV.PROJ_ELEMENT_ID

Line 3821: , px_status_code IN OUT NOCOPY Pa_task_types.initial_status_code%TYPE --File.Sql.39 bug 4440895

3817: , p_dlvr_owner_name IN VARCHAR2 := NULL
3818: , p_dlvr_type_id IN PA_PROJ_ELEMENTS.TYPE_ID%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3819: , px_actual_finish_date IN OUT NOCOPY DATE --File.Sql.39 bug 4440895
3820: , px_progress_weight IN OUT NOCOPY PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE --File.Sql.39 bug 4440895
3821: , px_status_code IN OUT NOCOPY Pa_task_types.initial_status_code%TYPE --File.Sql.39 bug 4440895
3822: , p_carrying_out_org_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3823: , p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE
3824: , p_task_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
3825: , p_calling_mode IN VARCHAR2 := 'INSERT'

Line 4161: FROM PA_TASK_TYPES

4157: l_dummy varchar2(1);
4158:
4159: CURSOR c_dlvr_type_id_exists IS
4160: SELECT 'X'
4161: FROM PA_TASK_TYPES
4162: WHERE TASK_TYPE_ID = p_deliverable_type_id
4163: AND sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active, sysdate)
4164: AND OBJECT_TYPE='PA_DLVR_TYPES';
4165:

Line 4963: , px_status_code IN OUT NOCOPY Pa_task_types.initial_status_code%TYPE --File.Sql.39 bug 4440895

4959: , p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4960: , p_dlvr_type_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4961: , px_actual_finish_date IN OUT NOCOPY DATE --File.Sql.39 bug 4440895
4962: , px_progress_weight IN OUT NOCOPY PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE --File.Sql.39 bug 4440895
4963: , px_status_code IN OUT NOCOPY Pa_task_types.initial_status_code%TYPE --File.Sql.39 bug 4440895
4964: , p_calling_Mode IN VARCHAR2 := 'INSERT'
4965: ) IS
4966:
4967: Cursor C1 IS

Line 4977: l_status_code Pa_task_types.initial_status_code%TYPE := NULL;

4973:
4974:
4975: l_dlvr_prg_enabled VARCHAR2(1) := NULL;
4976: l_dlvr_action_enabled VARCHAR2(1) := NULL;
4977: l_status_code Pa_task_types.initial_status_code%TYPE := NULL;
4978:
4979: BEGIN
4980: -- Fetching information based on deliverable type
4981: PA_DELIVERABLE_UTILS.get_dlvr_type_info

Line 5267: , pa_task_types dlvtype

5263:
5264: CURSOR c_dlv_type IS
5265: SELECT nvl(prog_entry_enable_flag,'N')
5266: from pa_proj_elements elem
5267: , pa_task_types dlvtype
5268: where elem.type_id = dlvtype.task_type_id
5269: and elem.proj_element_id = p_deliverable_id
5270: and elem.object_type = 'PA_DELIVERABLES'
5271: and elem.project_id = p_project_id;