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

Line 11: -- Note : Call insert_row method of pa_proj_elements, pa_proj_element_versions,

7:
8: -- Procedure : Create_Deliverable
9: -- Type : PRIVATE
10: -- Purpose : Create_Deliverable Procedure will be called for creation of deliverable
11: -- Note : Call insert_row method of pa_proj_elements, pa_proj_element_versions,
12: -- : pa_proj_element_sch and pa_object_relationships packages
13: -- Assumptions : None
14:
15: -- Parameters Type Required Description and Purpose

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

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
91: , p_parent_struct_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
92: , p_dlvr_type_id IN PA_PROJ_ELEMENTS.TYPE_ID%TYPE := NULL
93: , p_dlvr_type_name IN VARCHAR2 := NULL

Line 90: , p_parent_structure_id IN PA_PROJ_ELEMENTS.PARENT_STRUCTURE_ID%TYPE

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
91: , p_parent_struct_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
92: , p_dlvr_type_id IN PA_PROJ_ELEMENTS.TYPE_ID%TYPE := NULL
93: , p_dlvr_type_name IN VARCHAR2 := NULL
94: , p_dlvr_reference IN VARCHAR2 := NULL -- 3435905

Line 92: , p_dlvr_type_id IN PA_PROJ_ELEMENTS.TYPE_ID%TYPE := 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
91: , p_parent_struct_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
92: , p_dlvr_type_id IN PA_PROJ_ELEMENTS.TYPE_ID%TYPE := NULL
93: , p_dlvr_type_name IN VARCHAR2 := NULL
94: , p_dlvr_reference IN VARCHAR2 := NULL -- 3435905
95: , p_progress_weight IN PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE := NULL
96: , p_scheduled_finish_date IN PA_PROJ_ELEM_VER_SCHEDULE.SCHEDULED_FINISH_DATE%TYPE := NULL

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

91: , p_parent_struct_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
92: , p_dlvr_type_id IN PA_PROJ_ELEMENTS.TYPE_ID%TYPE := NULL
93: , p_dlvr_type_name IN VARCHAR2 := NULL
94: , p_dlvr_reference IN VARCHAR2 := NULL -- 3435905
95: , p_progress_weight IN PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE := NULL
96: , p_scheduled_finish_date IN PA_PROJ_ELEM_VER_SCHEDULE.SCHEDULED_FINISH_DATE%TYPE := NULL
97: , p_actual_finish_date IN PA_PROJ_ELEM_VER_SCHEDULE.ACTUAL_FINISH_DATE%TYPE := NULL
98: , p_task_id IN NUMBER := NULL
99: , p_task_version_id IN NUMBER := NULL

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

109: , p_attribute8 IN PA_PROJ_ELEMENTS.ATTRIBUTE8%TYPE := NULL
110: , p_attribute9 IN PA_PROJ_ELEMENTS.ATTRIBUTE9%TYPE := NULL
111: , p_attribute10 IN PA_PROJ_ELEMENTS.ATTRIBUTE10%TYPE := NULL
112: , p_attribute11 IN PA_PROJ_ELEMENTS.ATTRIBUTE11%TYPE := NULL
113: , p_attribute12 IN PA_PROJ_ELEMENTS.ATTRIBUTE12%TYPE := NULL
114: , p_attribute13 IN PA_PROJ_ELEMENTS.ATTRIBUTE13%TYPE := NULL
115: , p_attribute14 IN PA_PROJ_ELEMENTS.ATTRIBUTE14%TYPE := NULL
116: , p_attribute15 IN PA_PROJ_ELEMENTS.ATTRIBUTE15%TYPE := NULL
117: , p_dlvr_item_id OUT NOCOPY PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE --File.Sql.39 bug 4440895

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

110: , p_attribute9 IN PA_PROJ_ELEMENTS.ATTRIBUTE9%TYPE := NULL
111: , p_attribute10 IN PA_PROJ_ELEMENTS.ATTRIBUTE10%TYPE := NULL
112: , p_attribute11 IN PA_PROJ_ELEMENTS.ATTRIBUTE11%TYPE := NULL
113: , p_attribute12 IN PA_PROJ_ELEMENTS.ATTRIBUTE12%TYPE := NULL
114: , p_attribute13 IN PA_PROJ_ELEMENTS.ATTRIBUTE13%TYPE := NULL
115: , p_attribute14 IN PA_PROJ_ELEMENTS.ATTRIBUTE14%TYPE := NULL
116: , p_attribute15 IN PA_PROJ_ELEMENTS.ATTRIBUTE15%TYPE := NULL
117: , p_dlvr_item_id OUT NOCOPY PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE --File.Sql.39 bug 4440895
118: , p_pm_source_code IN VARCHAR2 := NULL /* Bug no. 3651113 */

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

111: , p_attribute10 IN PA_PROJ_ELEMENTS.ATTRIBUTE10%TYPE := NULL
112: , p_attribute11 IN PA_PROJ_ELEMENTS.ATTRIBUTE11%TYPE := NULL
113: , p_attribute12 IN PA_PROJ_ELEMENTS.ATTRIBUTE12%TYPE := NULL
114: , p_attribute13 IN PA_PROJ_ELEMENTS.ATTRIBUTE13%TYPE := NULL
115: , p_attribute14 IN PA_PROJ_ELEMENTS.ATTRIBUTE14%TYPE := NULL
116: , p_attribute15 IN PA_PROJ_ELEMENTS.ATTRIBUTE15%TYPE := NULL
117: , p_dlvr_item_id OUT NOCOPY PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE --File.Sql.39 bug 4440895
118: , p_pm_source_code IN VARCHAR2 := NULL /* Bug no. 3651113 */
119: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

112: , p_attribute11 IN PA_PROJ_ELEMENTS.ATTRIBUTE11%TYPE := NULL
113: , p_attribute12 IN PA_PROJ_ELEMENTS.ATTRIBUTE12%TYPE := NULL
114: , p_attribute13 IN PA_PROJ_ELEMENTS.ATTRIBUTE13%TYPE := NULL
115: , p_attribute14 IN PA_PROJ_ELEMENTS.ATTRIBUTE14%TYPE := NULL
116: , p_attribute15 IN PA_PROJ_ELEMENTS.ATTRIBUTE15%TYPE := NULL
117: , p_dlvr_item_id OUT NOCOPY PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE --File.Sql.39 bug 4440895
118: , p_pm_source_code IN VARCHAR2 := NULL /* Bug no. 3651113 */
119: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
120: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

113: , p_attribute12 IN PA_PROJ_ELEMENTS.ATTRIBUTE12%TYPE := NULL
114: , p_attribute13 IN PA_PROJ_ELEMENTS.ATTRIBUTE13%TYPE := NULL
115: , p_attribute14 IN PA_PROJ_ELEMENTS.ATTRIBUTE14%TYPE := NULL
116: , p_attribute15 IN PA_PROJ_ELEMENTS.ATTRIBUTE15%TYPE := NULL
117: , p_dlvr_item_id OUT NOCOPY PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE --File.Sql.39 bug 4440895
118: , p_pm_source_code IN VARCHAR2 := NULL /* Bug no. 3651113 */
119: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
120: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
121: , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 138: l_proj_element_id PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE := NULL;

134: l_debug_level4 CONSTANT NUMBER := 4;
135: l_debug_level5 CONSTANT NUMBER := 5;
136:
137: X_ROW_ID VARCHAR2(18);
138: l_proj_element_id PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE := NULL;
139: l_dlvr_version_id PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE := NULL;
140: l_new_pev_schedule_id PA_PROJ_ELEM_VER_SCHEDULE.PEV_SCHEDULE_ID%TYPE := NULL;
141: l_new_obj_rel_id PA_OBJECT_RELATIONSHIPS.OBJECT_RELATIONSHIP_ID%TYPE := NULL;
142: l_progress_weight PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE := NULL; -- 3570283 added

Line 142: l_progress_weight PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE := NULL; -- 3570283 added

138: l_proj_element_id PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE := NULL;
139: l_dlvr_version_id PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE := NULL;
140: l_new_pev_schedule_id PA_PROJ_ELEM_VER_SCHEDULE.PEV_SCHEDULE_ID%TYPE := NULL;
141: l_new_obj_rel_id PA_OBJECT_RELATIONSHIPS.OBJECT_RELATIONSHIP_ID%TYPE := NULL;
142: l_progress_weight PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE := NULL; -- 3570283 added
143: l_prog_rollup_method VARCHAR2(30) := NULL;
144:
145: l_dlvr_prg_flag VARCHAR2(1) := 'N'; -- 3570283 added
146: l_dlvr_act_flag VARCHAR2(1) := 'N'; -- 3570283 added

Line 211: Pa_Debug.WRITE(g_module_name,' PA_PROJ_ELEMENTS_PKG.Insert_Row Called ',

207:
208: END IF;
209:
210: IF l_debug_mode = 'Y' THEN
211: Pa_Debug.WRITE(g_module_name,' PA_PROJ_ELEMENTS_PKG.Insert_Row Called ',
212: l_debug_level3);
213: END IF;
214:
215: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 231: -- call insert_row of pa_proj_elements package

227: END IF;
228:
229: -- 3570283 added
230:
231: -- call insert_row of pa_proj_elements package
232:
233: PA_PROJ_ELEMENTS_PKG.Insert_Row
234: (
235: X_ROW_ID => X_ROW_ID

Line 233: PA_PROJ_ELEMENTS_PKG.Insert_Row

229: -- 3570283 added
230:
231: -- call insert_row of pa_proj_elements package
232:
233: PA_PROJ_ELEMENTS_PKG.Insert_Row
234: (
235: X_ROW_ID => X_ROW_ID
236: ,X_PROJ_ELEMENT_ID => l_proj_element_id
237: ,X_PROJECT_ID => p_project_id

Line 293: Pa_Debug.WRITE(g_module_name,' Out of PA_PROJ_ELEMENTS_PKG.Insert_Row Element ['||p_dlvr_number||']['||p_dlvr_number||']',

289:
290: p_dlvr_item_id := l_proj_element_id;
291:
292: IF l_debug_mode = 'Y' THEN
293: Pa_Debug.WRITE(g_module_name,' Out of PA_PROJ_ELEMENTS_PKG.Insert_Row Element ['||p_dlvr_number||']['||p_dlvr_number||']',
294: l_debug_level3);
295: END IF;
296:
297: IF l_debug_mode = 'Y' THEN

Line 606: -- Note : Call update_row method of pa_proj_elements, pa_proj_element_versions,

602:
603: -- Procedure : Update_Deliverable
604: -- Type : PRIVATE
605: -- Purpose : Update_Deliverable Procedure will be called for creation of deliverable
606: -- Note : Call update_row method of pa_proj_elements, pa_proj_element_versions,
607: -- : pa_proj_element_sch and pa_object_relationships packages
608: -- Assumptions : None
609:
610: -- Parameters Type Required Description and Purpose

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

670: , p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
671: , p_debug_mode IN VARCHAR2 := 'N'
672: , p_max_msg_count IN NUMBER := NULL
673: , p_record_version_number IN NUMBER := 1
674: , p_object_type IN PA_PROJ_ELEMENTS.OBJECT_TYPE%TYPE := 'PA_DELIVERABLES'
675: , p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE
676: , p_dlvr_number IN PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE
677: , p_dlvr_name IN PA_PROJ_ELEMENTS.NAME%TYPE
678: , p_dlvr_description IN PA_PROJ_ELEMENTS.DESCRIPTION%TYPE := NULL

Line 675: , p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE

671: , p_debug_mode IN VARCHAR2 := 'N'
672: , p_max_msg_count IN NUMBER := NULL
673: , p_record_version_number IN NUMBER := 1
674: , p_object_type IN PA_PROJ_ELEMENTS.OBJECT_TYPE%TYPE := 'PA_DELIVERABLES'
675: , p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE
676: , p_dlvr_number IN PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE
677: , p_dlvr_name IN PA_PROJ_ELEMENTS.NAME%TYPE
678: , p_dlvr_description IN PA_PROJ_ELEMENTS.DESCRIPTION%TYPE := NULL
679: , p_dlvr_owner_id IN PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE := NULL

Line 676: , p_dlvr_number IN PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE

672: , p_max_msg_count IN NUMBER := NULL
673: , p_record_version_number IN NUMBER := 1
674: , p_object_type IN PA_PROJ_ELEMENTS.OBJECT_TYPE%TYPE := 'PA_DELIVERABLES'
675: , p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE
676: , p_dlvr_number IN PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE
677: , p_dlvr_name IN PA_PROJ_ELEMENTS.NAME%TYPE
678: , p_dlvr_description IN PA_PROJ_ELEMENTS.DESCRIPTION%TYPE := NULL
679: , p_dlvr_owner_id IN PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE := NULL
680: , p_dlvr_owner_name IN VARCHAR2 := NULL

Line 677: , p_dlvr_name IN PA_PROJ_ELEMENTS.NAME%TYPE

673: , p_record_version_number IN NUMBER := 1
674: , p_object_type IN PA_PROJ_ELEMENTS.OBJECT_TYPE%TYPE := 'PA_DELIVERABLES'
675: , p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE
676: , p_dlvr_number IN PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE
677: , p_dlvr_name IN PA_PROJ_ELEMENTS.NAME%TYPE
678: , p_dlvr_description IN PA_PROJ_ELEMENTS.DESCRIPTION%TYPE := NULL
679: , p_dlvr_owner_id IN PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE := NULL
680: , p_dlvr_owner_name IN VARCHAR2 := NULL
681: , p_carrying_out_org_id IN PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE := NULL

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

674: , p_object_type IN PA_PROJ_ELEMENTS.OBJECT_TYPE%TYPE := 'PA_DELIVERABLES'
675: , p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE
676: , p_dlvr_number IN PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE
677: , p_dlvr_name IN PA_PROJ_ELEMENTS.NAME%TYPE
678: , p_dlvr_description IN PA_PROJ_ELEMENTS.DESCRIPTION%TYPE := NULL
679: , p_dlvr_owner_id IN PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE := NULL
680: , p_dlvr_owner_name IN VARCHAR2 := NULL
681: , p_carrying_out_org_id IN PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE := NULL
682: , p_carrying_out_org_name IN VARCHAR2 := NULL

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

675: , p_project_id IN PA_PROJ_ELEMENTS.PROJECT_ID%TYPE
676: , p_dlvr_number IN PA_PROJ_ELEMENTS.ELEMENT_NUMBER%TYPE
677: , p_dlvr_name IN PA_PROJ_ELEMENTS.NAME%TYPE
678: , p_dlvr_description IN PA_PROJ_ELEMENTS.DESCRIPTION%TYPE := NULL
679: , p_dlvr_owner_id IN PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE := NULL
680: , p_dlvr_owner_name IN VARCHAR2 := NULL
681: , p_carrying_out_org_id IN PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE := NULL
682: , p_carrying_out_org_name IN VARCHAR2 := NULL
683: , p_dlvr_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE := NULL

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

677: , p_dlvr_name IN PA_PROJ_ELEMENTS.NAME%TYPE
678: , p_dlvr_description IN PA_PROJ_ELEMENTS.DESCRIPTION%TYPE := NULL
679: , p_dlvr_owner_id IN PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE := NULL
680: , p_dlvr_owner_name IN VARCHAR2 := NULL
681: , p_carrying_out_org_id IN PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE := NULL
682: , p_carrying_out_org_name IN VARCHAR2 := NULL
683: , p_dlvr_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE := NULL
684: , p_status_code IN PA_PROJ_ELEMENTS.STATUS_CODE%TYPE := NULL
685: , p_parent_structure_id IN PA_PROJ_ELEMENTS.PARENT_STRUCTURE_ID%TYPE

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

680: , p_dlvr_owner_name IN VARCHAR2 := NULL
681: , p_carrying_out_org_id IN PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE := NULL
682: , p_carrying_out_org_name IN VARCHAR2 := NULL
683: , p_dlvr_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE := NULL
684: , p_status_code IN PA_PROJ_ELEMENTS.STATUS_CODE%TYPE := NULL
685: , p_parent_structure_id IN PA_PROJ_ELEMENTS.PARENT_STRUCTURE_ID%TYPE
686: , p_parent_struct_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
687: , p_dlvr_type_id IN PA_PROJ_ELEMENTS.TYPE_ID%TYPE := NULL
688: , p_dlvr_type_name IN VARCHAR2 := NULL

Line 685: , p_parent_structure_id IN PA_PROJ_ELEMENTS.PARENT_STRUCTURE_ID%TYPE

681: , p_carrying_out_org_id IN PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE := NULL
682: , p_carrying_out_org_name IN VARCHAR2 := NULL
683: , p_dlvr_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE := NULL
684: , p_status_code IN PA_PROJ_ELEMENTS.STATUS_CODE%TYPE := NULL
685: , p_parent_structure_id IN PA_PROJ_ELEMENTS.PARENT_STRUCTURE_ID%TYPE
686: , p_parent_struct_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
687: , p_dlvr_type_id IN PA_PROJ_ELEMENTS.TYPE_ID%TYPE := NULL
688: , p_dlvr_type_name IN VARCHAR2 := NULL
689: , p_progress_weight IN PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE := NULL

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

683: , p_dlvr_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE := NULL
684: , p_status_code IN PA_PROJ_ELEMENTS.STATUS_CODE%TYPE := NULL
685: , p_parent_structure_id IN PA_PROJ_ELEMENTS.PARENT_STRUCTURE_ID%TYPE
686: , p_parent_struct_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
687: , p_dlvr_type_id IN PA_PROJ_ELEMENTS.TYPE_ID%TYPE := NULL
688: , p_dlvr_type_name IN VARCHAR2 := NULL
689: , p_progress_weight IN PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE := NULL
690: , p_scheduled_finish_date IN PA_PROJ_ELEM_VER_SCHEDULE.SCHEDULED_FINISH_DATE%TYPE := NULL
691: , p_actual_finish_date IN PA_PROJ_ELEM_VER_SCHEDULE.ACTUAL_FINISH_DATE%TYPE := NULL

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

685: , p_parent_structure_id IN PA_PROJ_ELEMENTS.PARENT_STRUCTURE_ID%TYPE
686: , p_parent_struct_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
687: , p_dlvr_type_id IN PA_PROJ_ELEMENTS.TYPE_ID%TYPE := NULL
688: , p_dlvr_type_name IN VARCHAR2 := NULL
689: , p_progress_weight IN PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE := NULL
690: , p_scheduled_finish_date IN PA_PROJ_ELEM_VER_SCHEDULE.SCHEDULED_FINISH_DATE%TYPE := NULL
691: , p_actual_finish_date IN PA_PROJ_ELEM_VER_SCHEDULE.ACTUAL_FINISH_DATE%TYPE := NULL
692: , p_task_id IN NUMBER := NULL
693: , p_task_version_id IN NUMBER := NULL

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

691: , p_actual_finish_date IN PA_PROJ_ELEM_VER_SCHEDULE.ACTUAL_FINISH_DATE%TYPE := NULL
692: , p_task_id IN NUMBER := NULL
693: , p_task_version_id IN NUMBER := NULL
694: , p_task_name IN VARCHAR2 := NULL
695: , p_attribute_category IN PA_PROJ_ELEMENTS.ATTRIBUTE_CATEGORY%TYPE := NULL
696: , p_attribute1 IN PA_PROJ_ELEMENTS.ATTRIBUTE1%TYPE := NULL
697: , p_attribute2 IN PA_PROJ_ELEMENTS.ATTRIBUTE2%TYPE := NULL
698: , p_attribute3 IN PA_PROJ_ELEMENTS.ATTRIBUTE3%TYPE := NULL
699: , p_attribute4 IN PA_PROJ_ELEMENTS.ATTRIBUTE4%TYPE := NULL

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

692: , p_task_id IN NUMBER := NULL
693: , p_task_version_id IN NUMBER := NULL
694: , p_task_name IN VARCHAR2 := NULL
695: , p_attribute_category IN PA_PROJ_ELEMENTS.ATTRIBUTE_CATEGORY%TYPE := NULL
696: , p_attribute1 IN PA_PROJ_ELEMENTS.ATTRIBUTE1%TYPE := NULL
697: , p_attribute2 IN PA_PROJ_ELEMENTS.ATTRIBUTE2%TYPE := NULL
698: , p_attribute3 IN PA_PROJ_ELEMENTS.ATTRIBUTE3%TYPE := NULL
699: , p_attribute4 IN PA_PROJ_ELEMENTS.ATTRIBUTE4%TYPE := NULL
700: , p_attribute5 IN PA_PROJ_ELEMENTS.ATTRIBUTE5%TYPE := NULL

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

693: , p_task_version_id IN NUMBER := NULL
694: , p_task_name IN VARCHAR2 := NULL
695: , p_attribute_category IN PA_PROJ_ELEMENTS.ATTRIBUTE_CATEGORY%TYPE := NULL
696: , p_attribute1 IN PA_PROJ_ELEMENTS.ATTRIBUTE1%TYPE := NULL
697: , p_attribute2 IN PA_PROJ_ELEMENTS.ATTRIBUTE2%TYPE := NULL
698: , p_attribute3 IN PA_PROJ_ELEMENTS.ATTRIBUTE3%TYPE := NULL
699: , p_attribute4 IN PA_PROJ_ELEMENTS.ATTRIBUTE4%TYPE := NULL
700: , p_attribute5 IN PA_PROJ_ELEMENTS.ATTRIBUTE5%TYPE := NULL
701: , p_attribute6 IN PA_PROJ_ELEMENTS.ATTRIBUTE6%TYPE := NULL

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

694: , p_task_name IN VARCHAR2 := NULL
695: , p_attribute_category IN PA_PROJ_ELEMENTS.ATTRIBUTE_CATEGORY%TYPE := NULL
696: , p_attribute1 IN PA_PROJ_ELEMENTS.ATTRIBUTE1%TYPE := NULL
697: , p_attribute2 IN PA_PROJ_ELEMENTS.ATTRIBUTE2%TYPE := NULL
698: , p_attribute3 IN PA_PROJ_ELEMENTS.ATTRIBUTE3%TYPE := NULL
699: , p_attribute4 IN PA_PROJ_ELEMENTS.ATTRIBUTE4%TYPE := NULL
700: , p_attribute5 IN PA_PROJ_ELEMENTS.ATTRIBUTE5%TYPE := NULL
701: , p_attribute6 IN PA_PROJ_ELEMENTS.ATTRIBUTE6%TYPE := NULL
702: , p_attribute7 IN PA_PROJ_ELEMENTS.ATTRIBUTE7%TYPE := NULL

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

695: , p_attribute_category IN PA_PROJ_ELEMENTS.ATTRIBUTE_CATEGORY%TYPE := NULL
696: , p_attribute1 IN PA_PROJ_ELEMENTS.ATTRIBUTE1%TYPE := NULL
697: , p_attribute2 IN PA_PROJ_ELEMENTS.ATTRIBUTE2%TYPE := NULL
698: , p_attribute3 IN PA_PROJ_ELEMENTS.ATTRIBUTE3%TYPE := NULL
699: , p_attribute4 IN PA_PROJ_ELEMENTS.ATTRIBUTE4%TYPE := NULL
700: , p_attribute5 IN PA_PROJ_ELEMENTS.ATTRIBUTE5%TYPE := NULL
701: , p_attribute6 IN PA_PROJ_ELEMENTS.ATTRIBUTE6%TYPE := NULL
702: , p_attribute7 IN PA_PROJ_ELEMENTS.ATTRIBUTE7%TYPE := NULL
703: , p_attribute8 IN PA_PROJ_ELEMENTS.ATTRIBUTE8%TYPE := NULL

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

696: , p_attribute1 IN PA_PROJ_ELEMENTS.ATTRIBUTE1%TYPE := NULL
697: , p_attribute2 IN PA_PROJ_ELEMENTS.ATTRIBUTE2%TYPE := NULL
698: , p_attribute3 IN PA_PROJ_ELEMENTS.ATTRIBUTE3%TYPE := NULL
699: , p_attribute4 IN PA_PROJ_ELEMENTS.ATTRIBUTE4%TYPE := NULL
700: , p_attribute5 IN PA_PROJ_ELEMENTS.ATTRIBUTE5%TYPE := NULL
701: , p_attribute6 IN PA_PROJ_ELEMENTS.ATTRIBUTE6%TYPE := NULL
702: , p_attribute7 IN PA_PROJ_ELEMENTS.ATTRIBUTE7%TYPE := NULL
703: , p_attribute8 IN PA_PROJ_ELEMENTS.ATTRIBUTE8%TYPE := NULL
704: , p_attribute9 IN PA_PROJ_ELEMENTS.ATTRIBUTE9%TYPE := NULL

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

697: , p_attribute2 IN PA_PROJ_ELEMENTS.ATTRIBUTE2%TYPE := NULL
698: , p_attribute3 IN PA_PROJ_ELEMENTS.ATTRIBUTE3%TYPE := NULL
699: , p_attribute4 IN PA_PROJ_ELEMENTS.ATTRIBUTE4%TYPE := NULL
700: , p_attribute5 IN PA_PROJ_ELEMENTS.ATTRIBUTE5%TYPE := NULL
701: , p_attribute6 IN PA_PROJ_ELEMENTS.ATTRIBUTE6%TYPE := NULL
702: , p_attribute7 IN PA_PROJ_ELEMENTS.ATTRIBUTE7%TYPE := NULL
703: , p_attribute8 IN PA_PROJ_ELEMENTS.ATTRIBUTE8%TYPE := NULL
704: , p_attribute9 IN PA_PROJ_ELEMENTS.ATTRIBUTE9%TYPE := NULL
705: , p_attribute10 IN PA_PROJ_ELEMENTS.ATTRIBUTE10%TYPE := NULL

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

698: , p_attribute3 IN PA_PROJ_ELEMENTS.ATTRIBUTE3%TYPE := NULL
699: , p_attribute4 IN PA_PROJ_ELEMENTS.ATTRIBUTE4%TYPE := NULL
700: , p_attribute5 IN PA_PROJ_ELEMENTS.ATTRIBUTE5%TYPE := NULL
701: , p_attribute6 IN PA_PROJ_ELEMENTS.ATTRIBUTE6%TYPE := NULL
702: , p_attribute7 IN PA_PROJ_ELEMENTS.ATTRIBUTE7%TYPE := NULL
703: , p_attribute8 IN PA_PROJ_ELEMENTS.ATTRIBUTE8%TYPE := NULL
704: , p_attribute9 IN PA_PROJ_ELEMENTS.ATTRIBUTE9%TYPE := NULL
705: , p_attribute10 IN PA_PROJ_ELEMENTS.ATTRIBUTE10%TYPE := NULL
706: , p_attribute11 IN PA_PROJ_ELEMENTS.ATTRIBUTE11%TYPE := NULL

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

699: , p_attribute4 IN PA_PROJ_ELEMENTS.ATTRIBUTE4%TYPE := NULL
700: , p_attribute5 IN PA_PROJ_ELEMENTS.ATTRIBUTE5%TYPE := NULL
701: , p_attribute6 IN PA_PROJ_ELEMENTS.ATTRIBUTE6%TYPE := NULL
702: , p_attribute7 IN PA_PROJ_ELEMENTS.ATTRIBUTE7%TYPE := NULL
703: , p_attribute8 IN PA_PROJ_ELEMENTS.ATTRIBUTE8%TYPE := NULL
704: , p_attribute9 IN PA_PROJ_ELEMENTS.ATTRIBUTE9%TYPE := NULL
705: , p_attribute10 IN PA_PROJ_ELEMENTS.ATTRIBUTE10%TYPE := NULL
706: , p_attribute11 IN PA_PROJ_ELEMENTS.ATTRIBUTE11%TYPE := NULL
707: , p_attribute12 IN PA_PROJ_ELEMENTS.ATTRIBUTE12%TYPE := NULL

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

700: , p_attribute5 IN PA_PROJ_ELEMENTS.ATTRIBUTE5%TYPE := NULL
701: , p_attribute6 IN PA_PROJ_ELEMENTS.ATTRIBUTE6%TYPE := NULL
702: , p_attribute7 IN PA_PROJ_ELEMENTS.ATTRIBUTE7%TYPE := NULL
703: , p_attribute8 IN PA_PROJ_ELEMENTS.ATTRIBUTE8%TYPE := NULL
704: , p_attribute9 IN PA_PROJ_ELEMENTS.ATTRIBUTE9%TYPE := NULL
705: , p_attribute10 IN PA_PROJ_ELEMENTS.ATTRIBUTE10%TYPE := NULL
706: , p_attribute11 IN PA_PROJ_ELEMENTS.ATTRIBUTE11%TYPE := NULL
707: , p_attribute12 IN PA_PROJ_ELEMENTS.ATTRIBUTE12%TYPE := NULL
708: , p_attribute13 IN PA_PROJ_ELEMENTS.ATTRIBUTE13%TYPE := NULL

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

701: , p_attribute6 IN PA_PROJ_ELEMENTS.ATTRIBUTE6%TYPE := NULL
702: , p_attribute7 IN PA_PROJ_ELEMENTS.ATTRIBUTE7%TYPE := NULL
703: , p_attribute8 IN PA_PROJ_ELEMENTS.ATTRIBUTE8%TYPE := NULL
704: , p_attribute9 IN PA_PROJ_ELEMENTS.ATTRIBUTE9%TYPE := NULL
705: , p_attribute10 IN PA_PROJ_ELEMENTS.ATTRIBUTE10%TYPE := NULL
706: , p_attribute11 IN PA_PROJ_ELEMENTS.ATTRIBUTE11%TYPE := NULL
707: , p_attribute12 IN PA_PROJ_ELEMENTS.ATTRIBUTE12%TYPE := NULL
708: , p_attribute13 IN PA_PROJ_ELEMENTS.ATTRIBUTE13%TYPE := NULL
709: , p_attribute14 IN PA_PROJ_ELEMENTS.ATTRIBUTE14%TYPE := NULL

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

702: , p_attribute7 IN PA_PROJ_ELEMENTS.ATTRIBUTE7%TYPE := NULL
703: , p_attribute8 IN PA_PROJ_ELEMENTS.ATTRIBUTE8%TYPE := NULL
704: , p_attribute9 IN PA_PROJ_ELEMENTS.ATTRIBUTE9%TYPE := NULL
705: , p_attribute10 IN PA_PROJ_ELEMENTS.ATTRIBUTE10%TYPE := NULL
706: , p_attribute11 IN PA_PROJ_ELEMENTS.ATTRIBUTE11%TYPE := NULL
707: , p_attribute12 IN PA_PROJ_ELEMENTS.ATTRIBUTE12%TYPE := NULL
708: , p_attribute13 IN PA_PROJ_ELEMENTS.ATTRIBUTE13%TYPE := NULL
709: , p_attribute14 IN PA_PROJ_ELEMENTS.ATTRIBUTE14%TYPE := NULL
710: , p_attribute15 IN PA_PROJ_ELEMENTS.ATTRIBUTE15%TYPE := NULL

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

703: , p_attribute8 IN PA_PROJ_ELEMENTS.ATTRIBUTE8%TYPE := NULL
704: , p_attribute9 IN PA_PROJ_ELEMENTS.ATTRIBUTE9%TYPE := NULL
705: , p_attribute10 IN PA_PROJ_ELEMENTS.ATTRIBUTE10%TYPE := NULL
706: , p_attribute11 IN PA_PROJ_ELEMENTS.ATTRIBUTE11%TYPE := NULL
707: , p_attribute12 IN PA_PROJ_ELEMENTS.ATTRIBUTE12%TYPE := NULL
708: , p_attribute13 IN PA_PROJ_ELEMENTS.ATTRIBUTE13%TYPE := NULL
709: , p_attribute14 IN PA_PROJ_ELEMENTS.ATTRIBUTE14%TYPE := NULL
710: , p_attribute15 IN PA_PROJ_ELEMENTS.ATTRIBUTE15%TYPE := NULL
711: , p_dlvr_item_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE

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

704: , p_attribute9 IN PA_PROJ_ELEMENTS.ATTRIBUTE9%TYPE := NULL
705: , p_attribute10 IN PA_PROJ_ELEMENTS.ATTRIBUTE10%TYPE := NULL
706: , p_attribute11 IN PA_PROJ_ELEMENTS.ATTRIBUTE11%TYPE := NULL
707: , p_attribute12 IN PA_PROJ_ELEMENTS.ATTRIBUTE12%TYPE := NULL
708: , p_attribute13 IN PA_PROJ_ELEMENTS.ATTRIBUTE13%TYPE := NULL
709: , p_attribute14 IN PA_PROJ_ELEMENTS.ATTRIBUTE14%TYPE := NULL
710: , p_attribute15 IN PA_PROJ_ELEMENTS.ATTRIBUTE15%TYPE := NULL
711: , p_dlvr_item_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
712: , p_pm_source_code IN VARCHAR2 :=NULL /* Bug no. 3651113 */

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

705: , p_attribute10 IN PA_PROJ_ELEMENTS.ATTRIBUTE10%TYPE := NULL
706: , p_attribute11 IN PA_PROJ_ELEMENTS.ATTRIBUTE11%TYPE := NULL
707: , p_attribute12 IN PA_PROJ_ELEMENTS.ATTRIBUTE12%TYPE := NULL
708: , p_attribute13 IN PA_PROJ_ELEMENTS.ATTRIBUTE13%TYPE := NULL
709: , p_attribute14 IN PA_PROJ_ELEMENTS.ATTRIBUTE14%TYPE := NULL
710: , p_attribute15 IN PA_PROJ_ELEMENTS.ATTRIBUTE15%TYPE := NULL
711: , p_dlvr_item_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
712: , p_pm_source_code IN VARCHAR2 :=NULL /* Bug no. 3651113 */
713: , p_deliverable_reference IN VARCHAR2 := NULL -- added for bug# 3749447

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

706: , p_attribute11 IN PA_PROJ_ELEMENTS.ATTRIBUTE11%TYPE := NULL
707: , p_attribute12 IN PA_PROJ_ELEMENTS.ATTRIBUTE12%TYPE := NULL
708: , p_attribute13 IN PA_PROJ_ELEMENTS.ATTRIBUTE13%TYPE := NULL
709: , p_attribute14 IN PA_PROJ_ELEMENTS.ATTRIBUTE14%TYPE := NULL
710: , p_attribute15 IN PA_PROJ_ELEMENTS.ATTRIBUTE15%TYPE := NULL
711: , p_dlvr_item_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
712: , p_pm_source_code IN VARCHAR2 :=NULL /* Bug no. 3651113 */
713: , p_deliverable_reference IN VARCHAR2 := NULL -- added for bug# 3749447
714: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 711: , p_dlvr_item_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE

707: , p_attribute12 IN PA_PROJ_ELEMENTS.ATTRIBUTE12%TYPE := NULL
708: , p_attribute13 IN PA_PROJ_ELEMENTS.ATTRIBUTE13%TYPE := NULL
709: , p_attribute14 IN PA_PROJ_ELEMENTS.ATTRIBUTE14%TYPE := NULL
710: , p_attribute15 IN PA_PROJ_ELEMENTS.ATTRIBUTE15%TYPE := NULL
711: , p_dlvr_item_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
712: , p_pm_source_code IN VARCHAR2 :=NULL /* Bug no. 3651113 */
713: , p_deliverable_reference IN VARCHAR2 := NULL -- added for bug# 3749447
714: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
715: , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 739: l_progress_weight PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE := NULL; -- 3570283 added

735: l_debug_level4 CONSTANT NUMBER := 4;
736: l_debug_level5 CONSTANT NUMBER := 5;
737:
738: l_prog_rollup_method VARCHAR2(30) := NULL;
739: l_progress_weight PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE := NULL; -- 3570283 added
740: l_calling_mode VARCHAR2(30) := 'UPDATE_DUE_DATE';
741:
742:
743: l_ready_to_ship VARCHAR2(1) := 'N';

Line 779: PA_PROJ_ELEMENTS PPE

775: SELECT
776: ROWID
777: ,PM_SOURCE_REFERENCE
778: FROM
779: PA_PROJ_ELEMENTS PPE
780: WHERE
781: PPE.PROJ_ELEMENT_ID = p_dlvr_item_id AND
782: PPE.PROJECT_ID = p_project_id AND
783: PPE.OBJECT_TYPE = l_object_type;

Line 841: pa_proj_elements ppe,

837: ppe.base_percent_comp_deriv_code, --ppe.prog_rollup_method,
838: pvs.scheduled_finish_date,
839: pvs.actual_finish_date
840: From
841: pa_proj_elements ppe,
842: pa_proj_elem_ver_schedule pvs
843: Where
844: ppe.project_id = p_project_id and
845: ppe.proj_element_id = p_dlvr_item_id and

Line 1249: Pa_Debug.WRITE(g_module_name,' PA_PROJ_ELEMENTS_PKG.Update_Row Called ',

1245: l_debug_level3);
1246: END IF;
1247:
1248: IF l_debug_mode = 'Y' THEN
1249: Pa_Debug.WRITE(g_module_name,' PA_PROJ_ELEMENTS_PKG.Update_Row Called ',
1250: l_debug_level3);
1251: END IF;
1252:
1253: -- call update_row of pa_proj_elements package

Line 1253: -- call update_row of pa_proj_elements package

1249: Pa_Debug.WRITE(g_module_name,' PA_PROJ_ELEMENTS_PKG.Update_Row Called ',
1250: l_debug_level3);
1251: END IF;
1252:
1253: -- call update_row of pa_proj_elements package
1254:
1255: l_element_id := p_dlvr_item_id;
1256:
1257: -- 3570283 added

Line 1273: PA_PROJ_ELEMENTS_PKG.Update_Row

1269: OPEN l_row_id_ppe_csr;
1270: FETCH l_row_id_ppe_csr INTO ppe_rec;
1271: CLOSE l_row_id_ppe_csr;
1272:
1273: PA_PROJ_ELEMENTS_PKG.Update_Row
1274: (
1275: X_ROW_ID => ppe_rec.rowid
1276: ,X_PROJ_ELEMENT_ID => l_element_id
1277: ,X_PROJECT_ID => p_project_id

Line 1329: Pa_Debug.WRITE(g_module_name,' Out of PA_PROJ_ELEMENTS_PKG.Update_Row ',

1325: );
1326:
1327:
1328: IF l_debug_mode = 'Y' THEN
1329: Pa_Debug.WRITE(g_module_name,' Out of PA_PROJ_ELEMENTS_PKG.Update_Row ',
1330: l_debug_level3);
1331: END IF;
1332:
1333: IF l_debug_mode = 'Y' THEN

Line 1645: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE

1641: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
1642: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
1643: ,p_debug_mode IN VARCHAR2 :='N'
1644: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1645: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
1646: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
1647: ,p_rec_ver_number IN pa_proj_elements.record_version_number%TYPE
1648: ,p_project_id IN pa_projects_all.project_id%TYPE
1649: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1647: ,p_rec_ver_number IN pa_proj_elements.record_version_number%TYPE

1643: ,p_debug_mode IN VARCHAR2 :='N'
1644: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1645: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
1646: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
1647: ,p_rec_ver_number IN pa_proj_elements.record_version_number%TYPE
1648: ,p_project_id IN pa_projects_all.project_id%TYPE
1649: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1650: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1651: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1722: from PA_PROJ_ELEMENTS

1718:
1719: -- Lock the record before performing deletion
1720: BEGIN
1721: select 'x' into l_dummy
1722: from PA_PROJ_ELEMENTS
1723: where proj_element_id = p_dlv_element_id
1724: and record_version_number = decode(p_calling_module, 'AMG', record_version_number,p_rec_ver_number)
1725: for update of record_version_number NOWAIT;
1726: EXCEPTION

Line 1850: DELETE FROM PA_PROJ_ELEMENTS

1846:
1847: DELETE FROM PA_PROJ_ELEMENT_VERSIONS
1848: WHERE ELEMENT_VERSION_ID = p_dlv_version_id ;
1849:
1850: DELETE FROM PA_PROJ_ELEMENTS
1851: WHERE PROJ_ELEMENT_ID = p_dlv_element_id ;
1852:
1853: IF l_debug_mode = 'Y' THEN
1854: Pa_Debug.WRITE(g_module_name,' After deleting records from Project table, deleting OKE records['||x_return_status||']', 3);

Line 1944: DELETE FROM PA_PROJ_ELEMENTS

1940:
1941: --The nvl check has been included by avaithia on 29-Mar-2004
1942: IF nvl(l_action_element_id_tbl.LAST,0) > 0 THEN
1943: FORALL i IN l_action_element_id_tbl.FIRST..l_action_element_id_tbl.LAST
1944: DELETE FROM PA_PROJ_ELEMENTS
1945: WHERE PROJ_ELEMENT_ID = l_action_element_id_tbl(i);
1946:
1947: FORALL i IN l_action_version_id_tbl.FIRST..l_action_version_id_tbl.LAST
1948: DELETE FROM PA_PROJ_ELEMENT_VERSIONS

Line 2083: ,p_task_element_id IN pa_proj_elements.proj_element_id%TYPE

2079: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
2080: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
2081: ,p_debug_mode IN VARCHAR2 :='N'
2082: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2083: ,p_task_element_id IN pa_proj_elements.proj_element_id%TYPE
2084: ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE
2085: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
2086: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
2087: ,p_object_relationship_id IN pa_object_relationships.object_relationship_id%TYPE

Line 2085: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE

2081: ,p_debug_mode IN VARCHAR2 :='N'
2082: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2083: ,p_task_element_id IN pa_proj_elements.proj_element_id%TYPE
2084: ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE
2085: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
2086: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
2087: ,p_object_relationship_id IN pa_object_relationships.object_relationship_id%TYPE
2088: ,p_obj_rec_ver_number IN pa_object_relationships.record_version_number%TYPE
2089: ,p_project_id IN pa_projects_all.project_id%TYPE

Line 2310: ,p_task_element_id IN pa_proj_elements.proj_element_id%TYPE

2306: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
2307: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
2308: ,p_debug_mode IN VARCHAR2 :='N'
2309: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2310: ,p_task_element_id IN pa_proj_elements.proj_element_id%TYPE
2311: ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE
2312: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
2313: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
2314: ,p_project_id IN pa_projects_all.project_id%TYPE

Line 2312: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE

2308: ,p_debug_mode IN VARCHAR2 :='N'
2309: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2310: ,p_task_element_id IN pa_proj_elements.proj_element_id%TYPE
2311: ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE
2312: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
2313: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
2314: ,p_project_id IN pa_projects_all.project_id%TYPE
2315: ,p_calling_context IN VARCHAR2 -- Bug 3555460
2316: ,x_disassociation_allowed OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2682: ,p_task_element_id IN pa_proj_elements.proj_element_id%TYPE

2678: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
2679: ,p_debug_mode IN VARCHAR2 :='N'
2680: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2681: ,p_calling_context IN VARCHAR2 := 'PA_TASKS'
2682: ,p_task_element_id IN pa_proj_elements.proj_element_id%TYPE
2683: ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE
2684: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
2685: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
2686: ,p_project_id IN pa_projects_all.project_id%TYPE

Line 2684: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE

2680: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2681: ,p_calling_context IN VARCHAR2 := 'PA_TASKS'
2682: ,p_task_element_id IN pa_proj_elements.proj_element_id%TYPE
2683: ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE
2684: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
2685: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
2686: ,p_project_id IN pa_projects_all.project_id%TYPE
2687: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2688: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 2983: DELETE FROM PA_PROJ_ELEMENTS

2979: RAISE Invalid_Arg_Exc_Dlv ;
2980: END IF;
2981: */
2982: -- Delete the structure level record
2983: DELETE FROM PA_PROJ_ELEMENTS
2984: WHERE project_id = p_project_id
2985: AND object_type = 'PA_STRUCTURES'
2986: AND proj_element_id in (SELECT proj_element_id
2987: FROM pa_proj_structure_types

Line 3047: DELETE FROM PA_PROJ_ELEMENTS

3043: WHERE project_id = p_project_id
3044: AND element_version_id = l_dlv_version_tbl(j);
3045:
3046: FORALL j IN l_dlv_proj_elt_tbl.FIRST..l_dlv_proj_elt_tbl.LAST
3047: DELETE FROM PA_PROJ_ELEMENTS
3048: WHERE proj_element_id = l_dlv_proj_elt_tbl(j);
3049:
3050: --The nvl check is needed because :Say suppose only deliverable structure has been
3051: --enabled and there are no deliverables created so far,

Line 3179: ,p_task_element_id IN pa_proj_elements.proj_element_id%TYPE

3175: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
3176: ,p_debug_mode IN VARCHAR2 :='N'
3177: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
3178: ,p_calling_context IN VARCHAR2 := 'PA_TASKS'
3179: ,p_task_element_id IN pa_proj_elements.proj_element_id%TYPE
3180: ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE
3181: ,p_project_id IN pa_projects_all.project_id%TYPE
3182: ,p_delete_or_validate IN VARCHAR2 := 'B' -- 3955848 V- Validate , D - Delete, B - Validate and Delete ( default )
3183: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 3240: FROM pa_proj_elements ppe

3236: CURSOR C(c_project_id IN NUMBER) IS
3237: SELECT 'Y'
3238: FROM DUAL
3239: WHERE EXISTS (SELECT 'Y'
3240: FROM pa_proj_elements ppe
3241: ,pa_object_relationships obj1
3242: ,pa_task_types ptt
3243: WHERE obj1.object_id_from2 = p_task_element_id
3244: AND obj1.relationship_type = 'A'

Line 3474: FROM pa_proj_elements ppe

3470: SELECT 'Y'
3471: from dual
3472: WHERE EXISTS(
3473: SELECT 'Y'
3474: FROM pa_proj_elements ppe
3475: ,pa_object_relationships obj1
3476: ,pa_task_types ptt
3477: WHERE
3478: ppe.project_id = c_project_id

Line 3543: FROM pa_proj_elements

3539: AND object_type_to = 'PA_DELIVERABLES'
3540: AND relationship_type = 'A'
3541: AND relationship_subtype = 'TASK_TO_DELIVERABLE'
3542: AND object_id_from2 in (SELECT proj_element_id
3543: FROM pa_proj_elements
3544: WHERE project_id = p_project_id ) ;
3545:
3546: IF p_debug_mode = 'Y' THEN
3547: pa_debug.g_err_stage:= 'Exiting DELETE_DLV_ASSOCIATIONS' ;

Line 3690: CURSOR l_proj_element_data(c_proj_element_id IN pa_proj_elements.proj_element_id%TYPE)

3686:
3687: -- This is the cursor which will be called during copy deliverables,copy external and copy tasks.
3688: -- This cursor fetch the source deliverable info.
3689:
3690: CURSOR l_proj_element_data(c_proj_element_id IN pa_proj_elements.proj_element_id%TYPE)
3691: IS
3692: SELECT SUBSTR(p_prefix||ppe.element_number,1,100)
3693: ,SUBSTR(p_prefix||ppe.name,1,240)
3694: ,ppe.manager_person_id

Line 3721: FROM pa_proj_elements ppe

3717: ,pev.element_version_id -- Source element version id
3718: ,ppe.type_id
3719: ,pvs.scheduled_finish_date
3720: ,ptt.initial_status_code -- Bug#3515852
3721: FROM pa_proj_elements ppe
3722: ,pa_proj_elem_ver_schedule pvs
3723: ,pa_proj_element_versions pev
3724: ,pa_task_types ptt
3725: WHERE ppe.proj_element_id = c_proj_element_id

Line 3768: FROM pa_proj_elements ppe

3764: ,pev.element_version_id -- Source element version id
3765: ,ppe.type_id
3766: ,pvs.scheduled_finish_date
3767: ,ptt.initial_status_code -- Bug#3515852
3768: FROM pa_proj_elements ppe
3769: ,pa_proj_elem_ver_schedule pvs
3770: ,pa_proj_element_versions pev
3771: ,pa_task_types ptt
3772: WHERE ppe.project_id = p_source_project_id

Line 3803: ,pa_proj_elements ppe

3799: SELECT ppe.proj_element_id
3800: ,pev.element_version_id
3801: FROM pa_proj_structure_types pst
3802: ,pa_structure_types sty
3803: ,pa_proj_elements ppe
3804: ,pa_proj_element_versions pev
3805: WHERE ppe.project_id = p_target_project_id
3806: AND ppe.object_type = 'PA_STRUCTURES'
3807: AND pev.proj_element_id = ppe.proj_element_id

Line 3947: INSERT INTO PA_PROJ_ELEMENTS

3943: -- If p_calling_context is COPY_PROJECT then first
3944: -- populate the structure level record .
3945:
3946:
3947: INSERT INTO PA_PROJ_ELEMENTS
3948: ( proj_element_id
3949: ,project_id
3950: ,object_type
3951: ,element_number

Line 3989: FROM pa_proj_elements ppe,

3985: ,fnd_global.login_id
3986: ,l_parent_structure_id
3987: ,p_target_project_id
3988: ,'PA_PROJECTS'
3989: FROM pa_proj_elements ppe,
3990: pa_proj_structure_types pst
3991: WHERE ppe.object_type = 'PA_STRUCTURES'
3992: AND ppe.project_id = p_source_project_id
3993: AND pst.proj_element_id = ppe.proj_element_id

Line 4090: ,pa_proj_elements ppe

4086: ,ppe.pm_source_reference
4087: ,p_target_project_id
4088: ,'PA_PROJECTS'
4089: FROM pa_proj_elem_ver_structure ver
4090: ,pa_proj_elements ppe
4091: ,pa_proj_structure_types pst
4092: WHERE ver.project_id = p_source_project_id
4093: AND ppe.proj_element_id = ver.proj_element_id
4094: AND ppe.object_type = 'PA_STRUCTURES'

Line 4215: pa_debug.g_err_stage:= 'Populating PA_PROJ_ELEMENTS ';

4211:
4212: END IF ;
4213:
4214: IF l_debug_mode = 'Y' THEN
4215: pa_debug.g_err_stage:= 'Populating PA_PROJ_ELEMENTS ';
4216: pa_debug.write(g_module_name,pa_debug.g_err_stage,3) ;
4217: END IF;
4218:
4219: -- Validate unique deliverable number

Line 4229: l_y_or_n := PA_PROJ_ELEMENTS_UTILS.Check_element_Number_Unique

4225: IF p_calling_context <> 'COPY_PROJECT' THEN
4226:
4227: IF nvl(l_element_number_tbl.LAST,0)> 0 THEN -- Included for 4468344
4228: FOR i IN l_element_number_tbl.FIRST..l_element_number_tbl.LAST LOOP
4229: l_y_or_n := PA_PROJ_ELEMENTS_UTILS.Check_element_Number_Unique
4230: (p_element_number => l_element_number_tbl(i)
4231: ,p_element_id => null
4232: ,p_project_id => p_target_project_id
4233: ,p_structure_id => l_parent_structure_id

Line 4256: INSERT INTO PA_PROJ_ELEMENTS

4252: -- If clause added for bug# 3429221
4253:
4254: -- Populate pa_proj_element table
4255: FORALL i IN l_element_number_tbl.FIRST..l_element_number_tbl.LAST
4256: INSERT INTO PA_PROJ_ELEMENTS
4257: ( proj_element_id
4258: ,project_id
4259: ,object_type
4260: ,element_number

Line 4506: FROM pa_proj_elements tsk1

4502: ,dlv1.proj_element_id
4503: ,'TASK_TO_DELIVERABLE'
4504: ,1
4505: ,fnd_global.login_id
4506: FROM pa_proj_elements tsk1
4507: ,pa_proj_elements dlv1
4508: ,pa_proj_element_versions dlv2
4509: ,pa_object_relationships obj
4510: WHERE dlv1.project_id = p_target_project_id

Line 4507: ,pa_proj_elements dlv1

4503: ,'TASK_TO_DELIVERABLE'
4504: ,1
4505: ,fnd_global.login_id
4506: FROM pa_proj_elements tsk1
4507: ,pa_proj_elements dlv1
4508: ,pa_proj_element_versions dlv2
4509: ,pa_object_relationships obj
4510: WHERE dlv1.project_id = p_target_project_id
4511: AND dlv1.object_type = 'PA_DELIVERABLES'