APPS.AHL_FMP_MR_VISIT_TYPES_PVT dependencies on AHL_MR_VISIT_TYPES

Line 15: INSERT INTO AHL_MR_VISIT_TYPES

11: p_x_mr_visit_type_rec IN OUT NOCOPY mr_visit_type_REC_type
12: )
13: AS
14: BEGIN
15: INSERT INTO AHL_MR_VISIT_TYPES
16: (
17: MR_VISIT_TYPE_ID,
18: OBJECT_VERSION_NUMBER,
19: LAST_UPDATE_DATE,

Line 45: AHL_MR_VISIT_TYPES_S.NEXTVAL,

41: ATTRIBUTE15
42: )
43: VALUES
44: (
45: AHL_MR_VISIT_TYPES_S.NEXTVAL,
46: 1,
47: SYSDATE,
48: FND_GLOBAL.user_ID,
49: SYSDATE,

Line 80: UPDATE AHL_MR_VISIT_TYPES

76: p_mr_visit_type_rec IN mr_visit_type_REC_type
77: )
78: AS
79: BEGIN
80: UPDATE AHL_MR_VISIT_TYPES
81: SET mr_visit_type_ID =P_MR_VISIT_TYPE_REC.mr_visit_type_ID,
82: OBJECT_VERSION_NUMBER =P_MR_VISIT_TYPE_REC.OBJECT_VERSION_NUMBER+1,
83: MR_HEADER_ID =P_MR_VISIT_TYPE_REC.MR_HEADER_ID,
84: mr_visit_type_CODE =P_MR_VISIT_TYPE_REC.mr_visit_type_CODE,

Line 120: delete from AHL_mr_visit_types

116: p_mr_visit_type_rec IN mr_visit_type_REC_type
117: )
118: AS
119: BEGIN
120: delete from AHL_mr_visit_types
121: where mr_visit_type_ID = p_mr_visit_type_rec .mr_visit_type_ID
122: and object_version_number=p_mr_visit_type_rec .object_version_number;
123:
124: if (sql%ROWCOUNT=0)

Line 203: FROM AHL_MR_VISIT_TYPES_V

199: ATTRIBUTE12,
200: ATTRIBUTE13,
201: ATTRIBUTE14,
202: ATTRIBUTE15
203: FROM AHL_MR_VISIT_TYPES_V
204: WHERE MR_VISIT_TYPE_ID=C_MR_VISIT_TYPE_ID;
205:
206: l_mrvisittype_rec CurMrVisitType%rowtype;
207:

Line 434: FROM AHL_MR_VISIT_TYPES_app_v

430: as
431: CURSOR get_visit_id(c_mr_visit_type_id NUMBER,C_OBJECT_VERSION_NUMBER NUMBER)
432: IS
433: SELECT mr_visit_type_ID
434: FROM AHL_MR_VISIT_TYPES_app_v
435: WHERE mr_visit_type_ID=c_mr_visit_type_id
436: AND OBJECT_VERSION_NUMBER=C_OBJECT_VERSION_NUMBER
437: for update;
438:

Line 452: FROM AHL_mr_visit_typeS_app_v

448:
449: CURSOR CHECK_DUP_VISIT_CODE(c_mr_visit_type_code VARCHAR2,c_mr_header_id NUMBER)
450: IS
451: SELECT MR_VISIT_TYPE_CODE,MR_VISIT_TYPE_ID,MR_HEADER_ID
452: FROM AHL_mr_visit_typeS_app_v
453: WHERE MR_HEADER_ID=c_mr_header_id
454: and MR_VISIT_TYPE_CODE=c_mr_visit_type_CODE;
455:
456: -- Tamal [MEL/CDL] -- Begin changes

Line 478: FROM AHL_MR_VISIT_TYPES vt,

474: -- Cursor to check if visit type exists for a Planned MR
475: CURSOR Check_Visit_Type(c_mr_header_id NUMBER)
476: IS
477: SELECT 'x'
478: FROM AHL_MR_VISIT_TYPES vt,
479: AHL_MR_HEADERS_B mrh
480: WHERE vt.mr_header_id = mrh.mr_header_id
481: AND mrh.implement_status_code IN ('MANDATORY','OPTIONAL_IMPLEMENT')
482: AND mrh.mr_header_id = c_mr_header_id;