DBA Data[Home] [Help]

APPS.AHL_RSV_RESERVATIONS_PVT dependencies on FND_API

Line 27: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

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 :

Line 28: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

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

Line 29: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

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

Line 44: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 45: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 46: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 65: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

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 :

Line 66: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

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

Line 67: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

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

Line 82: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 83: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 84: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 103: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

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 :

Line 104: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

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

Line 105: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

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

Line 121: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 122: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 123: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 141: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

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 :

Line 142: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

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

Line 143: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

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

Line 158: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 159: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 160: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 180: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE

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 :

Line 181: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE

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

Line 182: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL

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

Line 196: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 197: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 198: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 270: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 271: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 272: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,