eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_FMP_MR_ROUTE_SEQNCE_PVT SQL Statements

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

Line: 27


		SELECT 	route_number, stage
		FROM 	ahl_mr_routes_v
		WHERE 	mr_route_id = p_mr_route_id;

Line: 40


		SELECT	nvl(max(mrr.stage), 1)
		INTO 	l_min_stage
		FROM	ahl_mr_routes_v mrr,
			ahl_mr_route_sequences mrs
		WHERE	mrr.mr_route_id = mrs.mr_route_id and
			mrs.related_mr_route_id = p_mr_route_id;

Line: 48


		SELECT 	nvl(min(mrr.stage), l_max_stage_num)
		INTO 	l_max_stage
		FROM	ahl_mr_routes_v mrr,
			ahl_mr_route_sequences mrs
		WHERE	mrr.mr_route_id = mrs.related_mr_route_id and
			mrs.mr_route_id = p_mr_route_id;

Line: 90


Select
MR_ROUTE_SEQUENCE_ID,
OBJECT_VERSION_NUMBER,
LAST_UPDATE_DATE,
LAST_UPDATED_BY,
CREATION_DATE,
CREATED_BY,
LAST_UPDATE_LOGIN,
MR_ROUTE_ID,
RELATED_MR_ROUTE_ID,
SEQUENCE_CODE,
SECURITY_GROUP_ID,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15
FROM AHL_MR_ROUTE_SEQUENCES_APP_V
Where MR_ROUTE_SEQUENCE_ID=c_MR_ROUTE_SEQUENCE_ID;

Line: 148


             IF P_X_MR_ROUTESEQ_TBL(I).LAST_UPDATE_DATE=FND_API.G_MISS_DATE
             THEN
             P_X_MR_ROUTESEQ_TBL(I).LAST_UPDATE_DATE:=NULL;

Line: 151


             ELSIF P_X_MR_ROUTESEQ_TBL(I).LAST_UPDATE_DATE IS NULL
             THEN
             P_X_MR_ROUTESEQ_TBL(I).LAST_UPDATE_DATE:=l_routeseq_rec.LAST_UPDATE_DATE;

Line: 155


             IF P_X_MR_ROUTESEQ_TBL(I).LAST_UPDATED_BY= FND_API.G_MISS_NUM
             THEN
             P_X_MR_ROUTESEQ_TBL(I).LAST_UPDATED_BY:=NULL;

Line: 158


             ELSIF P_X_MR_ROUTESEQ_TBL(I).LAST_UPDATED_BY IS NULL
             THEN
             P_X_MR_ROUTESEQ_TBL(I).LAST_UPDATED_BY:=l_routeseq_rec.LAST_UPDATED_BY;

Line: 176


             IF P_X_MR_ROUTESEQ_TBL(I).LAST_UPDATE_LOGIN= FND_API.G_MISS_NUM
             THEN
             P_X_MR_ROUTESEQ_TBL(I).LAST_UPDATE_LOGIN:=NULL;

Line: 179


             ELSIF P_X_MR_ROUTESEQ_TBL(I).LAST_UPDATE_LOGIN IS NULL
             THEN
             P_X_MR_ROUTESEQ_TBL(I).LAST_UPDATE_LOGIN:=l_routeseq_rec.LAST_UPDATE_LOGIN;

Line: 330


  Select COUNT(*)
  From  AHL_MR_ROUTES_APP_V
  Where MR_ROUTE_ID=C_MR_ROUTE_ID;

Line: 338


  Select MR_ROUTE_SEQUENCE_ID
  From  AHL_MR_ROUTE_SEQUENCES_APP_V
  Where MR_ROUTE_ID=C_MR_ROUTE_ID
  And   RELATED_MR_ROUTE_ID=C_RELATED_MR_ROUTE_ID
  And   SEQUENCE_CODE=C_SEQUENCE_CODE;

Line: 348


  SELECT MR_STATUS_CODE,TYPE_CODE
  From AHL_MR_HEADERS_APP_V
  Where MR_HEADER_ID=c_mr_header_id
  And MR_STATUS_CODE IN('DRAFT','APPROVAL_REJECTED');

Line: 485


  Select ROUTE_ID
  From AHL_ROUTES_APP_V
  WHERE UPPER(LTRIM(RTRIM(ROUTE_NO)))=UPPER(LTRIM(RTRIM(C_ROUTE_NO)))
  AND   NVL(END_DATE_ACTIVE,SYSDATE+1) >SYSDATE
  AND revision_number = c_revision_number;

Line: 493


  Select MR_ROUTE_ID
  From  AHL_MR_ROUTES_APP_V
  Where ROUTE_ID=C_ROUTE_ID
  And   MR_HEADER_ID=C_MR_HEADER_ID;

Line: 499


  Select ROUTE_NUMBER,ROUTE_ID
  From  AHL_MR_ROUTES_V
  Where MR_ROUTE_ID=C_MR_ROUTE_ID;

Line: 508


  Select COUNT(*)
  From  AHL_MR_ROUTES_APP_V
  Where MR_HEADER_ID=C_MR_HEADER_ID
  And   ROUTE_ID<>C_ROUTE_ID;

Line: 517


  Select count(*)
  From  AHL_MR_ROUTE_SEQUENCES_APP_V
  Where MR_ROUTE_ID=C_MR_ROUTE_ID
  And   RELATED_MR_ROUTE_ID=C_RELATED_MR_ROUTE_ID
  And   SEQUENCE_CODE=C_SEQUENCE_CODE;

Line: 586


                Select count(MR_ROUTE_ID) into l_counter
                  From  AHL_MR_ROUTES_APP_V
                  Where ROUTE_ID=l_route_id
                  And   MR_HEADER_ID=p_x_mr_route_seq_rec.mr_header_id;

Line: 595


                    select count(*) into l_counter3
                    from ahl_mr_routes_APP_V
                    where mr_header_id=p_x_mr_route_seq_rec.mr_header_id
                    and   route_id=l_route_id
                    and   mr_route_id=p_x_mr_route_seq_rec.related_mr_route_id;

Line: 603


                          FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_ROUTE_ID_SELECT_LOV');

Line: 665


        SELECT COUNT(*) INTO l_counter
        FROM  AHL_MR_ROUTE_SEQUENCES A
        WHERE MR_ROUTE_ID IN(SELECT MR_ROUTE_ID FROM AHL_MR_ROUTES_APP_V
                             WHERE MR_HEADER_ID=P_MR_HEADER_ID
                               AND MR_ROUTE_ID=A.MR_ROUTE_ID)
        START WITH RELATED_MR_ROUTE_ID=P_MR_ROUTE_ID
        CONNECT BY PRIOR MR_ROUTE_ID = RELATED_MR_ROUTE_ID;

Line: 720


 SELECT mr_route_id
 FROM AHL_MR_ROUTES_APP_V
 WHERE route_id = (SELECT route_id
 		   FROM  AHL_ROUTES_APP_V
 		   WHERE route_no = p_route_no
 		   AND   revision_number = p_route_revision)
 AND mr_header_id = p_mr_header_id;

Line: 923


               AHL_MR_ROUTE_SEQUENCES_PKG.DELETE_ROW(
			X_MR_ROUTE_SEQUENCE_ID =>P_X_MR_ROUTE_SEQ_TBL(i).MR_ROUTE_SEQUENCE_ID);

Line: 928


       AHL_MR_ROUTE_SEQUENCES_PKG.UPDATE_ROW (
                          X_MR_ROUTE_SEQUENCE_ID    =>p_x_mr_route_seq_tbl(i).MR_ROUTE_SEQUENCE_ID,
                          X_RELATED_MR_ROUTE_ID     =>p_x_mr_route_seq_tbl(i).RELATED_MR_ROUTE_ID,
                          X_SEQUENCE_CODE           =>p_x_mr_route_seq_tbl(i).SEQUENCE_CODE,
                          X_MR_ROUTE_ID             =>p_x_mr_route_seq_tbl(i).MR_ROUTE_ID,
                          X_OBJECT_VERSION_NUMBER   =>p_x_mr_route_seq_tbl(i).OBJECT_VERSION_NUMBER,
                          X_ATTRIBUTE_CATEGORY      =>p_x_mr_route_seq_tbl(i).ATTRIBUTE_CATEGORY,
                          X_ATTRIBUTE1              =>p_x_mr_route_seq_tbl(i).ATTRIBUTE1,
                          X_ATTRIBUTE2              =>p_x_mr_route_seq_tbl(i).ATTRIBUTE2,
                          X_ATTRIBUTE3              =>p_x_mr_route_seq_tbl(i).ATTRIBUTE3,
                          X_ATTRIBUTE4              =>p_x_mr_route_seq_tbl(i).ATTRIBUTE4,
                          X_ATTRIBUTE5              =>p_x_mr_route_seq_tbl(i).ATTRIBUTE5,
                          X_ATTRIBUTE6              =>p_x_mr_route_seq_tbl(i).ATTRIBUTE6,
                          X_ATTRIBUTE7              =>p_x_mr_route_seq_tbl(i).ATTRIBUTE7,
                          X_ATTRIBUTE8              =>p_x_mr_route_seq_tbl(i).ATTRIBUTE8,
                          X_ATTRIBUTE9              =>p_x_mr_route_seq_tbl(i).ATTRIBUTE9,
                          X_ATTRIBUTE10             =>p_x_mr_route_seq_tbl(i).ATTRIBUTE10,
                          X_ATTRIBUTE11             =>p_x_mr_route_seq_tbl(i).ATTRIBUTE11,
                          X_ATTRIBUTE12             =>p_x_mr_route_seq_tbl(i).ATTRIBUTE12,
                          X_ATTRIBUTE13             =>p_x_mr_route_seq_tbl(i).ATTRIBUTE13,
                          X_ATTRIBUTE14             =>p_x_mr_route_seq_tbl(i).ATTRIBUTE14,
                          X_ATTRIBUTE15             =>p_x_mr_route_seq_tbl(i).ATTRIBUTE15,
                          X_LAST_UPDATE_DATE        =>sysdate,
                          X_LAST_UPDATED_BY         =>fnd_global.user_id,
                          X_LAST_UPDATE_LOGIN       =>fnd_global.user_id);

Line: 956


            		AHL_MR_ROUTE_SEQUENCES_PKG.INSERT_ROW
			(
                          X_MR_ROUTE_SEQUENCE_ID     =>p_x_mr_route_seq_tbl(i).MR_ROUTE_SEQUENCE_ID,
                          X_RELATED_MR_ROUTE_ID      =>p_x_mr_route_seq_tbl(i).RELATED_MR_ROUTE_ID,
                          X_SEQUENCE_CODE            =>p_x_mr_route_seq_tbl(i).SEQUENCE_CODE,
                          X_MR_ROUTE_ID              =>p_x_mr_route_seq_tbl(i).MR_ROUTE_ID,
                          X_OBJECT_VERSION_NUMBER    =>1,
                          X_ATTRIBUTE_CATEGORY       =>p_x_mr_route_seq_tbl(i).ATTRIBUTE_CATEGORY,
                          X_ATTRIBUTE1               =>p_x_mr_route_seq_tbl(i).ATTRIBUTE1,
                          X_ATTRIBUTE2               =>p_x_mr_route_seq_tbl(i).ATTRIBUTE2,
                          X_ATTRIBUTE3               =>p_x_mr_route_seq_tbl(i).ATTRIBUTE3,
                          X_ATTRIBUTE4               =>p_x_mr_route_seq_tbl(i).ATTRIBUTE4,
                          X_ATTRIBUTE5               =>p_x_mr_route_seq_tbl(i).ATTRIBUTE5,
                          X_ATTRIBUTE6               =>p_x_mr_route_seq_tbl(i).ATTRIBUTE6,
                          X_ATTRIBUTE7               =>p_x_mr_route_seq_tbl(i).ATTRIBUTE7,
                          X_ATTRIBUTE8               =>p_x_mr_route_seq_tbl(i).ATTRIBUTE8,
                          X_ATTRIBUTE9               =>p_x_mr_route_seq_tbl(i).ATTRIBUTE9,
                          X_ATTRIBUTE10              =>p_x_mr_route_seq_tbl(i).ATTRIBUTE10,
                          X_ATTRIBUTE11              =>p_x_mr_route_seq_tbl(i).ATTRIBUTE11,
                          X_ATTRIBUTE12              =>p_x_mr_route_seq_tbl(i).ATTRIBUTE12,
                          X_ATTRIBUTE13              =>p_x_mr_route_seq_tbl(i).ATTRIBUTE13,
                          X_ATTRIBUTE14              =>p_x_mr_route_seq_tbl(i).ATTRIBUTE14,
                          X_ATTRIBUTE15              =>p_x_mr_route_seq_tbl(i).ATTRIBUTE15,
                          X_CREATION_DATE            =>sysdate,
                          X_CREATED_BY               =>fnd_global.user_id,
                          X_LAST_UPDATE_DATE         =>sysdate,
                          X_LAST_UPDATED_BY          =>fnd_global.user_id,
                          X_LAST_UPDATE_LOGIN        =>fnd_global.user_id);