17: --INVCONV kkillams
18: FUNCTION VALIDATE_MTSTATUS(
19: p_old_status_id mtl_material_statuses.status_id%TYPE,
20: p_new_status_id mtl_material_statuses.status_id%TYPE ,
21: p_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,
22: p_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,
23: p_organization_id mtl_secondary_inventories.organization_id%TYPE,
24: p_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE
25: )RETURN BOOLEAN;
18: FUNCTION VALIDATE_MTSTATUS(
19: p_old_status_id mtl_material_statuses.status_id%TYPE,
20: p_new_status_id mtl_material_statuses.status_id%TYPE ,
21: p_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,
22: p_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,
23: p_organization_id mtl_secondary_inventories.organization_id%TYPE,
24: p_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE
25: )RETURN BOOLEAN;
26:
20: p_new_status_id mtl_material_statuses.status_id%TYPE ,
21: p_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,
22: p_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,
23: p_organization_id mtl_secondary_inventories.organization_id%TYPE,
24: p_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE
25: )RETURN BOOLEAN;
26:
27: /* bug 6866429: Overloaded Method */
28: FUNCTION VALIDATE_MTSTATUS(
27: /* bug 6866429: Overloaded Method */
28: FUNCTION VALIDATE_MTSTATUS(
29: p_old_status_id mtl_material_statuses.status_id%TYPE,
30: p_new_status_id mtl_material_statuses.status_id%TYPE ,
31: p_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,
32: p_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,
33: p_organization_id mtl_secondary_inventories.organization_id%TYPE,
34: p_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE,
35: p_lot_number mtl_onhand_quantities_detail.lot_number%TYPE /* bug 6866429 */
28: FUNCTION VALIDATE_MTSTATUS(
29: p_old_status_id mtl_material_statuses.status_id%TYPE,
30: p_new_status_id mtl_material_statuses.status_id%TYPE ,
31: p_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,
32: p_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,
33: p_organization_id mtl_secondary_inventories.organization_id%TYPE,
34: p_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE,
35: p_lot_number mtl_onhand_quantities_detail.lot_number%TYPE /* bug 6866429 */
36: )RETURN BOOLEAN;
30: p_new_status_id mtl_material_statuses.status_id%TYPE ,
31: p_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,
32: p_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,
33: p_organization_id mtl_secondary_inventories.organization_id%TYPE,
34: p_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE,
35: p_lot_number mtl_onhand_quantities_detail.lot_number%TYPE /* bug 6866429 */
36: )RETURN BOOLEAN;
37:
38: PROCEDURE SET_MS_FLAGS(
31: p_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,
32: p_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,
33: p_organization_id mtl_secondary_inventories.organization_id%TYPE,
34: p_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE,
35: p_lot_number mtl_onhand_quantities_detail.lot_number%TYPE /* bug 6866429 */
36: )RETURN BOOLEAN;
37:
38: PROCEDURE SET_MS_FLAGS(
39: p_status_id MTL_MATERIAL_STATUSES.STATUS_ID%TYPE