APPS.AHL_MATERIALS_GRP dependencies on AHL_LTP_MTL_REQ_PVT

Line 68: l_alt_items AHL_LTP_MTL_REQ_PVT.Alt_Items_Tbl_Type;

64: l_priority NUMBER;
65: i NUMBER;
66: j NUMBER;
67: l_tbl_index NUMBER := 1;
68: l_alt_items AHL_LTP_MTL_REQ_PVT.Alt_Items_Tbl_Type;
69:
70: Cursor get_visit_task_id_csr(c_wip_entity_id IN NUMBER) IS
71: SELECT WO.VISIT_TASK_ID
72: FROM AHL_WORKORDERS WO

Line 127: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to call AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items with p_schedule_material_id as ' || l_material_rec.scheduled_material_id);

123: IF ((l_material_rec.item_group_id IS NOT NULL OR (l_material_rec.mc_header_id IS NOT NULL AND l_material_rec.position_key IS NOT NULL))
124: AND l_material_rec.inventory_item_id IS NOT NULL) THEN
125: -- Get the alternates by calling the LTP procedure
126: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
127: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to call AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items with p_schedule_material_id as ' || l_material_rec.scheduled_material_id);
128: END IF;
129: AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items(p_api_version => 1.0,
130: p_schedule_material_id => l_material_rec.scheduled_material_id,
131: x_alt_items => l_alt_items,

Line 129: AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items(p_api_version => 1.0,

125: -- Get the alternates by calling the LTP procedure
126: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
127: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'About to call AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items with p_schedule_material_id as ' || l_material_rec.scheduled_material_id);
128: END IF;
129: AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items(p_api_version => 1.0,
130: p_schedule_material_id => l_material_rec.scheduled_material_id,
131: x_alt_items => l_alt_items,
132: x_return_status => x_return_status,
133: x_msg_count => x_msg_count,

Line 136: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items returned ' || x_return_status);

132: x_return_status => x_return_status,
133: x_msg_count => x_msg_count,
134: x_msg_data => x_msg_data);
135: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
136: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items returned ' || x_return_status);
137: END IF;
138: EXIT WHEN x_return_status <> FND_API.G_RET_STS_SUCCESS;
139: IF (l_alt_items IS NULL OR l_alt_items.COUNT = 0) THEN
140: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 160: -- Get the alternate item returned by AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items

156: x_alt_item_tbl(l_tbl_index).ALT_ITEM_UOM_CODE := l_material_rec.UOM;
157: x_alt_item_tbl(l_tbl_index).REQUESTED_DATE := l_material_rec.REQUESTED_DATE;
158: x_alt_item_tbl(l_tbl_index).OPERATION_SEQUENCE := l_material_rec.OPERATION_SEQUENCE;
159: x_alt_item_tbl(l_tbl_index).SCHEDULED_MATERIAL_ID := l_material_rec.SCHEDULED_MATERIAL_ID;
160: -- Get the alternate item returned by AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items
161: x_alt_item_tbl(l_tbl_index).ALTERNATE_ITEM_ID := l_alt_items(j);
162: -- Use (index + 1) as the Priority since AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items returns altenate items ordered by priority
163: x_alt_item_tbl(l_tbl_index).PRIORITY := j + 1;
164: -- Increment index

Line 162: -- Use (index + 1) as the Priority since AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items returns altenate items ordered by priority

158: x_alt_item_tbl(l_tbl_index).OPERATION_SEQUENCE := l_material_rec.OPERATION_SEQUENCE;
159: x_alt_item_tbl(l_tbl_index).SCHEDULED_MATERIAL_ID := l_material_rec.SCHEDULED_MATERIAL_ID;
160: -- Get the alternate item returned by AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items
161: x_alt_item_tbl(l_tbl_index).ALTERNATE_ITEM_ID := l_alt_items(j);
162: -- Use (index + 1) as the Priority since AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items returns altenate items ordered by priority
163: x_alt_item_tbl(l_tbl_index).PRIORITY := j + 1;
164: -- Increment index
165: l_tbl_index := l_tbl_index + 1;
166: END LOOP; -- For all alternates returned by AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items

Line 166: END LOOP; -- For all alternates returned by AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items

162: -- Use (index + 1) as the Priority since AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items returns altenate items ordered by priority
163: x_alt_item_tbl(l_tbl_index).PRIORITY := j + 1;
164: -- Increment index
165: l_tbl_index := l_tbl_index + 1;
166: END LOOP; -- For all alternates returned by AHL_LTP_MTL_REQ_PVT.Get_Alternate_Items
167: END IF; -- If there are alternate items available for this requirement
168: END IF; -- If the material requirement can have alternates
169: i := i + 1;
170: END LOOP; -- All materials for the task