23: -- Function : Reserves the serial numbers in the p_serial_number_tbl
24: -- Pre-reqs :
25: -- Standard IN Parameters :
26: -- p_api_version IN NUMBER Required
27: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
28: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
29: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
30: -- p_module_type IN VARCHAR2 Default NULL
31: -- Standard OUT Parameters :
24: -- Pre-reqs :
25: -- Standard IN Parameters :
26: -- p_api_version IN NUMBER Required
27: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
28: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
29: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
30: -- p_module_type IN VARCHAR2 Default NULL
31: -- Standard OUT Parameters :
32: -- x_return_status OUT VARCHAR2 Required
25: -- Standard IN Parameters :
26: -- p_api_version IN NUMBER Required
27: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
28: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
29: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
30: -- p_module_type IN VARCHAR2 Default NULL
31: -- Standard OUT Parameters :
32: -- x_return_status OUT VARCHAR2 Required
33: -- x_msg_count OUT NUMBER Required
40: -- End of Comments.
41: ---------------------------------------------------------------------------------------------------------
42: PROCEDURE CREATE_RESERVATION(
43: p_api_version IN NUMBER := 1.0,
44: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
45: p_commit IN VARCHAR2 := FND_API.G_FALSE,
46: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
47: p_module_type IN VARCHAR2,
48: x_return_status OUT NOCOPY VARCHAR2,
41: ---------------------------------------------------------------------------------------------------------
42: PROCEDURE CREATE_RESERVATION(
43: p_api_version IN NUMBER := 1.0,
44: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
45: p_commit IN VARCHAR2 := FND_API.G_FALSE,
46: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
47: p_module_type IN VARCHAR2,
48: x_return_status OUT NOCOPY VARCHAR2,
49: x_msg_count OUT NOCOPY NUMBER,
42: PROCEDURE CREATE_RESERVATION(
43: p_api_version IN NUMBER := 1.0,
44: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
45: p_commit IN VARCHAR2 := FND_API.G_FALSE,
46: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
47: p_module_type IN VARCHAR2,
48: x_return_status OUT NOCOPY VARCHAR2,
49: x_msg_count OUT NOCOPY NUMBER,
50: x_msg_data OUT NOCOPY VARCHAR2,
61: -- Function : Updates reservation for serial numbers in the p_serial_number_tbl
62: -- Pre-reqs :
63: -- Standard IN Parameters :
64: -- p_api_version IN NUMBER Required
65: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
66: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
67: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
68: -- p_module_type IN VARCHAR2 Default NULL
69: -- Standard OUT Parameters :
62: -- Pre-reqs :
63: -- Standard IN Parameters :
64: -- p_api_version IN NUMBER Required
65: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
66: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
67: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
68: -- p_module_type IN VARCHAR2 Default NULL
69: -- Standard OUT Parameters :
70: -- x_return_status OUT VARCHAR2 Required
63: -- Standard IN Parameters :
64: -- p_api_version IN NUMBER Required
65: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
66: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
67: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
68: -- p_module_type IN VARCHAR2 Default NULL
69: -- Standard OUT Parameters :
70: -- x_return_status OUT VARCHAR2 Required
71: -- x_msg_count OUT NUMBER Required
78: -- End of Comments.
79: ---------------------------------------------------------------------------------------------------------
80: PROCEDURE UPDATE_RESERVATION(
81: p_api_version IN NUMBER := 1.0,
82: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
83: p_commit IN VARCHAR2 := FND_API.G_FALSE,
84: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
85: p_module_type IN VARCHAR2,
86: x_return_status OUT NOCOPY VARCHAR2,
79: ---------------------------------------------------------------------------------------------------------
80: PROCEDURE UPDATE_RESERVATION(
81: p_api_version IN NUMBER := 1.0,
82: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
83: p_commit IN VARCHAR2 := FND_API.G_FALSE,
84: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
85: p_module_type IN VARCHAR2,
86: x_return_status OUT NOCOPY VARCHAR2,
87: x_msg_count OUT NOCOPY NUMBER,
80: PROCEDURE UPDATE_RESERVATION(
81: p_api_version IN NUMBER := 1.0,
82: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
83: p_commit IN VARCHAR2 := FND_API.G_FALSE,
84: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
85: p_module_type IN VARCHAR2,
86: x_return_status OUT NOCOPY VARCHAR2,
87: x_msg_count OUT NOCOPY NUMBER,
88: x_msg_data OUT NOCOPY VARCHAR2,
99: -- Function : API to delete all the reservation made for a requirement
100: -- Pre-reqs :
101: -- Standard IN Parameters :
102: -- p_api_version IN NUMBER Required
103: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
104: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
105: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
106: -- p_module_type IN VARCHAR2 Default NULL
107: -- Standard OUT Parameters :
100: -- Pre-reqs :
101: -- Standard IN Parameters :
102: -- p_api_version IN NUMBER Required
103: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
104: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
105: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
106: -- p_module_type IN VARCHAR2 Default NULL
107: -- Standard OUT Parameters :
108: -- x_return_status OUT VARCHAR2 Required
101: -- Standard IN Parameters :
102: -- p_api_version IN NUMBER Required
103: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
104: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
105: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
106: -- p_module_type IN VARCHAR2 Default NULL
107: -- Standard OUT Parameters :
108: -- x_return_status OUT VARCHAR2 Required
109: -- x_msg_count OUT NUMBER Required
117: -- End of Comments.
118: ---------------------------------------------------------------------------------------------------------
119: PROCEDURE DELETE_RESERVATION(
120: p_api_version IN NUMBER := 1.0,
121: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
122: p_commit IN VARCHAR2 := FND_API.G_FALSE,
123: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
124: p_module_type IN VARCHAR2,
125: x_return_status OUT NOCOPY VARCHAR2,
118: ---------------------------------------------------------------------------------------------------------
119: PROCEDURE DELETE_RESERVATION(
120: p_api_version IN NUMBER := 1.0,
121: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
122: p_commit IN VARCHAR2 := FND_API.G_FALSE,
123: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
124: p_module_type IN VARCHAR2,
125: x_return_status OUT NOCOPY VARCHAR2,
126: x_msg_count OUT NOCOPY NUMBER,
119: PROCEDURE DELETE_RESERVATION(
120: p_api_version IN NUMBER := 1.0,
121: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
122: p_commit IN VARCHAR2 := FND_API.G_FALSE,
123: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
124: p_module_type IN VARCHAR2,
125: x_return_status OUT NOCOPY VARCHAR2,
126: x_msg_count OUT NOCOPY NUMBER,
127: x_msg_data OUT NOCOPY VARCHAR2,
137: -- Function : API to delete the reservation made for a particular serial number
138: -- Pre-reqs :
139: -- Standard IN Parameters :
140: -- p_api_version IN NUMBER Required
141: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
142: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
143: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
144: -- p_module_type IN VARCHAR2 Default NULL
145: -- Standard OUT Parameters :
138: -- Pre-reqs :
139: -- Standard IN Parameters :
140: -- p_api_version IN NUMBER Required
141: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
142: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
143: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
144: -- p_module_type IN VARCHAR2 Default NULL
145: -- Standard OUT Parameters :
146: -- x_return_status OUT VARCHAR2 Required
139: -- Standard IN Parameters :
140: -- p_api_version IN NUMBER Required
141: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
142: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
143: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
144: -- p_module_type IN VARCHAR2 Default NULL
145: -- Standard OUT Parameters :
146: -- x_return_status OUT VARCHAR2 Required
147: -- x_msg_count OUT NUMBER Required
154: -- End of Comments.
155: ---------------------------------------------------------------------------------------------------------
156: PROCEDURE RELIEVE_RESERVATION(
157: p_api_version IN NUMBER := 1.0,
158: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
159: p_commit IN VARCHAR2 := FND_API.G_FALSE,
160: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
161: p_module_type IN VARCHAR2,
162: x_return_status OUT NOCOPY VARCHAR2,
155: ---------------------------------------------------------------------------------------------------------
156: PROCEDURE RELIEVE_RESERVATION(
157: p_api_version IN NUMBER := 1.0,
158: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
159: p_commit IN VARCHAR2 := FND_API.G_FALSE,
160: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
161: p_module_type IN VARCHAR2,
162: x_return_status OUT NOCOPY VARCHAR2,
163: x_msg_count OUT NOCOPY NUMBER,
156: PROCEDURE RELIEVE_RESERVATION(
157: p_api_version IN NUMBER := 1.0,
158: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
159: p_commit IN VARCHAR2 := FND_API.G_FALSE,
160: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
161: p_module_type IN VARCHAR2,
162: x_return_status OUT NOCOPY VARCHAR2,
163: x_msg_count OUT NOCOPY NUMBER,
164: x_msg_data OUT NOCOPY VARCHAR2,
176: -- Function : API to delete the reservation made for a particular serial number
177: -- Pre-reqs :
178: -- Standard IN Parameters :
179: -- p_api_version IN NUMBER Required
180: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
181: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
182: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
183: -- p_module_type IN VARCHAR2 Default NULL
184: -- Standard OUT Parameters :
177: -- Pre-reqs :
178: -- Standard IN Parameters :
179: -- p_api_version IN NUMBER Required
180: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
181: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
182: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
183: -- p_module_type IN VARCHAR2 Default NULL
184: -- Standard OUT Parameters :
185: -- x_return_status OUT VARCHAR2 Required
178: -- Standard IN Parameters :
179: -- p_api_version IN NUMBER Required
180: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
181: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
182: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
183: -- p_module_type IN VARCHAR2 Default NULL
184: -- Standard OUT Parameters :
185: -- x_return_status OUT VARCHAR2 Required
186: -- x_msg_count OUT NUMBER Required
192: -- End of Comments.
193: ---------------------------------------------------------------------------------------------------------
194: PROCEDURE TRANSFER_RESERVATION(
195: p_api_version IN NUMBER := 1.0,
196: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
197: p_commit IN VARCHAR2 := FND_API.G_FALSE,
198: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
199: p_module_type IN VARCHAR2,
200: x_return_status OUT NOCOPY VARCHAR2,
193: ---------------------------------------------------------------------------------------------------------
194: PROCEDURE TRANSFER_RESERVATION(
195: p_api_version IN NUMBER := 1.0,
196: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
197: p_commit IN VARCHAR2 := FND_API.G_FALSE,
198: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
199: p_module_type IN VARCHAR2,
200: x_return_status OUT NOCOPY VARCHAR2,
201: x_msg_count OUT NOCOPY NUMBER,
194: PROCEDURE TRANSFER_RESERVATION(
195: p_api_version IN NUMBER := 1.0,
196: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
197: p_commit IN VARCHAR2 := FND_API.G_FALSE,
198: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
199: p_module_type IN VARCHAR2,
200: x_return_status OUT NOCOPY VARCHAR2,
201: x_msg_count OUT NOCOPY NUMBER,
202: x_msg_data OUT NOCOPY VARCHAR2,
266: -- End of Comments.
267: ---------------------------------------------------------------------------------------------------------
268: PROCEDURE TRNSFR_RSRV_FOR_MATRL_REQR(
269: p_api_version IN NUMBER := 1.0,
270: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
271: p_commit IN VARCHAR2 := FND_API.G_FALSE,
272: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
273: p_module_type IN VARCHAR2,
274: x_return_status OUT NOCOPY VARCHAR2,
267: ---------------------------------------------------------------------------------------------------------
268: PROCEDURE TRNSFR_RSRV_FOR_MATRL_REQR(
269: p_api_version IN NUMBER := 1.0,
270: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
271: p_commit IN VARCHAR2 := FND_API.G_FALSE,
272: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
273: p_module_type IN VARCHAR2,
274: x_return_status OUT NOCOPY VARCHAR2,
275: x_msg_count OUT NOCOPY NUMBER,
268: PROCEDURE TRNSFR_RSRV_FOR_MATRL_REQR(
269: p_api_version IN NUMBER := 1.0,
270: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
271: p_commit IN VARCHAR2 := FND_API.G_FALSE,
272: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
273: p_module_type IN VARCHAR2,
274: x_return_status OUT NOCOPY VARCHAR2,
275: x_msg_count OUT NOCOPY NUMBER,
276: x_msg_data OUT NOCOPY VARCHAR2,