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 2005/05/25 23:55:41 appldev noship $ */
3: procedure INSERT_ROW (
4:
5: X_MR_ROUTE_ID in out nocopy NUMBER,

Line 33: insert into AHL_MR_ROUTES (

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

Line 61: AHL_MR_ROUTES_S.NEXTVAL,

57: ATTRIBUTE15,
58: LAST_UPDATE_DATE,
59: OBJECT_VERSION_NUMBER)
60: values(
61: AHL_MR_ROUTES_S.NEXTVAL,
62: X_LAST_UPDATED_BY,
63: X_CREATION_DATE,
64: X_CREATED_BY,
65: X_LAST_UPDATE_LOGIN,

Line 117: update AHL_MR_ROUTES set

113: X_LAST_UPDATED_BY in NUMBER,
114: X_LAST_UPDATE_LOGIN in NUMBER
115: ) is
116: begin
117: update AHL_MR_ROUTES set
118: MR_HEADER_ID = X_MR_HEADER_ID,
119: ROUTE_ID = X_ROUTE_ID,
120: STAGE = X_STAGE,
121: ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,

Line 154: delete from AHL_MR_ROUTES

150: procedure DELETE_ROW (
151: X_MR_ROUTE_ID in NUMBER
152: ) is
153: begin
154: delete from AHL_MR_ROUTES
155: where MR_ROUTE_ID = X_MR_ROUTE_ID;
156:
157: if (sql%notfound) then
158: raise no_data_found;

Line 163: end AHL_MR_ROUTES_PKG;

159: end if;
160:
161: end DELETE_ROW;
162:
163: end AHL_MR_ROUTES_PKG;