APPS.AHL_MR_ROUTES_PKG dependencies on AHL_MR_ROUTES

Line 1: package body AHL_MR_ROUTES_PKG as

1: package body AHL_MR_ROUTES_PKG as
2: /* $Header: AHLLMRUB.pls 120.0.12020000.2 2012/12/06 22:36:07 sareepar ship $ */
3: procedure INSERT_ROW (
4:
5: X_MR_ROUTE_ID in out nocopy NUMBER,

Line 35: insert into AHL_MR_ROUTES (

31: X_LAST_UPDATED_BY in NUMBER,
32: X_LAST_UPDATE_LOGIN in NUMBER
33: ) is
34: begin
35: insert into AHL_MR_ROUTES (
36: MR_ROUTE_ID,
37: LAST_UPDATED_BY,
38: CREATION_DATE,
39: CREATED_BY,

Line 65: AHL_MR_ROUTES_S.NEXTVAL,

61: ATTRIBUTE15,
62: LAST_UPDATE_DATE,
63: OBJECT_VERSION_NUMBER)
64: values(
65: AHL_MR_ROUTES_S.NEXTVAL,
66: X_LAST_UPDATED_BY,
67: X_CREATION_DATE,
68: X_CREATED_BY,
69: X_LAST_UPDATE_LOGIN,

Line 125: update AHL_MR_ROUTES set

121: X_LAST_UPDATED_BY in NUMBER,
122: X_LAST_UPDATE_LOGIN in NUMBER
123: ) is
124: begin
125: update AHL_MR_ROUTES set
126: MR_HEADER_ID = X_MR_HEADER_ID,
127: ROUTE_ID = X_ROUTE_ID,
128: STAGE = X_STAGE,
129: --MANESING::VWP Enhancements, 21-Jan-2011, added stage type code

Line 164: delete from AHL_MR_ROUTES

160: procedure DELETE_ROW (
161: X_MR_ROUTE_ID in NUMBER
162: ) is
163: begin
164: delete from AHL_MR_ROUTES
165: where MR_ROUTE_ID = X_MR_ROUTE_ID;
166:
167: if (sql%notfound) then
168: raise no_data_found;

Line 173: end AHL_MR_ROUTES_PKG;

169: end if;
170:
171: end DELETE_ROW;
172:
173: end AHL_MR_ROUTES_PKG;