APPS.PO_PALT_MILESTONE_CMPL_HOOK SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 53

 * Name: Custom_Update_MS_Completion_Dt
 * Function:
 *  Gets completion date for milestones other than the 4 seede milestones(SOCREATE,SOPUBLIS,AWCREATE,AWAPPROV).
 *  Update ACTUAL_COMPLETION_DATE of PO_CLM_ASSGNMT_MILESTONE_DTLS table with the calculated completion date.
 *
 * Commented the code. Ct can uncomment it and use the code to write thier custom logic to calculate
 * completion dates.
 *
 * Parameters:
 * IN:
 *    pAssignment_Number  Assignment Number of the assignment whose milestones' completion dates need to be calculated.
 * End of Comments
 */
--------------------------------------------------------------------------------
PROCEDURE Custom_Update_MS_Completion_Dt(pAssignment_Number IN VARCHAR2) IS
/*
   l_Assignment_Id NUMBER;

Line: 75

   SELECT DISTINCT MILESTONE_CODE FROM PO_CLM_ASSGNMT_MILESTONE_DTLS
   WHERE ((MILESTONE_TYPE = 'S' AND MILESTONE_CODE NOT IN ('SOCREATE','SOPUBLIS','AWCREATE','AWAPPROV'))
            OR MILESTONE_TYPE = 'U')
   AND ACTUAL_COMPLETION_DATE IS NULL
   AND ASSIGNMENT_ID = l_Assignment_Id;

Line: 84

   SELECT ASSIGNMENT_ID
   INTO l_Assignment_Id
   FROM PO_CLM_ASSIGNMENTS
   WHERE ASSIGNMENT_NUMBER = pAssignment_Number;

Line: 99

         UPDATE PO_CLM_ASSGNMT_MILESTONE_DTLS
         SET ACTUAL_COMPLETION_DATE = l_comp_dt,
             last_updated_by       = fnd_global.user_id  ,
             last_update_date      = SYSDATE             ,
             last_update_login     = fnd_global.login_id
         WHERE ASSIGNMENT_ID = l_Assignment_Id
         and MILESTONE_CODE =  l_MS_Code;

Line: 115

END Custom_Update_MS_Completion_Dt;