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

Line 79: , p_object_type IN PA_PROJ_ELEMENTS.OBJECT_TYPE%TYPE := 'PA_DELIVERABLES'

75: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
76: , p_debug_mode IN VARCHAR2 := 'N'
77: , p_max_msg_count IN NUMBER := NULL
78: , p_record_version_number IN NUMBER := 1
79: , p_object_type IN PA_PROJ_ELEMENTS.OBJECT_TYPE%TYPE := 'PA_DELIVERABLES'
80: , p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE
81: , p_dlvr_number IN PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE
82: , p_dlvr_name IN PA_PROJ_ELEMENTS.NAME%TYPE
83: , p_dlvr_description IN PA_PROJ_ELEMENTS.DESCRIPTION%TYPE := NULL

Line 80: , p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE

76: , p_debug_mode IN VARCHAR2 := 'N'
77: , p_max_msg_count IN NUMBER := NULL
78: , p_record_version_number IN NUMBER := 1
79: , p_object_type IN PA_PROJ_ELEMENTS.OBJECT_TYPE%TYPE := 'PA_DELIVERABLES'
80: , p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE
81: , p_dlvr_number IN PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE
82: , p_dlvr_name IN PA_PROJ_ELEMENTS.NAME%TYPE
83: , p_dlvr_description IN PA_PROJ_ELEMENTS.DESCRIPTION%TYPE := NULL
84: , p_dlvr_owner_id IN PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE := NULL

Line 81: , p_dlvr_number IN PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE

77: , p_max_msg_count IN NUMBER := NULL
78: , p_record_version_number IN NUMBER := 1
79: , p_object_type IN PA_PROJ_ELEMENTS.OBJECT_TYPE%TYPE := 'PA_DELIVERABLES'
80: , p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE
81: , p_dlvr_number IN PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE
82: , p_dlvr_name IN PA_PROJ_ELEMENTS.NAME%TYPE
83: , p_dlvr_description IN PA_PROJ_ELEMENTS.DESCRIPTION%TYPE := NULL
84: , p_dlvr_owner_id IN PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE := NULL
85: , p_dlvr_owner_name IN VARCHAR2 := NULL

Line 82: , p_dlvr_name IN PA_PROJ_ELEMENTS.NAME%TYPE

78: , p_record_version_number IN NUMBER := 1
79: , p_object_type IN PA_PROJ_ELEMENTS.OBJECT_TYPE%TYPE := 'PA_DELIVERABLES'
80: , p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE
81: , p_dlvr_number IN PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE
82: , p_dlvr_name IN PA_PROJ_ELEMENTS.NAME%TYPE
83: , p_dlvr_description IN PA_PROJ_ELEMENTS.DESCRIPTION%TYPE := NULL
84: , p_dlvr_owner_id IN PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE := NULL
85: , p_dlvr_owner_name IN VARCHAR2 := NULL
86: , p_carrying_out_org_id IN PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE := NULL

Line 83: , p_dlvr_description IN PA_PROJ_ELEMENTS.DESCRIPTION%TYPE := NULL

79: , p_object_type IN PA_PROJ_ELEMENTS.OBJECT_TYPE%TYPE := 'PA_DELIVERABLES'
80: , p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE
81: , p_dlvr_number IN PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE
82: , p_dlvr_name IN PA_PROJ_ELEMENTS.NAME%TYPE
83: , p_dlvr_description IN PA_PROJ_ELEMENTS.DESCRIPTION%TYPE := NULL
84: , p_dlvr_owner_id IN PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE := NULL
85: , p_dlvr_owner_name IN VARCHAR2 := NULL
86: , p_carrying_out_org_id IN PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE := NULL
87: , p_carrying_out_org_name IN VARCHAR2 := NULL

Line 84: , p_dlvr_owner_id IN PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE := NULL

80: , p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE
81: , p_dlvr_number IN PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE
82: , p_dlvr_name IN PA_PROJ_ELEMENTS.NAME%TYPE
83: , p_dlvr_description IN PA_PROJ_ELEMENTS.DESCRIPTION%TYPE := NULL
84: , p_dlvr_owner_id IN PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE := NULL
85: , p_dlvr_owner_name IN VARCHAR2 := NULL
86: , p_carrying_out_org_id IN PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE := NULL
87: , p_carrying_out_org_name IN VARCHAR2 := NULL
88: , p_dlvr_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE := NULL

Line 86: , p_carrying_out_org_id IN PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE := NULL

82: , p_dlvr_name IN PA_PROJ_ELEMENTS.NAME%TYPE
83: , p_dlvr_description IN PA_PROJ_ELEMENTS.DESCRIPTION%TYPE := NULL
84: , p_dlvr_owner_id IN PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE := NULL
85: , p_dlvr_owner_name IN VARCHAR2 := NULL
86: , p_carrying_out_org_id IN PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE := NULL
87: , p_carrying_out_org_name IN VARCHAR2 := NULL
88: , p_dlvr_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE := NULL
89: , p_status_code IN PA_PROJ_ELEMENTS.STATUS_CODE%TYPE := NULL
90: , p_parent_structure_id IN PA_PROJ_ELEMENTS.PARENT_STRUCTURE_ID%TYPE := NULL

Line 89: , p_status_code IN PA_PROJ_ELEMENTS.STATUS_CODE%TYPE := NULL

85: , p_dlvr_owner_name IN VARCHAR2 := NULL
86: , p_carrying_out_org_id IN PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE := NULL
87: , p_carrying_out_org_name IN VARCHAR2 := NULL
88: , p_dlvr_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE := NULL
89: , p_status_code IN PA_PROJ_ELEMENTS.STATUS_CODE%TYPE := NULL
90: , p_parent_structure_id IN PA_PROJ_ELEMENTS.PARENT_STRUCTURE_ID%TYPE := NULL
91: , p_dlvr_type_id IN PA_PROJ_ELEMENTS.TYPE_ID%TYPE := NULL
92: , p_dlvr_type_name IN VARCHAR2 := NULL
93: , p_progress_weight IN PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE := NULL

Line 90: , p_parent_structure_id IN PA_PROJ_ELEMENTS.PARENT_STRUCTURE_ID%TYPE := NULL

86: , p_carrying_out_org_id IN PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE := NULL
87: , p_carrying_out_org_name IN VARCHAR2 := NULL
88: , p_dlvr_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE := NULL
89: , p_status_code IN PA_PROJ_ELEMENTS.STATUS_CODE%TYPE := NULL
90: , p_parent_structure_id IN PA_PROJ_ELEMENTS.PARENT_STRUCTURE_ID%TYPE := NULL
91: , p_dlvr_type_id IN PA_PROJ_ELEMENTS.TYPE_ID%TYPE := NULL
92: , p_dlvr_type_name IN VARCHAR2 := NULL
93: , p_progress_weight IN PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE := NULL
94: , p_scheduled_finish_date IN PA_PROJ_ELEM_VER_SCHEDULE.SCHEDULED_FINISH_DATE%TYPE := NULL

Line 91: , p_dlvr_type_id IN PA_PROJ_ELEMENTS.TYPE_ID%TYPE := NULL

87: , p_carrying_out_org_name IN VARCHAR2 := NULL
88: , p_dlvr_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE := NULL
89: , p_status_code IN PA_PROJ_ELEMENTS.STATUS_CODE%TYPE := NULL
90: , p_parent_structure_id IN PA_PROJ_ELEMENTS.PARENT_STRUCTURE_ID%TYPE := NULL
91: , p_dlvr_type_id IN PA_PROJ_ELEMENTS.TYPE_ID%TYPE := NULL
92: , p_dlvr_type_name IN VARCHAR2 := NULL
93: , p_progress_weight IN PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE := NULL
94: , p_scheduled_finish_date IN PA_PROJ_ELEM_VER_SCHEDULE.SCHEDULED_FINISH_DATE%TYPE := NULL
95: , p_actual_finish_date IN PA_PROJ_ELEM_VER_SCHEDULE.ACTUAL_FINISH_DATE%TYPE := NULL

Line 93: , p_progress_weight IN PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE := NULL

89: , p_status_code IN PA_PROJ_ELEMENTS.STATUS_CODE%TYPE := NULL
90: , p_parent_structure_id IN PA_PROJ_ELEMENTS.PARENT_STRUCTURE_ID%TYPE := NULL
91: , p_dlvr_type_id IN PA_PROJ_ELEMENTS.TYPE_ID%TYPE := NULL
92: , p_dlvr_type_name IN VARCHAR2 := NULL
93: , p_progress_weight IN PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE := NULL
94: , p_scheduled_finish_date IN PA_PROJ_ELEM_VER_SCHEDULE.SCHEDULED_FINISH_DATE%TYPE := NULL
95: , p_actual_finish_date IN PA_PROJ_ELEM_VER_SCHEDULE.ACTUAL_FINISH_DATE%TYPE := NULL
96: , p_task_id IN NUMBER := NULL
97: , p_task_version_id IN NUMBER := NULL

Line 100: , p_attribute_category IN PA_PROJ_ELEMENTS.ATTRIBUTE_CATEGORY%TYPE := NULL

96: , p_task_id IN NUMBER := NULL
97: , p_task_version_id IN NUMBER := NULL
98: , p_task_name IN VARCHAR2 := NULL
99: , p_deliverable_reference IN VARCHAR2 := NULL
100: , p_attribute_category IN PA_PROJ_ELEMENTS.ATTRIBUTE_CATEGORY%TYPE := NULL
101: , p_attribute1 IN PA_PROJ_ELEMENTS.ATTRIBUTE1%TYPE := NULL
102: , p_attribute2 IN PA_PROJ_ELEMENTS.ATTRIBUTE2%TYPE := NULL
103: , p_attribute3 IN PA_PROJ_ELEMENTS.ATTRIBUTE3%TYPE := NULL
104: , p_attribute4 IN PA_PROJ_ELEMENTS.ATTRIBUTE4%TYPE := NULL

Line 101: , p_attribute1 IN PA_PROJ_ELEMENTS.ATTRIBUTE1%TYPE := NULL

97: , p_task_version_id IN NUMBER := NULL
98: , p_task_name IN VARCHAR2 := NULL
99: , p_deliverable_reference IN VARCHAR2 := NULL
100: , p_attribute_category IN PA_PROJ_ELEMENTS.ATTRIBUTE_CATEGORY%TYPE := NULL
101: , p_attribute1 IN PA_PROJ_ELEMENTS.ATTRIBUTE1%TYPE := NULL
102: , p_attribute2 IN PA_PROJ_ELEMENTS.ATTRIBUTE2%TYPE := NULL
103: , p_attribute3 IN PA_PROJ_ELEMENTS.ATTRIBUTE3%TYPE := NULL
104: , p_attribute4 IN PA_PROJ_ELEMENTS.ATTRIBUTE4%TYPE := NULL
105: , p_attribute5 IN PA_PROJ_ELEMENTS.ATTRIBUTE5%TYPE := NULL

Line 102: , p_attribute2 IN PA_PROJ_ELEMENTS.ATTRIBUTE2%TYPE := NULL

98: , p_task_name IN VARCHAR2 := NULL
99: , p_deliverable_reference IN VARCHAR2 := NULL
100: , p_attribute_category IN PA_PROJ_ELEMENTS.ATTRIBUTE_CATEGORY%TYPE := NULL
101: , p_attribute1 IN PA_PROJ_ELEMENTS.ATTRIBUTE1%TYPE := NULL
102: , p_attribute2 IN PA_PROJ_ELEMENTS.ATTRIBUTE2%TYPE := NULL
103: , p_attribute3 IN PA_PROJ_ELEMENTS.ATTRIBUTE3%TYPE := NULL
104: , p_attribute4 IN PA_PROJ_ELEMENTS.ATTRIBUTE4%TYPE := NULL
105: , p_attribute5 IN PA_PROJ_ELEMENTS.ATTRIBUTE5%TYPE := NULL
106: , p_attribute6 IN PA_PROJ_ELEMENTS.ATTRIBUTE6%TYPE := NULL

Line 103: , p_attribute3 IN PA_PROJ_ELEMENTS.ATTRIBUTE3%TYPE := NULL

99: , p_deliverable_reference IN VARCHAR2 := NULL
100: , p_attribute_category IN PA_PROJ_ELEMENTS.ATTRIBUTE_CATEGORY%TYPE := NULL
101: , p_attribute1 IN PA_PROJ_ELEMENTS.ATTRIBUTE1%TYPE := NULL
102: , p_attribute2 IN PA_PROJ_ELEMENTS.ATTRIBUTE2%TYPE := NULL
103: , p_attribute3 IN PA_PROJ_ELEMENTS.ATTRIBUTE3%TYPE := NULL
104: , p_attribute4 IN PA_PROJ_ELEMENTS.ATTRIBUTE4%TYPE := NULL
105: , p_attribute5 IN PA_PROJ_ELEMENTS.ATTRIBUTE5%TYPE := NULL
106: , p_attribute6 IN PA_PROJ_ELEMENTS.ATTRIBUTE6%TYPE := NULL
107: , p_attribute7 IN PA_PROJ_ELEMENTS.ATTRIBUTE7%TYPE := NULL

Line 104: , p_attribute4 IN PA_PROJ_ELEMENTS.ATTRIBUTE4%TYPE := NULL

100: , p_attribute_category IN PA_PROJ_ELEMENTS.ATTRIBUTE_CATEGORY%TYPE := NULL
101: , p_attribute1 IN PA_PROJ_ELEMENTS.ATTRIBUTE1%TYPE := NULL
102: , p_attribute2 IN PA_PROJ_ELEMENTS.ATTRIBUTE2%TYPE := NULL
103: , p_attribute3 IN PA_PROJ_ELEMENTS.ATTRIBUTE3%TYPE := NULL
104: , p_attribute4 IN PA_PROJ_ELEMENTS.ATTRIBUTE4%TYPE := NULL
105: , p_attribute5 IN PA_PROJ_ELEMENTS.ATTRIBUTE5%TYPE := NULL
106: , p_attribute6 IN PA_PROJ_ELEMENTS.ATTRIBUTE6%TYPE := NULL
107: , p_attribute7 IN PA_PROJ_ELEMENTS.ATTRIBUTE7%TYPE := NULL
108: , p_attribute8 IN PA_PROJ_ELEMENTS.ATTRIBUTE8%TYPE := NULL

Line 105: , p_attribute5 IN PA_PROJ_ELEMENTS.ATTRIBUTE5%TYPE := NULL

101: , p_attribute1 IN PA_PROJ_ELEMENTS.ATTRIBUTE1%TYPE := NULL
102: , p_attribute2 IN PA_PROJ_ELEMENTS.ATTRIBUTE2%TYPE := NULL
103: , p_attribute3 IN PA_PROJ_ELEMENTS.ATTRIBUTE3%TYPE := NULL
104: , p_attribute4 IN PA_PROJ_ELEMENTS.ATTRIBUTE4%TYPE := NULL
105: , p_attribute5 IN PA_PROJ_ELEMENTS.ATTRIBUTE5%TYPE := NULL
106: , p_attribute6 IN PA_PROJ_ELEMENTS.ATTRIBUTE6%TYPE := NULL
107: , p_attribute7 IN PA_PROJ_ELEMENTS.ATTRIBUTE7%TYPE := NULL
108: , p_attribute8 IN PA_PROJ_ELEMENTS.ATTRIBUTE8%TYPE := NULL
109: , p_attribute9 IN PA_PROJ_ELEMENTS.ATTRIBUTE9%TYPE := NULL

Line 106: , p_attribute6 IN PA_PROJ_ELEMENTS.ATTRIBUTE6%TYPE := NULL

102: , p_attribute2 IN PA_PROJ_ELEMENTS.ATTRIBUTE2%TYPE := NULL
103: , p_attribute3 IN PA_PROJ_ELEMENTS.ATTRIBUTE3%TYPE := NULL
104: , p_attribute4 IN PA_PROJ_ELEMENTS.ATTRIBUTE4%TYPE := NULL
105: , p_attribute5 IN PA_PROJ_ELEMENTS.ATTRIBUTE5%TYPE := NULL
106: , p_attribute6 IN PA_PROJ_ELEMENTS.ATTRIBUTE6%TYPE := NULL
107: , p_attribute7 IN PA_PROJ_ELEMENTS.ATTRIBUTE7%TYPE := NULL
108: , p_attribute8 IN PA_PROJ_ELEMENTS.ATTRIBUTE8%TYPE := NULL
109: , p_attribute9 IN PA_PROJ_ELEMENTS.ATTRIBUTE9%TYPE := NULL
110: , p_attribute10 IN PA_PROJ_ELEMENTS.ATTRIBUTE10%TYPE := NULL

Line 107: , p_attribute7 IN PA_PROJ_ELEMENTS.ATTRIBUTE7%TYPE := NULL

103: , p_attribute3 IN PA_PROJ_ELEMENTS.ATTRIBUTE3%TYPE := NULL
104: , p_attribute4 IN PA_PROJ_ELEMENTS.ATTRIBUTE4%TYPE := NULL
105: , p_attribute5 IN PA_PROJ_ELEMENTS.ATTRIBUTE5%TYPE := NULL
106: , p_attribute6 IN PA_PROJ_ELEMENTS.ATTRIBUTE6%TYPE := NULL
107: , p_attribute7 IN PA_PROJ_ELEMENTS.ATTRIBUTE7%TYPE := NULL
108: , p_attribute8 IN PA_PROJ_ELEMENTS.ATTRIBUTE8%TYPE := NULL
109: , p_attribute9 IN PA_PROJ_ELEMENTS.ATTRIBUTE9%TYPE := NULL
110: , p_attribute10 IN PA_PROJ_ELEMENTS.ATTRIBUTE10%TYPE := NULL
111: , p_attribute11 IN PA_PROJ_ELEMENTS.ATTRIBUTE11%TYPE := NULL

Line 108: , p_attribute8 IN PA_PROJ_ELEMENTS.ATTRIBUTE8%TYPE := NULL

104: , p_attribute4 IN PA_PROJ_ELEMENTS.ATTRIBUTE4%TYPE := NULL
105: , p_attribute5 IN PA_PROJ_ELEMENTS.ATTRIBUTE5%TYPE := NULL
106: , p_attribute6 IN PA_PROJ_ELEMENTS.ATTRIBUTE6%TYPE := NULL
107: , p_attribute7 IN PA_PROJ_ELEMENTS.ATTRIBUTE7%TYPE := NULL
108: , p_attribute8 IN PA_PROJ_ELEMENTS.ATTRIBUTE8%TYPE := NULL
109: , p_attribute9 IN PA_PROJ_ELEMENTS.ATTRIBUTE9%TYPE := NULL
110: , p_attribute10 IN PA_PROJ_ELEMENTS.ATTRIBUTE10%TYPE := NULL
111: , p_attribute11 IN PA_PROJ_ELEMENTS.ATTRIBUTE11%TYPE := NULL
112: , p_attribute12 IN PA_PROJ_ELEMENTS.ATTRIBUTE12%TYPE := NULL

Line 109: , p_attribute9 IN PA_PROJ_ELEMENTS.ATTRIBUTE9%TYPE := NULL

105: , p_attribute5 IN PA_PROJ_ELEMENTS.ATTRIBUTE5%TYPE := NULL
106: , p_attribute6 IN PA_PROJ_ELEMENTS.ATTRIBUTE6%TYPE := NULL
107: , p_attribute7 IN PA_PROJ_ELEMENTS.ATTRIBUTE7%TYPE := NULL
108: , p_attribute8 IN PA_PROJ_ELEMENTS.ATTRIBUTE8%TYPE := NULL
109: , p_attribute9 IN PA_PROJ_ELEMENTS.ATTRIBUTE9%TYPE := NULL
110: , p_attribute10 IN PA_PROJ_ELEMENTS.ATTRIBUTE10%TYPE := NULL
111: , p_attribute11 IN PA_PROJ_ELEMENTS.ATTRIBUTE11%TYPE := NULL
112: , p_attribute12 IN PA_PROJ_ELEMENTS.ATTRIBUTE12%TYPE := NULL
113: , p_attribute13 IN PA_PROJ_ELEMENTS.ATTRIBUTE13%TYPE := NULL

Line 110: , p_attribute10 IN PA_PROJ_ELEMENTS.ATTRIBUTE10%TYPE := NULL

106: , p_attribute6 IN PA_PROJ_ELEMENTS.ATTRIBUTE6%TYPE := NULL
107: , p_attribute7 IN PA_PROJ_ELEMENTS.ATTRIBUTE7%TYPE := NULL
108: , p_attribute8 IN PA_PROJ_ELEMENTS.ATTRIBUTE8%TYPE := NULL
109: , p_attribute9 IN PA_PROJ_ELEMENTS.ATTRIBUTE9%TYPE := NULL
110: , p_attribute10 IN PA_PROJ_ELEMENTS.ATTRIBUTE10%TYPE := NULL
111: , p_attribute11 IN PA_PROJ_ELEMENTS.ATTRIBUTE11%TYPE := NULL
112: , p_attribute12 IN PA_PROJ_ELEMENTS.ATTRIBUTE12%TYPE := NULL
113: , p_attribute13 IN PA_PROJ_ELEMENTS.ATTRIBUTE13%TYPE := NULL
114: , p_attribute14 IN PA_PROJ_ELEMENTS.ATTRIBUTE14%TYPE := NULL

Line 111: , p_attribute11 IN PA_PROJ_ELEMENTS.ATTRIBUTE11%TYPE := NULL

107: , p_attribute7 IN PA_PROJ_ELEMENTS.ATTRIBUTE7%TYPE := NULL
108: , p_attribute8 IN PA_PROJ_ELEMENTS.ATTRIBUTE8%TYPE := NULL
109: , p_attribute9 IN PA_PROJ_ELEMENTS.ATTRIBUTE9%TYPE := NULL
110: , p_attribute10 IN PA_PROJ_ELEMENTS.ATTRIBUTE10%TYPE := NULL
111: , p_attribute11 IN PA_PROJ_ELEMENTS.ATTRIBUTE11%TYPE := NULL
112: , p_attribute12 IN PA_PROJ_ELEMENTS.ATTRIBUTE12%TYPE := NULL
113: , p_attribute13 IN PA_PROJ_ELEMENTS.ATTRIBUTE13%TYPE := NULL
114: , p_attribute14 IN PA_PROJ_ELEMENTS.ATTRIBUTE14%TYPE := NULL
115: , p_attribute15 IN PA_PROJ_ELEMENTS.ATTRIBUTE15%TYPE := NULL

Line 112: , p_attribute12 IN PA_PROJ_ELEMENTS.ATTRIBUTE12%TYPE := NULL

108: , p_attribute8 IN PA_PROJ_ELEMENTS.ATTRIBUTE8%TYPE := NULL
109: , p_attribute9 IN PA_PROJ_ELEMENTS.ATTRIBUTE9%TYPE := NULL
110: , p_attribute10 IN PA_PROJ_ELEMENTS.ATTRIBUTE10%TYPE := NULL
111: , p_attribute11 IN PA_PROJ_ELEMENTS.ATTRIBUTE11%TYPE := NULL
112: , p_attribute12 IN PA_PROJ_ELEMENTS.ATTRIBUTE12%TYPE := NULL
113: , p_attribute13 IN PA_PROJ_ELEMENTS.ATTRIBUTE13%TYPE := NULL
114: , p_attribute14 IN PA_PROJ_ELEMENTS.ATTRIBUTE14%TYPE := NULL
115: , p_attribute15 IN PA_PROJ_ELEMENTS.ATTRIBUTE15%TYPE := NULL
116: , p_item_id IN NUMBER := NULL

Line 113: , p_attribute13 IN PA_PROJ_ELEMENTS.ATTRIBUTE13%TYPE := NULL

109: , p_attribute9 IN PA_PROJ_ELEMENTS.ATTRIBUTE9%TYPE := NULL
110: , p_attribute10 IN PA_PROJ_ELEMENTS.ATTRIBUTE10%TYPE := NULL
111: , p_attribute11 IN PA_PROJ_ELEMENTS.ATTRIBUTE11%TYPE := NULL
112: , p_attribute12 IN PA_PROJ_ELEMENTS.ATTRIBUTE12%TYPE := NULL
113: , p_attribute13 IN PA_PROJ_ELEMENTS.ATTRIBUTE13%TYPE := NULL
114: , p_attribute14 IN PA_PROJ_ELEMENTS.ATTRIBUTE14%TYPE := NULL
115: , p_attribute15 IN PA_PROJ_ELEMENTS.ATTRIBUTE15%TYPE := NULL
116: , p_item_id IN NUMBER := NULL
117: , p_inventory_org_id IN NUMBER := NULL

Line 114: , p_attribute14 IN PA_PROJ_ELEMENTS.ATTRIBUTE14%TYPE := NULL

110: , p_attribute10 IN PA_PROJ_ELEMENTS.ATTRIBUTE10%TYPE := NULL
111: , p_attribute11 IN PA_PROJ_ELEMENTS.ATTRIBUTE11%TYPE := NULL
112: , p_attribute12 IN PA_PROJ_ELEMENTS.ATTRIBUTE12%TYPE := NULL
113: , p_attribute13 IN PA_PROJ_ELEMENTS.ATTRIBUTE13%TYPE := NULL
114: , p_attribute14 IN PA_PROJ_ELEMENTS.ATTRIBUTE14%TYPE := NULL
115: , p_attribute15 IN PA_PROJ_ELEMENTS.ATTRIBUTE15%TYPE := NULL
116: , p_item_id IN NUMBER := NULL
117: , p_inventory_org_id IN NUMBER := NULL
118: , p_quantity IN NUMBER := NULL

Line 115: , p_attribute15 IN PA_PROJ_ELEMENTS.ATTRIBUTE15%TYPE := NULL

111: , p_attribute11 IN PA_PROJ_ELEMENTS.ATTRIBUTE11%TYPE := NULL
112: , p_attribute12 IN PA_PROJ_ELEMENTS.ATTRIBUTE12%TYPE := NULL
113: , p_attribute13 IN PA_PROJ_ELEMENTS.ATTRIBUTE13%TYPE := NULL
114: , p_attribute14 IN PA_PROJ_ELEMENTS.ATTRIBUTE14%TYPE := NULL
115: , p_attribute15 IN PA_PROJ_ELEMENTS.ATTRIBUTE15%TYPE := NULL
116: , p_item_id IN NUMBER := NULL
117: , p_inventory_org_id IN NUMBER := NULL
118: , p_quantity IN NUMBER := NULL
119: , p_uom_code IN VARCHAR2 := NULL

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

121: , p_unit_price IN NUMBER := NULL
122: , p_unit_number IN VARCHAR2 := NULL
123: , p_currency_code IN VARCHAR2 := NULL
124: , p_pm_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR /* Bug no. 3651113 */
125: , p_dlvr_item_id OUT NOCOPY PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE --File.Sql.39 bug 4440895
126: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
127: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
128: , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
129: )

Line 151: l_dlvr_description PA_PROJ_ELEMENTS.DESCRIPTION%TYPE;

147: l_element_structure_id NUMBER;
148: is_dlvr_number_unique VARCHAR2(1) := 'N';
149: l_carrying_out_org NUMBER := NULL;
150:
151: l_dlvr_description PA_PROJ_ELEMENTS.DESCRIPTION%TYPE;
152: l_dlvr_owner_id PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE;
153: l_carrying_out_org_id PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE;
154: l_progress_weight PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE;
155: l_scheduled_finish_date DATE;

Line 152: l_dlvr_owner_id PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE;

148: is_dlvr_number_unique VARCHAR2(1) := 'N';
149: l_carrying_out_org NUMBER := NULL;
150:
151: l_dlvr_description PA_PROJ_ELEMENTS.DESCRIPTION%TYPE;
152: l_dlvr_owner_id PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE;
153: l_carrying_out_org_id PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE;
154: l_progress_weight PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE;
155: l_scheduled_finish_date DATE;
156: l_actual_finish_date DATE;

Line 153: l_carrying_out_org_id PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE;

149: l_carrying_out_org NUMBER := NULL;
150:
151: l_dlvr_description PA_PROJ_ELEMENTS.DESCRIPTION%TYPE;
152: l_dlvr_owner_id PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE;
153: l_carrying_out_org_id PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE;
154: l_progress_weight PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE;
155: l_scheduled_finish_date DATE;
156: l_actual_finish_date DATE;
157: l_dlvr_version_id PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE;

Line 154: l_progress_weight PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE;

150:
151: l_dlvr_description PA_PROJ_ELEMENTS.DESCRIPTION%TYPE;
152: l_dlvr_owner_id PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE;
153: l_carrying_out_org_id PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE;
154: l_progress_weight PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE;
155: l_scheduled_finish_date DATE;
156: l_actual_finish_date DATE;
157: l_dlvr_version_id PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE;
158:

Line 168: l_task_number Pa_Proj_Elements.Name%TYPE;

164: l_item_dlv VARCHAR2(1) := NULL;
165: l_dlv_rec oke_amg_grp.dlv_rec_type;
166:
167: l_project_number Pa_Projects_All.Segment1%TYPE;
168: l_task_number Pa_Proj_Elements.Name%TYPE;
169:
170: l_item_id OKE_DELIVERABLES_B.ITEM_ID%TYPE;
171: l_inventory_org_id OKE_DELIVERABLES_B.INVENTORY_ORG_ID%TYPE;
172: l_quantity OKE_DELIVERABLES_B.QUANTITY%TYPE;

Line 239: FROM Pa_Proj_Elements

235:
236: -- Fetching Task Name , Project Name to use as token in Error Messages.
237: IF (p_task_id IS NOT NULL AND p_task_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) THEN
238: SELECT name INTO l_task_number
239: FROM Pa_Proj_Elements
240: WHERE proj_element_id = p_task_id;
241: ELSE
242: l_task_number := null;
243: END IF;

Line 468: is_dlvr_number_unique := PA_PROJ_ELEMENTS_UTILS.Check_element_NUmber_Unique

464:
465: -- check for dlvr_number uniqueness
466: -- check for dlvr_number uniqueness
467:
468: is_dlvr_number_unique := PA_PROJ_ELEMENTS_UTILS.Check_element_NUmber_Unique
469: (
470: p_element_number => p_dlvr_number
471: ,p_element_id => l_element_id
472: ,p_project_id => p_project_id

Line 858: , p_object_type IN PA_PROJ_ELEMENTS.OBJECT_TYPE%TYPE := 'PA_DELIVERABLES'

854: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
855: , p_debug_mode IN VARCHAR2 := 'N'
856: , p_max_msg_count IN NUMBER := NULL
857: , p_record_version_number IN NUMBER := 1
858: , p_object_type IN PA_PROJ_ELEMENTS.OBJECT_TYPE%TYPE := 'PA_DELIVERABLES'
859: , p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE
860: , p_dlvr_number IN PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE
861: , p_dlvr_name IN PA_PROJ_ELEMENTS.NAME%TYPE
862: , p_dlvr_description IN PA_PROJ_ELEMENTS.DESCRIPTION%TYPE := NULL

Line 859: , p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE

855: , p_debug_mode IN VARCHAR2 := 'N'
856: , p_max_msg_count IN NUMBER := NULL
857: , p_record_version_number IN NUMBER := 1
858: , p_object_type IN PA_PROJ_ELEMENTS.OBJECT_TYPE%TYPE := 'PA_DELIVERABLES'
859: , p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE
860: , p_dlvr_number IN PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE
861: , p_dlvr_name IN PA_PROJ_ELEMENTS.NAME%TYPE
862: , p_dlvr_description IN PA_PROJ_ELEMENTS.DESCRIPTION%TYPE := NULL
863: , p_dlvr_owner_id IN PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE := NULL

Line 860: , p_dlvr_number IN PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE

856: , p_max_msg_count IN NUMBER := NULL
857: , p_record_version_number IN NUMBER := 1
858: , p_object_type IN PA_PROJ_ELEMENTS.OBJECT_TYPE%TYPE := 'PA_DELIVERABLES'
859: , p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE
860: , p_dlvr_number IN PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE
861: , p_dlvr_name IN PA_PROJ_ELEMENTS.NAME%TYPE
862: , p_dlvr_description IN PA_PROJ_ELEMENTS.DESCRIPTION%TYPE := NULL
863: , p_dlvr_owner_id IN PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE := NULL
864: , p_dlvr_owner_name IN VARCHAR2 := NULL

Line 861: , p_dlvr_name IN PA_PROJ_ELEMENTS.NAME%TYPE

857: , p_record_version_number IN NUMBER := 1
858: , p_object_type IN PA_PROJ_ELEMENTS.OBJECT_TYPE%TYPE := 'PA_DELIVERABLES'
859: , p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE
860: , p_dlvr_number IN PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE
861: , p_dlvr_name IN PA_PROJ_ELEMENTS.NAME%TYPE
862: , p_dlvr_description IN PA_PROJ_ELEMENTS.DESCRIPTION%TYPE := NULL
863: , p_dlvr_owner_id IN PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE := NULL
864: , p_dlvr_owner_name IN VARCHAR2 := NULL
865: , p_carrying_out_org_id IN PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE := NULL

Line 862: , p_dlvr_description IN PA_PROJ_ELEMENTS.DESCRIPTION%TYPE := NULL

858: , p_object_type IN PA_PROJ_ELEMENTS.OBJECT_TYPE%TYPE := 'PA_DELIVERABLES'
859: , p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE
860: , p_dlvr_number IN PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE
861: , p_dlvr_name IN PA_PROJ_ELEMENTS.NAME%TYPE
862: , p_dlvr_description IN PA_PROJ_ELEMENTS.DESCRIPTION%TYPE := NULL
863: , p_dlvr_owner_id IN PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE := NULL
864: , p_dlvr_owner_name IN VARCHAR2 := NULL
865: , p_carrying_out_org_id IN PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE := NULL
866: , p_carrying_out_org_name IN VARCHAR2 := NULL

Line 863: , p_dlvr_owner_id IN PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE := NULL

859: , p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE
860: , p_dlvr_number IN PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE
861: , p_dlvr_name IN PA_PROJ_ELEMENTS.NAME%TYPE
862: , p_dlvr_description IN PA_PROJ_ELEMENTS.DESCRIPTION%TYPE := NULL
863: , p_dlvr_owner_id IN PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE := NULL
864: , p_dlvr_owner_name IN VARCHAR2 := NULL
865: , p_carrying_out_org_id IN PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE := NULL
866: , p_carrying_out_org_name IN VARCHAR2 := NULL
867: , p_dlvr_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE := NULL

Line 865: , p_carrying_out_org_id IN PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE := NULL

861: , p_dlvr_name IN PA_PROJ_ELEMENTS.NAME%TYPE
862: , p_dlvr_description IN PA_PROJ_ELEMENTS.DESCRIPTION%TYPE := NULL
863: , p_dlvr_owner_id IN PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE := NULL
864: , p_dlvr_owner_name IN VARCHAR2 := NULL
865: , p_carrying_out_org_id IN PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE := NULL
866: , p_carrying_out_org_name IN VARCHAR2 := NULL
867: , p_dlvr_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE := NULL
868: , p_status_code IN PA_PROJ_ELEMENTS.STATUS_CODE%TYPE := NULL
869: , p_parent_structure_id IN PA_PROJ_ELEMENTS.PARENT_STRUCTURE_ID%TYPE := NULL

Line 868: , p_status_code IN PA_PROJ_ELEMENTS.STATUS_CODE%TYPE := NULL

864: , p_dlvr_owner_name IN VARCHAR2 := NULL
865: , p_carrying_out_org_id IN PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE := NULL
866: , p_carrying_out_org_name IN VARCHAR2 := NULL
867: , p_dlvr_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE := NULL
868: , p_status_code IN PA_PROJ_ELEMENTS.STATUS_CODE%TYPE := NULL
869: , p_parent_structure_id IN PA_PROJ_ELEMENTS.PARENT_STRUCTURE_ID%TYPE := NULL
870: , p_dlvr_type_id IN PA_PROJ_ELEMENTS.TYPE_ID%TYPE := NULL
871: , p_dlvr_type_name IN VARCHAR2 := NULL
872: , p_progress_weight IN PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE := NULL

Line 869: , p_parent_structure_id IN PA_PROJ_ELEMENTS.PARENT_STRUCTURE_ID%TYPE := NULL

865: , p_carrying_out_org_id IN PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE := NULL
866: , p_carrying_out_org_name IN VARCHAR2 := NULL
867: , p_dlvr_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE := NULL
868: , p_status_code IN PA_PROJ_ELEMENTS.STATUS_CODE%TYPE := NULL
869: , p_parent_structure_id IN PA_PROJ_ELEMENTS.PARENT_STRUCTURE_ID%TYPE := NULL
870: , p_dlvr_type_id IN PA_PROJ_ELEMENTS.TYPE_ID%TYPE := NULL
871: , p_dlvr_type_name IN VARCHAR2 := NULL
872: , p_progress_weight IN PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE := NULL
873: , p_scheduled_finish_date IN PA_PROJ_ELEM_VER_SCHEDULE.SCHEDULED_FINISH_DATE%TYPE := NULL

Line 870: , p_dlvr_type_id IN PA_PROJ_ELEMENTS.TYPE_ID%TYPE := NULL

866: , p_carrying_out_org_name IN VARCHAR2 := NULL
867: , p_dlvr_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE := NULL
868: , p_status_code IN PA_PROJ_ELEMENTS.STATUS_CODE%TYPE := NULL
869: , p_parent_structure_id IN PA_PROJ_ELEMENTS.PARENT_STRUCTURE_ID%TYPE := NULL
870: , p_dlvr_type_id IN PA_PROJ_ELEMENTS.TYPE_ID%TYPE := NULL
871: , p_dlvr_type_name IN VARCHAR2 := NULL
872: , p_progress_weight IN PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE := NULL
873: , p_scheduled_finish_date IN PA_PROJ_ELEM_VER_SCHEDULE.SCHEDULED_FINISH_DATE%TYPE := NULL
874: , p_actual_finish_date IN PA_PROJ_ELEM_VER_SCHEDULE.ACTUAL_FINISH_DATE%TYPE := NULL

Line 872: , p_progress_weight IN PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE := NULL

868: , p_status_code IN PA_PROJ_ELEMENTS.STATUS_CODE%TYPE := NULL
869: , p_parent_structure_id IN PA_PROJ_ELEMENTS.PARENT_STRUCTURE_ID%TYPE := NULL
870: , p_dlvr_type_id IN PA_PROJ_ELEMENTS.TYPE_ID%TYPE := NULL
871: , p_dlvr_type_name IN VARCHAR2 := NULL
872: , p_progress_weight IN PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE := NULL
873: , p_scheduled_finish_date IN PA_PROJ_ELEM_VER_SCHEDULE.SCHEDULED_FINISH_DATE%TYPE := NULL
874: , p_actual_finish_date IN PA_PROJ_ELEM_VER_SCHEDULE.ACTUAL_FINISH_DATE%TYPE := NULL
875: , p_task_id IN NUMBER := NULL
876: , p_task_version_id IN NUMBER := NULL

Line 879: , p_attribute_category IN PA_PROJ_ELEMENTS.ATTRIBUTE_CATEGORY%TYPE := NULL

875: , p_task_id IN NUMBER := NULL
876: , p_task_version_id IN NUMBER := NULL
877: , p_task_name IN VARCHAR2 := NULL
878: , p_deliverable_reference IN VARCHAR2 := NULL
879: , p_attribute_category IN PA_PROJ_ELEMENTS.ATTRIBUTE_CATEGORY%TYPE := NULL
880: , p_attribute1 IN PA_PROJ_ELEMENTS.ATTRIBUTE1%TYPE := NULL
881: , p_attribute2 IN PA_PROJ_ELEMENTS.ATTRIBUTE2%TYPE := NULL
882: , p_attribute3 IN PA_PROJ_ELEMENTS.ATTRIBUTE3%TYPE := NULL
883: , p_attribute4 IN PA_PROJ_ELEMENTS.ATTRIBUTE4%TYPE := NULL

Line 880: , p_attribute1 IN PA_PROJ_ELEMENTS.ATTRIBUTE1%TYPE := NULL

876: , p_task_version_id IN NUMBER := NULL
877: , p_task_name IN VARCHAR2 := NULL
878: , p_deliverable_reference IN VARCHAR2 := NULL
879: , p_attribute_category IN PA_PROJ_ELEMENTS.ATTRIBUTE_CATEGORY%TYPE := NULL
880: , p_attribute1 IN PA_PROJ_ELEMENTS.ATTRIBUTE1%TYPE := NULL
881: , p_attribute2 IN PA_PROJ_ELEMENTS.ATTRIBUTE2%TYPE := NULL
882: , p_attribute3 IN PA_PROJ_ELEMENTS.ATTRIBUTE3%TYPE := NULL
883: , p_attribute4 IN PA_PROJ_ELEMENTS.ATTRIBUTE4%TYPE := NULL
884: , p_attribute5 IN PA_PROJ_ELEMENTS.ATTRIBUTE5%TYPE := NULL

Line 881: , p_attribute2 IN PA_PROJ_ELEMENTS.ATTRIBUTE2%TYPE := NULL

877: , p_task_name IN VARCHAR2 := NULL
878: , p_deliverable_reference IN VARCHAR2 := NULL
879: , p_attribute_category IN PA_PROJ_ELEMENTS.ATTRIBUTE_CATEGORY%TYPE := NULL
880: , p_attribute1 IN PA_PROJ_ELEMENTS.ATTRIBUTE1%TYPE := NULL
881: , p_attribute2 IN PA_PROJ_ELEMENTS.ATTRIBUTE2%TYPE := NULL
882: , p_attribute3 IN PA_PROJ_ELEMENTS.ATTRIBUTE3%TYPE := NULL
883: , p_attribute4 IN PA_PROJ_ELEMENTS.ATTRIBUTE4%TYPE := NULL
884: , p_attribute5 IN PA_PROJ_ELEMENTS.ATTRIBUTE5%TYPE := NULL
885: , p_attribute6 IN PA_PROJ_ELEMENTS.ATTRIBUTE6%TYPE := NULL

Line 882: , p_attribute3 IN PA_PROJ_ELEMENTS.ATTRIBUTE3%TYPE := NULL

878: , p_deliverable_reference IN VARCHAR2 := NULL
879: , p_attribute_category IN PA_PROJ_ELEMENTS.ATTRIBUTE_CATEGORY%TYPE := NULL
880: , p_attribute1 IN PA_PROJ_ELEMENTS.ATTRIBUTE1%TYPE := NULL
881: , p_attribute2 IN PA_PROJ_ELEMENTS.ATTRIBUTE2%TYPE := NULL
882: , p_attribute3 IN PA_PROJ_ELEMENTS.ATTRIBUTE3%TYPE := NULL
883: , p_attribute4 IN PA_PROJ_ELEMENTS.ATTRIBUTE4%TYPE := NULL
884: , p_attribute5 IN PA_PROJ_ELEMENTS.ATTRIBUTE5%TYPE := NULL
885: , p_attribute6 IN PA_PROJ_ELEMENTS.ATTRIBUTE6%TYPE := NULL
886: , p_attribute7 IN PA_PROJ_ELEMENTS.ATTRIBUTE7%TYPE := NULL

Line 883: , p_attribute4 IN PA_PROJ_ELEMENTS.ATTRIBUTE4%TYPE := NULL

879: , p_attribute_category IN PA_PROJ_ELEMENTS.ATTRIBUTE_CATEGORY%TYPE := NULL
880: , p_attribute1 IN PA_PROJ_ELEMENTS.ATTRIBUTE1%TYPE := NULL
881: , p_attribute2 IN PA_PROJ_ELEMENTS.ATTRIBUTE2%TYPE := NULL
882: , p_attribute3 IN PA_PROJ_ELEMENTS.ATTRIBUTE3%TYPE := NULL
883: , p_attribute4 IN PA_PROJ_ELEMENTS.ATTRIBUTE4%TYPE := NULL
884: , p_attribute5 IN PA_PROJ_ELEMENTS.ATTRIBUTE5%TYPE := NULL
885: , p_attribute6 IN PA_PROJ_ELEMENTS.ATTRIBUTE6%TYPE := NULL
886: , p_attribute7 IN PA_PROJ_ELEMENTS.ATTRIBUTE7%TYPE := NULL
887: , p_attribute8 IN PA_PROJ_ELEMENTS.ATTRIBUTE8%TYPE := NULL

Line 884: , p_attribute5 IN PA_PROJ_ELEMENTS.ATTRIBUTE5%TYPE := NULL

880: , p_attribute1 IN PA_PROJ_ELEMENTS.ATTRIBUTE1%TYPE := NULL
881: , p_attribute2 IN PA_PROJ_ELEMENTS.ATTRIBUTE2%TYPE := NULL
882: , p_attribute3 IN PA_PROJ_ELEMENTS.ATTRIBUTE3%TYPE := NULL
883: , p_attribute4 IN PA_PROJ_ELEMENTS.ATTRIBUTE4%TYPE := NULL
884: , p_attribute5 IN PA_PROJ_ELEMENTS.ATTRIBUTE5%TYPE := NULL
885: , p_attribute6 IN PA_PROJ_ELEMENTS.ATTRIBUTE6%TYPE := NULL
886: , p_attribute7 IN PA_PROJ_ELEMENTS.ATTRIBUTE7%TYPE := NULL
887: , p_attribute8 IN PA_PROJ_ELEMENTS.ATTRIBUTE8%TYPE := NULL
888: , p_attribute9 IN PA_PROJ_ELEMENTS.ATTRIBUTE9%TYPE := NULL

Line 885: , p_attribute6 IN PA_PROJ_ELEMENTS.ATTRIBUTE6%TYPE := NULL

881: , p_attribute2 IN PA_PROJ_ELEMENTS.ATTRIBUTE2%TYPE := NULL
882: , p_attribute3 IN PA_PROJ_ELEMENTS.ATTRIBUTE3%TYPE := NULL
883: , p_attribute4 IN PA_PROJ_ELEMENTS.ATTRIBUTE4%TYPE := NULL
884: , p_attribute5 IN PA_PROJ_ELEMENTS.ATTRIBUTE5%TYPE := NULL
885: , p_attribute6 IN PA_PROJ_ELEMENTS.ATTRIBUTE6%TYPE := NULL
886: , p_attribute7 IN PA_PROJ_ELEMENTS.ATTRIBUTE7%TYPE := NULL
887: , p_attribute8 IN PA_PROJ_ELEMENTS.ATTRIBUTE8%TYPE := NULL
888: , p_attribute9 IN PA_PROJ_ELEMENTS.ATTRIBUTE9%TYPE := NULL
889: , p_attribute10 IN PA_PROJ_ELEMENTS.ATTRIBUTE10%TYPE := NULL

Line 886: , p_attribute7 IN PA_PROJ_ELEMENTS.ATTRIBUTE7%TYPE := NULL

882: , p_attribute3 IN PA_PROJ_ELEMENTS.ATTRIBUTE3%TYPE := NULL
883: , p_attribute4 IN PA_PROJ_ELEMENTS.ATTRIBUTE4%TYPE := NULL
884: , p_attribute5 IN PA_PROJ_ELEMENTS.ATTRIBUTE5%TYPE := NULL
885: , p_attribute6 IN PA_PROJ_ELEMENTS.ATTRIBUTE6%TYPE := NULL
886: , p_attribute7 IN PA_PROJ_ELEMENTS.ATTRIBUTE7%TYPE := NULL
887: , p_attribute8 IN PA_PROJ_ELEMENTS.ATTRIBUTE8%TYPE := NULL
888: , p_attribute9 IN PA_PROJ_ELEMENTS.ATTRIBUTE9%TYPE := NULL
889: , p_attribute10 IN PA_PROJ_ELEMENTS.ATTRIBUTE10%TYPE := NULL
890: , p_attribute11 IN PA_PROJ_ELEMENTS.ATTRIBUTE11%TYPE := NULL

Line 887: , p_attribute8 IN PA_PROJ_ELEMENTS.ATTRIBUTE8%TYPE := NULL

883: , p_attribute4 IN PA_PROJ_ELEMENTS.ATTRIBUTE4%TYPE := NULL
884: , p_attribute5 IN PA_PROJ_ELEMENTS.ATTRIBUTE5%TYPE := NULL
885: , p_attribute6 IN PA_PROJ_ELEMENTS.ATTRIBUTE6%TYPE := NULL
886: , p_attribute7 IN PA_PROJ_ELEMENTS.ATTRIBUTE7%TYPE := NULL
887: , p_attribute8 IN PA_PROJ_ELEMENTS.ATTRIBUTE8%TYPE := NULL
888: , p_attribute9 IN PA_PROJ_ELEMENTS.ATTRIBUTE9%TYPE := NULL
889: , p_attribute10 IN PA_PROJ_ELEMENTS.ATTRIBUTE10%TYPE := NULL
890: , p_attribute11 IN PA_PROJ_ELEMENTS.ATTRIBUTE11%TYPE := NULL
891: , p_attribute12 IN PA_PROJ_ELEMENTS.ATTRIBUTE12%TYPE := NULL

Line 888: , p_attribute9 IN PA_PROJ_ELEMENTS.ATTRIBUTE9%TYPE := NULL

884: , p_attribute5 IN PA_PROJ_ELEMENTS.ATTRIBUTE5%TYPE := NULL
885: , p_attribute6 IN PA_PROJ_ELEMENTS.ATTRIBUTE6%TYPE := NULL
886: , p_attribute7 IN PA_PROJ_ELEMENTS.ATTRIBUTE7%TYPE := NULL
887: , p_attribute8 IN PA_PROJ_ELEMENTS.ATTRIBUTE8%TYPE := NULL
888: , p_attribute9 IN PA_PROJ_ELEMENTS.ATTRIBUTE9%TYPE := NULL
889: , p_attribute10 IN PA_PROJ_ELEMENTS.ATTRIBUTE10%TYPE := NULL
890: , p_attribute11 IN PA_PROJ_ELEMENTS.ATTRIBUTE11%TYPE := NULL
891: , p_attribute12 IN PA_PROJ_ELEMENTS.ATTRIBUTE12%TYPE := NULL
892: , p_attribute13 IN PA_PROJ_ELEMENTS.ATTRIBUTE13%TYPE := NULL

Line 889: , p_attribute10 IN PA_PROJ_ELEMENTS.ATTRIBUTE10%TYPE := NULL

885: , p_attribute6 IN PA_PROJ_ELEMENTS.ATTRIBUTE6%TYPE := NULL
886: , p_attribute7 IN PA_PROJ_ELEMENTS.ATTRIBUTE7%TYPE := NULL
887: , p_attribute8 IN PA_PROJ_ELEMENTS.ATTRIBUTE8%TYPE := NULL
888: , p_attribute9 IN PA_PROJ_ELEMENTS.ATTRIBUTE9%TYPE := NULL
889: , p_attribute10 IN PA_PROJ_ELEMENTS.ATTRIBUTE10%TYPE := NULL
890: , p_attribute11 IN PA_PROJ_ELEMENTS.ATTRIBUTE11%TYPE := NULL
891: , p_attribute12 IN PA_PROJ_ELEMENTS.ATTRIBUTE12%TYPE := NULL
892: , p_attribute13 IN PA_PROJ_ELEMENTS.ATTRIBUTE13%TYPE := NULL
893: , p_attribute14 IN PA_PROJ_ELEMENTS.ATTRIBUTE14%TYPE := NULL

Line 890: , p_attribute11 IN PA_PROJ_ELEMENTS.ATTRIBUTE11%TYPE := NULL

886: , p_attribute7 IN PA_PROJ_ELEMENTS.ATTRIBUTE7%TYPE := NULL
887: , p_attribute8 IN PA_PROJ_ELEMENTS.ATTRIBUTE8%TYPE := NULL
888: , p_attribute9 IN PA_PROJ_ELEMENTS.ATTRIBUTE9%TYPE := NULL
889: , p_attribute10 IN PA_PROJ_ELEMENTS.ATTRIBUTE10%TYPE := NULL
890: , p_attribute11 IN PA_PROJ_ELEMENTS.ATTRIBUTE11%TYPE := NULL
891: , p_attribute12 IN PA_PROJ_ELEMENTS.ATTRIBUTE12%TYPE := NULL
892: , p_attribute13 IN PA_PROJ_ELEMENTS.ATTRIBUTE13%TYPE := NULL
893: , p_attribute14 IN PA_PROJ_ELEMENTS.ATTRIBUTE14%TYPE := NULL
894: , p_attribute15 IN PA_PROJ_ELEMENTS.ATTRIBUTE15%TYPE := NULL

Line 891: , p_attribute12 IN PA_PROJ_ELEMENTS.ATTRIBUTE12%TYPE := NULL

887: , p_attribute8 IN PA_PROJ_ELEMENTS.ATTRIBUTE8%TYPE := NULL
888: , p_attribute9 IN PA_PROJ_ELEMENTS.ATTRIBUTE9%TYPE := NULL
889: , p_attribute10 IN PA_PROJ_ELEMENTS.ATTRIBUTE10%TYPE := NULL
890: , p_attribute11 IN PA_PROJ_ELEMENTS.ATTRIBUTE11%TYPE := NULL
891: , p_attribute12 IN PA_PROJ_ELEMENTS.ATTRIBUTE12%TYPE := NULL
892: , p_attribute13 IN PA_PROJ_ELEMENTS.ATTRIBUTE13%TYPE := NULL
893: , p_attribute14 IN PA_PROJ_ELEMENTS.ATTRIBUTE14%TYPE := NULL
894: , p_attribute15 IN PA_PROJ_ELEMENTS.ATTRIBUTE15%TYPE := NULL
895: , p_item_id IN NUMBER := NULL

Line 892: , p_attribute13 IN PA_PROJ_ELEMENTS.ATTRIBUTE13%TYPE := NULL

888: , p_attribute9 IN PA_PROJ_ELEMENTS.ATTRIBUTE9%TYPE := NULL
889: , p_attribute10 IN PA_PROJ_ELEMENTS.ATTRIBUTE10%TYPE := NULL
890: , p_attribute11 IN PA_PROJ_ELEMENTS.ATTRIBUTE11%TYPE := NULL
891: , p_attribute12 IN PA_PROJ_ELEMENTS.ATTRIBUTE12%TYPE := NULL
892: , p_attribute13 IN PA_PROJ_ELEMENTS.ATTRIBUTE13%TYPE := NULL
893: , p_attribute14 IN PA_PROJ_ELEMENTS.ATTRIBUTE14%TYPE := NULL
894: , p_attribute15 IN PA_PROJ_ELEMENTS.ATTRIBUTE15%TYPE := NULL
895: , p_item_id IN NUMBER := NULL
896: , p_inventory_org_id IN NUMBER := NULL

Line 893: , p_attribute14 IN PA_PROJ_ELEMENTS.ATTRIBUTE14%TYPE := NULL

889: , p_attribute10 IN PA_PROJ_ELEMENTS.ATTRIBUTE10%TYPE := NULL
890: , p_attribute11 IN PA_PROJ_ELEMENTS.ATTRIBUTE11%TYPE := NULL
891: , p_attribute12 IN PA_PROJ_ELEMENTS.ATTRIBUTE12%TYPE := NULL
892: , p_attribute13 IN PA_PROJ_ELEMENTS.ATTRIBUTE13%TYPE := NULL
893: , p_attribute14 IN PA_PROJ_ELEMENTS.ATTRIBUTE14%TYPE := NULL
894: , p_attribute15 IN PA_PROJ_ELEMENTS.ATTRIBUTE15%TYPE := NULL
895: , p_item_id IN NUMBER := NULL
896: , p_inventory_org_id IN NUMBER := NULL
897: , p_quantity IN NUMBER := NULL

Line 894: , p_attribute15 IN PA_PROJ_ELEMENTS.ATTRIBUTE15%TYPE := NULL

890: , p_attribute11 IN PA_PROJ_ELEMENTS.ATTRIBUTE11%TYPE := NULL
891: , p_attribute12 IN PA_PROJ_ELEMENTS.ATTRIBUTE12%TYPE := NULL
892: , p_attribute13 IN PA_PROJ_ELEMENTS.ATTRIBUTE13%TYPE := NULL
893: , p_attribute14 IN PA_PROJ_ELEMENTS.ATTRIBUTE14%TYPE := NULL
894: , p_attribute15 IN PA_PROJ_ELEMENTS.ATTRIBUTE15%TYPE := NULL
895: , p_item_id IN NUMBER := NULL
896: , p_inventory_org_id IN NUMBER := NULL
897: , p_quantity IN NUMBER := NULL
898: , p_uom_code IN VARCHAR2 := NULL

Line 903: , p_dlvr_item_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE

899: , p_item_description IN VARCHAR2 := NULL
900: , p_unit_price IN NUMBER := NULL
901: , p_unit_number IN VARCHAR2 := NULL
902: , p_currency_code IN VARCHAR2 := NULL
903: , p_dlvr_item_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
904: , p_pm_source_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR /* Bug no. 3651113 */
905: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
906: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
907: , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 921: l_dlvr_name PA_PROJ_ELEMENTS.NAME%TYPE;

917: l_debug_level3 CONSTANT NUMBER := 3;
918: l_debug_level4 CONSTANT NUMBER := 4;
919: l_debug_level5 CONSTANT NUMBER := 5;
920:
921: l_dlvr_name PA_PROJ_ELEMENTS.NAME%TYPE;
922: l_dlvr_description PA_PROJ_ELEMENTS.DESCRIPTION%TYPE;
923: l_dlvr_owner_id PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE;
924: l_carrying_out_org_id PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE;
925: l_progress_weight PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE;

Line 922: l_dlvr_description PA_PROJ_ELEMENTS.DESCRIPTION%TYPE;

918: l_debug_level4 CONSTANT NUMBER := 4;
919: l_debug_level5 CONSTANT NUMBER := 5;
920:
921: l_dlvr_name PA_PROJ_ELEMENTS.NAME%TYPE;
922: l_dlvr_description PA_PROJ_ELEMENTS.DESCRIPTION%TYPE;
923: l_dlvr_owner_id PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE;
924: l_carrying_out_org_id PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE;
925: l_progress_weight PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE;
926: l_scheduled_finish_date DATE;

Line 923: l_dlvr_owner_id PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE;

919: l_debug_level5 CONSTANT NUMBER := 5;
920:
921: l_dlvr_name PA_PROJ_ELEMENTS.NAME%TYPE;
922: l_dlvr_description PA_PROJ_ELEMENTS.DESCRIPTION%TYPE;
923: l_dlvr_owner_id PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE;
924: l_carrying_out_org_id PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE;
925: l_progress_weight PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE;
926: l_scheduled_finish_date DATE;
927: l_actual_finish_date DATE;

Line 924: l_carrying_out_org_id PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE;

920:
921: l_dlvr_name PA_PROJ_ELEMENTS.NAME%TYPE;
922: l_dlvr_description PA_PROJ_ELEMENTS.DESCRIPTION%TYPE;
923: l_dlvr_owner_id PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE;
924: l_carrying_out_org_id PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE;
925: l_progress_weight PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE;
926: l_scheduled_finish_date DATE;
927: l_actual_finish_date DATE;
928: l_dlvr_version_id PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE;

Line 925: l_progress_weight PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE;

921: l_dlvr_name PA_PROJ_ELEMENTS.NAME%TYPE;
922: l_dlvr_description PA_PROJ_ELEMENTS.DESCRIPTION%TYPE;
923: l_dlvr_owner_id PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE;
924: l_carrying_out_org_id PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE;
925: l_progress_weight PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE;
926: l_scheduled_finish_date DATE;
927: l_actual_finish_date DATE;
928: l_dlvr_version_id PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE;
929: l_status_code PA_PROJ_ELEMENTS.STATUS_CODE%TYPE;

Line 929: l_status_code PA_PROJ_ELEMENTS.STATUS_CODE%TYPE;

925: l_progress_weight PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE;
926: l_scheduled_finish_date DATE;
927: l_actual_finish_date DATE;
928: l_dlvr_version_id PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE;
929: l_status_code PA_PROJ_ELEMENTS.STATUS_CODE%TYPE;
930: l_dlvr_type_id PA_PROJ_ELEMENTS.TYPE_ID%TYPE;
931: l_task_id PA_TASKS.TASK_ID%TYPE; --added bug 3651538
932: l_deliverable_reference PA_PROJ_ELEMENTS.PM_SOURCE_CODE%TYPE; -- added for bug# 3749447
933:

Line 930: l_dlvr_type_id PA_PROJ_ELEMENTS.TYPE_ID%TYPE;

926: l_scheduled_finish_date DATE;
927: l_actual_finish_date DATE;
928: l_dlvr_version_id PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE;
929: l_status_code PA_PROJ_ELEMENTS.STATUS_CODE%TYPE;
930: l_dlvr_type_id PA_PROJ_ELEMENTS.TYPE_ID%TYPE;
931: l_task_id PA_TASKS.TASK_ID%TYPE; --added bug 3651538
932: l_deliverable_reference PA_PROJ_ELEMENTS.PM_SOURCE_CODE%TYPE; -- added for bug# 3749447
933:
934: l_structure_type VARCHAR2(150) := 'DELIVERABLE';

Line 932: l_deliverable_reference PA_PROJ_ELEMENTS.PM_SOURCE_CODE%TYPE; -- added for bug# 3749447

928: l_dlvr_version_id PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE;
929: l_status_code PA_PROJ_ELEMENTS.STATUS_CODE%TYPE;
930: l_dlvr_type_id PA_PROJ_ELEMENTS.TYPE_ID%TYPE;
931: l_task_id PA_TASKS.TASK_ID%TYPE; --added bug 3651538
932: l_deliverable_reference PA_PROJ_ELEMENTS.PM_SOURCE_CODE%TYPE; -- added for bug# 3749447
933:
934: l_structure_type VARCHAR2(150) := 'DELIVERABLE';
935: l_structure_id NUMBER;
936: l_element_structure_id NUMBER;

Line 1208: is_dlvr_number_unique := PA_PROJ_ELEMENTS_UTILS.Check_element_NUmber_Unique

1204: END IF;
1205:
1206: -- check for dlvr_number uniqueness
1207:
1208: is_dlvr_number_unique := PA_PROJ_ELEMENTS_UTILS.Check_element_NUmber_Unique
1209: (
1210: p_element_number => p_dlvr_number
1211: ,p_element_id => p_dlvr_item_id
1212: ,p_project_id => p_project_id

Line 1528: ,p_task_element_id IN pa_proj_elements.proj_element_id%TYPE

1524: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
1525: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
1526: ,p_debug_mode IN VARCHAR2 :='N'
1527: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1528: ,p_task_element_id IN pa_proj_elements.proj_element_id%TYPE
1529: ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE
1530: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
1531: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
1532: ,p_object_relationship_id IN pa_object_relationships.object_relationship_id%TYPE

Line 1530: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE

1526: ,p_debug_mode IN VARCHAR2 :='N'
1527: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1528: ,p_task_element_id IN pa_proj_elements.proj_element_id%TYPE
1529: ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE
1530: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
1531: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
1532: ,p_object_relationship_id IN pa_object_relationships.object_relationship_id%TYPE
1533: ,p_obj_rec_ver_number IN pa_object_relationships.record_version_number%TYPE
1534: ,p_project_id IN pa_projects_all.project_id%TYPE

Line 1744: pa_proj_elements.name%TYPE INDEX BY BINARY_INTEGER ;

1740:
1741: TYPE l_error_msg_name_tbl_type IS TABLE OF
1742: fnd_new_messages.message_text%TYPE INDEX BY BINARY_INTEGER ;
1743: TYPE l_element_name_tbl_type IS TABLE OF
1744: pa_proj_elements.name%TYPE INDEX BY BINARY_INTEGER ;
1745: TYPE l_element_number_tbl_type IS TABLE OF
1746: pa_proj_elements.element_number%TYPE INDEX BY BINARY_INTEGER ;
1747:
1748: l_error_msg_name_tbl l_error_msg_name_tbl_type ;

Line 1746: pa_proj_elements.element_number%TYPE INDEX BY BINARY_INTEGER ;

1742: fnd_new_messages.message_text%TYPE INDEX BY BINARY_INTEGER ;
1743: TYPE l_element_name_tbl_type IS TABLE OF
1744: pa_proj_elements.name%TYPE INDEX BY BINARY_INTEGER ;
1745: TYPE l_element_number_tbl_type IS TABLE OF
1746: pa_proj_elements.element_number%TYPE INDEX BY BINARY_INTEGER ;
1747:
1748: l_error_msg_name_tbl l_error_msg_name_tbl_type ;
1749: l_element_name_tbl l_element_name_tbl_type ;
1750: l_element_number_tbl l_element_number_tbl_type ;

Line 2233: ,p_task_element_id IN pa_proj_elements.proj_element_id%TYPE

2229: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
2230: ,p_debug_mode IN VARCHAR2 :='N'
2231: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2232: ,p_calling_context IN VARCHAR2 := 'PA_TASKS'
2233: ,p_task_element_id IN pa_proj_elements.proj_element_id%TYPE
2234: ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE
2235: ,p_project_id IN pa_projects_all.project_id%TYPE
2236: ,p_delete_or_validate IN VARCHAR2 := 'B' -- 3955848 V- Validate , D - Delete, B - Validate and Delete
2237: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2678: FROM pa_proj_elements ppe

2674: SELECT ppe.proj_element_id
2675: ,pev1.element_version_id
2676: ,ppe.element_number
2677: ,ppe.name
2678: FROM pa_proj_elements ppe
2679: ,pa_proj_element_versions pev1
2680: ,pa_proj_element_versions pev2
2681: ,pa_object_relationships obj
2682: WHERE pev2.element_version_id = c_task_version_id

Line 2695: FROM pa_proj_elements ppe ,

2691: CURSOR c_get_element_id(c_task_version_id IN NUMBER )
2692: IS
2693: SELECT ppe.proj_element_id
2694: ,ppe.project_id
2695: FROM pa_proj_elements ppe ,
2696: pa_proj_element_versions pev
2697: WHERE pev.element_version_id = c_task_version_id
2698: AND ppe.proj_element_id = pev.proj_element_id
2699: AND nvl(ppe.base_percent_comp_deriv_code,'X') <> 'DELIVERABLE' ; -- 3461959 added nvl function