APPS.AHL_VISIT_TYPE_PVT dependencies on AHL_VISIT_TYPES_B

Line 105: DELETE FROM AHL_VISIT_TYPES_B

101: DELETE FROM AHL_VISIT_TYPES_TL
102: WHERE VISIT_TYPE_ID = p_visit_type_id;
103:
104: -- Delete Visit Types
105: DELETE FROM AHL_VISIT_TYPES_B
106: WHERE VISIT_TYPE_ID = p_visit_type_id;
107:
108: IF ( SQL%ROWCOUNT = 0 ) THEN
109: FND_MESSAGE.set_name('AHL','AHL_VST_TYP_REC_CHNGD');

Line 338: UPDATE AHL_VISIT_TYPES_B

334: IF(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
335:
336: AHL_DEBUG_PUB.debug(L_DEBUG || ': p_visit_type_id-' || p_visit_type_id || ': About to Complete visit type');
337:
338: UPDATE AHL_VISIT_TYPES_B
339: SET OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
340: LAST_UPDATE_DATE = G_LAST_UPDATE_DATE,
341: LAST_UPDATED_BY = G_LAST_UPDATED_BY,
342: LAST_UPDATE_LOGIN = G_LAST_UPDATE_LOGIN,

Line 460: FROM AHL_VISIT_TYPES_B

456: * Added cursor to get component visit flag for the given Visit Type.
457: */
458: CURSOR get_visit_type_dtls_csr (c_visit_type_id NUMBER) IS
459: SELECT component_visit_flag
460: FROM AHL_VISIT_TYPES_B
461: WHERE visit_type_id = c_visit_type_id;
462:
463: BEGIN
464:

Line 514: AHL_VISIT_TYPES_B

510: -- Stage Types
511:
512: -- Insert Visit Type Record
513: INSERT INTO
514: AHL_VISIT_TYPES_B
515: (VISIT_TYPE_ID ,
516: VISIT_TYPE_CODE ,
517: SERVICE_CATEGORY_CODE,
518: STATUS_CODE ,

Line 582: FROM AHL_VISIT_TYPES_B

578: ATTRIBUTE12 ,
579: ATTRIBUTE13 ,
580: ATTRIBUTE14 ,
581: ATTRIBUTE15
582: FROM AHL_VISIT_TYPES_B
583: WHERE VISIT_TYPE_ID = p_par_visit_type_id;
584:
585: -- Insert Into Visit Type _TL table
586: INSERT INTO

Line 923: FROM AHL_VISIT_TYPES_B VST_TYP

919:
920: CURSOR GET_MAX_UPDATE_DATE(C_VISIT_TYPE_ID NUMBER) IS
921: SELECT MAX(LAST_UPDATE_DATE) MAX_LUD FROM(
922: SELECT VST_TYP.LAST_UPDATE_DATE LAST_UPDATE_DATE
923: FROM AHL_VISIT_TYPES_B VST_TYP
924: WHERE VST_TYP.VISIT_TYPE_ID = C_VISIT_TYPE_ID
925:
926: UNION ALL
927:

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: