APPS.AHL_UMP_PROCESSUNIT_PVT dependencies on AHL_UNIT_EFFECTIVITIES_B

Line 345: -- from ahl_unit_effectivities_b.

341: x_contract_found_flag OUT NOCOPY BOOLEAN);
342:
343: -- After creation of all maintenance requirements for the instance in the temporary table,
344: -- assign unit effectivity IDs from existing un-accomplished maintenance requirements
345: -- from ahl_unit_effectivities_b.
346: PROCEDURE Assign_Unit_effectivity_IDs;
347:
348: -- Fix for Prev. Maint. performance bug# 5093064.
349: -- instead of calling procedure AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS,

Line 2736: AND NOT EXISTS (SELECT 'x' FROM AHL_UNIT_EFFECTIVITIES_B PARENT_UE

2732: AND (UE.Status_code IS NULL OR status_code = 'INIT-DUE')
2733: AND UE.defer_from_ue_id IS NULL -- do not pick deferred unit effectivities.
2734: AND nvl(UE.manually_planned_flag,'N') = 'N' -- do not pick manually planned UEs.
2735: -- do not pick up child UEs if parent init-accomplished.
2736: AND NOT EXISTS (SELECT 'x' FROM AHL_UNIT_EFFECTIVITIES_B PARENT_UE
2737: WHERE PARENT_UE.UNIT_EFFECTIVITY_ID = RELN.ORIGINATOR_UE_ID
2738: AND PARENT_UE.STATUS_CODE = 'INIT-ACCOMPLISHED')
2739: ORDER BY forecast_sequence ASC;
2740:

Line 2860: FROM ahl_ue_relationships uer, ahl_unit_effectivities_b ue1

2856: AND ue.mr_header_id = p_mr_header_id
2857: AND ue.status_code IS NULL
2858: AND ue.manually_planned_flag = 'Y'
2859: AND NOT EXISTS (SELECT 'x'
2860: FROM ahl_ue_relationships uer, ahl_unit_effectivities_b ue1
2861: WHERE uer.related_ue_id = ue.unit_effectivity_id
2862: AND uer.originator_ue_id = ue1.unit_effectivity_id
2863: AND ue1.object_type = 'SR');
2864: -- Do not pick MRs associated to a SR.

Line 6146: FROM ahl_unit_effectivities_b ue1, ahl_unit_effectivities_b ue2

6142: SELECT ue1.mr_header_id, ue1.csi_item_instance_id,
6143: ue2.mr_header_id related_mr_header_id,
6144: ue2.csi_item_instance_id related_csi_item_instance_id
6145: --FROM ahl_unit_effectivities_app_v ue1, ahl_unit_effectivities_app_v ue2
6146: FROM ahl_unit_effectivities_b ue1, ahl_unit_effectivities_b ue2
6147: WHERE ue1.unit_effectivity_id = p_ue_id AND
6148: ue2.unit_effectivity_id = p_related_ue_id;
6149:
6150: -- To check if mr has a preceding mr.

Line 7201: FROM ahl_unit_effectivities_b

7197: CURSOR ahl_due_date_csr(p_accomplishment_date IN DATE,
7198: p_mr_header_id IN NUMBER,
7199: p_csi_item_instance_id IN NUMBER) IS
7200: SELECT due_date
7201: FROM ahl_unit_effectivities_b
7202: WHERE mr_header_id = p_mr_header_id
7203: AND csi_item_instance_id = p_csi_item_instance_id
7204: AND trunc(accomplished_date) = trunc(p_accomplishment_date)
7205: AND status_code IN ('ACCOMPLISHED','INIT-ACCOMPLISHED','TERMINATED')

Line 7217: FROM ahl_unit_effectivities_b

7213: p_mr_header_id IN NUMBER,
7214: p_csi_item_instance_id IN NUMBER,
7215: p_service_line_id IN NUMBER) IS
7216: SELECT due_date, accomplished_date
7217: FROM ahl_unit_effectivities_b
7218: WHERE mr_header_id = p_mr_header_id
7219: AND csi_item_instance_id = p_csi_item_instance_id
7220: AND service_line_id = p_service_line_id
7221: --AND trunc(accomplished_date) = trunc(p_accomplishment_date)

Line 7985: -- belonging to the same instance from ahl_unit_effectivities_b.

7981:
7982: -------------------------------------------------------------
7983: -- After creation of all maintenance requirements for the instance in the temporary table,
7984: -- assign unit effectivity IDs from existing un-accomplished maintenance requirements
7985: -- belonging to the same instance from ahl_unit_effectivities_b.
7986: PROCEDURE Assign_Unit_Effectivity_IDs IS
7987:
7988: -- Added service_line_id to fix FP bug# 5481605.
7989: -- read temporary table sequentially.

Line 8000: FROM ahl_unit_effectivities_b UE

7996: p_mr_header_id IN NUMBER,
7997: p_service_line_id IN NUMBER,
7998: p_appl_usg_code IN VARCHAR2) IS
7999: SELECT ue.unit_effectivity_id
8000: FROM ahl_unit_effectivities_b UE
8001: WHERE mr_header_id = p_mr_header_id
8002: AND csi_item_instance_id = p_csi_item_instance_id
8003: AND application_usg_code = p_appl_usg_code
8004: AND service_line_id = p_service_line_id

Line 8023: l_appl_usg_code ahl_unit_effectivities_b.application_usg_code%TYPE;

8019:
8020: l_unit_effectivity_id NUMBER;
8021:
8022: l_ue_id_tbl nbr_tbl_type;
8023: l_appl_usg_code ahl_unit_effectivities_b.application_usg_code%TYPE;
8024:
8025: BEGIN
8026:
8027: IF G_DEBUG = 'Y' THEN

Line 9325: FROM ahl_unit_effectivities_b ue1, ahl_unit_effectivities_b ue2

9321: p_related_ue_id IN NUMBER ) IS
9322: SELECT ue1.mr_header_id, ue1.csi_item_instance_id,
9323: ue2.mr_header_id related_mr_header_id,
9324: ue2.csi_item_instance_id related_csi_item_instance_id
9325: FROM ahl_unit_effectivities_b ue1, ahl_unit_effectivities_b ue2
9326: WHERE ue1.unit_effectivity_id = p_ue_id AND
9327: ue2.unit_effectivity_id = p_related_ue_id;
9328:
9329: -- Read applicable relns table for group MR details.

Line 9481: FROM ahl_ue_relationships uer, ahl_unit_effectivities_b ue1

9477: FROM ahl_unit_effectivities_app_v ue
9478: /*
9479: WHERE NOT EXISTS ( SELECT 'x'
9480: --FROM ahl_ue_relationships uer, ahl_unit_effectivities_app_v ue1
9481: FROM ahl_ue_relationships uer, ahl_unit_effectivities_b ue1
9482: WHERE uer.related_ue_id = ue.unit_effectivity_id AND
9483: uer.originator_ue_id = ue1.unit_effectivity_id AND
9484: ue1.object_type <> 'SR' )
9485: */

Line 9572: l_message_code ahl_unit_effectivities_b.message_code%TYPE;

9568: originator_ue_id = p_unit_effectivity_id;
9569:
9570: l_exception_flag BOOLEAN;
9571: l_grp_match_flag VARCHAR2(1);
9572: l_message_code ahl_unit_effectivities_b.message_code%TYPE;
9573: l_status_code ahl_unit_effectivities_b.status_code%TYPE;
9574: l_junk VARCHAR2(1);
9575:
9576: l_ue_rec ahl_unit_effectivity_csr%ROWTYPE;

Line 9573: l_status_code ahl_unit_effectivities_b.status_code%TYPE;

9569:
9570: l_exception_flag BOOLEAN;
9571: l_grp_match_flag VARCHAR2(1);
9572: l_message_code ahl_unit_effectivities_b.message_code%TYPE;
9573: l_status_code ahl_unit_effectivities_b.status_code%TYPE;
9574: l_junk VARCHAR2(1);
9575:
9576: l_ue_rec ahl_unit_effectivity_csr%ROWTYPE;
9577: