APPS.AHL_FMP_PVT dependencies on AHL_APPLICABLE_MRS

Line 2201: AHL_DEBUG_PUB.debug('AHL_APPLICABLE_MRS Attributes : mr_header_id ' ||

2197: x_applicable_mr_tbl(l_index).copy_accomplishment_flag := l_get_mr_attri.copy_accomplishment_flag;
2198: x_applicable_mr_tbl(l_index).implement_status_code := l_get_mr_attri.implement_status_code;
2199: x_applicable_mr_tbl(l_index).descendent_count := l_get_mr_attri.descendent_count;
2200: IF l_debug = 'Y' THEN
2201: AHL_DEBUG_PUB.debug('AHL_APPLICABLE_MRS Attributes : mr_header_id ' ||
2202: x_applicable_mr_tbl(l_index).mr_header_id || ' mr_effectivity_id ' ||
2203: x_applicable_mr_tbl(l_index).mr_effectivity_id || ' item_instance_id ' ||
2204: x_applicable_mr_tbl(l_index).item_instance_id || ' repetitive_flag ' ||
2205: x_applicable_mr_tbl(l_index).repetitive_flag || ' show_repetitive_code ' ||

Line 3272: DELETE FROM AHL_APPLICABLE_MRS;

3268:
3269: BEGIN
3270: -- Initialize temporary table.
3271: SAVEPOINT GET_VISIT_APPLICABLE_MRS_PVT;
3272: DELETE FROM AHL_APPLICABLE_MRS;
3273:
3274: -- call api to fetch all applicable mrs for ASO installation.
3275: AHL_FMP_PVT.get_applicable_mrs(
3276: p_api_version => l_api_version,

Line 3298: -- Populate temporary table ahl_applicable_mrs.

3294: END IF;
3295:
3296:
3297:
3298: -- Populate temporary table ahl_applicable_mrs.
3299: IF (l_appl_mrs_tbl.COUNT > 0) THEN
3300: FOR i IN l_appl_mrs_tbl.FIRST..l_appl_mrs_tbl.LAST LOOP
3301: -- dbms_output.put_line( l_appl_mrs_tbl(i).item_instance_id||' '||
3302: -- l_appl_mrs_tbl(i).mr_header_id);

Line 3303: INSERT INTO AHL_APPLICABLE_MRS

3299: IF (l_appl_mrs_tbl.COUNT > 0) THEN
3300: FOR i IN l_appl_mrs_tbl.FIRST..l_appl_mrs_tbl.LAST LOOP
3301: -- dbms_output.put_line( l_appl_mrs_tbl(i).item_instance_id||' '||
3302: -- l_appl_mrs_tbl(i).mr_header_id);
3303: INSERT INTO AHL_APPLICABLE_MRS
3304: (
3305: CSI_ITEM_INSTANCE_ID,
3306: MR_HEADER_ID,
3307: MR_EFFECTIVITY_ID,

Line 3333: DELETE AHL_APPLICABLE_MRS A

3329:
3330: AHL_UMP_UTIL_PKG.process_group_mrs;
3331:
3332: -- Delete visit types that do not match..
3333: DELETE AHL_APPLICABLE_MRS A
3334: WHERE NOT EXISTS (SELECT 'x' FROM AHL_MR_VISIT_TYPES
3335: WHERE MR_HEADER_ID=A.MR_HEADER_ID
3336: AND MR_VISIT_TYPE_CODE = P_VISIT_TYPE_CODE
3337: );

Line 3340: DELETE AHL_APPLICABLE_MRS A

3336: AND MR_VISIT_TYPE_CODE = P_VISIT_TYPE_CODE
3337: );
3338:
3339: -- delete MRs from relationships table to remove duplicates.
3340: DELETE AHL_APPLICABLE_MRS A
3341: WHERE EXISTS ( select 'x' FROM
3342: AHL_APPLICABLE_MR_RELNS REL
3343: WHERE REL.related_mr_header_id = A.mr_header_id
3344: AND REL.RELATED_CSI_ITEM_INSTANCE_ID = A.CSI_ITEM_INSTANCE_ID);

Line 3348: WHERE NOT EXISTS (SELECT 'x' FROM AHL_APPLICABLE_MRS B

3344: AND REL.RELATED_CSI_ITEM_INSTANCE_ID = A.CSI_ITEM_INSTANCE_ID);
3345:
3346: -- Delete corressponding records for the above deletes from relationships table.
3347: DELETE AHL_APPLICABLE_MR_RELNS A
3348: WHERE NOT EXISTS (SELECT 'x' FROM AHL_APPLICABLE_MRS B
3349: WHERE B.MR_HEADER_ID = A.ORIG_MR_HEADER_ID
3350: AND B.CSI_ITEM_INSTANCE_ID = A.ORIG_CSI_ITEM_INSTANCE_ID);
3351:
3352: