DBA Data[Home] [Help]

APPS.AHL_RM_MATERIAL_AS_PVT dependencies on AHL_RT_OPER_MATERIALS_S

Line 2500: AHL_RT_OPER_MATERIALS_S.NEXTVAL,

2496: LAST_UPDATE_LOGIN,
2497: IN_SERVICE --pdoki added for OGMA 105 issue
2498: ) VALUES
2499: (
2500: AHL_RT_OPER_MATERIALS_S.NEXTVAL,
2501: p_x_material_req_tbl(i).object_version_number,
2502: p_object_id,
2503: p_association_type,
2504: p_x_material_req_tbl(i).position_path_id ,

Line 2580: UPDATE AHL_RT_OPER_MATERIALS SET

2576: ELSIF ( p_x_material_req_tbl(i).dml_operation = 'U' ) THEN
2577:
2578: BEGIN
2579: -- Update the record
2580: UPDATE AHL_RT_OPER_MATERIALS SET
2581: object_version_number = object_version_number + 1,
2582: item_comp_detail_id = p_x_material_req_tbl(i).item_comp_detail_id ,
2583: position_path_id = p_x_material_req_tbl(i).position_path_id ,
2584: item_group_id = p_x_material_req_tbl(i).item_group_id,