APPS.AHL_ROUTES_PKG dependencies on AHL_ROUTES_B

Line 76: cursor C is select ROWID from AHL_ROUTES_B

72: X_LAST_UPDATE_DATE in DATE,
73: X_LAST_UPDATED_BY in NUMBER,
74: X_LAST_UPDATE_LOGIN in NUMBER
75: ) is
76: cursor C is select ROWID from AHL_ROUTES_B
77: where ROUTE_ID = X_ROUTE_ID
78: ;
79: begin
80: insert into AHL_ROUTES_B (

Line 80: insert into AHL_ROUTES_B (

76: cursor C is select ROWID from AHL_ROUTES_B
77: where ROUTE_ID = X_ROUTE_ID
78: ;
79: begin
80: insert into AHL_ROUTES_B (
81: QA_INSPECTION_TYPE,
82: ENABLED_FLAG,
83: SUMMARY_FLAG,
84: START_DATE_ACTIVE,

Line 381: from AHL_ROUTES_B

377: ATTRIBUTE12,
378: ATTRIBUTE13,
379: ATTRIBUTE14,
380: ATTRIBUTE15
381: from AHL_ROUTES_B
382: where ROUTE_ID = X_ROUTE_ID
383: for update of ROUTE_ID nowait;
384: recinfo c%rowtype;
385:

Line 600: update AHL_ROUTES_B set

596: X_LAST_UPDATED_BY in NUMBER,
597: X_LAST_UPDATE_LOGIN in NUMBER
598: ) is
599: begin
600: update AHL_ROUTES_B set
601: QA_INSPECTION_TYPE = X_QA_INSPECTION_TYPE,
602: ENABLED_FLAG = X_ENABLED_FLAG,
603: SUMMARY_FLAG = X_SUMMARY_FLAG,
604: START_DATE_ACTIVE = X_START_DATE_ACTIVE,

Line 694: delete from AHL_ROUTES_B

690: if (sql%notfound) then
691: raise no_data_found;
692: end if;
693:
694: delete from AHL_ROUTES_B
695: where ROUTE_ID = X_ROUTE_ID;
696:
697: if (sql%notfound) then
698: raise no_data_found;

Line 708: from AHL_ROUTES_B B

704: begin
705: delete from AHL_ROUTES_TL T
706: where not exists
707: (select NULL
708: from AHL_ROUTES_B B
709: where B.ROUTE_ID = T.ROUTE_ID
710: );
711:
712: update AHL_ROUTES_TL T set (