APPS.AHL_RM_MATERIAL_AS_PVT dependencies on AHL_RT_OPER_MATERIALS

Line 978: FROM AHL_RT_OPER_MATERIALS_V

974: exclude_flag,
975: rework_percent,
976: replace_percent,
977: in_service --pdoki added for OGMA 105 issue
978: FROM AHL_RT_OPER_MATERIALS_V
979: WHERE rt_oper_material_id = c_rt_oper_material_id;
980:
981: BEGIN
982:

Line 983: -- Get the old record from AHL_RT_OPER_MATERIALS.

979: WHERE rt_oper_material_id = c_rt_oper_material_id;
980:
981: BEGIN
982:
983: -- Get the old record from AHL_RT_OPER_MATERIALS.
984: OPEN get_old_rec( p_x_material_req_rec.rt_oper_material_id );
985:
986: FETCH get_old_rec INTO
987: l_old_material_req_rec.item_group_id,

Line 1264: -- Get the old record from AHL_RT_OPER_MATERIALS.

1260: ;
1261:
1262: BEGIN
1263:
1264: -- Get the old record from AHL_RT_OPER_MATERIALS.
1265: OPEN get_old_rec( p_x_route_efct_rec.ROUTE_EFFECTIVITY_ID );
1266:
1267: FETCH get_old_rec INTO
1268: l_old_route_efct_rec.inventory_item_id

Line 1909: AHL_RT_OPER_MATERIALS ROMV

1905: ROMV.item_group_id,
1906: ROMV.inventory_item_id,
1907: ROMV.inventory_org_id
1908: FROM
1909: AHL_RT_OPER_MATERIALS ROMV
1910: WHERE
1911: ROMV.object_id = c_object_id AND
1912: ROMV.association_type_code = c_association_type AND
1913: NOT EXISTS

Line 2460: INSERT INTO AHL_RT_OPER_MATERIALS

2456: BEGIN
2457: -- Insert the record
2458: p_x_material_req_tbl(i).object_version_number := 1;
2459:
2460: INSERT INTO AHL_RT_OPER_MATERIALS
2461: (
2462: RT_OPER_MATERIAL_ID,
2463: OBJECT_VERSION_NUMBER,
2464: OBJECT_ID,

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 2570: 'AHL_RT_OPER_MATERIALS insert error = ['||SQLERRM||']'

2566: fnd_log.string
2567: (
2568: fnd_log.level_unexpected,
2569: 'ahl.plsql.'||G_PKG_NAME||'.'||G_API_NAME,
2570: 'AHL_RT_OPER_MATERIALS insert error = ['||SQLERRM||']'
2571: );
2572: END IF;
2573: END IF;
2574: END;

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,

Line 2640: 'AHL_RT_OPER_MATERIALS update error = ['||SQLERRM||']'

2636: fnd_log.string
2637: (
2638: fnd_log.level_unexpected,
2639: 'ahl.plsql.'||G_PKG_NAME||'.'||G_API_NAME,
2640: 'AHL_RT_OPER_MATERIALS update error = ['||SQLERRM||']'
2641: );
2642: END IF;
2643: END IF;
2644: END;

Line 2649: DELETE AHL_RT_OPER_MATERIALS

2645:
2646: ELSIF ( p_x_material_req_tbl(i).dml_operation = 'D' ) THEN
2647:
2648: -- Delete the record
2649: DELETE AHL_RT_OPER_MATERIALS
2650: WHERE rt_oper_material_id = p_x_material_req_tbl(i).rt_oper_material_id
2651: AND object_version_number = p_x_material_req_tbl(i).object_version_number;
2652:
2653: -- If the record does not exist, then, abort API.

Line 3122: DELETE FROM AHL_RT_OPER_MATERIALS

3118:
3119: ELSIF ( p_x_route_efct_tbl(i).dml_operation = 'D' ) THEN
3120:
3121: -- Delete the record
3122: DELETE FROM AHL_RT_OPER_MATERIALS
3123: WHERE OBJECT_ID = p_x_route_efct_tbl(i).route_effectivity_id
3124: AND ASSOCIATION_TYPE_CODE = 'DISPOSITION';
3125:
3126: -- If no records exist, then, Continue.