DBA Data[Home] [Help]

APPS.AHL_RM_MATERIAL_AS_PVT dependencies on AHL_RT_OPER_MATERIALS_S

Line 2387: AHL_RT_OPER_MATERIALS_S.NEXTVAL,

2383: POSITION_KEY
2384: --sukhwsin: Added columns for SB Effectivity ends
2385: ) VALUES
2386: (
2387: AHL_RT_OPER_MATERIALS_S.NEXTVAL,
2388: p_x_material_req_tbl(i).object_version_number,
2389: p_object_id,
2390: p_association_type,
2391: p_x_material_req_tbl(i).position_path_id ,

Line 2470: UPDATE AHL_RT_OPER_MATERIALS SET

2466: END;
2467: ELSIF ( p_x_material_req_tbl(i).dml_operation = 'U' ) THEN
2468: BEGIN
2469: -- Update the record
2470: UPDATE AHL_RT_OPER_MATERIALS SET
2471: object_version_number = object_version_number + 1,
2472: item_comp_detail_id = p_x_material_req_tbl(i).item_comp_detail_id ,
2473: position_path_id = p_x_material_req_tbl(i).position_path_id ,
2474: item_group_id = p_x_material_req_tbl(i).item_group_id,