APPS.AHL_ROUTES_PKG dependencies on AHL_ROUTES_B

Line 86: cursor C is select ROWID from AHL_ROUTES_B

82: X_LAST_UPDATE_DATE in DATE,
83: X_LAST_UPDATED_BY in NUMBER,
84: X_LAST_UPDATE_LOGIN in NUMBER
85: ) is
86: cursor C is select ROWID from AHL_ROUTES_B
87: where ROUTE_ID = X_ROUTE_ID
88: ;
89: begin
90: insert into AHL_ROUTES_B (

Line 90: insert into AHL_ROUTES_B (

86: cursor C is select ROWID from AHL_ROUTES_B
87: where ROUTE_ID = X_ROUTE_ID
88: ;
89: begin
90: insert into AHL_ROUTES_B (
91: QA_INSPECTION_TYPE,
92: ENABLED_FLAG,
93: SUMMARY_FLAG,
94: START_DATE_ACTIVE,

Line 430: from AHL_ROUTES_B

426: ATTRIBUTE12,
427: ATTRIBUTE13,
428: ATTRIBUTE14,
429: ATTRIBUTE15
430: from AHL_ROUTES_B
431: where ROUTE_ID = X_ROUTE_ID
432: for update of ROUTE_ID nowait;
433: recinfo c%rowtype;
434:

Line 676: update AHL_ROUTES_B set

672: X_LAST_UPDATED_BY in NUMBER,
673: X_LAST_UPDATE_LOGIN in NUMBER
674: ) is
675: begin
676: update AHL_ROUTES_B set
677: QA_INSPECTION_TYPE = X_QA_INSPECTION_TYPE,
678: ENABLED_FLAG = X_ENABLED_FLAG,
679: SUMMARY_FLAG = X_SUMMARY_FLAG,
680: START_DATE_ACTIVE = X_START_DATE_ACTIVE,

Line 780: delete from AHL_ROUTES_B

776: if (sql%notfound) then
777: raise no_data_found;
778: end if;
779:
780: delete from AHL_ROUTES_B
781: where ROUTE_ID = X_ROUTE_ID;
782:
783: if (sql%notfound) then
784: raise no_data_found;

Line 794: from AHL_ROUTES_B B

790: begin
791: delete from AHL_ROUTES_TL T
792: where not exists
793: (select NULL
794: from AHL_ROUTES_B B
795: where B.ROUTE_ID = T.ROUTE_ID
796: );
797:
798: update AHL_ROUTES_TL T set (