APPS.AHL_FMP_MR_ROUTE_SEQNCE_PVT dependencies on AHL_MR_ROUTE_SEQUENCES

Line 43: ahl_mr_route_sequences mrs

39: -- Get the minimum bound for route stage, based on routes executed before
40: SELECT nvl(max(mrr.stage), 1)
41: INTO l_min_stage
42: FROM ahl_mr_routes_v mrr,
43: ahl_mr_route_sequences mrs
44: WHERE mrr.mr_route_id = mrs.mr_route_id and
45: mrs.related_mr_route_id = p_mr_route_id;
46:
47: -- Get the maximum bound for route stage, based on routes executed after

Line 51: ahl_mr_route_sequences mrs

47: -- Get the maximum bound for route stage, based on routes executed after
48: SELECT nvl(min(mrr.stage), l_max_stage_num)
49: INTO l_max_stage
50: FROM ahl_mr_routes_v mrr,
51: ahl_mr_route_sequences mrs
52: WHERE mrr.mr_route_id = mrs.related_mr_route_id and
53: mrs.mr_route_id = p_mr_route_id;
54:
55: OPEN get_mr_route_det (p_mr_route_id);

Line 118: FROM AHL_MR_ROUTE_SEQUENCES_APP_V

114: ATTRIBUTE12,
115: ATTRIBUTE13,
116: ATTRIBUTE14,
117: ATTRIBUTE15
118: FROM AHL_MR_ROUTE_SEQUENCES_APP_V
119: Where MR_ROUTE_SEQUENCE_ID=c_MR_ROUTE_SEQUENCE_ID;
120:
121: l_routeseq_rec CurGetSeqDet%rowtype;
122:

Line 339: From AHL_MR_ROUTE_SEQUENCES_APP_V

335:
336: CURSOR CHECK_UNIQ(C_MR_ROUTE_ID NUMBER,C_RELATED_MR_ROUTE_ID NUMBER,C_SEQUENCE_CODE VARCHAR2)
337: IS
338: Select MR_ROUTE_SEQUENCE_ID
339: From AHL_MR_ROUTE_SEQUENCES_APP_V
340: Where MR_ROUTE_ID=C_MR_ROUTE_ID
341: And RELATED_MR_ROUTE_ID=C_RELATED_MR_ROUTE_ID
342: And SEQUENCE_CODE=C_SEQUENCE_CODE;
343:

Line 518: From AHL_MR_ROUTE_SEQUENCES_APP_V

514:
515: CURSOR CHECK_UNIQ(C_MR_ROUTE_ID NUMBER,C_RELATED_MR_ROUTE_ID NUMBER,C_SEQUENCE_CODE VARCHAR2)
516: IS
517: Select count(*)
518: From AHL_MR_ROUTE_SEQUENCES_APP_V
519: Where MR_ROUTE_ID=C_MR_ROUTE_ID
520: And RELATED_MR_ROUTE_ID=C_RELATED_MR_ROUTE_ID
521: And SEQUENCE_CODE=C_SEQUENCE_CODE;
522:

Line 666: FROM AHL_MR_ROUTE_SEQUENCES A

662: BEGIN
663: x_return_status:=FND_API.G_RET_STS_SUCCESS;
664:
665: SELECT COUNT(*) INTO l_counter
666: FROM AHL_MR_ROUTE_SEQUENCES A
667: WHERE MR_ROUTE_ID IN(SELECT MR_ROUTE_ID FROM AHL_MR_ROUTES_APP_V
668: WHERE MR_HEADER_ID=P_MR_HEADER_ID
669: AND MR_ROUTE_ID=A.MR_ROUTE_ID)
670: START WITH RELATED_MR_ROUTE_ID=P_MR_ROUTE_ID

Line 923: AHL_MR_ROUTE_SEQUENCES_PKG.DELETE_ROW(

919:
920:
921: -- Calling for Validation
922: IF L_MR_ROUTE_SEQ_TBL(i).DML_OPERATION='D' then
923: AHL_MR_ROUTE_SEQUENCES_PKG.DELETE_ROW(
924: X_MR_ROUTE_SEQUENCE_ID =>P_X_MR_ROUTE_SEQ_TBL(i).MR_ROUTE_SEQUENCE_ID);
925:
926: ELSIF L_MR_ROUTE_SEQ_TBL(i).DML_operation='U' then
927:

Line 928: AHL_MR_ROUTE_SEQUENCES_PKG.UPDATE_ROW (

924: X_MR_ROUTE_SEQUENCE_ID =>P_X_MR_ROUTE_SEQ_TBL(i).MR_ROUTE_SEQUENCE_ID);
925:
926: ELSIF L_MR_ROUTE_SEQ_TBL(i).DML_operation='U' then
927:
928: AHL_MR_ROUTE_SEQUENCES_PKG.UPDATE_ROW (
929: X_MR_ROUTE_SEQUENCE_ID =>p_x_mr_route_seq_tbl(i).MR_ROUTE_SEQUENCE_ID,
930: X_RELATED_MR_ROUTE_ID =>p_x_mr_route_seq_tbl(i).RELATED_MR_ROUTE_ID,
931: X_SEQUENCE_CODE =>p_x_mr_route_seq_tbl(i).SEQUENCE_CODE,
932: X_MR_ROUTE_ID =>p_x_mr_route_seq_tbl(i).MR_ROUTE_ID,

Line 956: AHL_MR_ROUTE_SEQUENCES_PKG.INSERT_ROW

952: X_LAST_UPDATE_LOGIN =>fnd_global.user_id);
953:
954: ELSIF p_x_mr_route_seq_tbl(i).DML_operation='C' then
955:
956: AHL_MR_ROUTE_SEQUENCES_PKG.INSERT_ROW
957: (
958: X_MR_ROUTE_SEQUENCE_ID =>p_x_mr_route_seq_tbl(i).MR_ROUTE_SEQUENCE_ID,
959: X_RELATED_MR_ROUTE_ID =>p_x_mr_route_seq_tbl(i).RELATED_MR_ROUTE_ID,
960: X_SEQUENCE_CODE =>p_x_mr_route_seq_tbl(i).SEQUENCE_CODE,