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_LTP_MTL_REQ_PVT dependencies on AHL_LTP_MTL_REQ_PVT

Line 1: PACKAGE BODY AHL_LTP_MTL_REQ_PVT AS

1: PACKAGE BODY AHL_LTP_MTL_REQ_PVT AS
2: /* $Header: AHLVLMRB.pls 120.1.12010000.2 2008/11/12 06:28:21 skpathak ship $ */
3:
4: -----------------------
5: -- Declare Constants --

Line 7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_LTP_MTL_REQ_PVT';

3:
4: -----------------------
5: -- Declare Constants --
6: -----------------------
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_LTP_MTL_REQ_PVT';
8:
9: G_LOG_PREFIX CONSTANT VARCHAR2(100) := 'ahl.plsql.AHL_LTP_MTL_REQ_PVT';
10:
11: G_NO_FLAG CONSTANT VARCHAR2(1) := 'N';

Line 9: G_LOG_PREFIX CONSTANT VARCHAR2(100) := 'ahl.plsql.AHL_LTP_MTL_REQ_PVT';

5: -- Declare Constants --
6: -----------------------
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_LTP_MTL_REQ_PVT';
8:
9: G_LOG_PREFIX CONSTANT VARCHAR2(100) := 'ahl.plsql.AHL_LTP_MTL_REQ_PVT';
10:
11: G_NO_FLAG CONSTANT VARCHAR2(1) := 'N';
12: G_YES_FLAG CONSTANT VARCHAR2(1) := 'Y';
13:

Line 144: -- x_route_mtl_req_tbl OUT AHL_LTP_MTL_REQ_PVT.Route_Mtl_Req_Tbl Required

140: -- The date when the materials are required. If provided, the positions of Master Configs
141: -- (for position path based disposition list requirement) are validated against this date.
142: -- p_request_type IN VARCHAR2 Required
143: -- Should be either 'FORECAST' or 'PLANNED'
144: -- x_route_mtl_req_tbl OUT AHL_LTP_MTL_REQ_PVT.Route_Mtl_Req_Tbl Required
145: -- The Table of records containing the material requirements for the route
146: --
147: -- Version :
148: -- Initial Version 1.0

Line 165: x_route_mtl_req_tbl OUT NOCOPY AHL_LTP_MTL_REQ_PVT.Route_Mtl_Req_Tbl_Type) IS

161: p_mr_route_id IN NUMBER,
162: p_item_instance_id IN NUMBER,
163: p_requirement_date IN DATE := null,
164: p_request_type IN VARCHAR2,
165: x_route_mtl_req_tbl OUT NOCOPY AHL_LTP_MTL_REQ_PVT.Route_Mtl_Req_Tbl_Type) IS
166:
167: CURSOR get_mc_dtls_csr(c_instance_id IN NUMBER) IS
168: select UC.MASTER_CONFIG_ID, MC.MC_ID, MC.VERSION_NUMBER
169: from AHL_UNIT_CONFIG_HEADERS UC, AHL_MC_HEADERS_B MC

Line 190: l_disp_req_list AHL_LTP_MTL_REQ_PVT.Route_Mtl_Req_Tbl_Type;

186: l_inst_item_id NUMBER;
187: l_mc_header_id NUMBER;
188: l_mc_id NUMBER;
189: l_mc_version NUMBER;
190: l_disp_req_list AHL_LTP_MTL_REQ_PVT.Route_Mtl_Req_Tbl_Type;
191: l_route_req_list AHL_LTP_MTL_REQ_PVT.Route_Mtl_Req_Tbl_Type;
192: l_index NUMBER;
193: l_temp_item_id NUMBER;
194: l_temp_ig_id NUMBER;

Line 191: l_route_req_list AHL_LTP_MTL_REQ_PVT.Route_Mtl_Req_Tbl_Type;

187: l_mc_header_id NUMBER;
188: l_mc_id NUMBER;
189: l_mc_version NUMBER;
190: l_disp_req_list AHL_LTP_MTL_REQ_PVT.Route_Mtl_Req_Tbl_Type;
191: l_route_req_list AHL_LTP_MTL_REQ_PVT.Route_Mtl_Req_Tbl_Type;
192: l_index NUMBER;
193: l_temp_item_id NUMBER;
194: l_temp_ig_id NUMBER;
195: l_found BOOLEAN;

Line 669: AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM_Qty(INVENTORY_ITEM_ID, UOM_CODE, QUANTITY) AS PRIMARY_QUANTITY,

665: ROM.INVENTORY_ITEM_ID,
666: ROM.INVENTORY_ORG_ID,
667: ROM.UOM_CODE,
668: ROM.QUANTITY,
669: AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM_Qty(INVENTORY_ITEM_ID, UOM_CODE, QUANTITY) AS PRIMARY_QUANTITY,
670: AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM(INVENTORY_ITEM_ID, INVENTORY_ORG_ID) AS PRIMARY_UOM_CODE,
671: ITEM_GROUP_ID,
672: ITEM_COMP_DETAIL_ID,
673: POSITION_PATH_ID,

Line 670: AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM(INVENTORY_ITEM_ID, INVENTORY_ORG_ID) AS PRIMARY_UOM_CODE,

666: ROM.INVENTORY_ORG_ID,
667: ROM.UOM_CODE,
668: ROM.QUANTITY,
669: AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM_Qty(INVENTORY_ITEM_ID, UOM_CODE, QUANTITY) AS PRIMARY_QUANTITY,
670: AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM(INVENTORY_ITEM_ID, INVENTORY_ORG_ID) AS PRIMARY_UOM_CODE,
671: ITEM_GROUP_ID,
672: ITEM_COMP_DETAIL_ID,
673: POSITION_PATH_ID,
674: PP.PATH_POS_COMMON_ID,

Line 689: DECODE(ICD.inventory_item_id, null, c_quantity, AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM_Qty(ICD.inventory_item_id, c_uom, c_quantity)) QUANTITY,

685: CURSOR get_item_comp_dtls_csr(c_item_comp_detail_id IN NUMBER,
686: c_quantity IN NUMBER,
687: c_uom IN VARCHAR2) IS
688: SELECT ICD.inventory_item_id, ICD.inventory_master_org_id, ICD.item_group_id,
689: DECODE(ICD.inventory_item_id, null, c_quantity, AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM_Qty(ICD.inventory_item_id, c_uom, c_quantity)) QUANTITY,
690: DECODE(ICD.inventory_item_id, null, c_uom, AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM(ICD.inventory_item_id, inventory_master_org_id)) UOM
691: FROM AHL_ITEM_COMP_DETAILS ICD
692: WHERE ITEM_COMP_DETAIL_ID = c_item_comp_detail_id;
693:

Line 690: DECODE(ICD.inventory_item_id, null, c_uom, AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM(ICD.inventory_item_id, inventory_master_org_id)) UOM

686: c_quantity IN NUMBER,
687: c_uom IN VARCHAR2) IS
688: SELECT ICD.inventory_item_id, ICD.inventory_master_org_id, ICD.item_group_id,
689: DECODE(ICD.inventory_item_id, null, c_quantity, AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM_Qty(ICD.inventory_item_id, c_uom, c_quantity)) QUANTITY,
690: DECODE(ICD.inventory_item_id, null, c_uom, AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM(ICD.inventory_item_id, inventory_master_org_id)) UOM
691: FROM AHL_ITEM_COMP_DETAILS ICD
692: WHERE ITEM_COMP_DETAIL_ID = c_item_comp_detail_id;
693:
694: l_mc_route_effectivity_id NUMBER;

Line 1009: AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM_Qty(INVENTORY_ITEM_ID, UOM_CODE, QUANTITY) AS PRIMARY_QUANTITY,

1005: ROM.INVENTORY_ITEM_ID,
1006: ROM.INVENTORY_ORG_ID,
1007: ROM.QUANTITY,
1008: ROM.UOM_CODE,
1009: AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM_Qty(INVENTORY_ITEM_ID, UOM_CODE, QUANTITY) AS PRIMARY_QUANTITY,
1010: AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM(INVENTORY_ITEM_ID, INVENTORY_ORG_ID) AS PRIMARY_UOM_CODE,
1011: ROM.ITEM_GROUP_ID
1012: FROM AHL_RT_OPER_MATERIALS ROM
1013: WHERE OBJECT_ID = p_route_id

Line 1010: AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM(INVENTORY_ITEM_ID, INVENTORY_ORG_ID) AS PRIMARY_UOM_CODE,

1006: ROM.INVENTORY_ORG_ID,
1007: ROM.QUANTITY,
1008: ROM.UOM_CODE,
1009: AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM_Qty(INVENTORY_ITEM_ID, UOM_CODE, QUANTITY) AS PRIMARY_QUANTITY,
1010: AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM(INVENTORY_ITEM_ID, INVENTORY_ORG_ID) AS PRIMARY_UOM_CODE,
1011: ROM.ITEM_GROUP_ID
1012: FROM AHL_RT_OPER_MATERIALS ROM
1013: WHERE OBJECT_ID = p_route_id
1014: AND ASSOCIATION_TYPE_CODE = G_ASSOC_TYPE_ROUTE;

Line 1027: SUM(AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM_Qty(INVENTORY_ITEM_ID, UOM_CODE, QUANTITY)) AS QUANTITY, --Total Primary Qty

1023: TO_NUMBER(NULL) AS ROUTE_OPERATION_ID,
1024: INVENTORY_ITEM_ID,
1025: INVENTORY_ORG_ID,
1026: -- Aggregate item quantities across operations when forecasting
1027: SUM(AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM_Qty(INVENTORY_ITEM_ID, UOM_CODE, QUANTITY)) AS QUANTITY, --Total Primary Qty
1028: AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM(INVENTORY_ITEM_ID, INVENTORY_ORG_ID) AS UOM_CODE,
1029: -- support for Oracle 8
1030: --NULL AS ITEM_GROUP_ID
1031: TO_NUMBER(NULL) AS ITEM_GROUP_ID

Line 1028: AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM(INVENTORY_ITEM_ID, INVENTORY_ORG_ID) AS UOM_CODE,

1024: INVENTORY_ITEM_ID,
1025: INVENTORY_ORG_ID,
1026: -- Aggregate item quantities across operations when forecasting
1027: SUM(AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM_Qty(INVENTORY_ITEM_ID, UOM_CODE, QUANTITY)) AS QUANTITY, --Total Primary Qty
1028: AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM(INVENTORY_ITEM_ID, INVENTORY_ORG_ID) AS UOM_CODE,
1029: -- support for Oracle 8
1030: --NULL AS ITEM_GROUP_ID
1031: TO_NUMBER(NULL) AS ITEM_GROUP_ID
1032: FROM AHL_RT_OPER_MATERIALS ROM

Line 1056: AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM_Qty(INVENTORY_ITEM_ID, UOM_CODE, QUANTITY) AS QUANTITY, -- Primary Qty

1052: SELECT RT_OPER_MATERIAL_ID,
1053: OBJECT_ID AS ROUTE_OPERATION_ID,
1054: INVENTORY_ITEM_ID,
1055: INVENTORY_ORG_ID,
1056: AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM_Qty(INVENTORY_ITEM_ID, UOM_CODE, QUANTITY) AS QUANTITY, -- Primary Qty
1057: AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM(INVENTORY_ITEM_ID, INVENTORY_ORG_ID) AS UOM_CODE,
1058: --NULL AS ITEM_GROUP_ID
1059: -- support for Oracle 8
1060: TO_NUMBER(NULL) AS ITEM_GROUP_ID

Line 1057: AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM(INVENTORY_ITEM_ID, INVENTORY_ORG_ID) AS UOM_CODE,

1053: OBJECT_ID AS ROUTE_OPERATION_ID,
1054: INVENTORY_ITEM_ID,
1055: INVENTORY_ORG_ID,
1056: AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM_Qty(INVENTORY_ITEM_ID, UOM_CODE, QUANTITY) AS QUANTITY, -- Primary Qty
1057: AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM(INVENTORY_ITEM_ID, INVENTORY_ORG_ID) AS UOM_CODE,
1058: --NULL AS ITEM_GROUP_ID
1059: -- support for Oracle 8
1060: TO_NUMBER(NULL) AS ITEM_GROUP_ID
1061: FROM AHL_RT_OPER_MATERIALS ROM

Line 1113: SUM(AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM_Qty(INVENTORY_ITEM_ID, UOM_CODE, QUANTITY)) AS QUANTITY, /Total Primary Qty /

1109: TO_NUMBER(NULL) AS ROUTE_OPERATION_ID,
1110: INVENTORY_ITEM_ID,
1111: INVENTORY_ORG_ID,
1112: -- Aggregate item quantities across operations when forecasting
1113: SUM(AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM_Qty(INVENTORY_ITEM_ID, UOM_CODE, QUANTITY)) AS QUANTITY, /*Total Primary Qty */
1114: AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM(INVENTORY_ITEM_ID, INVENTORY_ORG_ID) AS UOM_CODE,
1115: TO_NUMBER(NULL) AS ITEM_GROUP_ID
1116: FROM AHL_RT_OPER_MATERIALS ROM
1117: WHERE OBJECT_ID in ( SELECT RO.operation_id

Line 1114: AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM(INVENTORY_ITEM_ID, INVENTORY_ORG_ID) AS UOM_CODE,

1110: INVENTORY_ITEM_ID,
1111: INVENTORY_ORG_ID,
1112: -- Aggregate item quantities across operations when forecasting
1113: SUM(AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM_Qty(INVENTORY_ITEM_ID, UOM_CODE, QUANTITY)) AS QUANTITY, /*Total Primary Qty */
1114: AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM(INVENTORY_ITEM_ID, INVENTORY_ORG_ID) AS UOM_CODE,
1115: TO_NUMBER(NULL) AS ITEM_GROUP_ID
1116: FROM AHL_RT_OPER_MATERIALS ROM
1117: WHERE OBJECT_ID in ( SELECT RO.operation_id
1118: FROM AHL_OPERATIONS_B_KFV O, ahl_route_operations RO

Line 1162: AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM_Qty(INVENTORY_ITEM_ID, UOM_CODE, QUANTITY) AS QUANTITY, /* Primary Qty */

1158: SELECT RT_OPER_MATERIAL_ID,
1159: OBJECT_ID AS ROUTE_OPERATION_ID,
1160: INVENTORY_ITEM_ID,
1161: INVENTORY_ORG_ID,
1162: AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM_Qty(INVENTORY_ITEM_ID, UOM_CODE, QUANTITY) AS QUANTITY, /* Primary Qty */
1163: AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM(INVENTORY_ITEM_ID, INVENTORY_ORG_ID) AS UOM_CODE,
1164: TO_NUMBER(NULL) AS ITEM_GROUP_ID
1165: FROM AHL_RT_OPER_MATERIALS ROM
1166: WHERE OBJECT_ID in ( SELECT RO.operation_id

Line 1163: AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM(INVENTORY_ITEM_ID, INVENTORY_ORG_ID) AS UOM_CODE,

1159: OBJECT_ID AS ROUTE_OPERATION_ID,
1160: INVENTORY_ITEM_ID,
1161: INVENTORY_ORG_ID,
1162: AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM_Qty(INVENTORY_ITEM_ID, UOM_CODE, QUANTITY) AS QUANTITY, /* Primary Qty */
1163: AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM(INVENTORY_ITEM_ID, INVENTORY_ORG_ID) AS UOM_CODE,
1164: TO_NUMBER(NULL) AS ITEM_GROUP_ID
1165: FROM AHL_RT_OPER_MATERIALS ROM
1166: WHERE OBJECT_ID in ( SELECT RO.operation_id
1167: FROM AHL_OPERATIONS_B_KFV O, ahl_route_operations RO

Line 1678: END AHL_LTP_MTL_REQ_PVT;

1674: ------------------------------------
1675: -- End Local Function Definitions --
1676: ------------------------------------
1677:
1678: END AHL_LTP_MTL_REQ_PVT;