APPS.AHL_FMP_MR_ROUTE_PVT dependencies on AHL_MR_ROUTES

Line 43: FROM AHL_MR_ROUTES_V

39: ATTRIBUTE12,
40: ATTRIBUTE13,
41: ATTRIBUTE14,
42: ATTRIBUTE15
43: FROM AHL_MR_ROUTES_V
44: WHERE MR_ROUTE_ID=C_MR_ROUTE_ID;
45: l_mr_route_rec CurGetRouteDet%rowtype;
46: BEGIN
47: IF P_X_MR_ROUTE_TBL.COUNT >0

Line 511: FROM AHL_MR_ROUTES

507: */
508: IF (p_x_mr_route_rec.dml_operation = 'U') THEN
509: SELECT NVL(stage, 0), NVL(p_x_mr_route_rec.stage, 0)
510: INTO l_curr_stage_number, l_passed_stage_number
511: FROM AHL_MR_ROUTES
512: WHERE mr_route_id = p_x_mr_route_rec.mr_route_id;
513: END IF;
514:
515: IF ( (p_x_mr_route_rec.dml_operation = 'C' AND p_x_mr_route_rec.stage IS NOT NULL) OR

Line 677: DELETE AHL_MR_ROUTES

673: DELETE AHL_MR_ROUTE_SEQUENCES a
674: where (MR_ROUTE_ID =P_X_MR_ROUTE_TBL(i).MR_ROUTE_ID or RELATED_MR_ROUTE_ID=P_X_MR_ROUTE_TBL(i).MR_ROUTE_ID);
675:
676:
677: DELETE AHL_MR_ROUTES
678: where MR_ROUTE_ID =p_x_MR_ROUTE_TBL(i).MR_ROUTE_ID
679: and OBJECT_VERSION_NUMBER=p_x_MR_ROUTE_TBL(i).object_version_number;
680:
681: IF sql%rowcount=0 then

Line 689: AHL_MR_ROUTES_PKG.UPDATE_ROW (

685: END IF;
686:
687: ELSIF P_X_MR_ROUTE_TBL(i).DML_operation='U' then
688:
689: AHL_MR_ROUTES_PKG.UPDATE_ROW (
690: X_MR_ROUTE_ID =>P_X_MR_ROUTE_TBL(i).MR_ROUTE_ID,
691: X_OBJECT_VERSION_NUMBER =>p_x_MR_ROUTE_TBL(i).object_version_number,
692: X_MR_HEADER_ID =>P_X_MR_ROUTE_TBL(i).MR_HEADER_ID,
693: X_ROUTE_ID =>P_X_MR_ROUTE_TBL(i).ROUTE_ID,

Line 720: AHL_MR_ROUTES_PKG.INSERT_ROW (

716:
717: ELSIF P_X_MR_ROUTE_TBL(i).DML_operation='C' then
718:
719:
720: AHL_MR_ROUTES_PKG.INSERT_ROW (
721: X_MR_ROUTE_ID =>P_X_MR_ROUTE_TBL(i).MR_ROUTE_ID,
722: X_OBJECT_VERSION_NUMBER =>1,
723: X_MR_HEADER_ID =>P_X_MR_ROUTE_TBL(i).MR_HEADER_ID,
724: X_ROUTE_ID =>P_X_MR_ROUTE_TBL(i).ROUTE_ID,