148: ,p_SERVICE_PRIORITY
149: ,p_WF_ITEM_TYPE
150: ,p_WF_ACTIVITY
151: ,sysdate
152: ,FND_GLOBAL.user_id
153: ,sysdate
154: ,FND_GLOBAL.user_id
155: ,FND_GLOBAL.login_id
156: ) ;
150: ,p_WF_ACTIVITY
151: ,sysdate
152: ,FND_GLOBAL.user_id
153: ,sysdate
154: ,FND_GLOBAL.user_id
155: ,FND_GLOBAL.login_id
156: ) ;
157: IF SQL%NOTFOUND THEN
158: FND_MESSAGE.SET_NAME('WSH', 'WSH_INSERT_FAILED');
151: ,sysdate
152: ,FND_GLOBAL.user_id
153: ,sysdate
154: ,FND_GLOBAL.user_id
155: ,FND_GLOBAL.login_id
156: ) ;
157: IF SQL%NOTFOUND THEN
158: FND_MESSAGE.SET_NAME('WSH', 'WSH_INSERT_FAILED');
159: FND_MSG_PUB.ADD;
324: ,SERVICE_PRIORITY = p_SERVICE_PRIORITY
325: ,WF_ITEM_TYPE = p_WF_ITEM_TYPE
326: ,WF_ACTIVITY = p_WF_ACTIVITY
327: ,LAST_UPDATE_DATE = sysdate
328: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
329: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
330: where cc_service_sequence_id = p_cc_service_sequence_id ;
331: IF SQL%NOTFOUND THEN
332: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_FAILED');
325: ,WF_ITEM_TYPE = p_WF_ITEM_TYPE
326: ,WF_ACTIVITY = p_WF_ACTIVITY
327: ,LAST_UPDATE_DATE = sysdate
328: ,LAST_UPDATED_BY = FND_GLOBAL.user_id
329: ,LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
330: where cc_service_sequence_id = p_cc_service_sequence_id ;
331: IF SQL%NOTFOUND THEN
332: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_FAILED');
333: FND_MSG_PUB.ADD;