65:
66: BEGIN
67:
68: SELECT Count(*) into l_Assignment_found
69: FROM PO_CLM_ASSGNMT_ACTION_HISTORY
70: WHERE ASSIGNMENT_ID = pAssignmentId
71: and ACTION_END_DATE is NULL;
72:
73: SELECT ASSIGNMENT_NUMBER
81: WHERE USER_ID = fnd_global.user_id;
82:
83: IF (l_Assignment_found = 0) then
84:
85: INSERT INTO PO_CLM_ASSGNMT_ACTION_HISTORY
86: (ASSIGNMENT_ID ,
87: OLD_STATUS ,
88: NEW_STATUS ,
89: OLD_BUYER_ID ,
112: fnd_global.user_id,
113: sysdate,
114: fnd_global.login_id);
115: ELSE
116: UPDATE PO_CLM_ASSGNMT_ACTION_HISTORY
117: SET ACTION_END_DATE = SYSDATE-1/(24*60*60),
118: last_updated_by = fnd_global.user_id ,
119: last_update_date = SYSDATE ,
120: last_update_login = fnd_global.login_id
121: WHERE ASSIGNMENT_ID = pAssignmentId
122: AND ACTION_END_DATE IS NULL
123: AND (NEW_STATUS = Decode(pOldStatus,1,6,pOldStatus) OR NEW_STATUS = Decode(pOldStatus,1,7,pOldStatus));
124:
125: INSERT INTO PO_CLM_ASSGNMT_ACTION_HISTORY
126: (ASSIGNMENT_ID ,
127: OLD_STATUS ,
128: NEW_STATUS ,
129: OLD_BUYER_ID ,