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.GMI_LOCKS dependencies on IC_LOCT_INV

Line 5: locks rows in ic_loct_inv. It is intended to be used by the allocation

1: PACKAGE GMI_LOCKS AUTHID CURRENT_USER AS
2: /* $Header: GMIULCKS.pls 115.6 2004/01/08 21:14:28 adeshmuk ship $
3:
4: This file contains the specification of a package which
5: locks rows in ic_loct_inv. It is intended to be used by the allocation
6: logic in the OM/OPM integration. At the start of an allocation session
7: for a particular item/whse/lot/location, the procedures in this package
8: prevent users from accessing the inventory simultaneously whilst it is
9: being allocated. This prevents multiple allocation of the same stock and

Line 61: i_item_id IN ic_loct_inv.item_id%TYPE,

57: 28-Oct-2002 J.DiIorio 11.5.1J Bug#2643440 - added nocopy.
58: */
59: PROCEDURE lock_inventory
60: (
61: i_item_id IN ic_loct_inv.item_id%TYPE,
62: o_lock_status OUT NOCOPY BOOLEAN
63: );
64: PROCEDURE lock_inventory
65: (

Line 66: i_item_id IN ic_loct_inv.item_id%TYPE,

62: o_lock_status OUT NOCOPY BOOLEAN
63: );
64: PROCEDURE lock_inventory
65: (
66: i_item_id IN ic_loct_inv.item_id%TYPE,
67: i_whse_code IN ic_whse_mst.whse_code%TYPE,
68: o_lock_status OUT NOCOPY BOOLEAN
69: );
70: PROCEDURE lock_inventory

Line 72: i_item_id IN ic_loct_inv.item_id%TYPE,

68: o_lock_status OUT NOCOPY BOOLEAN
69: );
70: PROCEDURE lock_inventory
71: (
72: i_item_id IN ic_loct_inv.item_id%TYPE,
73: i_whse_code IN ic_loct_inv.whse_code%TYPE,
74: i_lot_id IN ic_loct_inv.lot_id%TYPE,
75: i_lot_status IN ic_loct_inv.lot_status%TYPE,
76: o_lock_status OUT NOCOPY BOOLEAN

Line 73: i_whse_code IN ic_loct_inv.whse_code%TYPE,

69: );
70: PROCEDURE lock_inventory
71: (
72: i_item_id IN ic_loct_inv.item_id%TYPE,
73: i_whse_code IN ic_loct_inv.whse_code%TYPE,
74: i_lot_id IN ic_loct_inv.lot_id%TYPE,
75: i_lot_status IN ic_loct_inv.lot_status%TYPE,
76: o_lock_status OUT NOCOPY BOOLEAN
77: );

Line 74: i_lot_id IN ic_loct_inv.lot_id%TYPE,

70: PROCEDURE lock_inventory
71: (
72: i_item_id IN ic_loct_inv.item_id%TYPE,
73: i_whse_code IN ic_loct_inv.whse_code%TYPE,
74: i_lot_id IN ic_loct_inv.lot_id%TYPE,
75: i_lot_status IN ic_loct_inv.lot_status%TYPE,
76: o_lock_status OUT NOCOPY BOOLEAN
77: );
78: /* Bug 3356201 */

Line 75: i_lot_status IN ic_loct_inv.lot_status%TYPE,

71: (
72: i_item_id IN ic_loct_inv.item_id%TYPE,
73: i_whse_code IN ic_loct_inv.whse_code%TYPE,
74: i_lot_id IN ic_loct_inv.lot_id%TYPE,
75: i_lot_status IN ic_loct_inv.lot_status%TYPE,
76: o_lock_status OUT NOCOPY BOOLEAN
77: );
78: /* Bug 3356201 */
79: PROCEDURE lock_inventory

Line 81: i_item_id IN ic_loct_inv.item_id%TYPE,

77: );
78: /* Bug 3356201 */
79: PROCEDURE lock_inventory
80: (
81: i_item_id IN ic_loct_inv.item_id%TYPE,
82: i_whse_code IN ic_loct_inv.whse_code%TYPE,
83: i_lot_id IN ic_loct_inv.lot_id%TYPE,
84: i_location IN ic_loct_inv.location%TYPE,
85: o_lock_status OUT NOCOPY BOOLEAN

Line 82: i_whse_code IN ic_loct_inv.whse_code%TYPE,

78: /* Bug 3356201 */
79: PROCEDURE lock_inventory
80: (
81: i_item_id IN ic_loct_inv.item_id%TYPE,
82: i_whse_code IN ic_loct_inv.whse_code%TYPE,
83: i_lot_id IN ic_loct_inv.lot_id%TYPE,
84: i_location IN ic_loct_inv.location%TYPE,
85: o_lock_status OUT NOCOPY BOOLEAN
86: );

Line 83: i_lot_id IN ic_loct_inv.lot_id%TYPE,

79: PROCEDURE lock_inventory
80: (
81: i_item_id IN ic_loct_inv.item_id%TYPE,
82: i_whse_code IN ic_loct_inv.whse_code%TYPE,
83: i_lot_id IN ic_loct_inv.lot_id%TYPE,
84: i_location IN ic_loct_inv.location%TYPE,
85: o_lock_status OUT NOCOPY BOOLEAN
86: );
87: PROCEDURE lock_inventory

Line 84: i_location IN ic_loct_inv.location%TYPE,

80: (
81: i_item_id IN ic_loct_inv.item_id%TYPE,
82: i_whse_code IN ic_loct_inv.whse_code%TYPE,
83: i_lot_id IN ic_loct_inv.lot_id%TYPE,
84: i_location IN ic_loct_inv.location%TYPE,
85: o_lock_status OUT NOCOPY BOOLEAN
86: );
87: PROCEDURE lock_inventory
88: (

Line 89: i_item_id IN ic_loct_inv.item_id%TYPE,

85: o_lock_status OUT NOCOPY BOOLEAN
86: );
87: PROCEDURE lock_inventory
88: (
89: i_item_id IN ic_loct_inv.item_id%TYPE,
90: i_whse_code IN ic_loct_inv.whse_code%TYPE,
91: i_location IN ic_loct_inv.location%TYPE,
92: o_lock_status OUT NOCOPY BOOLEAN
93: );

Line 90: i_whse_code IN ic_loct_inv.whse_code%TYPE,

86: );
87: PROCEDURE lock_inventory
88: (
89: i_item_id IN ic_loct_inv.item_id%TYPE,
90: i_whse_code IN ic_loct_inv.whse_code%TYPE,
91: i_location IN ic_loct_inv.location%TYPE,
92: o_lock_status OUT NOCOPY BOOLEAN
93: );
94: PROCEDURE lock_inventory

Line 91: i_location IN ic_loct_inv.location%TYPE,

87: PROCEDURE lock_inventory
88: (
89: i_item_id IN ic_loct_inv.item_id%TYPE,
90: i_whse_code IN ic_loct_inv.whse_code%TYPE,
91: i_location IN ic_loct_inv.location%TYPE,
92: o_lock_status OUT NOCOPY BOOLEAN
93: );
94: PROCEDURE lock_inventory
95: (

Line 96: i_item_id IN ic_loct_inv.item_id%TYPE,

92: o_lock_status OUT NOCOPY BOOLEAN
93: );
94: PROCEDURE lock_inventory
95: (
96: i_item_id IN ic_loct_inv.item_id%TYPE,
97: i_whse_code IN ic_loct_inv.whse_code%TYPE,
98: i_lot_id IN ic_loct_inv.lot_id%TYPE,
99: i_lot_status IN ic_loct_inv.lot_status%TYPE,
100: i_location IN ic_loct_inv.location%TYPE,

Line 97: i_whse_code IN ic_loct_inv.whse_code%TYPE,

93: );
94: PROCEDURE lock_inventory
95: (
96: i_item_id IN ic_loct_inv.item_id%TYPE,
97: i_whse_code IN ic_loct_inv.whse_code%TYPE,
98: i_lot_id IN ic_loct_inv.lot_id%TYPE,
99: i_lot_status IN ic_loct_inv.lot_status%TYPE,
100: i_location IN ic_loct_inv.location%TYPE,
101: o_lock_status OUT NOCOPY BOOLEAN

Line 98: i_lot_id IN ic_loct_inv.lot_id%TYPE,

94: PROCEDURE lock_inventory
95: (
96: i_item_id IN ic_loct_inv.item_id%TYPE,
97: i_whse_code IN ic_loct_inv.whse_code%TYPE,
98: i_lot_id IN ic_loct_inv.lot_id%TYPE,
99: i_lot_status IN ic_loct_inv.lot_status%TYPE,
100: i_location IN ic_loct_inv.location%TYPE,
101: o_lock_status OUT NOCOPY BOOLEAN
102: );

Line 99: i_lot_status IN ic_loct_inv.lot_status%TYPE,

95: (
96: i_item_id IN ic_loct_inv.item_id%TYPE,
97: i_whse_code IN ic_loct_inv.whse_code%TYPE,
98: i_lot_id IN ic_loct_inv.lot_id%TYPE,
99: i_lot_status IN ic_loct_inv.lot_status%TYPE,
100: i_location IN ic_loct_inv.location%TYPE,
101: o_lock_status OUT NOCOPY BOOLEAN
102: );
103: PROCEDURE lock_inventory

Line 100: i_location IN ic_loct_inv.location%TYPE,

96: i_item_id IN ic_loct_inv.item_id%TYPE,
97: i_whse_code IN ic_loct_inv.whse_code%TYPE,
98: i_lot_id IN ic_loct_inv.lot_id%TYPE,
99: i_lot_status IN ic_loct_inv.lot_status%TYPE,
100: i_location IN ic_loct_inv.location%TYPE,
101: o_lock_status OUT NOCOPY BOOLEAN
102: );
103: PROCEDURE lock_inventory
104: (

Line 105: i_item_id IN ic_loct_inv.item_id%TYPE,

101: o_lock_status OUT NOCOPY BOOLEAN
102: );
103: PROCEDURE lock_inventory
104: (
105: i_item_id IN ic_loct_inv.item_id%TYPE,
106: i_whse_code IN ic_loct_inv.whse_code%TYPE,
107: i_lot_id IN ic_loct_inv.lot_id%TYPE,
108: i_lot_status IN ic_loct_inv.lot_status%TYPE,
109: i_location IN ic_loct_inv.location%TYPE,

Line 106: i_whse_code IN ic_loct_inv.whse_code%TYPE,

102: );
103: PROCEDURE lock_inventory
104: (
105: i_item_id IN ic_loct_inv.item_id%TYPE,
106: i_whse_code IN ic_loct_inv.whse_code%TYPE,
107: i_lot_id IN ic_loct_inv.lot_id%TYPE,
108: i_lot_status IN ic_loct_inv.lot_status%TYPE,
109: i_location IN ic_loct_inv.location%TYPE,
110: i_attempts IN NUMBER,

Line 107: i_lot_id IN ic_loct_inv.lot_id%TYPE,

103: PROCEDURE lock_inventory
104: (
105: i_item_id IN ic_loct_inv.item_id%TYPE,
106: i_whse_code IN ic_loct_inv.whse_code%TYPE,
107: i_lot_id IN ic_loct_inv.lot_id%TYPE,
108: i_lot_status IN ic_loct_inv.lot_status%TYPE,
109: i_location IN ic_loct_inv.location%TYPE,
110: i_attempts IN NUMBER,
111: o_lock_status OUT NOCOPY BOOLEAN

Line 108: i_lot_status IN ic_loct_inv.lot_status%TYPE,

104: (
105: i_item_id IN ic_loct_inv.item_id%TYPE,
106: i_whse_code IN ic_loct_inv.whse_code%TYPE,
107: i_lot_id IN ic_loct_inv.lot_id%TYPE,
108: i_lot_status IN ic_loct_inv.lot_status%TYPE,
109: i_location IN ic_loct_inv.location%TYPE,
110: i_attempts IN NUMBER,
111: o_lock_status OUT NOCOPY BOOLEAN
112: );

Line 109: i_location IN ic_loct_inv.location%TYPE,

105: i_item_id IN ic_loct_inv.item_id%TYPE,
106: i_whse_code IN ic_loct_inv.whse_code%TYPE,
107: i_lot_id IN ic_loct_inv.lot_id%TYPE,
108: i_lot_status IN ic_loct_inv.lot_status%TYPE,
109: i_location IN ic_loct_inv.location%TYPE,
110: i_attempts IN NUMBER,
111: o_lock_status OUT NOCOPY BOOLEAN
112: );
113: END GMI_LOCKS;