546: P_OBJECT_VERSION_NUMBER =>l_object_version_number+1,
547: P_ORIG_STATUS_CODE =>'ACTIVE',
548: P_NEW_STATUS_CODE =>'APPROVED',
549: P_REJECT_STATUS_CODE =>'REJECTED',
550: P_REQUESTER_USERID =>fnd_global.user_id,
551: P_NOTES_FROM_REQUESTER =>NULL,
552: P_WORKFLOWPROCESS =>'AHL_GEN_APPROVAL',
553: P_ITEM_TYPE =>'AHLGAPP');
554:
931: P_OBJECT_VERSION_NUMBER =>l_object_version_number+1,
932: P_ORIG_STATUS_CODE =>'ACTIVE',
933: P_NEW_STATUS_CODE =>'APPROVED',
934: P_REJECT_STATUS_CODE =>'REJECTED',
935: P_REQUESTER_USERID =>fnd_global.user_id,
936: P_NOTES_FROM_REQUESTER =>NULL,
937: -- P_WORKFLOWPROCESS =>'AHL_GEN_APPROVAL',
938: P_WORKFLOWPROCESS =>l_process_name,
939: P_ITEM_TYPE =>'AHLGAPP');
1284: X_ATTRIBUTE14 =>l_mr_route_Rec.ATTRIBUTE14,
1285: X_ATTRIBUTE15 =>l_mr_route_Rec.ATTRIBUTE15,
1286: X_OBJECT_VERSION_NUMBER =>1,
1287: X_CREATION_DATE =>sysdate,
1288: X_CREATED_BY =>fnd_global.user_id,
1289: X_LAST_UPDATE_DATE =>sysdate,
1290: X_LAST_UPDATED_BY =>fnd_global.user_id,
1291: X_LAST_UPDATE_LOGIN =>fnd_global.user_id);
1292: OPEN CurGetRouteSeqDet(l_old_mr_ROUTE_ID);
1286: X_OBJECT_VERSION_NUMBER =>1,
1287: X_CREATION_DATE =>sysdate,
1288: X_CREATED_BY =>fnd_global.user_id,
1289: X_LAST_UPDATE_DATE =>sysdate,
1290: X_LAST_UPDATED_BY =>fnd_global.user_id,
1291: X_LAST_UPDATE_LOGIN =>fnd_global.user_id);
1292: OPEN CurGetRouteSeqDet(l_old_mr_ROUTE_ID);
1293: LOOP
1294: FETCH CurGetRouteSeqDet INTO l_mr_route_seq_rec;
1287: X_CREATION_DATE =>sysdate,
1288: X_CREATED_BY =>fnd_global.user_id,
1289: X_LAST_UPDATE_DATE =>sysdate,
1290: X_LAST_UPDATED_BY =>fnd_global.user_id,
1291: X_LAST_UPDATE_LOGIN =>fnd_global.user_id);
1292: OPEN CurGetRouteSeqDet(l_old_mr_ROUTE_ID);
1293: LOOP
1294: FETCH CurGetRouteSeqDet INTO l_mr_route_seq_rec;
1295: IF CurGetRouteSeqDet%FOUND
1328: X_ATTRIBUTE13 =>l_mr_route_seq_rec.ATTRIBUTE13,
1329: X_ATTRIBUTE14 =>l_mr_route_seq_rec.ATTRIBUTE14,
1330: X_ATTRIBUTE15 =>l_mr_route_seq_rec.ATTRIBUTE15,
1331: X_CREATION_DATE =>sysdate,
1332: X_CREATED_BY =>fnd_global.user_id,
1333: X_LAST_UPDATE_DATE =>sysdate,
1334: X_LAST_UPDATED_BY =>fnd_global.user_id,
1335: X_LAST_UPDATE_LOGIN =>fnd_global.user_id);
1336: ELSE
1330: X_ATTRIBUTE15 =>l_mr_route_seq_rec.ATTRIBUTE15,
1331: X_CREATION_DATE =>sysdate,
1332: X_CREATED_BY =>fnd_global.user_id,
1333: X_LAST_UPDATE_DATE =>sysdate,
1334: X_LAST_UPDATED_BY =>fnd_global.user_id,
1335: X_LAST_UPDATE_LOGIN =>fnd_global.user_id);
1336: ELSE
1337: EXIT WHEN CurGetRouteSeqDet%NOTFOUND;
1338: END IF;
1331: X_CREATION_DATE =>sysdate,
1332: X_CREATED_BY =>fnd_global.user_id,
1333: X_LAST_UPDATE_DATE =>sysdate,
1334: X_LAST_UPDATED_BY =>fnd_global.user_id,
1335: X_LAST_UPDATE_LOGIN =>fnd_global.user_id);
1336: ELSE
1337: EXIT WHEN CurGetRouteSeqDet%NOTFOUND;
1338: END IF;
1339: END LOOP;