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_INSTANCES

Line 210: FROM ahl_unit_config_headers a,ahl_applicable_instances b

206:
207: /*CURSOR get_top_inst2(c_relationship_id NUMBER)
208: IS
209: SELECT a.csi_item_instance_id instance_id
210: FROM ahl_unit_config_headers a,ahl_applicable_instances b
211: WHERE a.csi_item_instance_id=b.csi_item_instance_id
212: and a.master_config_id=b.position_id
213: AND b.position_id=c_relationship_id
214: and SYSDATE between trunc(nvl(A.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))

Line 225: FROM ahl_unit_config_headers a,ahl_applicable_instances b

221: --same as before, but include all nodes, not only top node
222: CURSOR get_inst2(c_relationship_id NUMBER)
223: IS
224: SELECT a.csi_item_instance_id instance_id
225: FROM ahl_unit_config_headers a,ahl_applicable_instances b
226: WHERE a.csi_item_instance_id=b.csi_item_instance_id
227: and b.position_id= c_relationship_id
228: AND SYSDATE between trunc(nvl(A.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
229: UNION

Line 231: FROM csi_ii_relationships a,ahl_applicable_instances b

227: and b.position_id= c_relationship_id
228: AND SYSDATE between trunc(nvl(A.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
229: UNION
230: SELECT a.subject_id instance_id
231: FROM csi_ii_relationships a,ahl_applicable_instances b
232: WHERE a.subject_id=b.csi_item_instance_id
233: and b.position_id=c_relationship_id
234: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
235: AND a.relationship_type_code = 'COMPONENT-OF';

Line 243: FROM ahl_unit_config_headers A,ahl_applicable_instances api

239: --top node
240: /*CURSOR get_top_inst3(c_relationship_id NUMBER, c_inventory_item_id NUMBER)
241: IS
242: SELECT a.csi_item_instance_id instance_id
243: FROM ahl_unit_config_headers A,ahl_applicable_instances api
244: --WHERE A.master_config_id=api.position_id
245: --AND A.csi_item_instance_id=api.csi_item_instance_id
246: WHERE A.csi_item_instance_id=api.csi_item_instance_id
247: AND api.position_id= C_RELATIONSHIP_ID

Line 260: FROM ahl_unit_config_headers A,ahl_applicable_instances api

256: --same as before, but include all nodes, not only top node
257: CURSOR get_inst3(c_relationship_id NUMBER, c_inventory_item_id NUMBER)
258: IS
259: SELECT a.csi_item_instance_id instance_id
260: FROM ahl_unit_config_headers A,ahl_applicable_instances api
261: WHERE A.csi_item_instance_id=api.csi_item_instance_id
262: AND api.position_id=c_relationship_id
263: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate))
264: and trunc(nvl(a.active_end_date,sysdate+1))

Line 273: FROM csi_ii_relationships A,ahl_applicable_instances api

269: and trunc(nvl(b.active_end_date,sysdate+1))
270: AND inventory_item_id = c_inventory_item_id)
271: UNION
272: SELECT subject_id instance_id
273: FROM csi_ii_relationships A,ahl_applicable_instances api
274: WHERE api.position_id=c_relationship_id
275: and api.csi_item_instance_id=a.subject_id
276: AND relationship_type_code = 'COMPONENT-OF'
277: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate))

Line 367: FROM ahl_unit_config_headers A,ahl_applicable_instances api

363: START WITH D.pc_node_id = c_pc_node_id
364: CONNECT BY D.parent_node_id = PRIOR D.pc_node_id))
365: UNION -- aobe query added to fix bug number 5448015
366: SELECT a.csi_item_instance_id instance_id
367: FROM ahl_unit_config_headers A,ahl_applicable_instances api
368: WHERE SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
369: AND a.csi_item_instance_id=api.csi_item_instance_id
370: AND EXISTS (SELECT 'X'
371: FROM csi_item_instances B

Line 389: AND A.SUBJECT_id IN (SELECT csi_item_instance_id from ahl_applicable_instances

385: SELECT a.subject_id instance_id
386: FROM csi_ii_relationships A
387: WHERE relationship_type_code = 'COMPONENT-OF'
388: AND sysdate between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
389: AND A.SUBJECT_id IN (SELECT csi_item_instance_id from ahl_applicable_instances
390: where csi_item_instance_id=a.subject_id )
391: AND EXISTS (SELECT 'X'
392: FROM csi_item_instances B
393: WHERE B.instance_id = A.subject_id

Line 454: FROM ahl_unit_config_headers A,ahl_applicable_instances api

450: AND a.relationship_type_code = 'COMPONENT-OF';*/
451: --position in MC and PC node defined in MR effectivity definition, just top node
452: /*CURSOR get_top_inst5(c_relationship_id NUMBER, c_pc_node_id NUMBER) IS
453: SELECT a.csi_item_instance_id instance_id
454: FROM ahl_unit_config_headers A,ahl_applicable_instances api
455: WHERE api.position_id = c_relationship_id
456: and a.csi_item_instance_id=api.csi_item_instance_id
457: --and A.master_config_id=api.position_id
458: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))

Line 470: FROM ahl_unit_config_headers A,ahl_applicable_instances api

466: START WITH C.pc_node_id = c_pc_node_id
467: CONNECT BY C.parent_node_id = PRIOR C.pc_node_id))
468: UNION
469: SELECT a.csi_item_instance_id instance_id
470: FROM ahl_unit_config_headers A,ahl_applicable_instances api
471: WHERE api.position_id = c_relationship_id
472: --and A.master_config_id=api.position_id
473: and api.csi_item_instance_id=a.csi_item_instance_id
474: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))

Line 493: FROM ahl_unit_config_headers A,ahl_applicable_instances api

489: );*/
490: --same as before, but include all node, not only top node
491: /*CURSOR get_inst5(c_relationship_id NUMBER, c_pc_node_id NUMBER) IS
492: SELECT a.csi_item_instance_id instance_id
493: FROM ahl_unit_config_headers A,ahl_applicable_instances api
494: WHERE api.csi_item_instance_id=a.csi_item_instance_id
495: and api.position_id=c_relationship_id
496: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
497: AND EXISTS (SELECT 'X'

Line 510: AND subject_id in (Select csi_item_instance_id from ahl_applicable_instances)

506: UNION
507: SELECT a.subject_id instance_id
508: FROM csi_ii_relationships a
509: WHERE relationship_type_code = 'COMPONENT-OF'
510: AND subject_id in (Select csi_item_instance_id from ahl_applicable_instances)
511: AND sysdate between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
512: START WITH object_id IN (SELECT csi_item_instance_id
513: FROM ahl_unit_config_headers Ax
514: WHERE ax.csi_item_instance_id=a.subject_id AND

Line 532: FROM ahl_unit_config_headers A,ahl_applicable_instances api

528: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
529: AND a.relationship_type_code = 'COMPONENT-OF'
530: UNION
531: SELECT a.csi_item_instance_id instance_id
532: FROM ahl_unit_config_headers A,ahl_applicable_instances api
533: WHERE api.position_id = c_relationship_id
534: and api.csi_item_instance_id= a.csi_item_instance_id
535: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
536: AND EXISTS (SELECT 'X'

Line 553: AND subject_id in (Select csi_item_instance_id from ahl_applicable_instances)

549: UNION
550: SELECT a.subject_id instance_id
551: FROM csi_ii_relationships a
552: WHERE a.relationship_type_code = 'COMPONENT-OF'
553: AND subject_id in (Select csi_item_instance_id from ahl_applicable_instances)
554: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
555: AND subject_id in (select csi_item_instance_id from ahl_applicable_instances)
556: START WITH object_id IN (SELECT ax.instance_id
557: FROM csi_item_instances Ax

Line 555: AND subject_id in (select csi_item_instance_id from ahl_applicable_instances)

551: FROM csi_ii_relationships a
552: WHERE a.relationship_type_code = 'COMPONENT-OF'
553: AND subject_id in (Select csi_item_instance_id from ahl_applicable_instances)
554: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
555: AND subject_id in (select csi_item_instance_id from ahl_applicable_instances)
556: START WITH object_id IN (SELECT ax.instance_id
557: FROM csi_item_instances Ax
558: WHERE SYSDATE between trunc(nvl(ax.active_start_date,sysdate)) and trunc(nvl(ax.active_end_date,sysdate+1))
559: AND instance_id=a.subject_id

Line 579: FROM ahl_unit_config_headers A,ahl_applicable_instances api

575: --all inventory item, position in MC and PC node defined in MR effectivity
576: --definition, just top node
577: /*CURSOR get_top_inst6(c_inventory_item_id NUMBER, c_relationship_id NUMBER, c_pc_node_id NUMBER) IS
578: SELECT a.csi_item_instance_id instance_id
579: FROM ahl_unit_config_headers A,ahl_applicable_instances api
580: WHERE api.position_id = c_relationship_id
581: AND api.csi_item_instance_id=A.csi_item_instance_id
582: --and A.master_config_id=api.position_id
583: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))

Line 599: FROM ahl_unit_config_headers A,ahl_applicable_instances api

595: START WITH D.pc_node_id = c_pc_node_id
596: CONNECT BY D.parent_node_id = PRIOR D.pc_node_id))
597: UNION
598: SELECT a.csi_item_instance_id instance_id
599: FROM ahl_unit_config_headers A,ahl_applicable_instances api
600: WHERE Api.position_id = c_relationship_id
601: AND A.csi_item_instance_id=API.csi_item_instance_id
602: --and A.master_config_id=api.position_id
603: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))

Line 621: FROM ahl_unit_config_headers A,ahl_applicable_instances api

617: CONNECT BY D.parent_node_id= PRIOR D.pc_node_id)));*/
618: --same as before, but include all nodes, not only top node
619: /*CURSOR get_inst6(c_inventory_item_id NUMBER, c_relationship_id NUMBER, c_pc_node_id NUMBER) IS
620: SELECT a.csi_item_instance_id instance_id
621: FROM ahl_unit_config_headers A,ahl_applicable_instances api
622: WHERE api.position_id = c_relationship_id
623: AND api.csi_item_instance_id=A.csi_item_instance_id
624: -- AND subject_id in (Select csi_item_instance_id from ahl_applicable_instances)
625: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))

Line 624: -- AND subject_id in (Select csi_item_instance_id from ahl_applicable_instances)

620: SELECT a.csi_item_instance_id instance_id
621: FROM ahl_unit_config_headers A,ahl_applicable_instances api
622: WHERE api.position_id = c_relationship_id
623: AND api.csi_item_instance_id=A.csi_item_instance_id
624: -- AND subject_id in (Select csi_item_instance_id from ahl_applicable_instances)
625: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
626: AND EXISTS (SELECT 'X'
627: FROM csi_item_instances B
628: WHERE B.instance_id = api.csi_item_instance_id

Line 644: AND a.relationship_id in (Select position_id from AHL_APPLICABLE_INSTANCES)

640: UNION
641: SELECT a.subject_id instance_id
642: FROM csi_ii_relationships A
643: WHERE relationship_type_code = 'COMPONENT-OF'
644: AND a.relationship_id in (Select position_id from AHL_APPLICABLE_INSTANCES)
645: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
646: AND EXISTS (SELECT 'X'
647: FROM csi_item_instances B
648: WHERE B.instance_id = A.subject_id

Line 652: FROM ahl_unit_config_headers C,ahl_applicable_instances api

648: WHERE B.instance_id = A.subject_id
649: AND SYSDATE between trunc(nvl(b.active_start_date,sysdate)) and trunc(nvl(b.active_end_date,sysdate+1))
650: AND B.inventory_item_id = c_inventory_item_id)
651: START WITH object_id IN (SELECT c.csi_item_instance_id
652: FROM ahl_unit_config_headers C,ahl_applicable_instances api
653: WHERE c.csi_item_instance_id=api.csi_item_instance_id
654: and api.position_id=c_relationship_id and
655: EXISTS (SELECT 'X'
656: FROM ahl_pc_associations D

Line 670: FROM ahl_unit_config_headers A,ahl_applicable_instances api

666: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
667: AND a.relationship_type_code = 'COMPONENT-OF'
668: UNION
669: SELECT a.csi_item_instance_id instance_id
670: FROM ahl_unit_config_headers A,ahl_applicable_instances api
671: WHERE api.position_id = c_relationship_id
672: AND A.csi_item_instance_id=API.csi_item_instance_id
673: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
674: AND EXISTS (SELECT 'X'

Line 692: AND a.subject_id in (Select csi_item_instance_id from AHL_APPLICABLE_INSTANCES )

688: UNION
689: SELECT subject_id instance_id
690: FROM csi_ii_relationships A
691: WHERE relationship_type_code = 'COMPONENT-OF'
692: AND a.subject_id in (Select csi_item_instance_id from AHL_APPLICABLE_INSTANCES )
693: AND SYSDATE between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
694: AND EXISTS (SELECT 'X'
695: FROM csi_item_instances B
696: WHERE B.instance_id = A.subject_id

Line 728: FROM csi_item_instances A,ahl_applicable_instances api

724: AND AHL_FMP_PVT.is_pc_assoc_valid(A.instance_id,c_pc_node_id) = FND_API.G_TRUE;
725:
726: CURSOR get_inst5(c_relationship_id NUMBER, c_pc_node_id NUMBER) IS
727: SELECT A.instance_id
728: FROM csi_item_instances A,ahl_applicable_instances api
729: WHERE A.instance_id = api.csi_item_instance_id
730: AND sysdate between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
731: AND api.position_id=c_relationship_id
732: AND AHL_FMP_PVT.is_pc_assoc_valid(A.instance_id,c_pc_node_id) = FND_API.G_TRUE;

Line 736: FROM csi_item_instances A,ahl_applicable_instances api

732: AND AHL_FMP_PVT.is_pc_assoc_valid(A.instance_id,c_pc_node_id) = FND_API.G_TRUE;
733:
734: CURSOR get_inst6(c_inventory_item_id NUMBER, c_relationship_id NUMBER, c_pc_node_id NUMBER) IS
735: SELECT A.instance_id
736: FROM csi_item_instances A,ahl_applicable_instances api
737: WHERE A.instance_id = api.csi_item_instance_id
738: AND sysdate between trunc(nvl(a.active_start_date,sysdate)) and trunc(nvl(a.active_end_date,sysdate+1))
739: AND api.position_id=c_relationship_id
740: AND A.inventory_item_id = c_inventory_item_id

Line 791: DELETE FROM ahl_applicable_instances;

787: -- Check whether the mr_header_id exists --
788: AHL_DEBUG_PUB.debug(' Phase 1');
789:
790: DELETE FROM ahl_mr_instances_temp;
791: DELETE FROM ahl_applicable_instances;
792:
793: OPEN check_mr_exists(p_mr_header_id);
794: FETCH check_mr_exists INTO l_mr_header_id;
795: IF check_mr_exists%NOTFOUND THEN

Line 828: from ahl_applicable_instances;

824:
825: IF l_debug = 'Y' THEN
826: AHL_DEBUG_PUB.debug(' After Call to MC path positions');
827: Select count(*) into l_counter
828: from ahl_applicable_instances;
829: AHL_DEBUG_PUB.debug('Number of Recs found in ahl_applicable_instances are ...'||l_counter);
830: END IF;
831: END IF;
832: l_mr_header_id := l_mr_effect.mr_header_id;

Line 829: AHL_DEBUG_PUB.debug('Number of Recs found in ahl_applicable_instances are ...'||l_counter);

825: IF l_debug = 'Y' THEN
826: AHL_DEBUG_PUB.debug(' After Call to MC path positions');
827: Select count(*) into l_counter
828: from ahl_applicable_instances;
829: AHL_DEBUG_PUB.debug('Number of Recs found in ahl_applicable_instances are ...'||l_counter);
830: END IF;
831: END IF;
832: l_mr_header_id := l_mr_effect.mr_header_id;
833:

Line 1764: FROM ahl_applicable_instances aai,csi_item_instances cii,

1760: WHERE ciea1.instance_id = cii.instance_id AND ciea1.attribute_code = 'AHL_MFG_DATE'
1761: AND ciea1.attribute_level = 'GLOBAL') mfg_date,
1762: cii.serial_number --,
1763: --(SELECT 'Y' from ahl_mr_effectivity_dtls where mr_effectivity_id = a.mr_effectivity_id and ROWNUM < 2) eff_dtls_flag
1764: FROM ahl_applicable_instances aai,csi_item_instances cii,
1765: ahl_mr_effectivities A
1766: WHERE
1767: --A.mr_header_id = NVL(c_mr_header_id, A.mr_header_id)
1768: --AND

Line 1802: FROM ahl_applicable_instances aai,csi_item_instances cii,

1798: WHERE ciea1.instance_id = cii.instance_id AND ciea1.attribute_code = 'AHL_MFG_DATE'
1799: AND ciea1.attribute_level = 'GLOBAL') mfg_date,
1800: cii.serial_number --,
1801: --(SELECT 'Y' from ahl_mr_effectivity_dtls where mr_effectivity_id = a.mr_effectivity_id and ROWNUM < 2) eff_dtls_flag
1802: FROM ahl_applicable_instances aai,csi_item_instances cii,
1803: ahl_mr_effectivities A
1804: WHERE A.mr_header_id = c_mr_header_id
1805: AND A.relationship_id IS NOT NULL
1806: AND aai.position_id = A.relationship_id

Line 2025: FROM ahl_applicable_instances aai,csi_item_instances cii,ahl_mr_visit_types vis,

2021: WHERE ciea1.instance_id = cii.instance_id AND ciea1.attribute_code = 'AHL_MFG_DATE'
2022: AND ciea1.attribute_level = 'GLOBAL') mfg_date,
2023: cii.serial_number --,
2024: --(SELECT 'Y' from ahl_mr_effectivity_dtls where mr_effectivity_id = a.mr_effectivity_id and ROWNUM < 2) eff_dtls_flag
2025: FROM ahl_applicable_instances aai,csi_item_instances cii,ahl_mr_visit_types vis,
2026: ahl_mr_effectivities A
2027: WHERE A.mr_header_id = vis.mr_header_id
2028: AND vis.mr_visit_type_code = c_visit_type_code
2029: AND A.relationship_id IS NOT NULL

Line 2111: from ahl_applicable_instances

2107:
2108: -- validate patch position Id.
2109: CURSOR relationship_csr(c_instance_id IN NUMBER) IS
2110: select position_id
2111: from ahl_applicable_instances
2112: where csi_item_instance_id = c_instance_id;
2113: */
2114:
2115: /*

Line 2237: WHERE EXISTS (select 'x' from ahl_applicable_instances);

2233: -- added to fix perf bug# 9434441
2234: CURSOR appl_inst_exists_csr IS
2235: SELECT 'x'
2236: FROM dual
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.

Line 2333: -- start processing. First populate temp table ahl_applicable_instances by calling

2329: CLOSE uc_top_inst;
2330: */
2331:
2332:
2333: -- start processing. First populate temp table ahl_applicable_instances by calling
2334: -- MC api to map instance (and components) to path positions.
2335:
2336: IF l_debug = 'Y' THEN
2337: AHL_DEBUG_PUB.debug('Start Processing..', l_debug_prefix);

Line 2387: -- initialize flag that indicate that ahl_applicable_instances has at least one row.

2383: l_path_posn_flag := TRUE;
2384: END IF;
2385:
2386: -- fix for perf bug# 9434441
2387: -- initialize flag that indicate that ahl_applicable_instances has at least one row.
2388: l_appl_inst_exists_flag := FALSE;
2389:
2390:
2391: IF (l_path_posn_flag) THEN

Line 2397: DELETE FROM ahl_applicable_instances;

2393: IF l_debug = 'Y' THEN
2394: AHL_DEBUG_PUB.debug('Processing MC Relationships..', l_debug_prefix);
2395: END IF;
2396:
2397: DELETE FROM ahl_applicable_instances;
2398: -- for input instance.
2399: AHL_MC_PATH_POSITION_PVT.map_instance_to_positions
2400: (
2401: p_api_version => 1.0,

Line 3007: DELETE FROM ahl_applicable_instances;

3003:
3004: END IF; -- l_bulk_insert_idx
3005:
3006:
3007: DELETE FROM ahl_applicable_instances;
3008:
3009: --DBMS_OUTPUT.PUT_LINE('API2: Successfully executed API2!');
3010: IF l_debug = 'Y' THEN
3011: AHL_DEBUG_PUB.debug('End private API: AHL_FMP_PVT.GET_APPLICABLE_MRS', l_debug_prefix);

Line 4665: FROM ahl_applicable_instances aai,csi_item_instances cii,

4661: (SELECT to_date(ciea1.attribute_value, 'DD/MM/YYYY') from csi_inst_extend_attrib_v ciea1
4662: WHERE ciea1.instance_id = cii.instance_id AND ciea1.attribute_code = 'AHL_MFG_DATE'
4663: AND ciea1.attribute_level = 'GLOBAL') mfg_date,
4664: cii.serial_number
4665: FROM ahl_applicable_instances aai,csi_item_instances cii,
4666: ahl_mr_effectivities A
4667: WHERE A.mr_header_id = c_mr_header_id
4668: AND A.relationship_id IS NOT NULL
4669: AND aai.position_id = A.relationship_id

Line 4782: WHERE EXISTS (select 'x' from ahl_applicable_instances);

4778: -- added to fix perf bug# 9434441
4779: CURSOR appl_inst_exists_csr IS
4780: SELECT 'x'
4781: FROM dual
4782: WHERE EXISTS (select 'x' from ahl_applicable_instances);
4783:
4784: l_appl_inst_exists_flag BOOLEAN;
4785:
4786: BEGIN

Line 4828: -- start processing. First populate temp table ahl_applicable_instances by calling

4824: IF l_debug = 'Y' THEN
4825: AHL_DEBUG_PUB.debug('After instance validation:' || p_item_instance_id, l_debug_prefix);
4826: END IF;
4827:
4828: -- start processing. First populate temp table ahl_applicable_instances by calling
4829: -- MC api to map instance (and components) to path positions.
4830:
4831: IF l_debug = 'Y' THEN
4832: AHL_DEBUG_PUB.debug('Start Processing..', l_debug_prefix);

Line 4858: -- initialize flag that indicate that ahl_applicable_instances has at least one row.

4854: END IF;
4855: CLOSE relationship_mr_csr;
4856:
4857: -- fix for perf bug# 9434441
4858: -- initialize flag that indicate that ahl_applicable_instances has at least one row.
4859: l_appl_inst_exists_flag := FALSE;
4860:
4861:
4862: IF (l_path_posn_flag) THEN

Line 4868: DELETE FROM ahl_applicable_instances;

4864: IF l_debug = 'Y' THEN
4865: AHL_DEBUG_PUB.debug('Processing MC Relationships..', l_debug_prefix);
4866: END IF;
4867:
4868: DELETE FROM ahl_applicable_instances;
4869: -- for input instance.
4870: AHL_MC_PATH_POSITION_PVT.map_instance_to_positions
4871: (
4872: p_api_version => 1.0,

Line 5169: DELETE FROM ahl_applicable_instances;

5165: END IF;
5166:
5167: END LOOP;
5168:
5169: DELETE FROM ahl_applicable_instances;
5170:
5171: IF l_debug = 'Y' THEN
5172: AHL_DEBUG_PUB.debug('End private API: AHL_FMP_PVT.GET_MR_APPLICABILITY', l_debug_prefix);
5173: AHL_DEBUG_PUB.disable_debug;