APPS.AHL_PP_MATERIALS_PVT dependencies on AHL_SCHEDULE_MATERIALS_S

Line 640: UPDATE AHL_SCHEDULE_MATERIALS SET

636: --debadey: Marshalling FDD sction 5.15 - AOG flag addition
637: X_AOG_FLAG IN VARCHAR2
638: ) IS
639: BEGIN
640: UPDATE AHL_SCHEDULE_MATERIALS SET
641: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER + 1,
642: INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID,
643: SCHEDULE_DESIGNATOR = X_SCHEDULE_DESIGNATOR,
644: VISIT_ID = X_VISIT_ID,

Line 2396: SELECT ahl_schedule_materials_s.NEXTVAL

2392: l_Req_Material_Tbl(i).aog_flag := p_x_req_material_tbl(i).aog_flag;
2393: END IF;
2394: -- end of changes by debadey for Marshalling
2395: -- Get Sequence Number for schedule material ID
2396: SELECT ahl_schedule_materials_s.NEXTVAL
2397: INTO l_schedule_material_id FROM DUAL;
2398: --
2399: --
2400: IF G_DEBUG='Y' THEN

Line 6444: -- p_asm_id IN ahl_schedule_materials.schedule_material_id

6440: -- x_msg_count OUT NUMBER Required
6441: -- x_msg_data OUT VARCHAR2 Required
6442: --
6443: -- Process_Material Notification Parameters :
6444: -- p_asm_id IN ahl_schedule_materials.schedule_material_id
6445: -- p_alternate_item_id IN New Inventory_Item_Id which will replace old inventory item.
6446: PROCEDURE Wo_Mat_Req_Item_Change(
6447: p_api_version IN NUMBER,
6448: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,