eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 41: p_old_status_id mtl_material_statuses.status_id%TYPE,

37: )RETURN BOOLEAN;
38:
39: /* ER 7530736: Overloaded Method */
40: FUNCTION validate_mtstatus(
41: p_old_status_id mtl_material_statuses.status_id%TYPE,
42: p_new_status_id mtl_material_statuses.status_id%TYPE ,
43: p_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,
44: p_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,
45: p_organization_id mtl_secondary_inventories.organization_id%TYPE,

Line 42: p_new_status_id mtl_material_statuses.status_id%TYPE ,

38:
39: /* ER 7530736: Overloaded Method */
40: FUNCTION validate_mtstatus(
41: p_old_status_id mtl_material_statuses.status_id%TYPE,
42: p_new_status_id mtl_material_statuses.status_id%TYPE ,
43: p_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,
44: p_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,
45: p_organization_id mtl_secondary_inventories.organization_id%TYPE,
46: p_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE,

Line 54: p_old_status_id mtl_material_statuses.status_id%TYPE,

50: )RETURN BOOLEAN;
51:
52: /* bug 10171471 call VALIDATE_MTSTATUS to Return char */
53: FUNCTION VALIDATE_MTSTATUS2 (
54: p_old_status_id mtl_material_statuses.status_id%TYPE,
55: p_new_status_id mtl_material_statuses.status_id%TYPE ,
56: p_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,
57: p_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,
58: p_organization_id mtl_secondary_inventories.organization_id%TYPE,

Line 55: p_new_status_id mtl_material_statuses.status_id%TYPE ,

51:
52: /* bug 10171471 call VALIDATE_MTSTATUS to Return char */
53: FUNCTION VALIDATE_MTSTATUS2 (
54: p_old_status_id mtl_material_statuses.status_id%TYPE,
55: p_new_status_id mtl_material_statuses.status_id%TYPE ,
56: p_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,
57: p_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,
58: p_organization_id mtl_secondary_inventories.organization_id%TYPE,
59: p_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE,

Line 64: p_status_id MTL_MATERIAL_STATUSES.STATUS_ID%TYPE

60: p_lot_number mtl_onhand_quantities_detail.lot_number%TYPE
61: )RETURN CHAR;
62:
63: PROCEDURE SET_MS_FLAGS(
64: p_status_id MTL_MATERIAL_STATUSES.STATUS_ID%TYPE
65: ,p_org_id MTL_SECONDARY_INVENTORIES.ORGANIZATION_ID%TYPE
66: ,p_inventory_item_id MTL_LOT_NUMBERS.INVENTORY_ITEM_ID%TYPE DEFAULT NULL
67: ,p_secondary_inventory_name MTL_SECONDARY_INVENTORIES.SECONDARY_INVENTORY_NAME%TYPE DEFAULT NULL
68: ,p_lot_number MTL_LOT_NUMBERS.LOT_NUMBER%TYPE DEFAULT NULL