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_VISIT_TYPE_PVT dependencies on AHL_VISIT_TYPE_STAGES_B

Line 78: FROM AHL_VISIT_TYPE_STAGES_B AVTSB

74:
75: -- Delete Stage Types
76: DELETE FROM AHL_VST_TYP_STG_TYP_ASOC
77: WHERE VISIT_TYPE_STAGE_ID IN (SELECT VISIT_TYPE_STAGE_ID
78: FROM AHL_VISIT_TYPE_STAGES_B AVTSB
79: WHERE VISIT_TYPE_ID = p_visit_type_id);
80:
81: -- Delete Stage Links
82: DELETE FROM AHL_VST_TYP_STAGE_LINKS

Line 84: FROM AHL_VISIT_TYPE_STAGES_B AVTSB

80:
81: -- Delete Stage Links
82: DELETE FROM AHL_VST_TYP_STAGE_LINKS
83: WHERE OBJECT_ID IN (SELECT VISIT_TYPE_STAGE_ID
84: FROM AHL_VISIT_TYPE_STAGES_B AVTSB
85: WHERE VISIT_TYPE_ID = p_visit_type_id)
86: OR SUBJECT_ID IN(SELECT VISIT_TYPE_STAGE_ID
87: FROM AHL_VISIT_TYPE_STAGES_B AVTSB
88: WHERE VISIT_TYPE_ID = p_visit_type_id);

Line 87: FROM AHL_VISIT_TYPE_STAGES_B AVTSB

83: WHERE OBJECT_ID IN (SELECT VISIT_TYPE_STAGE_ID
84: FROM AHL_VISIT_TYPE_STAGES_B AVTSB
85: WHERE VISIT_TYPE_ID = p_visit_type_id)
86: OR SUBJECT_ID IN(SELECT VISIT_TYPE_STAGE_ID
87: FROM AHL_VISIT_TYPE_STAGES_B AVTSB
88: WHERE VISIT_TYPE_ID = p_visit_type_id);
89:
90: -- Delete Stages from TL
91: DELETE FROM AHL_VISIT_TYPE_STAGES_TL

Line 93: FROM AHL_VISIT_TYPE_STAGES_B AVTSB

89:
90: -- Delete Stages from TL
91: DELETE FROM AHL_VISIT_TYPE_STAGES_TL
92: WHERE VISIT_TYPE_STAGE_ID IN (SELECT VISIT_TYPE_STAGE_ID
93: FROM AHL_VISIT_TYPE_STAGES_B AVTSB
94: WHERE VISIT_TYPE_ID = p_visit_type_id);
95:
96: -- Delete Stages
97: DELETE FROM AHL_VISIT_TYPE_STAGES_B

Line 97: DELETE FROM AHL_VISIT_TYPE_STAGES_B

93: FROM AHL_VISIT_TYPE_STAGES_B AVTSB
94: WHERE VISIT_TYPE_ID = p_visit_type_id);
95:
96: -- Delete Stages
97: DELETE FROM AHL_VISIT_TYPE_STAGES_B
98: WHERE VISIT_TYPE_ID = p_visit_type_id;
99:
100: -- Delete Visit Types from TL
101: DELETE FROM AHL_VISIT_TYPES_TL

Line 198: FROM AHL_VISIT_TYPE_STAGES_B AVTSB

194:
195: -- cursor to get the count of stages in the visit type
196: CURSOR count_stage(c_visit_type_id IN Number) IS
197: Select COUNT(VISIT_TYPE_STAGE_ID)
198: FROM AHL_VISIT_TYPE_STAGES_B AVTSB
199: WHERE VISIT_TYPE_ID = c_visit_type_id;
200:
201:
202: -- cursor to count the number of stage types in the

Line 208: AHL_VISIT_TYPE_STAGES_B AVTSB

204: CURSOR count_stage_type(c_visit_type_id IN Number) IS
205: SELECT AVTSB.STAGE_NUMBER,
206: COUNT(VISIT_TYP_STAGE_TYP_ASOC_ID) as Count
207: FROM AHL_VST_TYP_STG_TYP_ASOC AVTSTA,
208: AHL_VISIT_TYPE_STAGES_B AVTSB
209: WHERE AVTSB.VISIT_TYPE_STAGE_ID = AVTSTA.VISIT_TYPE_STAGE_ID(+)
210: AND AVTSB.VISIT_TYPE_ID = c_visit_type_id
211: group by AVTSB.STAGE_NUMBER;
212:

Line 437: FROM AHL_VISIT_TYPE_STAGES_B

433: l_component_visit_flag VARCHAR2(1);
434:
435: CURSOR get_stages(c_visit_type_id IN Number) IS
436: SELECT VISIT_TYPE_STAGE_ID
437: FROM AHL_VISIT_TYPE_STAGES_B
438: WHERE VISIT_TYPE_ID = c_visit_type_id;
439:
440: CURSOR get_seq_stage_id IS
441: SELECT AHL_VISIT_TYPE_STAGES_B_S.nextVal

Line 441: SELECT AHL_VISIT_TYPE_STAGES_B_S.nextVal

437: FROM AHL_VISIT_TYPE_STAGES_B
438: WHERE VISIT_TYPE_ID = c_visit_type_id;
439:
440: CURSOR get_seq_stage_id IS
441: SELECT AHL_VISIT_TYPE_STAGES_B_S.nextVal
442: FROM dual;
443:
444: /* MANESING::Component Maintenance Planning Project, 05-Jul-2011,
445: * Removed mc_name from view AHL_VISIT_TYPES_VL, thereby added outer join with table AHL_MC_HEADERS_B.

Line 632: AHL_VISIT_TYPE_STAGES_B

628: CLOSE get_seq_stage_id;
629:
630: -- Insert into Stages Table
631: INSERT INTO
632: AHL_VISIT_TYPE_STAGES_B
633: (VISIT_TYPE_STAGE_ID ,
634: VISIT_TYPE_ID ,
635: DURATION ,
636: STAGE_NUMBER ,

Line 689: FROM AHL_VISIT_TYPE_STAGES_B

685: ATTRIBUTE12 ,
686: ATTRIBUTE13 ,
687: ATTRIBUTE14 ,
688: ATTRIBUTE15
689: FROM AHL_VISIT_TYPE_STAGES_B
690: WHERE VISIT_TYPE_STAGE_ID = stage_rec.VISIT_TYPE_STAGE_ID;
691:
692: -- Insert into Stages _TL table
693: INSERT INTO

Line 841: AHL_VISIT_TYPE_STAGES_B Stages1,

837: LINKS.ATTRIBUTE13 ,
838: LINKS.ATTRIBUTE14 ,
839: LINKS.ATTRIBUTE15
840: FROM AHL_VST_TYP_STAGE_LINKS LINKS,
841: AHL_VISIT_TYPE_STAGES_B Stages1,
842: AHL_VISIT_TYPE_STAGES_B Stages2,
843: AHL_VISIT_TYPE_STAGES_B Stages3
844: WHERE LINKS.OBJECT_ID = Stages1.VISIT_TYPE_STAGE_ID
845: AND Stages1.VISIT_TYPE_ID = p_par_visit_type_id

Line 842: AHL_VISIT_TYPE_STAGES_B Stages2,

838: LINKS.ATTRIBUTE14 ,
839: LINKS.ATTRIBUTE15
840: FROM AHL_VST_TYP_STAGE_LINKS LINKS,
841: AHL_VISIT_TYPE_STAGES_B Stages1,
842: AHL_VISIT_TYPE_STAGES_B Stages2,
843: AHL_VISIT_TYPE_STAGES_B Stages3
844: WHERE LINKS.OBJECT_ID = Stages1.VISIT_TYPE_STAGE_ID
845: AND Stages1.VISIT_TYPE_ID = p_par_visit_type_id
846: --Object id and Subject Id to be inserted in the new record have to be of the newly created stages.

Line 843: AHL_VISIT_TYPE_STAGES_B Stages3

839: LINKS.ATTRIBUTE15
840: FROM AHL_VST_TYP_STAGE_LINKS LINKS,
841: AHL_VISIT_TYPE_STAGES_B Stages1,
842: AHL_VISIT_TYPE_STAGES_B Stages2,
843: AHL_VISIT_TYPE_STAGES_B Stages3
844: WHERE LINKS.OBJECT_ID = Stages1.VISIT_TYPE_STAGE_ID
845: AND Stages1.VISIT_TYPE_ID = p_par_visit_type_id
846: --Object id and Subject Id to be inserted in the new record have to be of the newly created stages.
847: --So these ids of the Stages having the same stage number as the old stages are taken

Line 850: FROM AHL_VISIT_TYPE_STAGES_B

846: --Object id and Subject Id to be inserted in the new record have to be of the newly created stages.
847: --So these ids of the Stages having the same stage number as the old stages are taken
848: AND Stages2.VISIT_TYPE_ID = p_visit_type_id
849: AND Stages2.STAGE_NUMBER = (SELECT STAGE_NUMBER
850: FROM AHL_VISIT_TYPE_STAGES_B
851: WHERE VISIT_TYPE_STAGE_ID = LINKS.OBJECT_ID)
852: AND Stages3.VISIT_TYPE_ID = p_visit_type_id
853: AND Stages3.STAGE_NUMBER = (SELECT STAGE_NUMBER
854: FROM AHL_VISIT_TYPE_STAGES_B

Line 854: FROM AHL_VISIT_TYPE_STAGES_B

850: FROM AHL_VISIT_TYPE_STAGES_B
851: WHERE VISIT_TYPE_STAGE_ID = LINKS.OBJECT_ID)
852: AND Stages3.VISIT_TYPE_ID = p_visit_type_id
853: AND Stages3.STAGE_NUMBER = (SELECT STAGE_NUMBER
854: FROM AHL_VISIT_TYPE_STAGES_B
855: WHERE VISIT_TYPE_STAGE_ID = LINKS.SUBJECT_ID);
856:
857: END IF; -- NVL(l_component_visit_flag, 'N') = 'N'
858:

Line 929: FROM AHL_VISIT_TYPE_STAGES_B STAGES, AHL_VISIT_TYPES_B VST_TYP

925:
926: UNION ALL
927:
928: SELECT MAX(STAGES.LAST_UPDATE_DATE) LAST_UPDATE_DATE
929: FROM AHL_VISIT_TYPE_STAGES_B STAGES, AHL_VISIT_TYPES_B VST_TYP
930: WHERE STAGES.VISIT_TYPE_ID = VST_TYP.VISIT_TYPE_ID
931: AND VST_TYP.VISIT_TYPE_ID = C_VISIT_TYPE_ID
932:
933: UNION ALL

Line 936: FROM AHL_VST_TYP_STAGE_LINKS LINKS, AHL_VISIT_TYPE_STAGES_B STAGES, AHL_VISIT_TYPES_B VST_TYP

932:
933: UNION ALL
934:
935: SELECT MAX(LINKS.LAST_UPDATE_DATE) LAST_UPDATE_DATE
936: FROM AHL_VST_TYP_STAGE_LINKS LINKS, AHL_VISIT_TYPE_STAGES_B STAGES, AHL_VISIT_TYPES_B VST_TYP
937: WHERE VST_TYP.VISIT_TYPE_ID = STAGES.VISIT_TYPE_ID
938: AND STAGES.VISIT_TYPE_STAGE_ID = LINKS.OBJECT_ID
939: AND VST_TYP.VISIT_TYPE_ID = C_VISIT_TYPE_ID
940:

Line 944: FROM AHL_VST_TYP_STG_TYP_ASOC STG_TYP, AHL_VISIT_TYPE_STAGES_B STAGES, AHL_VISIT_TYPES_B VST_TYP

940:
941: UNION ALL
942:
943: SELECT MAX(STG_TYP.LAST_UPDATE_DATE) LAST_UPDATE_DATE
944: FROM AHL_VST_TYP_STG_TYP_ASOC STG_TYP, AHL_VISIT_TYPE_STAGES_B STAGES, AHL_VISIT_TYPES_B VST_TYP
945: WHERE VST_TYP.VISIT_TYPE_ID = STAGES.VISIT_TYPE_ID
946: AND STAGES.VISIT_TYPE_STAGE_ID = STG_TYP.VISIT_TYPE_STAGE_ID
947: AND VST_TYP.VISIT_TYPE_ID = C_VISIT_TYPE_ID) QRSLT;
948: