APPS.PO_PALT_MS_COMPLETION dependencies on PO_CLM_ASSGNMT_MILESTONE_DTLS

Line 152: SELECT MILESTONE_CODE FROM PO_CLM_ASSGNMT_MILESTONE_DTLS

148: SELECT ASSIGNMENT_NUMBER,ASSIGNMENT_ID FROM PO_CLM_ASSIGNMENTS
149: WHERE ASSIGNMENT_STATUS IN (1,2,7);
150:
151: CURSOR Get_Uncompleted_System_MS IS
152: SELECT MILESTONE_CODE FROM PO_CLM_ASSGNMT_MILESTONE_DTLS
153: WHERE MILESTONE_TYPE = 'S'
154: AND ACTUAL_COMPLETION_DATE IS NULL
155: AND ASSIGNMENT_ID = l_Assignment_Id;
156:

Line 185: UPDATE PO_CLM_ASSGNMT_MILESTONE_DTLS

181: L_Solicit_Creation_Dt := Get_Solicitation_Creation_Dt(l_Assignment_Number);
182: END IF;
183: IF (L_Solicit_Creation_Dt IS NOT NULL) THEN
184: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Milestone Solicitation Creation for Assignment'||l_Assignment_Number||' Completed ON '|| to_char(L_Solicit_Creation_Dt,'DD-MON-YYYY HH24:MI:SS'));
185: UPDATE PO_CLM_ASSGNMT_MILESTONE_DTLS
186: SET ACTUAL_COMPLETION_DATE = L_Solicit_Creation_Dt,
187: last_updated_by = fnd_global.user_id ,
188: last_update_date = SYSDATE ,
189: last_update_login = fnd_global.login_id

Line 205: UPDATE PO_CLM_ASSGNMT_MILESTONE_DTLS

201: L_Solicit_Publish_Dt := Get_Solicitation_Publish_Dt(l_Assignment_Number);
202: END IF;
203: IF (L_Solicit_Publish_Dt IS NOT NULL) THEN
204: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Milestone Publish Solicitation for Assignment'||l_Assignment_Number||' Completed ON '|| to_char(L_Solicit_Publish_Dt,'DD-MON-YYYY HH24:MI:SS'));
205: UPDATE PO_CLM_ASSGNMT_MILESTONE_DTLS
206: SET ACTUAL_COMPLETION_DATE = L_Solicit_Publish_Dt,
207: last_updated_by = fnd_global.user_id ,
208: last_update_date = SYSDATE ,
209: last_update_login = fnd_global.login_id

Line 225: UPDATE PO_CLM_ASSGNMT_MILESTONE_DTLS

221: L_Award_Creation_Dt := Get_Award_Creation_Dt(l_Assignment_Number);
222: END IF;
223: IF (L_Award_Creation_Dt IS NOT NULL) THEN
224: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Milestone Award Creation for Assignment'||l_Assignment_Number||' Completed ON '|| to_char(L_Award_Creation_Dt,'DD-MON-YYYY HH24:MI:SS'));
225: UPDATE PO_CLM_ASSGNMT_MILESTONE_DTLS
226: SET ACTUAL_COMPLETION_DATE = L_Award_Creation_Dt,
227: last_updated_by = fnd_global.user_id ,
228: last_update_date = SYSDATE ,
229: last_update_login = fnd_global.login_id

Line 247: UPDATE PO_CLM_ASSGNMT_MILESTONE_DTLS

243: END IF;
244:
245: IF (L_Award_Approval_Dt IS NOT NULL) THEN
246: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Milestone Award Approval for Assignment'||l_Assignment_Number||' Completed ON '|| to_char(L_Award_Approval_Dt,'DD-MON-YYYY HH24:MI:SS'));
247: UPDATE PO_CLM_ASSGNMT_MILESTONE_DTLS
248: SET ACTUAL_COMPLETION_DATE = L_Award_Approval_Dt,
249: last_updated_by = fnd_global.user_id ,
250: last_update_date = SYSDATE ,
251: last_update_login = fnd_global.login_id

Line 264: FROM PO_CLM_ASSGNMT_MILESTONE_DTLS

260:
261: /* Added code to update completion dates for all milestones other than the 4 seeded milestones.*/
262: SELECT Count(*)
263: INTO l_incomp_MS_count
264: FROM PO_CLM_ASSGNMT_MILESTONE_DTLS
265: WHERE ((MILESTONE_TYPE = 'S' AND MILESTONE_CODE NOT IN ('SOCREATE','SOPUBLIS','AWCREATE','AWAPPROV'))
266: OR MILESTONE_TYPE = 'U')
267: AND ACTUAL_COMPLETION_DATE IS NULL
268: AND ASSIGNMENT_ID = l_Assignment_Id;

Line 281: FROM PO_CLM_ASSGNMT_MILESTONE_DTLS

277: l_incomplete_MS_Count := 0;
278:
279: SELECT Count(*)
280: INTO l_incomplete_MS_Count
281: FROM PO_CLM_ASSGNMT_MILESTONE_DTLS
282: WHERE ASSIGNMENT_ID = l_Assignment_Id
283: and ACTUAL_COMPLETION_DATE is NULL ;
284:
285: IF (l_incomplete_MS_Count = 0) THEN

Line 289: FROM PO_CLM_ASSGNMT_MILESTONE_DTLS

285: IF (l_incomplete_MS_Count = 0) THEN
286: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment '||l_Assignment_Number||' is Completed');
287: UPDATE PO_CLM_ASSIGNMENTS
288: SET ACTUAL_COMPLETION_DATE = (SELECT Max(ACTUAL_COMPLETION_DATE)
289: FROM PO_CLM_ASSGNMT_MILESTONE_DTLS
290: WHERE ASSIGNMENT_ID = l_Assignment_Id) ,
291: ASSIGNMENT_STATUS = 4,
292: last_updated_by = fnd_global.user_id ,
293: last_update_date = SYSDATE ,