eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_VISITS_PKG dependencies on AHL_VISITS_B

Line 60: cursor C is select ROWID from AHL_VISITS_B

56: X_LAST_UPDATE_DATE in DATE,
57: X_LAST_UPDATED_BY in NUMBER,
58: X_LAST_UPDATE_LOGIN in NUMBER
59: ) is
60: cursor C is select ROWID from AHL_VISITS_B
61: where VISIT_ID = X_VISIT_ID
62: ;
63: begin
64: insert into AHL_VISITS_B (

Line 64: insert into AHL_VISITS_B (

60: cursor C is select ROWID from AHL_VISITS_B
61: where VISIT_ID = X_VISIT_ID
62: ;
63: begin
64: insert into AHL_VISITS_B (
65: ESTIMATED_PRICE,
66: PRIORITY_CODE,
67: PROJECT_TEMPLATE_ID,
68: UNIT_SCHEDULE_ID,

Line 310: from AHL_VISITS_B

306: ATTRIBUTE12,
307: ATTRIBUTE13,
308: ATTRIBUTE14,
309: ATTRIBUTE15
310: from AHL_VISITS_B
311: where VISIT_ID = X_VISIT_ID
312: for update of VISIT_ID nowait;
313: recinfo c%rowtype;
314:

Line 500: update AHL_VISITS_B set

496: X_LAST_UPDATED_BY in NUMBER,
497: X_LAST_UPDATE_LOGIN in NUMBER
498: ) is
499: begin
500: update AHL_VISITS_B set
501: ESTIMATED_PRICE = X_ESTIMATED_PRICE,
502: PRIORITY_CODE = X_PRIORITY_CODE,
503: PROJECT_TEMPLATE_ID = X_PROJECT_TEMPLATE_ID,
504: UNIT_SCHEDULE_ID = X_UNIT_SCHEDULE_ID,

Line 582: delete from AHL_VISITS_B

578: if (sql%notfound) then
579: raise no_data_found;
580: end if;
581:
582: delete from AHL_VISITS_B
583: where VISIT_ID = X_VISIT_ID;
584:
585: if (sql%notfound) then
586: raise no_data_found;

Line 596: from AHL_VISITS_B B

592: begin
593: delete from AHL_VISITS_TL T
594: where not exists
595: (select NULL
596: from AHL_VISITS_B B
597: where B.VISIT_ID = T.VISIT_ID
598: );
599:
600: update AHL_VISITS_TL T set (