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_FMP_PVT dependencies on AHL_APPLICABLE_MRS

Line 2241: -- added to fix perf bug# 13629335 to support bulk insert into ahl_applicable_mrs.

2237: WHERE EXISTS (select 'x' from ahl_applicable_instances);
2238:
2239: l_appl_inst_exists_flag BOOLEAN;
2240:
2241: -- added to fix perf bug# 13629335 to support bulk insert into ahl_applicable_mrs.
2242: l_bulk_mr_hdr_id_tbl nbr_tbl_type;
2243: l_bulk_mr_eff_id_tbl nbr_tbl_type;
2244: l_bulk_csi_ii_id_tbl nbr_tbl_type;
2245: l_bulk_repetitive_flag_tbl vchar_tbl_type;

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

2786: x_applicable_mr_tbl(l_index).relationship_code := l_get_mr_attri.relationship_code;
2787: x_applicable_mr_tbl(l_index).start_mr_header_id := l_get_mr_attri.start_mr_header_id;
2788: x_applicable_mr_tbl(l_index).sequence_number := l_get_mr_attri.sequence_number;
2789: IF l_debug = 'Y' THEN
2790: AHL_DEBUG_PUB.debug('AHL_APPLICABLE_MRS Attributes : mr_header_id ' ||
2791: x_applicable_mr_tbl(l_index).mr_header_id || ' mr_effectivity_id ' ||
2792: x_applicable_mr_tbl(l_index).mr_effectivity_id || ' item_instance_id ' ||
2793: x_applicable_mr_tbl(l_index).item_instance_id || ' repetitive_flag ' ||
2794: x_applicable_mr_tbl(l_index).repetitive_flag || ' show_repetitive_code ' ||

Line 2821: -- insert into table ahl_applicable_mrs

2817: l_bulk_start_mr_hdr_tbl(l_bulk_insert_idx) := l_get_mr_attri.start_mr_header_id;
2818: l_bulk_seq_num_tbl(l_bulk_insert_idx) := l_get_mr_attri.sequence_number;
2819:
2820: IF (l_bulk_insert_idx >= 1000) THEN
2821: -- insert into table ahl_applicable_mrs
2822: FORALL z IN 1..l_bulk_insert_idx
2823:
2824: INSERT INTO AHL_APPLICABLE_MRS (
2825: MR_HEADER_ID,

Line 2824: INSERT INTO AHL_APPLICABLE_MRS (

2820: IF (l_bulk_insert_idx >= 1000) THEN
2821: -- insert into table ahl_applicable_mrs
2822: FORALL z IN 1..l_bulk_insert_idx
2823:
2824: INSERT INTO AHL_APPLICABLE_MRS (
2825: MR_HEADER_ID,
2826: MR_EFFECTIVITY_ID,
2827: CSI_ITEM_INSTANCE_ID,
2828: REPETITIVE_FLAG ,

Line 2859: AHL_DEBUG_PUB.debug('l_bulk_insert_idx:'||l_bulk_insert_idx||': Inserted '||SQL%ROWCOUNT||' rows in AHL_APPLICABLE_MRS');

2855: 1 -- default
2856: );
2857:
2858: IF l_debug = 'Y' THEN
2859: AHL_DEBUG_PUB.debug('l_bulk_insert_idx:'||l_bulk_insert_idx||': Inserted '||SQL%ROWCOUNT||' rows in AHL_APPLICABLE_MRS');
2860: END IF;
2861:
2862: -- reset
2863: l_bulk_insert_idx := 0;

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

2876: l_bulk_seq_num_tbl.delete;
2877: END IF; -- l_bulk_insert_idx
2878:
2879: IF l_debug = 'Y' THEN
2880: AHL_DEBUG_PUB.debug('AHL_APPLICABLE_MRS Attributes : mr_header_id ' ||
2881: l_mr_header_id_tbl(i) || ' mr_effectivity_id ' ||
2882: l_mr_effectivity_id_tbl(i) || ' item_instance_id ' ||
2883: l_instance_id_tbl(i) || ' repetitive_flag ' ||
2884: l_get_mr_attri.repetitive_flag || ' show_repetitive_code ' ||

Line 2964: -- insert into gtt ahl_applicable_mrs

2960: END LOOP;
2961:
2962: -- Insert any leftover MRs if present.
2963: IF (l_bulk_insert_idx > 0) THEN
2964: -- insert into gtt ahl_applicable_mrs
2965: FORALL z IN 1..l_bulk_insert_idx
2966: INSERT INTO AHL_APPLICABLE_MRS (
2967: MR_HEADER_ID,
2968: MR_EFFECTIVITY_ID,

Line 2966: INSERT INTO AHL_APPLICABLE_MRS (

2962: -- Insert any leftover MRs if present.
2963: IF (l_bulk_insert_idx > 0) THEN
2964: -- insert into gtt ahl_applicable_mrs
2965: FORALL z IN 1..l_bulk_insert_idx
2966: INSERT INTO AHL_APPLICABLE_MRS (
2967: MR_HEADER_ID,
2968: MR_EFFECTIVITY_ID,
2969: CSI_ITEM_INSTANCE_ID,
2970: REPETITIVE_FLAG ,

Line 3001: AHL_DEBUG_PUB.debug('Leftover:l_bulk_insert_idx:'||l_bulk_insert_idx||': Inserted '||SQL%ROWCOUNT||' rows in AHL_APPLICABLE_MRS');

2997: 1 -- default
2998: );
2999:
3000: IF l_debug = 'Y' THEN
3001: AHL_DEBUG_PUB.debug('Leftover:l_bulk_insert_idx:'||l_bulk_insert_idx||': Inserted '||SQL%ROWCOUNT||' rows in AHL_APPLICABLE_MRS');
3002: END IF;
3003:
3004: END IF; -- l_bulk_insert_idx
3005:

Line 4236: DELETE FROM AHL_APPLICABLE_MRS;

4232:
4233: BEGIN
4234: -- Initialize temporary table.
4235: SAVEPOINT GET_VISIT_APPLICABLE_MRS_PVT;
4236: DELETE FROM AHL_APPLICABLE_MRS;
4237:
4238: -- call api to fetch all applicable mrs for ASO installation.
4239: AHL_FMP_PVT.get_applicable_mrs(
4240: p_api_version => l_api_version,

Line 4262: -- Populate temporary table ahl_applicable_mrs.

4258: END IF;
4259:
4260:
4261:
4262: -- Populate temporary table ahl_applicable_mrs.
4263: IF (l_appl_mrs_tbl.COUNT > 0) THEN
4264: FOR i IN l_appl_mrs_tbl.FIRST..l_appl_mrs_tbl.LAST LOOP
4265: -- dbms_output.put_line( l_appl_mrs_tbl(i).item_instance_id||' '||
4266: -- l_appl_mrs_tbl(i).mr_header_id);

Line 4267: INSERT INTO AHL_APPLICABLE_MRS

4263: IF (l_appl_mrs_tbl.COUNT > 0) THEN
4264: FOR i IN l_appl_mrs_tbl.FIRST..l_appl_mrs_tbl.LAST LOOP
4265: -- dbms_output.put_line( l_appl_mrs_tbl(i).item_instance_id||' '||
4266: -- l_appl_mrs_tbl(i).mr_header_id);
4267: INSERT INTO AHL_APPLICABLE_MRS
4268: (
4269: CSI_ITEM_INSTANCE_ID,
4270: MR_HEADER_ID,
4271: MR_EFFECTIVITY_ID,

Line 4297: DELETE AHL_APPLICABLE_MRS A

4293:
4294: AHL_UMP_UTIL_PKG.process_group_mrs;
4295:
4296: -- Delete visit types that do not match..
4297: DELETE AHL_APPLICABLE_MRS A
4298: WHERE NOT EXISTS (SELECT 'x' FROM AHL_MR_VISIT_TYPES
4299: WHERE MR_HEADER_ID=A.MR_HEADER_ID
4300: AND MR_VISIT_TYPE_CODE = P_VISIT_TYPE_CODE
4301: );

Line 4304: DELETE AHL_APPLICABLE_MRS A

4300: AND MR_VISIT_TYPE_CODE = P_VISIT_TYPE_CODE
4301: );
4302:
4303: -- delete MRs from relationships table to remove duplicates.
4304: DELETE AHL_APPLICABLE_MRS A
4305: WHERE EXISTS ( select 'x' FROM
4306: AHL_APPLICABLE_MR_RELNS REL
4307: WHERE REL.related_mr_header_id = A.mr_header_id
4308: AND REL.RELATED_CSI_ITEM_INSTANCE_ID = A.CSI_ITEM_INSTANCE_ID);

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

4308: AND REL.RELATED_CSI_ITEM_INSTANCE_ID = A.CSI_ITEM_INSTANCE_ID);
4309:
4310: -- Delete corressponding records for the above deletes from relationships table.
4311: DELETE AHL_APPLICABLE_MR_RELNS A
4312: WHERE NOT EXISTS (SELECT 'x' FROM AHL_APPLICABLE_MRS B
4313: WHERE B.MR_HEADER_ID = A.ORIG_MR_HEADER_ID
4314: AND B.CSI_ITEM_INSTANCE_ID = A.ORIG_CSI_ITEM_INSTANCE_ID);
4315:
4316:

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

5102: x_applicable_mr_tbl(l_index).copy_accomplishment_flag := l_get_mr_attri.copy_accomplishment_flag;
5103: x_applicable_mr_tbl(l_index).implement_status_code := l_get_mr_attri.implement_status_code;
5104: x_applicable_mr_tbl(l_index).descendent_count := l_get_mr_attri.descendent_count;
5105: IF l_debug = 'Y' THEN
5106: AHL_DEBUG_PUB.debug('AHL_APPLICABLE_MRS Attributes : mr_header_id ' ||
5107: x_applicable_mr_tbl(l_index).mr_header_id || ' mr_effectivity_id ' ||
5108: x_applicable_mr_tbl(l_index).mr_effectivity_id || ' item_instance_id ' ||
5109: x_applicable_mr_tbl(l_index).item_instance_id || ' repetitive_flag ' ||
5110: x_applicable_mr_tbl(l_index).repetitive_flag || ' show_repetitive_code ' ||