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_VWP_STAGES_PKG dependencies on AHL_VISIT_STAGE_TYP_ASOC

Line 468: cursor C is select ROWID from AHL_VISIT_STAGE_TYP_ASOC

464: X_ATTRIBUTE13 in VARCHAR2,
465: X_ATTRIBUTE14 in VARCHAR2,
466: X_ATTRIBUTE15 in VARCHAR2
467: ) is
468: cursor C is select ROWID from AHL_VISIT_STAGE_TYP_ASOC
469: where STAGE_TYPE_ASSOC_ID = X_STAGE_TYPE_ASSOC_ID
470: ;
471: begin
472: insert into AHL_VISIT_STAGE_TYP_ASOC (

Line 472: insert into AHL_VISIT_STAGE_TYP_ASOC (

468: cursor C is select ROWID from AHL_VISIT_STAGE_TYP_ASOC
469: where STAGE_TYPE_ASSOC_ID = X_STAGE_TYPE_ASSOC_ID
470: ;
471: begin
472: insert into AHL_VISIT_STAGE_TYP_ASOC (
473: STAGE_TYPE_ASSOC_ID,
474: STAGE_ID,
475: STAGE_TYPE_CODE,
476: CREATION_DATE,

Line 539: delete from AHL_VISIT_STAGE_TYP_ASOC

535: X_STAGE_TYPE_ASSOC_ID in NUMBER
536: ) is
537: begin
538:
539: delete from AHL_VISIT_STAGE_TYP_ASOC
540: where STAGE_TYPE_ASSOC_ID = X_STAGE_TYPE_ASSOC_ID;
541:
542: if (sql%notfound) then
543: raise no_data_found;