DBA Data[Home] [Help]

APPS.INV_MATERIAL_STATUS_PKG dependencies on MTL_MATERIAL_STATUSES

Line 19: p_old_status_id mtl_material_statuses.status_id%TYPE,

15: p_status_rec IN INV_MATERIAL_STATUS_PUB.mtl_status_update_rec_type );
16:
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,

Line 20: p_new_status_id mtl_material_statuses.status_id%TYPE ,

16:
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

Line 29: p_old_status_id mtl_material_statuses.status_id%TYPE,

25: )RETURN BOOLEAN;
26:
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,

Line 30: p_new_status_id mtl_material_statuses.status_id%TYPE ,

26:
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,

Line 39: p_status_id MTL_MATERIAL_STATUSES.STATUS_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
40: ,p_org_id MTL_SECONDARY_INVENTORIES.ORGANIZATION_ID%TYPE
41: ,p_inventory_item_id MTL_LOT_NUMBERS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
42: ,p_secondary_inventory_name MTL_SECONDARY_INVENTORIES.SECONDARY_INVENTORY_NAME%TYPE DEFAULT NULL
43: ,p_lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE DEFAULT NULL