50: -- Parameters :
51: --
52: -- Standard IN Parameters :
53: -- p_api_version IN NUMBER Required
54: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
55: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
56: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
57: -- Based on this flag, the API will set the default attributes.
58: -- p_module_type In VARCHAR2 Default NULL
51: --
52: -- Standard IN Parameters :
53: -- p_api_version IN NUMBER Required
54: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
55: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
56: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
57: -- Based on this flag, the API will set the default attributes.
58: -- p_module_type In VARCHAR2 Default NULL
59: -- This will be null.
52: -- Standard IN Parameters :
53: -- p_api_version IN NUMBER Required
54: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
55: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
56: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
57: -- Based on this flag, the API will set the default attributes.
58: -- p_module_type In VARCHAR2 Default NULL
59: -- This will be null.
60: -- Standard OUT Parameters :
68: --
69:
70: PROCEDURE Create_Space_Assignment (
71: p_api_version IN NUMBER,
72: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
73: p_commit IN VARCHAR2 := FND_API.g_false,
74: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
75: p_module_type IN VARCHAR2 := 'JSP',
76: p_x_space_assign_rec IN OUT NOCOPY ahl_ltp_space_assign_pub.Space_Assignment_Rec,
69:
70: PROCEDURE Create_Space_Assignment (
71: p_api_version IN NUMBER,
72: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
73: p_commit IN VARCHAR2 := FND_API.g_false,
74: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
75: p_module_type IN VARCHAR2 := 'JSP',
76: p_x_space_assign_rec IN OUT NOCOPY ahl_ltp_space_assign_pub.Space_Assignment_Rec,
77: p_reschedule_flag IN VARCHAR2,
70: PROCEDURE Create_Space_Assignment (
71: p_api_version IN NUMBER,
72: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
73: p_commit IN VARCHAR2 := FND_API.g_false,
74: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
75: p_module_type IN VARCHAR2 := 'JSP',
76: p_x_space_assign_rec IN OUT NOCOPY ahl_ltp_space_assign_pub.Space_Assignment_Rec,
77: p_reschedule_flag IN VARCHAR2,
78: x_return_status OUT NOCOPY VARCHAR2,
88: -- Parameters :
89: --
90: -- Standard IN Parameters :
91: -- p_api_version IN NUMBER Required
92: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
93: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
94: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
95: -- Based on this flag, the API will set the default attributes.
96: -- p_module_type In VARCHAR2 Default NULL
89: --
90: -- Standard IN Parameters :
91: -- p_api_version IN NUMBER Required
92: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
93: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
94: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
95: -- Based on this flag, the API will set the default attributes.
96: -- p_module_type In VARCHAR2 Default NULL
97: -- This will be null.
90: -- Standard IN Parameters :
91: -- p_api_version IN NUMBER Required
92: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
93: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
94: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
95: -- Based on this flag, the API will set the default attributes.
96: -- p_module_type In VARCHAR2 Default NULL
97: -- This will be null.
98: -- Standard OUT Parameters :
105: -- List of space assignemnts for a visit
106: --
107: PROCEDURE Update_Space_Assignment (
108: p_api_version IN NUMBER,
109: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
110: p_commit IN VARCHAR2 := FND_API.g_false,
111: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
112: p_module_type IN VARCHAR2 := 'JSP',
113: p_space_assign_rec IN ahl_ltp_space_assign_pub.Space_Assignment_Rec,
106: --
107: PROCEDURE Update_Space_Assignment (
108: p_api_version IN NUMBER,
109: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
110: p_commit IN VARCHAR2 := FND_API.g_false,
111: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
112: p_module_type IN VARCHAR2 := 'JSP',
113: p_space_assign_rec IN ahl_ltp_space_assign_pub.Space_Assignment_Rec,
114: x_return_status OUT NOCOPY VARCHAR2,
107: PROCEDURE Update_Space_Assignment (
108: p_api_version IN NUMBER,
109: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
110: p_commit IN VARCHAR2 := FND_API.g_false,
111: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
112: p_module_type IN VARCHAR2 := 'JSP',
113: p_space_assign_rec IN ahl_ltp_space_assign_pub.Space_Assignment_Rec,
114: x_return_status OUT NOCOPY VARCHAR2,
115: x_msg_count OUT NOCOPY NUMBER,
124: -- Parameters :
125: --
126: -- Standard IN Parameters :
127: -- p_api_version IN NUMBER Required
128: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
129: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
130: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
131: -- Based on this flag, the API will set the default attributes.
132: -- p_module_type In VARCHAR2 Default NULL
125: --
126: -- Standard IN Parameters :
127: -- p_api_version IN NUMBER Required
128: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
129: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
130: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
131: -- Based on this flag, the API will set the default attributes.
132: -- p_module_type In VARCHAR2 Default NULL
133: -- This will be null.
126: -- Standard IN Parameters :
127: -- p_api_version IN NUMBER Required
128: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
129: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
130: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
131: -- Based on this flag, the API will set the default attributes.
132: -- p_module_type In VARCHAR2 Default NULL
133: -- This will be null.
134: -- Standard OUT Parameters :
141: -- List of space assignemnts for a visit
142: --
143: PROCEDURE Delete_Space_assignment (
144: p_api_version IN NUMBER,
145: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
146: p_commit IN VARCHAR2 := FND_API.g_false,
147: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
148: p_space_assign_rec IN ahl_ltp_space_assign_pub.Space_Assignment_Rec,
149: x_return_status OUT NOCOPY VARCHAR2,
142: --
143: PROCEDURE Delete_Space_assignment (
144: p_api_version IN NUMBER,
145: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
146: p_commit IN VARCHAR2 := FND_API.g_false,
147: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
148: p_space_assign_rec IN ahl_ltp_space_assign_pub.Space_Assignment_Rec,
149: x_return_status OUT NOCOPY VARCHAR2,
150: x_msg_count OUT NOCOPY NUMBER,
143: PROCEDURE Delete_Space_assignment (
144: p_api_version IN NUMBER,
145: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
146: p_commit IN VARCHAR2 := FND_API.g_false,
147: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
148: p_space_assign_rec IN ahl_ltp_space_assign_pub.Space_Assignment_Rec,
149: x_return_status OUT NOCOPY VARCHAR2,
150: x_msg_count OUT NOCOPY NUMBER,
151: x_msg_data OUT NOCOPY VARCHAR2
161: -- Parameters :
162: --
163: -- Standard IN Parameters :
164: -- p_api_version IN NUMBER Required
165: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
166: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
167: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
168: -- Based on this flag, the API will set the default attributes.
169: -- p_module_type In VARCHAR2 Default NULL
162: --
163: -- Standard IN Parameters :
164: -- p_api_version IN NUMBER Required
165: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
166: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
167: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
168: -- Based on this flag, the API will set the default attributes.
169: -- p_module_type In VARCHAR2 Default NULL
170: -- This will be null.
163: -- Standard IN Parameters :
164: -- p_api_version IN NUMBER Required
165: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
166: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
167: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
168: -- Based on this flag, the API will set the default attributes.
169: -- p_module_type In VARCHAR2 Default NULL
170: -- This will be null.
171: -- Standard OUT Parameters :
178: -- List of space assignemnts for a visit
179: --
180: PROCEDURE Schedule_Visit (
181: p_api_version IN NUMBER,
182: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
183: p_commit IN VARCHAR2 := FND_API.g_false,
184: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
185: p_module_type IN VARCHAR2 := 'JSP',
186: p_x_schedule_visit_rec IN OUT NOCOPY ahl_ltp_space_assign_pub.Schedule_Visit_Rec,
179: --
180: PROCEDURE Schedule_Visit (
181: p_api_version IN NUMBER,
182: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
183: p_commit IN VARCHAR2 := FND_API.g_false,
184: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
185: p_module_type IN VARCHAR2 := 'JSP',
186: p_x_schedule_visit_rec IN OUT NOCOPY ahl_ltp_space_assign_pub.Schedule_Visit_Rec,
187: x_return_status OUT NOCOPY VARCHAR2,
180: PROCEDURE Schedule_Visit (
181: p_api_version IN NUMBER,
182: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
183: p_commit IN VARCHAR2 := FND_API.g_false,
184: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
185: p_module_type IN VARCHAR2 := 'JSP',
186: p_x_schedule_visit_rec IN OUT NOCOPY ahl_ltp_space_assign_pub.Schedule_Visit_Rec,
187: x_return_status OUT NOCOPY VARCHAR2,
188: x_msg_count OUT NOCOPY NUMBER,
199: -- Parameters :
200: --
201: -- Standard IN Parameters :
202: -- p_api_version IN NUMBER Required
203: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
204: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
205: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
206: -- Based on this flag, the API will set the default attributes.
207: -- p_module_type In VARCHAR2 Default NULL
200: --
201: -- Standard IN Parameters :
202: -- p_api_version IN NUMBER Required
203: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
204: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
205: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
206: -- Based on this flag, the API will set the default attributes.
207: -- p_module_type In VARCHAR2 Default NULL
208: -- This will be null.
201: -- Standard IN Parameters :
202: -- p_api_version IN NUMBER Required
203: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
204: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
205: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
206: -- Based on this flag, the API will set the default attributes.
207: -- p_module_type In VARCHAR2 Default NULL
208: -- This will be null.
209: -- Standard OUT Parameters :
216: -- List of space assignemnts for a visit
217: --
218: PROCEDURE Unschedule_Visit (
219: p_api_version IN NUMBER,
220: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
221: p_commit IN VARCHAR2 := FND_API.g_false,
222: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
223: p_module_type IN VARCHAR2 := 'JSP',
224: p_x_schedule_visit_rec IN OUT NOCOPY ahl_ltp_space_assign_pub.Schedule_Visit_Rec,
217: --
218: PROCEDURE Unschedule_Visit (
219: p_api_version IN NUMBER,
220: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
221: p_commit IN VARCHAR2 := FND_API.g_false,
222: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
223: p_module_type IN VARCHAR2 := 'JSP',
224: p_x_schedule_visit_rec IN OUT NOCOPY ahl_ltp_space_assign_pub.Schedule_Visit_Rec,
225: x_return_status OUT NOCOPY VARCHAR2,
218: PROCEDURE Unschedule_Visit (
219: p_api_version IN NUMBER,
220: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
221: p_commit IN VARCHAR2 := FND_API.g_false,
222: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
223: p_module_type IN VARCHAR2 := 'JSP',
224: p_x_schedule_visit_rec IN OUT NOCOPY ahl_ltp_space_assign_pub.Schedule_Visit_Rec,
225: x_return_status OUT NOCOPY VARCHAR2,
226: x_msg_count OUT NOCOPY NUMBER,
235: -- Parameters :
236: --
237: -- Standard IN Parameters :
238: -- p_api_version IN NUMBER Required
239: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
240: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
241: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
242: -- p_module_type In VARCHAR2 Default NULL
243: -- Standard OUT Parameters :
236: --
237: -- Standard IN Parameters :
238: -- p_api_version IN NUMBER Required
239: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
240: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
241: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
242: -- p_module_type In VARCHAR2 Default NULL
243: -- Standard OUT Parameters :
244: -- x_return_status OUT VARCHAR2 Required
237: -- Standard IN Parameters :
238: -- p_api_version IN NUMBER Required
239: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
240: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
241: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
242: -- p_module_type In VARCHAR2 Default NULL
243: -- Standard OUT Parameters :
244: -- x_return_status OUT VARCHAR2 Required
245: -- x_msg_count OUT NUMBER Required
250: --
251: --
252: PROCEDURE VALIDATE_SPACES_WITH_VISIT (
253: p_api_version IN NUMBER,
254: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
255: p_commit IN VARCHAR2 := Fnd_Api.g_false,
256: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
257: p_module_type IN VARCHAR2 := NULL,
258: p_visit_id IN NUMBER,
251: --
252: PROCEDURE VALIDATE_SPACES_WITH_VISIT (
253: p_api_version IN NUMBER,
254: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
255: p_commit IN VARCHAR2 := Fnd_Api.g_false,
256: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
257: p_module_type IN VARCHAR2 := NULL,
258: p_visit_id IN NUMBER,
259: x_return_status OUT NOCOPY VARCHAR2,
252: PROCEDURE VALIDATE_SPACES_WITH_VISIT (
253: p_api_version IN NUMBER,
254: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
255: p_commit IN VARCHAR2 := Fnd_Api.g_false,
256: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
257: p_module_type IN VARCHAR2 := NULL,
258: p_visit_id IN NUMBER,
259: x_return_status OUT NOCOPY VARCHAR2,
260: x_msg_count OUT NOCOPY NUMBER,