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_PROJ_ELEMENTS

Line 56: -- Note : If there is an entry for the deliverable type id in the pa_proj_elements table

52:
53: -- SubProgram : IS_DLV_TYPE_IN_USE
54: -- Type : UTIL FUNCTION
55: -- Purpose : This function will check whether deliverable type is in use
56: -- Note : If there is an entry for the deliverable type id in the pa_proj_elements table
57: -- it means that deliverable type is in use.
58: -- Assumptions : None
59: -- Parameter IN/OUT Type Required Description and Purpose
60: -- --------------------------- ------------ ---------- --------- ---------------------------

Line 76: --PA_PROJ_ELEMENTS table .If it is present then

72: l_dummy varchar2(1);
73:
74: --The cursor c_dlv_type_in_use will return 'X'
75: --if the deliverable type id is present in the
76: --PA_PROJ_ELEMENTS table .If it is present then
77: --it means that it is in use.
78:
79: CURSOR c_dlv_type_in_use IS
80: SELECT 'X'

Line 83: FROM PA_PROJ_ELEMENTS

79: CURSOR c_dlv_type_in_use IS
80: SELECT 'X'
81: FROM DUAL
82: WHERE EXISTS (SELECT 'X'
83: FROM PA_PROJ_ELEMENTS
84: WHERE TYPE_ID = p_deliverable_type_id
85: AND OBJECT_TYPE='PA_DELIVERABLES');
86:
87: BEGIN

Line 191: PA_PROJ_ELEMENTS ppe

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
195: and obj.object_type_from = 'PA_DELIVERABLES'

Line 226: -- from the PA_PROJ_ELEMENTS table.

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.
227: -- Assumptions : None
228: -- Parameter IN/OUT Type Required Description and Purpose
229: -- --------------------------- ------------ ---------- --------- ---------------------------
230:

Line 255: PA_PROJ_ELEMENTS ppe1,

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'
259: and ppe1.proj_element_id = obj.object_id_to2

Line 256: PA_PROJ_ELEMENTS ppe2

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'
259: and ppe1.proj_element_id = obj.object_id_to2
260: and ppe2. proj_element_id = obj.object_id_from2

Line 324: -- p_deliverable_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE N Deliverable Type Id

320: -- Note : None
321: -- Assumption : None
322: -- Parameter IN/OUT Type Required Description and Purpose
323: -- --------------------------- ------------ ---------- --------- ---------------------------
324: -- p_deliverable_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE N Deliverable Type Id
325:
326: FUNCTION GET_ASSOCIATED_TASKS
327: (
328: p_deliverable_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE

Line 328: p_deliverable_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE

324: -- p_deliverable_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE N Deliverable Type Id
325:
326: FUNCTION GET_ASSOCIATED_TASKS
327: (
328: p_deliverable_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
329: ) RETURN VARCHAR2
330: IS
331:
332: TYPE l_tbl IS TABLE OF VARCHAR2(350) INDEX BY BINARY_INTEGER;

Line 340: FROM PA_PROJ_ELEMENTS ppe ,

336: l_meaning varchar2(80);
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

Line 415: ,p_dlvr_item_id IN pa_proj_elements.proj_element_id%TYPE

411: -- x_msg_data OUT
412:
413: PROCEDURE GET_OKE_FLAGS
414: ( p_project_id IN pa_projects_all.project_id%TYPE
415: ,p_dlvr_item_id IN pa_proj_elements.proj_element_id%TYPE
416: ,p_dlvr_version_id IN pa_proj_element_versions.element_version_id%TYPE
417: ,p_action_item_id IN pa_proj_elements.proj_element_id%TYPE
418: ,p_action_version_id IN pa_proj_element_versions.element_version_id%TYPE
419: ,p_calling_module IN VARCHAR2

Line 417: ,p_action_item_id IN pa_proj_elements.proj_element_id%TYPE

413: PROCEDURE GET_OKE_FLAGS
414: ( p_project_id IN pa_projects_all.project_id%TYPE
415: ,p_dlvr_item_id IN pa_proj_elements.proj_element_id%TYPE
416: ,p_dlvr_version_id IN pa_proj_element_versions.element_version_id%TYPE
417: ,p_action_item_id IN pa_proj_elements.proj_element_id%TYPE
418: ,p_action_version_id IN pa_proj_element_versions.element_version_id%TYPE
419: ,p_calling_module IN VARCHAR2
420: ,x_ready_to_ship OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
421: ,x_ready_to_procure OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 541: ,p_dlvr_item_id IN pa_proj_elements.proj_element_id%TYPE

537: -- p_dlvr_version_id IN NUMBER Y version id of the deliverable
538:
539: FUNCTION IS_TASK_ASSGMNT_EXISTS
540: ( p_project_id IN pa_projects_all.project_id%TYPE
541: ,p_dlvr_item_id IN pa_proj_elements.proj_element_id%TYPE
542: ,p_dlvr_version_id IN pa_proj_element_versions.element_version_id%TYPE
543: )
544: RETURN VARCHAR2
545: IS

Line 585: ,p_dlvr_item_id IN pa_proj_elements.proj_element_id%TYPE

581:
582:
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

Line 588: ,p_dlvr_status_code IN PA_PROJ_ELEMENTS.STATUS_CODE%TYPE

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
592: )

Line 849: p_action_element_id IN pa_proj_elements.proj_element_id%TYPE

845: -- p_action_element_id IN NUMBER Y Element Id Of Action
846:
847: FUNCTION GET_FUNCTION_CODE
848: (
849: p_action_element_id IN pa_proj_elements.proj_element_id%TYPE
850: )
851: RETURN VARCHAR2
852: IS
853: CURSOR c_function_code IS

Line 855: FROM pa_proj_elements

851: RETURN VARCHAR2
852: IS
853: CURSOR c_function_code IS
854: SELECT function_code
855: FROM pa_proj_elements
856: WHERE proj_element_id = p_action_element_id ;
857: l_function_code pa_proj_elements.function_code%TYPE ;
858: BEGIN
859: OPEN c_function_code ;

Line 857: l_function_code pa_proj_elements.function_code%TYPE ;

853: CURSOR c_function_code IS
854: SELECT function_code
855: FROM pa_proj_elements
856: WHERE proj_element_id = p_action_element_id ;
857: l_function_code pa_proj_elements.function_code%TYPE ;
858: BEGIN
859: OPEN c_function_code ;
860: FETCH c_function_code INTO l_function_code ;
861: IF c_function_code%NOTFOUND THEN

Line 883: p_dlvr_item_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE

879:
880:
881: FUNCTION IS_DLV_DOC_DEFINED
882: (
883: p_dlvr_item_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
884: ,p_dlvr_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
885: ) RETURN VARCHAR2
886: IS
887:

Line 964: ,p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE

960: PROCEDURE GET_STRUCTURE_INFO
961: (
962: p_api_version IN NUMBER := 1.0
963: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
964: ,p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE
965: ,p_structure_type IN VARCHAR2 := 'DELIVERABLE'
966: ,x_proj_element_id OUT NOCOPY PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE --File.Sql.39 bug 4440895
967: ,x_element_version_id OUT NOCOPY PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE --File.Sql.39 bug 4440895
968: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 966: ,x_proj_element_id OUT NOCOPY PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE --File.Sql.39 bug 4440895

962: p_api_version IN NUMBER := 1.0
963: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
964: ,p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE
965: ,p_structure_type IN VARCHAR2 := 'DELIVERABLE'
966: ,x_proj_element_id OUT NOCOPY PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE --File.Sql.39 bug 4440895
967: ,x_element_version_id OUT NOCOPY PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE --File.Sql.39 bug 4440895
968: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
969: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
970: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1010: pa_proj_elements ppe,

1006: /*Select
1007: ppe.proj_element_id
1008: ,pev.element_version_id
1009: From
1010: pa_proj_elements ppe,
1011: pa_proj_element_versions pev,
1012: pa_proj_structure_types pst,
1013: pa_structure_types st
1014: Where

Line 1096: -- : Retrieve Carrying Out Organization Id from pa_proj_elements if task_id is not null

1092: -- Procedure : GET_CARRYING_OUT_ORG
1093: -- Type : UTILITY
1094: -- Purpose : To retrieve Carrying Out Organization Id
1095: -- Note : Retrieve Carrying Out Organization Id from pa_projects if task_id is null,
1096: -- : Retrieve Carrying Out Organization Id from pa_proj_elements if task_id is not null
1097: -- Assumptions : None
1098:
1099: -- Parameters Type Required Description and Purpose
1100: -- --------------------------- ------ -------- --------------------------------------------------------

Line 1106: p_project_id PA_PROJ_ELEMENTS.PROJECT_ID%TYPE

1102: -- p_task_id NUMBER Y Task Id
1103:
1104: FUNCTION GET_CARRYING_OUT_ORG
1105: (
1106: p_project_id PA_PROJ_ELEMENTS.PROJECT_ID%TYPE
1107: ,p_task_id PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
1108: )
1109: RETURN NUMBER
1110: IS

Line 1107: ,p_task_id PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE

1103:
1104: FUNCTION GET_CARRYING_OUT_ORG
1105: (
1106: p_project_id PA_PROJ_ELEMENTS.PROJECT_ID%TYPE
1107: ,p_task_id PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
1108: )
1109: RETURN NUMBER
1110: IS
1111: x_organization_id PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE;

Line 1111: x_organization_id PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE;

1107: ,p_task_id PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
1108: )
1109: RETURN NUMBER
1110: IS
1111: x_organization_id PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE;
1112: BEGIN
1113: -- if task_id is null then retrive carrying_out_organization_id from pa_projects
1114: IF (p_task_id IS NULL) THEN
1115: SELECT

Line 1120: -- else retrive carrying_out_organization_id from pa_proj_elements

1116: p.carrying_out_organization_id INTO x_organization_id
1117: FROM
1118: PA_PROJECTS_ALL p
1119: WHERE p.project_id = p_project_id;
1120: -- else retrive carrying_out_organization_id from pa_proj_elements
1121: ELSE
1122: SELECT
1123: ppe.carrying_out_organization_id INTO x_organization_id
1124: FROM

Line 1125: PA_PROJ_ELEMENTS ppe

1121: ELSE
1122: SELECT
1123: ppe.carrying_out_organization_id INTO x_organization_id
1124: FROM
1125: PA_PROJ_ELEMENTS ppe
1126: WHERE
1127: ppe.proj_element_id = p_task_id
1128: AND ppe.object_type = 'PA_TASKS'
1129: AND ppe.project_id = p_project_id;

Line 1153: -- Note : Retrieve Progress Rollup Method from pa_proj_elements for task id

1149:
1150: -- Procedure : GET_PROGRESS_ROLLUP_METHOD
1151: -- Type : UTILITY
1152: -- Purpose : To retrieve Progress Rollup Method
1153: -- Note : Retrieve Progress Rollup Method from pa_proj_elements for task id
1154: -- :
1155: -- Assumptions : None
1156:
1157: -- Parameters Type Required Description and Purpose

Line 1164: p_task_id PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE

1160:
1161:
1162: FUNCTION GET_PROGRESS_ROLLUP_METHOD
1163: (
1164: p_task_id PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
1165: )
1166: RETURN VARCHAR2
1167: IS
1168: x_base_percent_comp_deriv_code VARCHAR2(30);

Line 1172: FROM PA_PROJ_ELEMENTS ppe

1168: x_base_percent_comp_deriv_code VARCHAR2(30);
1169: BEGIN
1170: SELECT ppe.base_percent_comp_deriv_code
1171: INTO x_base_percent_comp_deriv_code
1172: FROM PA_PROJ_ELEMENTS ppe
1173: WHERE ppe.proj_element_id = p_task_id
1174: AND ppe.object_type = 'PA_TASKS';
1175:
1176: -- 3625019 when task type is changed from update task detail page

Line 1187: pa_proj_elements ppe

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;
1191:

Line 1226: p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE

1222: -- p_project_id NUMBER Y Project Id
1223:
1224: FUNCTION IS_ACTIONS_EXISTS
1225: (
1226: p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE
1227: ,p_proj_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
1228: )
1229: RETURN VARCHAR2
1230: IS

Line 1227: ,p_proj_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE

1223:
1224: FUNCTION IS_ACTIONS_EXISTS
1225: (
1226: p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE
1227: ,p_proj_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
1228: )
1229: RETURN VARCHAR2
1230: IS
1231: x_actions_exists VARCHAR2(1) := 'N';

Line 1286: p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE

1282: -- p_project_id NUMBER Y Project Id
1283:
1284: FUNCTION IS_BILLING_FUNCTION_EXISTS
1285: (
1286: p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE
1287: ,p_proj_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
1288: )
1289: RETURN VARCHAR2
1290: IS

Line 1287: ,p_proj_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE

1283:
1284: FUNCTION IS_BILLING_FUNCTION_EXISTS
1285: (
1286: p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE
1287: ,p_proj_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
1288: )
1289: RETURN VARCHAR2
1290: IS
1291: x_biling_function_exists VARCHAR2(1) := 'N';

Line 1306: ,PA_PROJ_ELEMENTS PPE

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
1310: AND POR.OBJECT_TYPE_FROM = 'PA_DELIVERABLES'

Line 1348: p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE

1344: -- p_project_id NUMBER Y Project Id
1345:
1346: FUNCTION IS_DELIVERABLE_HAS_PROGRESS
1347: (
1348: p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE
1349: ,p_proj_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
1350: )
1351: RETURN VARCHAR2
1352: IS

Line 1349: ,p_proj_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE

1345:
1346: FUNCTION IS_DELIVERABLE_HAS_PROGRESS
1347: (
1348: p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE
1349: ,p_proj_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
1350: )
1351: RETURN VARCHAR2
1352: IS
1353: x_deliverable_has_progress VARCHAR2(1) := 'N';

Line 1443: -- Note : Retrieve Name and Number from pa_proj_elements

1439:
1440: -- Procedure : GET_DLVR_DETAIL
1441: -- Type : UTILITY
1442: -- Purpose : To retrieve Deliverable name and number
1443: -- Note : Retrieve Name and Number from pa_proj_elements
1444: -- :
1445: -- Assumptions : None
1446:
1447: -- Parameters Type Required Description and Purpose

Line 1457: ,x_name OUT NOCOPY PA_PROJ_ELEMENTS.NAME%TYPE --File.Sql.39 bug 4440895

1453:
1454: PROCEDURE GET_DLVR_DETAIL
1455: (
1456: p_dlvr_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
1457: ,x_name OUT NOCOPY PA_PROJ_ELEMENTS.NAME%TYPE --File.Sql.39 bug 4440895
1458: ,x_number OUT NOCOPY PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE --File.Sql.39 bug 4440895
1459: )
1460: IS
1461: CURSOR l_dlvr_info_csr

Line 1458: ,x_number OUT NOCOPY PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE --File.Sql.39 bug 4440895

1454: PROCEDURE GET_DLVR_DETAIL
1455: (
1456: p_dlvr_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
1457: ,x_name OUT NOCOPY PA_PROJ_ELEMENTS.NAME%TYPE --File.Sql.39 bug 4440895
1458: ,x_number OUT NOCOPY PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE --File.Sql.39 bug 4440895
1459: )
1460: IS
1461: CURSOR l_dlvr_info_csr
1462: IS

Line 1467: PA_PROJ_ELEMENTS PPE,

1463: SELECT
1464: PPE.NAME,
1465: PPE.ELEMENT_NUMBER
1466: FROM
1467: PA_PROJ_ELEMENTS PPE,
1468: PA_PROJ_ELEMENT_VERSIONS PEV
1469: WHERE
1470: PEV.ELEMENT_VERSION_ID = p_dlvr_ver_id
1471: AND PPE.PROJECT_ID = PEV.PROJECT_ID

Line 1503: -- Note : Retrieve Action Name and Number from pa_proj_elements

1499:
1500: -- Procedure : GET_ACTION_DETAIL
1501: -- Type : UTILITY
1502: -- Purpose : To retrieve Deliverable Action name and number
1503: -- Note : Retrieve Action Name and Number from pa_proj_elements
1504: -- :
1505: -- Assumptions : None
1506:
1507: -- Parameters Type Required Description and Purpose

Line 1517: ,x_name OUT NOCOPY PA_PROJ_ELEMENTS.NAME%TYPE --File.Sql.39 bug 4440895

1513:
1514: PROCEDURE GET_ACTION_DETAIL
1515: (
1516: p_dlvr_action_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
1517: ,x_name OUT NOCOPY PA_PROJ_ELEMENTS.NAME%TYPE --File.Sql.39 bug 4440895
1518: ,x_number OUT NOCOPY PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE --File.Sql.39 bug 4440895
1519: )
1520: IS
1521:

Line 1518: ,x_number OUT NOCOPY PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE --File.Sql.39 bug 4440895

1514: PROCEDURE GET_ACTION_DETAIL
1515: (
1516: p_dlvr_action_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
1517: ,x_name OUT NOCOPY PA_PROJ_ELEMENTS.NAME%TYPE --File.Sql.39 bug 4440895
1518: ,x_number OUT NOCOPY PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE --File.Sql.39 bug 4440895
1519: )
1520: IS
1521:
1522: CURSOR l_dlvr_action_info_csr

Line 1528: PA_PROJ_ELEMENTS PPE,

1524: SELECT
1525: PPE.NAME,
1526: PPE.ELEMENT_NUMBER
1527: FROM
1528: PA_PROJ_ELEMENTS PPE,
1529: PA_PROJ_ELEMENT_VERSIONS PEV
1530: WHERE
1531: PEV.ELEMENT_VERSION_ID = p_dlvr_action_ver_id
1532: AND PPE.PROJECT_ID = PEV.PROJECT_ID

Line 1632: ,x_project_id OUT NOCOPY PA_PROJ_ELEMENTS.PROJECT_ID%TYPE --File.Sql.39 bug 4440895

1628:
1629: PROCEDURE GET_DLVR_PROJECT_DETAIL
1630: (
1631: p_dlvr_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
1632: ,x_project_id OUT NOCOPY PA_PROJ_ELEMENTS.PROJECT_ID%TYPE --File.Sql.39 bug 4440895
1633: ,x_project_name OUT NOCOPY PA_PROJECTS_ALL.NAME%TYPE --File.Sql.39 bug 4440895
1634: )
1635: IS
1636:

Line 1691: ,x_project_id OUT NOCOPY PA_PROJ_ELEMENTS.PROJECT_ID%TYPE --File.Sql.39 bug 4440895

1687:
1688: PROCEDURE GET_ACTION_PROJECT_DETAIL
1689: (
1690: p_dlvr_action_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
1691: ,x_project_id OUT NOCOPY PA_PROJ_ELEMENTS.PROJECT_ID%TYPE --File.Sql.39 bug 4440895
1692: ,x_project_name OUT NOCOPY PA_PROJECTS_ALL.NAME%TYPE --File.Sql.39 bug 4440895
1693: )
1694: IS
1695:

Line 1758: PA_PROJ_ELEMENTS PPE

1754: IS
1755: SELECT
1756: PPE. NAME||'('|| PPE.ELEMENT_NUMBER||')' NAME_NUMBER
1757: FROM
1758: PA_PROJ_ELEMENTS PPE
1759: WHERE PPE.PROJ_ELEMENT_ID = p_task_id
1760: AND PPE.OBJECT_TYPE = 'PA_TASKS';
1761:
1762: BEGIN

Line 1803: p_project_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE

1799: -- x_owner_name VARCHAR Owner Name
1800:
1801: PROCEDURE GET_DEFAULT_DLVR_OWNER
1802: (
1803: p_project_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
1804: ,p_task_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
1805: ,x_owner_id OUT NOCOPY PER_ALL_PEOPLE_F.PERSON_ID%TYPE --File.Sql.39 bug 4440895
1806: ,x_owner_name OUT NOCOPY PER_ALL_PEOPLE_F.FULL_NAME%TYPE --File.Sql.39 bug 4440895
1807: )

Line 1816: PA_PROJ_ELEMENTS PPE,

1812: SELECT
1813: PPF.PERSON_ID
1814: ,PPF.FULL_NAME
1815: FROM
1816: PA_PROJ_ELEMENTS PPE,
1817: PER_ALL_PEOPLE_F PPF,
1818: PA_PROJ_ELEMENT_VERSIONS PEV
1819: WHERE
1820: PEV.ELEMENT_VERSION_ID = p_task_ver_id

Line 1878: p_project_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE

1874: -- x_due_date DATE Dlvr Due Date
1875:
1876: PROCEDURE GET_DEFAULT_DLVR_DATE
1877: (
1878: p_project_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
1879: ,p_task_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
1880: ,x_due_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
1881: )
1882: IS

Line 2000: ,PA_PROJ_ELEMENTS PPE

1996: PPF.PERSON_ID
1997: ,PPF.FULL_NAME
1998: FROM
1999: PA_PROJ_ELEMENT_VERSIONS PEV
2000: ,PA_PROJ_ELEMENTS PPE
2001: ,PER_ALL_PEOPLE_F PPF
2002: WHERE
2003: PEV.ELEMENT_VERSION_ID = p_dlvr_ver_id
2004: AND PPE.OBJECT_TYPE = 'PA_DELIVERABLES'

Line 2055: ,p_function_code IN PA_PROJ_ELEMENTS.FUNCTION_CODE%TYPE

2051: (
2052: p_dlvr_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
2053: ,p_task_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
2054: ,p_project_mode IN VARCHAR2
2055: ,p_function_code IN PA_PROJ_ELEMENTS.FUNCTION_CODE%TYPE
2056: ,x_due_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
2057: )
2058: IS
2059:

Line 2177: p_dlv_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE

2173: -- exists for Deliverable
2174:
2175: FUNCTION IS_DLV_BASED_ASSCN_EXISTS
2176: (
2177: p_dlv_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
2178: ,p_dlv_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE := NULL
2179: )
2180: RETURN VARCHAR2
2181: IS

Line 2190: PA_PROJ_ELEMENTS ppe

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
2194: and obj.object_type_from = 'PA_TASKS'

Line 2206: pa_proj_elements ppe,

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

Line 2235: p_dlv_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE

2231: -- with ready to ship flag as 'Y'
2232:
2233: FUNCTION GET_READY_TO_SHIP_FLAG
2234: (
2235: p_dlv_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
2236: ,p_dlv_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
2237: ) RETURN VARCHAR2
2238: IS
2239: CURSOR ship_flag_dlv IS

Line 2269: p_dlv_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE

2265: END GET_READY_TO_SHIP_FLAG ;
2266:
2267: FUNCTION GET_READY_TO_PROC_FLAG
2268: (
2269: p_dlv_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
2270: ,p_dlv_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
2271: ) RETURN VARCHAR2
2272: IS
2273: CURSOR proc_flag_dlv IS

Line 2306: p_proj_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE

2302: -- progress enabled deliverable .
2303:
2304: FUNCTION IS_PROG_ENABLED_DLV_EXISTS
2305: (
2306: p_proj_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
2307: ) RETURN VARCHAR2
2308: IS
2309: CURSOR c_prog_enabled_dlv_exists IS
2310: SELECT 'Y'

Line 2314: ,pa_proj_elements ppe

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

Line 2344: p_proj_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE

2340: -- This API will return 'Y' is progress is enabled for deliverable
2341:
2342: FUNCTION IS_PROGRESS_ENABLED
2343: (
2344: p_proj_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
2345: ) RETURN VARCHAR2
2346: IS
2347: CURSOR c_is_prog_enabled_dlv IS
2348: SELECT 'Y'

Line 2349: FROM pa_proj_elements ppe

2345: ) RETURN VARCHAR2
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

Line 2447: FROM pa_proj_elements ppe

2443: ) RETURN VARCHAR2
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 */

Line 2461: l_dummy pa_proj_elements.description%TYPE;

2457: AND obj.object_id_from2 = ppe.proj_element_id
2458: AND ppe.object_type = 'PA_DELIVERABLES' /*Included this clause for Performance fix Bug # 3614361 */
2459: ;
2460:
2461: l_dummy pa_proj_elements.description%TYPE;
2462: BEGIN
2463: OPEN c_dlv_desc;
2464: FETCH c_dlv_desc into l_dummy ;
2465: CLOSE c_dlv_desc;

Line 2481: pa_proj_elements ppe

2477: CURSOR c_dlv_desc IS
2478: SELECT
2479: ppe.description
2480: FROM
2481: pa_proj_elements ppe
2482: ,pa_proj_element_versions pev
2483: WHERE
2484: pev.element_version_id = p_deliverable_id
2485: AND ppe.object_type = 'PA_DELIVERABLES'

Line 2490: l_dummy pa_proj_elements.description%TYPE;

2486: AND pev.object_type = 'PA_DELIVERABLES'
2487: AND ppe.proj_element_id = pev.proj_element_id
2488: AND ppe.project_id = pev.project_id;
2489:
2490: l_dummy pa_proj_elements.description%TYPE;
2491:
2492: BEGIN
2493: OPEN c_dlv_desc;
2494: FETCH c_dlv_desc into l_dummy ;

Line 2511: FROM pa_proj_elements ppe

2507: CURSOR c_is_dlv_item_based IS
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

Line 2664: ,p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE

2660:
2661: PROCEDURE CHECK_DLVR_DISABLE_ALLOWED( p_api_version IN NUMBER := 1.0
2662: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
2663: ,p_debug_mode IN VARCHAR2 := 'N'
2664: ,p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE
2665: ,x_return_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2666: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2667: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2668: ,x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895

Line 2677: FROM pa_proj_elements ppe,

2673: CURSOR cur_tsk_assoc IS
2674: SELECT 1 FROM dual
2675: WHERE EXISTS(
2676: SELECT ppe.proj_element_id DlvrElemId, ppev.element_version_id DlvrElemVerId
2677: FROM pa_proj_elements ppe,
2678: pa_proj_element_versions ppev
2679: WHERE ppe.proj_element_id = ppev.proj_element_id
2680: AND ppe.project_id = p_project_id
2681: AND ppev.project_id = p_project_id

Line 2692: FROM pa_proj_elements ppe

2688: CURSOR cur_dlvr_progress IS
2689: SELECT 1 FROM dual
2690: WHERE EXISTS(
2691: SELECT 1
2692: FROM pa_proj_elements ppe
2693: WHERE ppe.project_id = p_project_id
2694: AND ppe.object_type = 'PA_DELIVERABLES'
2695: AND 'Y' = PA_DELIVERABLE_UTILS.IS_DELIVERABLE_HAS_PROGRESS(p_project_id,ppe.proj_element_id)
2696: );

Line 2702: FROM pa_proj_elements ppe,

2698: /*
2699: SELECT 1 FROM dual
2700: WHERE EXISTS(
2701: SELECT ppe.proj_element_id DlvrElemId, ppev.element_version_id DlvrElemVerId
2702: FROM pa_proj_elements ppe,
2703: pa_proj_element_versions ppev
2704: WHERE ppe.project_id = p_project_id
2705: AND ppe.object_type = 'PA_DELIVERABLES'
2706: AND 'Y' = PA_DELIVERABLE_UTILS.IS_DELIVERABLE_HAS_PROGRESS(p_project_id,ppe.proj_element_id)

Line 2714: FROM pa_proj_elements ppe,

2710: CURSOR cur_ship_or_proc IS
2711: SELECT 1 FROM dual
2712: WHERE EXISTS(
2713: SELECT ppe.proj_element_id DlvrElemId, ppev.element_version_id DlvrElemVerId
2714: FROM pa_proj_elements ppe,
2715: pa_proj_element_versions ppev
2716: WHERE ppe.proj_element_id = ppev.proj_element_id
2717: AND ppe.project_id = p_project_id
2718: AND ppev.project_id = p_project_id

Line 2729: FROM pa_proj_elements ppe

2725: CURSOR cur_billing_fn IS
2726: SELECT 1 FROM dual
2727: WHERE EXISTS(
2728: SELECT 1
2729: FROM pa_proj_elements ppe
2730: WHERE ppe.project_id = p_project_id
2731: AND ppe.object_type = 'PA_ACTIONS'
2732: AND PA_DELIVERABLE_UTILS.GET_FUNCTION_CODE(ppe.proj_element_id) = 'BILLING'
2733: AND 'Y' = PA_Billing_Wrkbnch_Events.CHECK_BILLING_EVENT_EXISTS(p_project_id,ppe.proj_element_id)

Line 2876: FROM pa_proj_elements ppe,

2872: CURSOR cur_check_cancel_possible IS
2873: SELECT 1 FROM dual
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

Line 2900: FROM pa_proj_elements ppe,

2896: OR PA_DELIVERABLE_UTILS.GET_FUNCTION_CODE(obj2.object_id_to2) = 'BILLING' )
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

Line 2959: UPDATE pa_proj_elements

2955: CLOSE cur_check_cancel_possible;
2956: END IF;
2957: END IF;
2958: FOR assoc_dlvr_rec IN cur_get_assoc_dlvr LOOP
2959: UPDATE pa_proj_elements
2960: SET status_code = p_status_code
2961: WHERE proj_element_id = assoc_dlvr_rec.proj_element_id;
2962: END LOOP;
2963:

Line 3010: FROM pa_proj_elements ppe,

3006: CURSOR cur_check_transaction_init IS
3007: SELECT 1 FROM dual
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

Line 3104: ,p_task_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE

3100:
3101: PROCEDURE CHECK_PROGRESS_MTH_CODE_VALID( p_api_version IN NUMBER := 1.0
3102: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
3103: ,p_debug_mode IN VARCHAR2 := 'N'
3104: ,p_task_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
3105: ,p_prog_method_code IN PA_PROJ_ELEMENTS.BASE_PERCENT_COMP_DERIV_CODE%TYPE
3106: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3107: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3108: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 3105: ,p_prog_method_code IN PA_PROJ_ELEMENTS.BASE_PERCENT_COMP_DERIV_CODE%TYPE

3101: PROCEDURE CHECK_PROGRESS_MTH_CODE_VALID( p_api_version IN NUMBER := 1.0
3102: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
3103: ,p_debug_mode IN VARCHAR2 := 'N'
3104: ,p_task_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
3105: ,p_prog_method_code IN PA_PROJ_ELEMENTS.BASE_PERCENT_COMP_DERIV_CODE%TYPE
3106: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3107: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3108: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3109: )

Line 3116: FROM pa_proj_elements ppe,

3112: CURSOR cur_assoc_dlvr_has_prog IS
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

Line 3132: FROM pa_proj_elements ppe,

3128: CURSOR cur_dlvr_assoc_exists IS
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'

Line 3224: ,p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE

3220:
3221: FUNCTION CHECK_PROJ_DLV_TXN_EXISTS( p_api_version IN NUMBER := 1.0
3222: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
3223: ,p_debug_mode IN VARCHAR2 := 'N'
3224: ,p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE
3225: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3226: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3227: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3228: )

Line 3235: FROM pa_proj_elements ppe,

3231: CURSOR cur_proj_txn_exists IS
3232: SELECT 'Y' FROM dual
3233: WHERE EXISTS(
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

Line 3236: pa_proj_elements ppe2,

3232: SELECT 'Y' FROM dual
3233: WHERE EXISTS(
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

Line 3325: p_task_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE

3321: END CHECK_PROJ_DLV_TXN_EXISTS;
3322:
3323: FUNCTION GET_ASSOCIATED_DELIVERABLES
3324: (
3325: p_task_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
3326: ) RETURN VARCHAR2
3327: IS
3328:
3329: TYPE l_tbl IS TABLE OF VARCHAR2(350) INDEX BY BINARY_INTEGER;

Line 3337: FROM PA_PROJ_ELEMENTS ppe ,

3333: l_meaning varchar2(80);
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

Line 3565: FROM pa_proj_elements ppe,

3561: IS
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'

Line 3590: from pa_proj_elements ppe,

3586: CURSOR C IS
3587: SELECT 'Y'
3588: FROM DUAL
3589: WHERE EXISTS (Select 'Y'
3590: from pa_proj_elements ppe,
3591: pa_proj_element_versions pev
3592: where pev.element_version_id = p_action_version_id
3593: and ppe.proj_element_id = pev.proj_element_id
3594: and ppe.function_code = 'BILLING'

Line 3656: FROM PA_PROJ_ELEMENTS PPE,

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
3659: AND PEV.ELEMENT_VERSION_ID = p_deliverable_id
3660: AND PEV.OBJECT_TYPE='PA_DELIVERABLES'

Line 3692: pa_proj_elements ppe

3688: CURSOR c_dlv_name_number IS
3689: SELECT
3690: ppe.name || '(' || ppe.element_number || ')'
3691: FROM
3692: pa_proj_elements ppe
3693: ,pa_proj_element_versions pev
3694: WHERE
3695: pev.element_version_id = p_deliverable_id
3696: AND ppe.object_type = 'PA_DELIVERABLES'

Line 3729: pa_proj_elements ppe

3725: CURSOR c_dlv_name_number IS
3726: SELECT
3727: ppe.ELEMENT_NUMBER
3728: FROM
3729: pa_proj_elements ppe
3730: ,pa_proj_element_versions pev
3731: WHERE
3732: pev.element_version_id = p_deliverable_id
3733: AND ppe.object_type = 'PA_DELIVERABLES'

Line 3771: pa_proj_elements ppe,

3767: CURSOR c_dlvr_owner IS
3768: select
3769: ppe.manager_person_id
3770: from
3771: pa_proj_elements ppe,
3772: pa_proj_element_versions pev
3773: where
3774: pev.element_version_id = p_deliverable_id
3775: and pev.object_type = 'PA_DELIVERABLES'

Line 3814: , p_dlvr_number IN PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

3810: Procedure Validate_Deliverable
3811: (
3812: p_deliverable_id IN NUMBER
3813: , p_deliverable_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3814: , p_dlvr_number IN PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3815: , p_dlvr_name IN PA_PROJ_ELEMENTS.NAME%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3816: , px_dlvr_owner_id IN OUT NOCOPY PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%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

Line 3815: , p_dlvr_name IN PA_PROJ_ELEMENTS.NAME%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

3811: (
3812: p_deliverable_id IN NUMBER
3813: , p_deliverable_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3814: , p_dlvr_number IN PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3815: , p_dlvr_name IN PA_PROJ_ELEMENTS.NAME%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3816: , px_dlvr_owner_id IN OUT NOCOPY PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%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

Line 3816: , px_dlvr_owner_id IN OUT NOCOPY PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE --File.Sql.39 bug 4440895

3812: p_deliverable_id IN NUMBER
3813: , p_deliverable_reference IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3814: , p_dlvr_number IN PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3815: , p_dlvr_name IN PA_PROJ_ELEMENTS.NAME%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3816: , px_dlvr_owner_id IN OUT NOCOPY PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%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

Line 3818: , p_dlvr_type_id IN PA_PROJ_ELEMENTS.TYPE_ID%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

3814: , p_dlvr_number IN PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3815: , p_dlvr_name IN PA_PROJ_ELEMENTS.NAME%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
3816: , px_dlvr_owner_id IN OUT NOCOPY PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%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

Line 3820: , px_progress_weight IN OUT NOCOPY PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE --File.Sql.39 bug 4440895

3816: , px_dlvr_owner_id IN OUT NOCOPY PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%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

Line 3823: , p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE

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'
3826: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3827: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 3824: , p_task_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE

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'
3826: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3827: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3828: , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 3835: l_dlvr_owner_id PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE;

3831: l_api_name CONSTANT VARCHAR2(100) := 'VALIDATE_DELIVERABLE';
3832: l_debug_mode VARCHAR2(1);
3833: l_msg_data VARCHAR2(2000);
3834:
3835: l_dlvr_owner_id PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE;
3836: --added for Bug: 4537865
3837: l_new_dlvr_owner_id PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE;
3838: l_new_carrying_out_org_id PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE;
3839: --added for Bug: 4537865

Line 3837: l_new_dlvr_owner_id PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE;

3833: l_msg_data VARCHAR2(2000);
3834:
3835: l_dlvr_owner_id PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE;
3836: --added for Bug: 4537865
3837: l_new_dlvr_owner_id PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE;
3838: l_new_carrying_out_org_id PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE;
3839: --added for Bug: 4537865
3840: l_carrying_out_org_id PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE;
3841: l_dlvr_prg_enabled VARCHAR2(1) := NULL;

Line 3838: l_new_carrying_out_org_id PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE;

3834:
3835: l_dlvr_owner_id PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE;
3836: --added for Bug: 4537865
3837: l_new_dlvr_owner_id PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE;
3838: l_new_carrying_out_org_id PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE;
3839: --added for Bug: 4537865
3840: l_carrying_out_org_id PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE;
3841: l_dlvr_prg_enabled VARCHAR2(1) := NULL;
3842: l_dlvr_action_enabled VARCHAR2(1) := NULL;

Line 3840: l_carrying_out_org_id PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE;

3836: --added for Bug: 4537865
3837: l_new_dlvr_owner_id PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE;
3838: l_new_carrying_out_org_id PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE;
3839: --added for Bug: 4537865
3840: l_carrying_out_org_id PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE;
3841: l_dlvr_prg_enabled VARCHAR2(1) := NULL;
3842: l_dlvr_action_enabled VARCHAR2(1) := NULL;
3843: l_status_code PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE := NULL;
3844: l_status_code_valid VARCHAR2(1) := NULL;

Line 3843: l_status_code PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE := NULL;

3839: --added for Bug: 4537865
3840: l_carrying_out_org_id PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE;
3841: l_dlvr_prg_enabled VARCHAR2(1) := NULL;
3842: l_dlvr_action_enabled VARCHAR2(1) := NULL;
3843: l_status_code PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE := NULL;
3844: l_status_code_valid VARCHAR2(1) := NULL;
3845:
3846: l_project_number Pa_Projects_All.Segment1%TYPE;
3847: l_task_number Pa_Proj_Elements.Name%TYPE;

Line 3847: l_task_number Pa_Proj_Elements.Name%TYPE;

3843: l_status_code PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE := NULL;
3844: l_status_code_valid VARCHAR2(1) := NULL;
3845:
3846: l_project_number Pa_Projects_All.Segment1%TYPE;
3847: l_task_number Pa_Proj_Elements.Name%TYPE;
3848:
3849: BEGIN
3850:
3851: x_msg_count := 0;

Line 3874: FROM Pa_Proj_Elements

3870:
3871: -- Fetching Task Name , Project Name to use as token in Error Messages.
3872: IF (p_task_id IS NOT NULL AND p_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
3873: SELECT name INTO l_task_number
3874: FROM Pa_Proj_Elements
3875: WHERE proj_element_id = p_task_id;
3876: ELSE
3877: l_task_number := null;
3878: END IF;

Line 4201: pa_proj_elements ppe

4197: CURSOR c_dlvr_version IS
4198: SELECT
4199: pev.element_version_id
4200: FROM
4201: pa_proj_elements ppe
4202: ,pa_proj_element_versions pev
4203: WHERE
4204: pev.proj_element_id = p_deliverable_id
4205: AND ppe.object_type = 'PA_DELIVERABLES'

Line 4326: FROM pa_proj_elements elem, pa_projects_all proj

4322:
4323: CURSOR l_dlvr_ref_csr
4324: IS
4325: SELECT elem.proj_element_id, proj.segment1
4326: FROM pa_proj_elements elem, pa_projects_all proj
4327: where pm_source_reference = p_deliverable_reference
4328: and elem.project_id = p_project_id
4329: and elem.project_id = proj.project_id
4330: and object_type = 'PA_DELIVERABLES';

Line 4441: FROM pa_proj_elements

4437:
4438: CURSOR l_dlvr_id_csr
4439: IS
4440: SELECT 'X'
4441: FROM pa_proj_elements
4442: where proj_element_id = p_deliverable_id
4443: and project_id = p_project_id
4444: and object_type = 'PA_DELIVERABLES';
4445:

Line 4449: FROM pa_proj_elements

4445:
4446: CURSOR l_dlvr_ref_csr
4447: IS
4448: SELECT proj_element_id
4449: FROM pa_proj_elements
4450: where pm_source_reference = p_deliverable_reference
4451: and project_id = p_project_id
4452: and object_type = 'PA_DELIVERABLES';
4453:

Line 4590: pa_proj_elements ppe

4586: CURSOR c_action_version IS
4587: SELECT
4588: pev.element_version_id
4589: FROM
4590: pa_proj_elements ppe
4591: ,pa_proj_element_versions pev
4592: WHERE
4593: pev.proj_element_id = p_action_id
4594: AND ppe.object_type = 'PA_ACTIONS'

Line 4633: FROM pa_proj_elements ppe,

4629:
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

Line 4646: , pa_proj_elements elem

4642: CURSOR proj_num IS
4643: SELECT proj.segment1
4644: , elem.name
4645: FROM pa_projects_all proj
4646: , pa_proj_elements elem
4647: WHERE proj.project_id = p_project_id
4648: AND elem.project_id = proj.project_id
4649: AND elem.object_type = 'PA_DELIVERABLES'
4650: AND elem.proj_element_id = p_deliverable_id;

Line 4656: l_deliverable_name Pa_proj_elements.name%TYPE;

4652: l_api_name CONSTANT VARCHAR2(30) := 'is_action_reference_unique';
4653: l_action_id NUMBER ;
4654: l_dummy VARCHAR2(1);
4655: l_project_number Pa_Projects_All.Segment1%TYPE;
4656: l_deliverable_name Pa_proj_elements.name%TYPE;
4657:
4658: BEGIN
4659:
4660: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4791: FROM pa_proj_elements ppe,

4787:
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

Line 4803: FROM pa_proj_elements ppe,

4799:
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

Line 4816: , pa_proj_elements elem

4812: CURSOR proj_num IS
4813: SELECT proj.segment1
4814: , elem.name
4815: FROM pa_projects_all proj
4816: , pa_proj_elements elem
4817: WHERE proj.project_id = p_project_id
4818: AND elem.project_id = proj.project_id
4819: AND elem.object_type = 'PA_DELIVERABLES'
4820: AND elem.proj_element_id = p_deliverable_id;

Line 4827: l_deliverable_name Pa_proj_elements.name%TYPE;

4823: l_api_name CONSTANT VARCHAR2(30) := 'Convert_pm_dlvrref_to_id';
4824: l_action_id NUMBER ;
4825: l_dummy VARCHAR2(1);
4826: l_project_number Pa_Projects_All.Segment1%TYPE;
4827: l_deliverable_name Pa_proj_elements.name%TYPE;
4828:
4829: BEGIN
4830:
4831: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4962: , px_progress_weight IN OUT NOCOPY PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE --File.Sql.39 bug 4440895

4958: p_deliverable_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
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:

Line 5046: l_name Pa_Proj_Elements.Name%TYPE;

5042: SELECT segment1||':Deliverable'
5043: FROM pa_Projects_All
5044: WHERE Project_id = p_Project_Id;
5045:
5046: l_name Pa_Proj_Elements.Name%TYPE;
5047: l_structure_id Pa_Proj_Elements.Proj_Element_Id%TYPE;
5048: l_structure_version_id Pa_Proj_Element_Versions.Element_Version_Id%TYPE;
5049: l_pev_structure_id Pa_Proj_Element_Versions.Element_Version_Id%TYPE;
5050:

Line 5047: l_structure_id Pa_Proj_Elements.Proj_Element_Id%TYPE;

5043: FROM pa_Projects_All
5044: WHERE Project_id = p_Project_Id;
5045:
5046: l_name Pa_Proj_Elements.Name%TYPE;
5047: l_structure_id Pa_Proj_Elements.Proj_Element_Id%TYPE;
5048: l_structure_version_id Pa_Proj_Element_Versions.Element_Version_Id%TYPE;
5049: l_pev_structure_id Pa_Proj_Element_Versions.Element_Version_Id%TYPE;
5050:
5051: l_api_name CONSTANT VARCHAR2(30) := 'ENABLE_DELIVERABLES';

Line 5266: from pa_proj_elements elem

5262: l_dummy varchar2(1):='N';
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'

Line 5414: l_latest_pub_wp_struct_id := PA_PROJ_ELEMENTS_UTILS.latest_published_ver_id(p_project_id);

5410: BEGIN
5411:
5412: -- retrieve published wp structure version id
5413:
5414: l_latest_pub_wp_struct_id := PA_PROJ_ELEMENTS_UTILS.latest_published_ver_id(p_project_id);
5415:
5416: -- check whether task exists for published wp structure
5417: -- if yes
5418: -- retrieve task version id, set is_task_in_published_ver to 'Y' and task version id in local variable

Line 5503: FROM pa_proj_elements

5499: CURSOR dlv_based_task IS
5500: SELECT 'Y'
5501: FROM dual
5502: WHERE EXISTS ( SELECT 'Y'
5503: FROM pa_proj_elements
5504: WHERE base_percent_comp_deriv_code = 'DELIVERABLE'
5505: AND object_type = 'PA_TASKS'
5506: AND project_id = p_project_id);
5507: l_dummy VARCHAR2(1) := 'N' ;

Line 5525: FROM pa_proj_elements

5521: CURSOR is_dlv_exists IS
5522: SELECT 'Y'
5523: FROM dual
5524: WHERE EXISTS ( SELECT 'Y'
5525: FROM pa_proj_elements
5526: WHERE object_type = 'PA_DELIVERABLES'
5527: AND project_id = p_project_id);
5528: l_dummy VARCHAR2(1) := 'N' ;
5529: BEGIN

Line 5848: p_dlv_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE

5844: -- p_dlv_version_id IN NUMBER Yes Deliverable Version Id
5845:
5846: FUNCTION IS_SHIPPING_INITIATED
5847: (
5848: p_dlv_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
5849: ,p_dlv_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
5850: ) RETURN VARCHAR2
5851: IS
5852: CURSOR ship_flag_dlv IS

Line 5894: p_dlv_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE

5890:
5891:
5892: FUNCTION IS_PROCUREMENT_INITIATED
5893: (
5894: p_dlv_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
5895: ,p_dlv_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
5896: ) RETURN VARCHAR2
5897: IS
5898: CURSOR proc_flag_dlv IS

Line 5940: p_dlv_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE

5936:
5937:
5938: FUNCTION IS_BILLING_EVENT_PROCESSED
5939: (
5940: p_dlv_element_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
5941: ,p_dlv_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
5942: ) RETURN VARCHAR2
5943: IS
5944: CURSOR bill_flag_dlv IS

Line 5990: ,x_bill_description OUT NOCOPY PA_PROJ_ELEMENTS.DESCRIPTION%TYPE --File.Sql.39 bug 4440895

5986: PROCEDURE GET_BILLING_DETAILS
5987: (
5988: p_action_version_id IN PA_PROJ_ELEM_VER_SCHEDULE.ELEMENT_VERSION_ID%TYPE
5989: ,x_bill_completion_date OUT NOCOPY PA_PROJ_ELEM_VER_SCHEDULE.ACTUAL_FINISH_DATE%TYPE --File.Sql.39 bug 4440895
5990: ,x_bill_description OUT NOCOPY PA_PROJ_ELEMENTS.DESCRIPTION%TYPE --File.Sql.39 bug 4440895
5991: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5992: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5993: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5994: )

Line 6002: PA_PROJ_ELEMENTS PPE,

5998: SELECT
5999: PPE.DESCRIPTION
6000: ,PES.ACTUAL_FINISH_DATE
6001: FROM
6002: PA_PROJ_ELEMENTS PPE,
6003: PA_PROJ_ELEM_VER_SCHEDULE PES
6004: WHERE
6005: PES.ELEMENT_VERSION_ID = p_action_version_id
6006: AND PES.PROJ_ELEMENT_ID = PPE.PROJ_ELEMENT_ID

Line 6111: l_latest_pub_wp_struct_id := PA_PROJ_ELEMENTS_UTILS.latest_published_ver_id(p_project_id);

6107:
6108: -- retrieve published wp structure version id
6109: -- if task is in in latest published wp verion, return task version id and parent structure version id
6110:
6111: l_latest_pub_wp_struct_id := PA_PROJ_ELEMENTS_UTILS.latest_published_ver_id(p_project_id);
6112:
6113: IF l_latest_pub_wp_struct_id IS NOT NULL THEN
6114:
6115: OPEN c_task_exists(l_latest_pub_wp_struct_id);

Line 6183: ,x_ship_name OUT NOCOPY PA_PROJ_ELEMENTS.NAME%TYPE --File.Sql.39 bug 4440895

6179: PROCEDURE GET_SHIP_PROC_ACTN_DETAIL
6180: (
6181: p_dlvr_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
6182: ,x_ship_id OUT NOCOPY PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE --File.Sql.39 bug 4440895
6183: ,x_ship_name OUT NOCOPY PA_PROJ_ELEMENTS.NAME%TYPE --File.Sql.39 bug 4440895
6184: ,x_ship_due_date OUT NOCOPY PA_PROJ_ELEM_VER_SCHEDULE.SCHEDULED_FINISH_DATE%TYPE --File.Sql.39 bug 4440895
6185: ,x_proc_id OUT NOCOPY PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE --File.Sql.39 bug 4440895
6186: ,x_proc_name OUT NOCOPY PA_PROJ_ELEMENTS.NAME%TYPE --File.Sql.39 bug 4440895
6187: ,x_proc_due_date OUT NOCOPY PA_PROJ_ELEM_VER_SCHEDULE.SCHEDULED_FINISH_DATE%TYPE --File.Sql.39 bug 4440895

Line 6186: ,x_proc_name OUT NOCOPY PA_PROJ_ELEMENTS.NAME%TYPE --File.Sql.39 bug 4440895

6182: ,x_ship_id OUT NOCOPY PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE --File.Sql.39 bug 4440895
6183: ,x_ship_name OUT NOCOPY PA_PROJ_ELEMENTS.NAME%TYPE --File.Sql.39 bug 4440895
6184: ,x_ship_due_date OUT NOCOPY PA_PROJ_ELEM_VER_SCHEDULE.SCHEDULED_FINISH_DATE%TYPE --File.Sql.39 bug 4440895
6185: ,x_proc_id OUT NOCOPY PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE --File.Sql.39 bug 4440895
6186: ,x_proc_name OUT NOCOPY PA_PROJ_ELEMENTS.NAME%TYPE --File.Sql.39 bug 4440895
6187: ,x_proc_due_date OUT NOCOPY PA_PROJ_ELEM_VER_SCHEDULE.SCHEDULED_FINISH_DATE%TYPE --File.Sql.39 bug 4440895
6188: )
6189: IS
6190:

Line 6199: ,pa_proj_elements ppe

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
6203: pev.element_version_id = p_dlvr_id

Line 6223: ,pa_proj_elements ppe

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
6227: pev.element_version_id = p_dlvr_id