APPS.AHL_COMPLEX_MX_PVT dependencies on AHL_COMPLEX_MX_PVT

Line 1: PACKAGE body AHL_COMPLEX_MX_PVT AS

1: PACKAGE body AHL_COMPLEX_MX_PVT AS
2: /* $Header: AHLVCAMB.pls 120.0.12020000.3 2013/02/11 22:47:00 sikumar noship $ */
3:
4: -----------------------------------------------------------------
5: -- Define Global CONSTANTS --

Line 8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_COMPLEX_MX_PVT';

4: -----------------------------------------------------------------
5: -- Define Global CONSTANTS --
6: -----------------------------------------------------------------
7: G_APP_NAME CONSTANT VARCHAR2(3) := 'AHL';
8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_COMPLEX_MX_PVT';
9: G_DEBUG VARCHAR2(1) := NVL(AHL_DEBUG_PUB.is_log_enabled,'N');
10: ------------------------------------
11: -- Common constants and variables --
12: ------------------------------------

Line 709: AND AHL_COMPLEX_MX_PVT.Is_Instance_On_Visit(visit.visit_id,subject_id)='Y'

705: (SELECT object_id
706: FROM csi_ii_relationships
707: WHERE 1 =1
708: START WITH subject_id = p_instance_id
709: AND AHL_COMPLEX_MX_PVT.Is_Instance_On_Visit(visit.visit_id,subject_id)='Y'
710: CONNECT BY PRIOR object_id = subject_id
711: AND AHL_COMPLEX_MX_PVT.Is_Instance_On_Visit(visit.visit_id,subject_id)='Y'
712: UNION
713:

Line 711: AND AHL_COMPLEX_MX_PVT.Is_Instance_On_Visit(visit.visit_id,subject_id)='Y'

707: WHERE 1 =1
708: START WITH subject_id = p_instance_id
709: AND AHL_COMPLEX_MX_PVT.Is_Instance_On_Visit(visit.visit_id,subject_id)='Y'
710: CONNECT BY PRIOR object_id = subject_id
711: AND AHL_COMPLEX_MX_PVT.Is_Instance_On_Visit(visit.visit_id,subject_id)='Y'
712: UNION
713:
714: SELECT p_instance_id object_id FROM dual
715: )

Line 877: AND TRUNC(AHL_COMPLEX_MX_PVT.Get_Visit_End_Date(VST.VISIT_ID)) BETWEEN TRUNC(START_DATE) AND TRUNC(END_DATE)

873: AND VST.ORGANIZATION_ID = ORG_ID
874: and vts.return_to_supply_flag = 'Y'
875: and vts.status_code <> 'DELETED'
876: and not exists (select '1' from ahl_workorders where visit_task_id = vts.visit_task_id and status_code in (12,22,4,5,7))
877: AND TRUNC(AHL_COMPLEX_MX_PVT.Get_Visit_End_Date(VST.VISIT_ID)) BETWEEN TRUNC(START_DATE) AND TRUNC(END_DATE)
878: union
879: SELECT distinct vst.visit_id, vst.item_instance_id
880: FROM
881: AHL_VISITS_B VST

Line 889: AND TRUNC(AHL_COMPLEX_MX_PVT.Get_Visit_End_Date(VST.VISIT_ID)) BETWEEN TRUNC(START_DATE) AND TRUNC(END_DATE)

885: AND VST.INVENTORY_ITEM_ID = ITEM_ID
886: AND VST.ORGANIZATION_ID = ORG_ID
887: and exists(select 1 from ahl_visit_tasks_b vts where vts.visit_id = vst.visit_id and vts.return_to_supply_flag = 'Y' and vts.inventory_item_id <> vst.inventory_item_id and
888: vts.status_code <> 'DELETED' and not exists (select '1' from ahl_workorders where visit_task_id = vts.visit_task_id and status_code in (12,22,4,5,7)) and rownum < 2)
889: AND TRUNC(AHL_COMPLEX_MX_PVT.Get_Visit_End_Date(VST.VISIT_ID)) BETWEEN TRUNC(START_DATE) AND TRUNC(END_DATE)
890: );
891:
892: l_visit_cnt NUMBER := 0;
893: BEGIN

Line 936: and LAST_DAY(AHL_COMPLEX_MX_PVT.Get_Visit_End_Date(VST.VISIT_ID)) = REQ_DATE

932: AND VST.ORGANIZATION_ID = ORG_ID
933: and vts.return_to_supply_flag = 'Y'
934: and vts.status_code <> 'DELETED'
935: and not exists (select '1' from ahl_workorders where visit_task_id = vts.visit_task_id and status_code in (12,22,4,5,7))
936: and LAST_DAY(AHL_COMPLEX_MX_PVT.Get_Visit_End_Date(VST.VISIT_ID)) = REQ_DATE
937: union
938: SELECT distinct vst.visit_id, vst.item_instance_id
939: FROM
940: AHL_VISITS_B VST

Line 947: and LAST_DAY(AHL_COMPLEX_MX_PVT.Get_Visit_End_Date(VST.VISIT_ID)) = REQ_DATE

943: AND VST.INVENTORY_ITEM_ID = ITEM_ID
944: AND VST.ORGANIZATION_ID = ORG_ID
945: and exists(select 1 from ahl_visit_tasks_b vts where vts.visit_id = vst.visit_id and vts.return_to_supply_flag = 'Y' and vts.inventory_item_id <> vst.inventory_item_id and
946: vts.status_code <> 'DELETED' and not exists (select '1' from ahl_workorders where visit_task_id = vts.visit_task_id and status_code in (12,22,4,5,7)) and rownum < 2)
947: and LAST_DAY(AHL_COMPLEX_MX_PVT.Get_Visit_End_Date(VST.VISIT_ID)) = REQ_DATE
948: );
949:
950: l_visit_cnt NUMBER := 0;
951: BEGIN

Line 1093: END AHL_COMPLEX_MX_PVT;

1089: END Is_Instance_On_Visit;
1090:
1091: --sukhwsin::Complex Assembly Maintenance - changes ends
1092:
1093: END AHL_COMPLEX_MX_PVT;