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_ONHAND_QUANTITIES_DETAIL

Line 21: p_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,

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;

Line 22: p_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,

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:

Line 24: p_inventory_item_id mtl_onhand_quantities_detail.inventory_item_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:
27: /* bug 6866429: Overloaded Method */
28: FUNCTION VALIDATE_MTSTATUS(

Line 31: p_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,

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 */

Line 32: p_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,

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: p_lpn_id mtl_onhand_quantities_detail.lpn_id%TYPE DEFAULT NULL -- Bug 14240066

Line 34: p_inventory_item_id mtl_onhand_quantities_detail.inventory_item_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: p_lpn_id mtl_onhand_quantities_detail.lpn_id%TYPE DEFAULT NULL -- Bug 14240066
37: )RETURN BOOLEAN;
38:

Line 35: p_lot_number mtl_onhand_quantities_detail.lot_number%TYPE, /* bug 6866429 */

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: p_lpn_id mtl_onhand_quantities_detail.lpn_id%TYPE DEFAULT NULL -- Bug 14240066
37: )RETURN BOOLEAN;
38:
39: /* ER 7530736: Overloaded Method */

Line 36: p_lpn_id mtl_onhand_quantities_detail.lpn_id%TYPE DEFAULT NULL -- Bug 14240066

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: p_lpn_id mtl_onhand_quantities_detail.lpn_id%TYPE DEFAULT NULL -- Bug 14240066
37: )RETURN BOOLEAN;
38:
39: /* ER 7530736: Overloaded Method */
40: FUNCTION validate_mtstatus(

Line 43: p_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,

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,
47: p_lot_number mtl_onhand_quantities_detail.lot_number%TYPE, /* bug 6837479 */

Line 44: p_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,

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,
47: p_lot_number mtl_onhand_quantities_detail.lot_number%TYPE, /* bug 6837479 */
48: p_dummy_param NUMBER,

Line 46: p_inventory_item_id mtl_onhand_quantities_detail.inventory_item_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,
47: p_lot_number mtl_onhand_quantities_detail.lot_number%TYPE, /* bug 6837479 */
48: p_dummy_param NUMBER,
49: p_lpn_id mtl_onhand_quantities_detail.lpn_id%TYPE DEFAULT NULL -- Bug 14240066
50: )RETURN BOOLEAN;

Line 47: p_lot_number mtl_onhand_quantities_detail.lot_number%TYPE, /* bug 6837479 */

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,
47: p_lot_number mtl_onhand_quantities_detail.lot_number%TYPE, /* bug 6837479 */
48: p_dummy_param NUMBER,
49: p_lpn_id mtl_onhand_quantities_detail.lpn_id%TYPE DEFAULT NULL -- Bug 14240066
50: )RETURN BOOLEAN;
51:

Line 49: p_lpn_id mtl_onhand_quantities_detail.lpn_id%TYPE DEFAULT NULL -- Bug 14240066

45: p_organization_id mtl_secondary_inventories.organization_id%TYPE,
46: p_inventory_item_id mtl_onhand_quantities_detail.inventory_item_id%TYPE,
47: p_lot_number mtl_onhand_quantities_detail.lot_number%TYPE, /* bug 6837479 */
48: p_dummy_param NUMBER,
49: p_lpn_id mtl_onhand_quantities_detail.lpn_id%TYPE DEFAULT NULL -- Bug 14240066
50: )RETURN BOOLEAN;
51:
52: /* bug 10171471 call VALIDATE_MTSTATUS to Return char */
53: FUNCTION VALIDATE_MTSTATUS2 (

Line 56: p_subinventory_code mtl_onhand_quantities_detail.subinventory_code%TYPE,

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,
60: p_lot_number mtl_onhand_quantities_detail.lot_number%TYPE

Line 57: p_locator_id mtl_onhand_quantities_detail.locator_id%TYPE,

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,
60: p_lot_number mtl_onhand_quantities_detail.lot_number%TYPE
61: )RETURN CHAR;

Line 59: p_inventory_item_id mtl_onhand_quantities_detail.inventory_item_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,
60: p_lot_number mtl_onhand_quantities_detail.lot_number%TYPE
61: )RETURN CHAR;
62:
63: PROCEDURE SET_MS_FLAGS(

Line 60: p_lot_number mtl_onhand_quantities_detail.lot_number%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,
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