48: -- Parameters :
49: --
50: -- Standard IN Parameters :
51: -- p_api_version IN NUMBER Required
52: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
53: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
54: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
55: -- Based on this flag, the API will set the default attributes.
56: -- p_module_type In VARCHAR2 Default NULL
49: --
50: -- Standard IN Parameters :
51: -- p_api_version IN NUMBER Required
52: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
53: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
54: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
55: -- Based on this flag, the API will set the default attributes.
56: -- p_module_type In VARCHAR2 Default NULL
57: -- This will be null.
50: -- Standard IN Parameters :
51: -- p_api_version IN NUMBER Required
52: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
53: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
54: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
55: -- Based on this flag, the API will set the default attributes.
56: -- p_module_type In VARCHAR2 Default NULL
57: -- This will be null.
58: -- Standard OUT Parameters :
66: --
67:
68: PROCEDURE Create_Space_Assignment (
69: p_api_version IN NUMBER,
70: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
71: p_commit IN VARCHAR2 := FND_API.g_false,
72: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
73: p_module_type IN VARCHAR2 := 'JSP',
74: p_x_space_assign_rec IN OUT NOCOPY ahl_ltp_space_assign_pub.Space_Assignment_Rec,
67:
68: PROCEDURE Create_Space_Assignment (
69: p_api_version IN NUMBER,
70: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
71: p_commit IN VARCHAR2 := FND_API.g_false,
72: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
73: p_module_type IN VARCHAR2 := 'JSP',
74: p_x_space_assign_rec IN OUT NOCOPY ahl_ltp_space_assign_pub.Space_Assignment_Rec,
75: p_reschedule_flag IN VARCHAR2,
68: PROCEDURE Create_Space_Assignment (
69: p_api_version IN NUMBER,
70: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
71: p_commit IN VARCHAR2 := FND_API.g_false,
72: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
73: p_module_type IN VARCHAR2 := 'JSP',
74: p_x_space_assign_rec IN OUT NOCOPY ahl_ltp_space_assign_pub.Space_Assignment_Rec,
75: p_reschedule_flag IN VARCHAR2,
76: x_return_status OUT NOCOPY VARCHAR2,
86: -- Parameters :
87: --
88: -- Standard IN Parameters :
89: -- p_api_version IN NUMBER Required
90: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
91: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
92: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
93: -- Based on this flag, the API will set the default attributes.
94: -- p_module_type In VARCHAR2 Default NULL
87: --
88: -- Standard IN Parameters :
89: -- p_api_version IN NUMBER Required
90: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
91: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
92: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
93: -- Based on this flag, the API will set the default attributes.
94: -- p_module_type In VARCHAR2 Default NULL
95: -- This will be null.
88: -- Standard IN Parameters :
89: -- p_api_version IN NUMBER Required
90: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
91: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
92: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
93: -- Based on this flag, the API will set the default attributes.
94: -- p_module_type In VARCHAR2 Default NULL
95: -- This will be null.
96: -- Standard OUT Parameters :
103: -- List of space assignemnts for a visit
104: --
105: PROCEDURE Update_Space_Assignment (
106: p_api_version IN NUMBER,
107: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
108: p_commit IN VARCHAR2 := FND_API.g_false,
109: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
110: p_module_type IN VARCHAR2 := 'JSP',
111: p_space_assign_rec IN ahl_ltp_space_assign_pub.Space_Assignment_Rec,
104: --
105: PROCEDURE Update_Space_Assignment (
106: p_api_version IN NUMBER,
107: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
108: p_commit IN VARCHAR2 := FND_API.g_false,
109: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
110: p_module_type IN VARCHAR2 := 'JSP',
111: p_space_assign_rec IN ahl_ltp_space_assign_pub.Space_Assignment_Rec,
112: x_return_status OUT NOCOPY VARCHAR2,
105: PROCEDURE Update_Space_Assignment (
106: p_api_version IN NUMBER,
107: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
108: p_commit IN VARCHAR2 := FND_API.g_false,
109: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
110: p_module_type IN VARCHAR2 := 'JSP',
111: p_space_assign_rec IN ahl_ltp_space_assign_pub.Space_Assignment_Rec,
112: x_return_status OUT NOCOPY VARCHAR2,
113: x_msg_count OUT NOCOPY NUMBER,
122: -- Parameters :
123: --
124: -- Standard IN Parameters :
125: -- p_api_version IN NUMBER Required
126: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
127: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
128: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
129: -- Based on this flag, the API will set the default attributes.
130: -- p_module_type In VARCHAR2 Default NULL
123: --
124: -- Standard IN Parameters :
125: -- p_api_version IN NUMBER Required
126: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
127: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
128: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
129: -- Based on this flag, the API will set the default attributes.
130: -- p_module_type In VARCHAR2 Default NULL
131: -- This will be null.
124: -- Standard IN Parameters :
125: -- p_api_version IN NUMBER Required
126: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
127: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
128: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
129: -- Based on this flag, the API will set the default attributes.
130: -- p_module_type In VARCHAR2 Default NULL
131: -- This will be null.
132: -- Standard OUT Parameters :
139: -- List of space assignemnts for a visit
140: --
141: PROCEDURE Delete_Space_assignment (
142: p_api_version IN NUMBER,
143: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
144: p_commit IN VARCHAR2 := FND_API.g_false,
145: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
146: p_space_assign_rec IN ahl_ltp_space_assign_pub.Space_Assignment_Rec,
147: x_return_status OUT NOCOPY VARCHAR2,
140: --
141: PROCEDURE Delete_Space_assignment (
142: p_api_version IN NUMBER,
143: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
144: p_commit IN VARCHAR2 := FND_API.g_false,
145: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
146: p_space_assign_rec IN ahl_ltp_space_assign_pub.Space_Assignment_Rec,
147: x_return_status OUT NOCOPY VARCHAR2,
148: x_msg_count OUT NOCOPY NUMBER,
141: PROCEDURE Delete_Space_assignment (
142: p_api_version IN NUMBER,
143: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
144: p_commit IN VARCHAR2 := FND_API.g_false,
145: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
146: p_space_assign_rec IN ahl_ltp_space_assign_pub.Space_Assignment_Rec,
147: x_return_status OUT NOCOPY VARCHAR2,
148: x_msg_count OUT NOCOPY NUMBER,
149: x_msg_data OUT NOCOPY VARCHAR2
159: -- Parameters :
160: --
161: -- Standard IN Parameters :
162: -- p_api_version IN NUMBER Required
163: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
164: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
165: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
166: -- Based on this flag, the API will set the default attributes.
167: -- p_module_type In VARCHAR2 Default NULL
160: --
161: -- Standard IN Parameters :
162: -- p_api_version IN NUMBER Required
163: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
164: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
165: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
166: -- Based on this flag, the API will set the default attributes.
167: -- p_module_type In VARCHAR2 Default NULL
168: -- This will be null.
161: -- Standard IN Parameters :
162: -- p_api_version IN NUMBER Required
163: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
164: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
165: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
166: -- Based on this flag, the API will set the default attributes.
167: -- p_module_type In VARCHAR2 Default NULL
168: -- This will be null.
169: -- Standard OUT Parameters :
176: -- List of space assignemnts for a visit
177: --
178: PROCEDURE Schedule_Visit (
179: p_api_version IN NUMBER,
180: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
181: p_commit IN VARCHAR2 := FND_API.g_false,
182: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
183: p_module_type IN VARCHAR2 := 'JSP',
184: p_x_schedule_visit_rec IN OUT NOCOPY ahl_ltp_space_assign_pub.Schedule_Visit_Rec,
177: --
178: PROCEDURE Schedule_Visit (
179: p_api_version IN NUMBER,
180: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
181: p_commit IN VARCHAR2 := FND_API.g_false,
182: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
183: p_module_type IN VARCHAR2 := 'JSP',
184: p_x_schedule_visit_rec IN OUT NOCOPY ahl_ltp_space_assign_pub.Schedule_Visit_Rec,
185: x_return_status OUT NOCOPY VARCHAR2,
178: PROCEDURE Schedule_Visit (
179: p_api_version IN NUMBER,
180: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
181: p_commit IN VARCHAR2 := FND_API.g_false,
182: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
183: p_module_type IN VARCHAR2 := 'JSP',
184: p_x_schedule_visit_rec IN OUT NOCOPY ahl_ltp_space_assign_pub.Schedule_Visit_Rec,
185: x_return_status OUT NOCOPY VARCHAR2,
186: x_msg_count OUT NOCOPY NUMBER,
197: -- Parameters :
198: --
199: -- Standard IN Parameters :
200: -- p_api_version IN NUMBER Required
201: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
202: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
203: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
204: -- Based on this flag, the API will set the default attributes.
205: -- p_module_type In VARCHAR2 Default NULL
198: --
199: -- Standard IN Parameters :
200: -- p_api_version IN NUMBER Required
201: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
202: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
203: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
204: -- Based on this flag, the API will set the default attributes.
205: -- p_module_type In VARCHAR2 Default NULL
206: -- This will be null.
199: -- Standard IN Parameters :
200: -- p_api_version IN NUMBER Required
201: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
202: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
203: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
204: -- Based on this flag, the API will set the default attributes.
205: -- p_module_type In VARCHAR2 Default NULL
206: -- This will be null.
207: -- Standard OUT Parameters :
214: -- List of space assignemnts for a visit
215: --
216: PROCEDURE Unschedule_Visit (
217: p_api_version IN NUMBER,
218: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
219: p_commit IN VARCHAR2 := FND_API.g_false,
220: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
221: p_module_type IN VARCHAR2 := 'JSP',
222: p_x_schedule_visit_rec IN OUT NOCOPY ahl_ltp_space_assign_pub.Schedule_Visit_Rec,
215: --
216: PROCEDURE Unschedule_Visit (
217: p_api_version IN NUMBER,
218: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
219: p_commit IN VARCHAR2 := FND_API.g_false,
220: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
221: p_module_type IN VARCHAR2 := 'JSP',
222: p_x_schedule_visit_rec IN OUT NOCOPY ahl_ltp_space_assign_pub.Schedule_Visit_Rec,
223: x_return_status OUT NOCOPY VARCHAR2,
216: PROCEDURE Unschedule_Visit (
217: p_api_version IN NUMBER,
218: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
219: p_commit IN VARCHAR2 := FND_API.g_false,
220: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
221: p_module_type IN VARCHAR2 := 'JSP',
222: p_x_schedule_visit_rec IN OUT NOCOPY ahl_ltp_space_assign_pub.Schedule_Visit_Rec,
223: x_return_status OUT NOCOPY VARCHAR2,
224: x_msg_count OUT NOCOPY NUMBER,