APPS.AHL_PP_MATERIALS_PVT dependencies on AHL_SCHEDULE_MATERIALS_S

Line 575: UPDATE AHL_SCHEDULE_MATERIALS SET

571: X_LAST_UPDATED_BY IN NUMBER,
572: X_LAST_UPDATE_LOGIN IN NUMBER
573: ) IS
574: BEGIN
575: UPDATE AHL_SCHEDULE_MATERIALS SET
576: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER + 1,
577: INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID,
578: SCHEDULE_DESIGNATOR = X_SCHEDULE_DESIGNATOR,
579: VISIT_ID = X_VISIT_ID,

Line 1604: SELECT ahl_schedule_materials_s.NEXTVAL

1600: l_Req_Material_Tbl(i).attribute15 := p_x_req_material_tbl(i).attribute15;
1601: END IF;
1602: --
1603: -- Get Sequence Number for schedule material ID
1604: SELECT ahl_schedule_materials_s.NEXTVAL
1605: INTO l_schedule_material_id FROM DUAL;
1606: --
1607: --
1608: IF G_DEBUG='Y' THEN