APPS.INV_GMI_MIGRATION dependencies on MTL_MATERIAL_STATUS_S

Line 58: | INSERT_ROW in package mtl_material_statuses_pkg |

54: | disallowed for status with shipping indicator |
55: | unchecked |
56: | Kedar Bavadekar - 07/01/09. Fix for Bug#8650503. |
57: | Added parameter X_ONHAND_CONTROL in call to |
58: | INSERT_ROW in package mtl_material_statuses_pkg |
59: | Kedar Bavadekar - 03/17/10 . Fix for Bug#9143261 |
60: | - Update on-hand control field for exisiting status |
61: | and new statues |
62: | Kedar Bavadekar - 03/29/2010 Bug#9403348 |

Line 872: FROM mtl_material_statuses_tl

868: BEGIN
869: -- Check if the material status already exists in the discrete
870: SELECT count(*)
871: INTO l_count
872: FROM mtl_material_statuses_tl
873: WHERE
874: status_code = l_lot_status.lot_status and
875: rownum = 1;
876:

Line 879: UPDATE mtl_material_statuses_b -- 10413599

875: rownum = 1;
876:
877: IF (l_count > 0) THEN
878: /* Start for fix for Bug#9143261 */
879: UPDATE mtl_material_statuses_b -- 10413599
880: SET onhand_control = 1
881: WHERE status_id = (SELECT status_id
882: FROM mtl_material_statuses_tl
883: WHERE status_code = l_lot_status.lot_status

Line 882: FROM mtl_material_statuses_tl

878: /* Start for fix for Bug#9143261 */
879: UPDATE mtl_material_statuses_b -- 10413599
880: SET onhand_control = 1
881: WHERE status_id = (SELECT status_id
882: FROM mtl_material_statuses_tl
883: WHERE status_code = l_lot_status.lot_status
884: AND rownum = 1);
885: /* End for fix for Bug#9143261 */
886:

Line 891: FROM mtl_material_statuses_tl

887: /* Start for fix for Bug#10413599 */
888:
889: UPDATE ic_lots_sts
890: SET status_id = (SELECT status_id
891: FROM mtl_material_statuses_tl
892: WHERE status_code = l_lot_status.lot_status
893: AND rownum = 1),
894: migrated_ind = 1
895: WHERE lot_status = l_lot_status.lot_status;

Line 924: SELECT mtl_material_status_s.NEXTVAL

920: p_app_short_name => 'GMI');
921: raise FND_API.G_EXC_ERROR;
922: END IF;
923:
924: SELECT mtl_material_status_s.NEXTVAL
925: INTO l_status_id
926: FROM DUAL;
927:
928: l_availability_type := 2;

Line 934: MTL_MATERIAL_STATUSES_PKG.INSERT_ROW (

930: IF (l_lot_status.nettable_ind = 1) THEN
931: l_availability_type := 1;
932: END IF;
933: END IF;
934: MTL_MATERIAL_STATUSES_PKG.INSERT_ROW (
935: X_ROWID => l_rowid,
936: X_STATUS_ID => l_status_id,
937: X_ATTRIBUTE1 => NULL,
938: X_ATTRIBUTE2 => NULL,