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

Line 515: -- Function : Calls FMP and populates the AHL_APPLICABLE_MRS table.

511: -----------------------------------------------------------------------
512: -- Start of Comments --
513: -- Procedure name : Populate_Appl_MRs
514: -- Type : Private
515: -- Function : Calls FMP and populates the AHL_APPLICABLE_MRS table.
516: -- Pre-reqs :
517: -- Parameters :
518: --
519: -- Populate_Appl_MRs Parameters:

Line 556: FROM AHL_APPLICABLE_MRS

552: l_mr_valid_flag VARCHAR2(1);
553:
554: CURSOR get_start_mr_header_id IS
555: SELECT DISTINCT MR_HEADER_ID
556: FROM AHL_APPLICABLE_MRS
557: WHERE START_MR_HEADER_ID = MR_HEADER_ID
558: AND ACCOMPLISH_TRIGGER_TYPE IN ('LOOP', 'CHAIN');
559:
560: CURSOR get_mr_header_id(c_item_instance_id IN NUMBER) IS

Line 562: FROM AHL_APPLICABLE_MRS

558: AND ACCOMPLISH_TRIGGER_TYPE IN ('LOOP', 'CHAIN');
559:
560: CURSOR get_mr_header_id(c_item_instance_id IN NUMBER) IS
561: SELECT MR_HEADER_ID
562: FROM AHL_APPLICABLE_MRS
563: WHERE CSI_ITEM_INSTANCE_ID = c_item_instance_id
564: AND ACCOMPLISH_TRIGGER_TYPE IN ('LOOP', 'CHAIN');
565: --apattark end for SB effectivity changes
566:

Line 570: DELETE FROM AHL_APPLICABLE_MRS;

566:
567: BEGIN
568:
569: -- Initialize temporary table.
570: DELETE FROM AHL_APPLICABLE_MRS;
571:
572: -- call api to fetch all applicable mrs for ASO installation.
573: AHL_FMP_PVT.get_applicable_mrs(
574: p_api_version => l_api_version,

Line 599: -- Populate temporary table ahl_applicable_mrs.

595:
596: -- fix perf bug# 13629335
597: -- commented following code as this is done by ahl_fmp_pvt.get_applicable_mrs API.
598: /*
599: -- Populate temporary table ahl_applicable_mrs.
600: IF (l_appl_mrs_tbl.COUNT > 0) THEN
601: FOR i IN l_appl_mrs_tbl.FIRST..l_appl_mrs_tbl.LAST LOOP
602: -- dbms_output.put_line( l_appl_mrs_tbl(i).item_instance_id||' '||
603: -- l_appl_mrs_tbl(i).mr_header_id);

Line 604: INSERT INTO AHL_APPLICABLE_MRS (

600: IF (l_appl_mrs_tbl.COUNT > 0) THEN
601: FOR i IN l_appl_mrs_tbl.FIRST..l_appl_mrs_tbl.LAST LOOP
602: -- dbms_output.put_line( l_appl_mrs_tbl(i).item_instance_id||' '||
603: -- l_appl_mrs_tbl(i).mr_header_id);
604: INSERT INTO AHL_APPLICABLE_MRS (
605: CSI_ITEM_INSTANCE_ID,
606: MR_HEADER_ID,
607: MR_EFFECTIVITY_ID,
608: REPETITIVE_FLAG ,

Line 640: UPDATE AHL_APPLICABLE_MRS apmr

636: END IF;
637: */
638:
639: -- delete loop/chain data that do not have loop / chain seq #1
640: UPDATE AHL_APPLICABLE_MRS apmr
641: SET accomplish_trigger_type = null,
642: start_mr_header_id = null
643: WHERE start_mr_header_id is not null
644: AND not exists (select 'x' from AHL_APPLICABLE_MRS apmr1

Line 644: AND not exists (select 'x' from AHL_APPLICABLE_MRS apmr1

640: UPDATE AHL_APPLICABLE_MRS apmr
641: SET accomplish_trigger_type = null,
642: start_mr_header_id = null
643: WHERE start_mr_header_id is not null
644: AND not exists (select 'x' from AHL_APPLICABLE_MRS apmr1
645: where apmr1.csi_item_instance_id = apmr.csi_item_instance_id
646: and apmr1.mr_header_id = apmr.start_mr_header_id
647: and apmr1.accomplish_trigger_type = apmr.accomplish_trigger_type
648: and apmr1.loop_chain_seq_num = 1);

Line 662: FROM AHL_APPLICABLE_MRS

658: l_start_mr_relns);
659:
660: IF (l_start_mr_relns.count > 0) THEN
661: SELECT DISTINCT CSI_ITEM_INSTANCE_ID BULK COLLECT INTO l_item_instance_tbl
662: FROM AHL_APPLICABLE_MRS
663: WHERE MR_HEADER_ID = l_start_mr_relns(0).mr_header_id;
664:
665: IF (l_item_instance_tbl.count > 0) THEN
666: FOR m IN l_item_instance_tbl.FIRST..l_item_instance_tbl.LAST

Line 695: UPDATE AHL_APPLICABLE_MRS

691: END LOOP;
692: END IF; -- l_item_instance_tbl.count
693: FOR k IN l_start_mr_relns.FIRST..l_start_mr_relns.LAST LOOP
694: IF (l_process_flag = 'N') THEN
695: UPDATE AHL_APPLICABLE_MRS
696: SET ACCOMPLISH_TRIGGER_TYPE = null
697: WHERE MR_HEADER_ID = l_start_mr_relns(k).MR_HEADER_ID
698: AND ACCOMPLISH_TRIGGER_TYPE IN ('LOOP','CHAIN') ;
699: END IF;

Line 713: CURSOR ahl_applicable_mrs_csr IS

709: --------------------------------------------------------------------
710: PROCEDURE Process_Group_MRs
711: IS
712: --
713: CURSOR ahl_applicable_mrs_csr IS
714: SELECT distinct mr_header_id, csi_item_instance_id
715: FROM ahl_applicable_mrs
716: WHERE descendent_count > 0;
717:

Line 715: FROM ahl_applicable_mrs

711: IS
712: --
713: CURSOR ahl_applicable_mrs_csr IS
714: SELECT distinct mr_header_id, csi_item_instance_id
715: FROM ahl_applicable_mrs
716: WHERE descendent_count > 0;
717:
718: --
719: l_mr_header_id NUMBER;

Line 727: OPEN ahl_applicable_mrs_csr;

723:
724: -- Initialize temporary table.
725: DELETE FROM AHL_APPLICABLE_MR_RELNS;
726:
727: OPEN ahl_applicable_mrs_csr;
728: LOOP
729: FETCH ahl_applicable_mrs_csr INTO l_mr_header_id,
730: l_csi_ii_id;
731: EXIT WHEN ahl_applicable_mrs_csr%NOTFOUND;

Line 729: FETCH ahl_applicable_mrs_csr INTO l_mr_header_id,

725: DELETE FROM AHL_APPLICABLE_MR_RELNS;
726:
727: OPEN ahl_applicable_mrs_csr;
728: LOOP
729: FETCH ahl_applicable_mrs_csr INTO l_mr_header_id,
730: l_csi_ii_id;
731: EXIT WHEN ahl_applicable_mrs_csr%NOTFOUND;
732: process_group_mr_instance(
733: p_top_mr_id => l_mr_header_id,

Line 731: EXIT WHEN ahl_applicable_mrs_csr%NOTFOUND;

727: OPEN ahl_applicable_mrs_csr;
728: LOOP
729: FETCH ahl_applicable_mrs_csr INTO l_mr_header_id,
730: l_csi_ii_id;
731: EXIT WHEN ahl_applicable_mrs_csr%NOTFOUND;
732: process_group_mr_instance(
733: p_top_mr_id => l_mr_header_id,
734: p_top_item_instance_id => l_csi_ii_id);
735: END LOOP;

Line 736: CLOSE ahl_applicable_mrs_csr;

732: process_group_mr_instance(
733: p_top_mr_id => l_mr_header_id,
734: p_top_item_instance_id => l_csi_ii_id);
735: END LOOP;
736: CLOSE ahl_applicable_mrs_csr;
737:
738: END Process_Group_MRs;
739:
740: -----------------------------------------------------------------------

Line 823: FROM ahl_applicable_mrs

819: SELECT csi_item_instance_id,
820: (select subj_child_exists from ahl_config_components
821: where subject_id = csi_item_instance_id) child_exists
822: FROM (SELECT distinct csi_item_instance_id
823: FROM ahl_applicable_mrs
824: WHERE mr_header_id = p_mr_id);
825: --
826: CURSOR ahl_appl_child_mrs_csr(p_mr_id IN NUMBER,
827: p_item_instance_id IN NUMBER) IS

Line 833: FROM ahl_applicable_mrs

829: --Priyan Changed the SQl Query for performance tuning reasons
830: --Refer to Bug # 4918807
831:
832: /*SELECT distinct csi_item_instance_id
833: FROM ahl_applicable_mrs
834: WHERE mr_header_id = p_mr_id
835: AND (csi_item_instance_id = p_item_instance_id
836: OR csi_item_instance_id IN (SELECT subject_id
837: FROM csi_ii_relationships

Line 850: FROM ahl_applicable_mrs amr,

846: ); */
847:
848: /* Modified for performance in R12.0. replaced with WITH clause
849: SELECT distinct csi_item_instance_id
850: FROM ahl_applicable_mrs amr,
851: (SELECT subject_id
852: FROM csi_ii_relationships
853: START WITH object_id = p_item_instance_id
854: AND relationship_type_code = 'COMPONENT-OF'

Line 884: FROM ahl_applicable_mrs AMR

880: FROM DUAL)
881: SELECT csi_item_instance_id
882: FROM INST
883: WHERE EXISTS (SELECT 'x'
884: FROM ahl_applicable_mrs AMR
885: WHERE amr.mr_header_id = p_mr_id
886: AND amr.csi_item_instance_id = inst.csi_item_instance_id);
887: */
888:

Line 893: FROM ahl_applicable_mrs AMR

889: /* perf tuning: bug# 9434441
890: SELECT subject_id csi_item_instance_id
891: FROM csi_ii_relationships
892: WHERE EXISTS (SELECT 'x'
893: FROM ahl_applicable_mrs AMR
894: WHERE amr.mr_header_id = p_mr_id
895: AND amr.csi_item_instance_id = subject_id)
896: START WITH object_id = p_item_instance_id
897: AND relationship_type_code = 'COMPONENT-OF'

Line 908: FROM ahl_applicable_mrs AMR

904: UNION ALL
905: SELECT p_item_instance_id csi_item_instance_id
906: FROM DUAL
907: WHERE EXISTS (SELECT 'x'
908: FROM ahl_applicable_mrs AMR
909: WHERE amr.mr_header_id = p_mr_id
910: AND amr.csi_item_instance_id = p_item_instance_id);
911: */
912:

Line 918: FROM ahl_applicable_mrs AMR

914: -- this SQL will be executed only if subj_child_exists = Y
915: SELECT /*+ push_subq */ subject_id csi_item_instance_id
916: FROM ahl_config_components
917: WHERE EXISTS (SELECT /*+ push_subq */ 'x'
918: FROM ahl_applicable_mrs AMR
919: WHERE amr.mr_header_id = p_mr_id
920: AND amr.csi_item_instance_id = subject_id)
921: START WITH object_id = p_item_instance_id
922: CONNECT BY PRIOR subject_id = object_id

Line 927: FROM ahl_applicable_mrs AMR

923: UNION ALL
924: SELECT p_item_instance_id csi_item_instance_id
925: FROM DUAL
926: WHERE EXISTS (SELECT /*+ push_subq */ 'x'
927: FROM ahl_applicable_mrs AMR
928: WHERE amr.mr_header_id = p_mr_id
929: AND amr.csi_item_instance_id = p_item_instance_id);
930:
931: --

Line 940: FROM ahl_applicable_mrs AMR

936:
937: SELECT p_item_instance_id csi_item_instance_id
938: FROM DUAL
939: WHERE EXISTS (SELECT /*+ push_subq */ 'x'
940: FROM ahl_applicable_mrs AMR
941: WHERE amr.mr_header_id = p_mr_id
942: AND amr.csi_item_instance_id = p_item_instance_id);
943: --
944: -- added to fix perf bug# 13629335

Line 952: FROM ahl_applicable_mrs AMR

948: p_item_instance_id IN NUMBER) IS
949: SELECT /*+ push_subq */ cmp.subject_id csi_item_instance_id
950: FROM ahl_config_components cmp
951: WHERE EXISTS (SELECT /*+ push_subq */ 'x'
952: FROM ahl_applicable_mrs AMR
953: WHERE amr.mr_header_id = p_mr_id
954: AND amr.csi_item_instance_id = cmp.subject_id)
955: UNION ALL
956: SELECT p_item_instance_id subject_id

Line 959: FROM ahl_applicable_mrs AMR

955: UNION ALL
956: SELECT p_item_instance_id subject_id
957: FROM DUAL
958: WHERE EXISTS (SELECT /*+ push_subq */ 'x'
959: FROM ahl_applicable_mrs AMR
960: WHERE amr.mr_header_id = p_mr_id
961: AND amr.csi_item_instance_id = p_item_instance_id);
962:
963: --