490: P_OBJECT_VERSION_NUMBER =>l_object_version_number+1,
491: P_ORIG_STATUS_CODE =>'ACTIVE',
492: P_NEW_STATUS_CODE =>'APPROVED',
493: P_REJECT_STATUS_CODE =>'REJECTED',
494: P_REQUESTER_USERID =>fnd_global.user_id,
495: P_NOTES_FROM_REQUESTER =>NULL,
496: P_WORKFLOWPROCESS =>'AHL_GEN_APPROVAL',
497: P_ITEM_TYPE =>'AHLGAPP');
498:
873: P_OBJECT_VERSION_NUMBER =>l_object_version_number+1,
874: P_ORIG_STATUS_CODE =>'ACTIVE',
875: P_NEW_STATUS_CODE =>'APPROVED',
876: P_REJECT_STATUS_CODE =>'REJECTED',
877: P_REQUESTER_USERID =>fnd_global.user_id,
878: P_NOTES_FROM_REQUESTER =>NULL,
879: -- P_WORKFLOWPROCESS =>'AHL_GEN_APPROVAL',
880: P_WORKFLOWPROCESS =>l_process_name,
881: P_ITEM_TYPE =>'AHLGAPP');
1224: X_ATTRIBUTE14 =>l_mr_route_Rec.ATTRIBUTE14,
1225: X_ATTRIBUTE15 =>l_mr_route_Rec.ATTRIBUTE15,
1226: X_OBJECT_VERSION_NUMBER =>1,
1227: X_CREATION_DATE =>sysdate,
1228: X_CREATED_BY =>fnd_global.user_id,
1229: X_LAST_UPDATE_DATE =>sysdate,
1230: X_LAST_UPDATED_BY =>fnd_global.user_id,
1231: X_LAST_UPDATE_LOGIN =>fnd_global.user_id);
1232: OPEN CurGetRouteSeqDet(l_old_mr_ROUTE_ID);
1226: X_OBJECT_VERSION_NUMBER =>1,
1227: X_CREATION_DATE =>sysdate,
1228: X_CREATED_BY =>fnd_global.user_id,
1229: X_LAST_UPDATE_DATE =>sysdate,
1230: X_LAST_UPDATED_BY =>fnd_global.user_id,
1231: X_LAST_UPDATE_LOGIN =>fnd_global.user_id);
1232: OPEN CurGetRouteSeqDet(l_old_mr_ROUTE_ID);
1233: LOOP
1234: FETCH CurGetRouteSeqDet INTO l_mr_route_seq_rec;
1227: X_CREATION_DATE =>sysdate,
1228: X_CREATED_BY =>fnd_global.user_id,
1229: X_LAST_UPDATE_DATE =>sysdate,
1230: X_LAST_UPDATED_BY =>fnd_global.user_id,
1231: X_LAST_UPDATE_LOGIN =>fnd_global.user_id);
1232: OPEN CurGetRouteSeqDet(l_old_mr_ROUTE_ID);
1233: LOOP
1234: FETCH CurGetRouteSeqDet INTO l_mr_route_seq_rec;
1235: IF CurGetRouteSeqDet%FOUND
1268: X_ATTRIBUTE13 =>l_mr_route_seq_rec.ATTRIBUTE13,
1269: X_ATTRIBUTE14 =>l_mr_route_seq_rec.ATTRIBUTE14,
1270: X_ATTRIBUTE15 =>l_mr_route_seq_rec.ATTRIBUTE15,
1271: X_CREATION_DATE =>sysdate,
1272: X_CREATED_BY =>fnd_global.user_id,
1273: X_LAST_UPDATE_DATE =>sysdate,
1274: X_LAST_UPDATED_BY =>fnd_global.user_id,
1275: X_LAST_UPDATE_LOGIN =>fnd_global.user_id);
1276: ELSE
1270: X_ATTRIBUTE15 =>l_mr_route_seq_rec.ATTRIBUTE15,
1271: X_CREATION_DATE =>sysdate,
1272: X_CREATED_BY =>fnd_global.user_id,
1273: X_LAST_UPDATE_DATE =>sysdate,
1274: X_LAST_UPDATED_BY =>fnd_global.user_id,
1275: X_LAST_UPDATE_LOGIN =>fnd_global.user_id);
1276: ELSE
1277: EXIT WHEN CurGetRouteSeqDet%NOTFOUND;
1278: END IF;
1271: X_CREATION_DATE =>sysdate,
1272: X_CREATED_BY =>fnd_global.user_id,
1273: X_LAST_UPDATE_DATE =>sysdate,
1274: X_LAST_UPDATED_BY =>fnd_global.user_id,
1275: X_LAST_UPDATE_LOGIN =>fnd_global.user_id);
1276: ELSE
1277: EXIT WHEN CurGetRouteSeqDet%NOTFOUND;
1278: END IF;
1279: END LOOP;