94: -- Parameters :
95: --
96: -- Standard IN Parameters :
97: -- p_api_version IN NUMBER Required
98: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
99: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
100: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
101: -- Based on this flag, the API will set the default attributes.
102: -- p_module_type In VARCHAR2 Default NULL
95: --
96: -- Standard IN Parameters :
97: -- p_api_version IN NUMBER Required
98: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
99: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
100: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
101: -- Based on this flag, the API will set the default attributes.
102: -- p_module_type In VARCHAR2 Default NULL
103: -- This will be null.
96: -- Standard IN Parameters :
97: -- p_api_version IN NUMBER Required
98: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
99: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
100: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
101: -- Based on this flag, the API will set the default attributes.
102: -- p_module_type In VARCHAR2 Default NULL
103: -- This will be null.
104: -- Standard OUT Parameters :
113: --
114:
115: PROCEDURE Assign_Sch_Visit_Spaces (
116: p_api_version IN NUMBER,
117: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
118: p_commit IN VARCHAR2 := Fnd_Api.g_false,
119: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
120: p_module_type IN VARCHAR2 := 'JSP',
121: p_x_space_assignment_tbl IN OUT NOCOPY Space_Assignment_Tbl,
114:
115: PROCEDURE Assign_Sch_Visit_Spaces (
116: p_api_version IN NUMBER,
117: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
118: p_commit IN VARCHAR2 := Fnd_Api.g_false,
119: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
120: p_module_type IN VARCHAR2 := 'JSP',
121: p_x_space_assignment_tbl IN OUT NOCOPY Space_Assignment_Tbl,
122: p_x_schedule_visit_rec IN OUT NOCOPY Schedule_Visit_Rec,
115: PROCEDURE Assign_Sch_Visit_Spaces (
116: p_api_version IN NUMBER,
117: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
118: p_commit IN VARCHAR2 := Fnd_Api.g_false,
119: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
120: p_module_type IN VARCHAR2 := 'JSP',
121: p_x_space_assignment_tbl IN OUT NOCOPY Space_Assignment_Tbl,
122: p_x_schedule_visit_rec IN OUT NOCOPY Schedule_Visit_Rec,
123: x_return_status OUT NOCOPY VARCHAR2,
134: -- Parameters :
135: --
136: -- Standard IN Parameters :
137: -- p_api_version IN NUMBER Required
138: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
139: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
140: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
141: -- Based on this flag, the API will set the default attributes.
142: -- p_module_type In VARCHAR2 Default NULL
135: --
136: -- Standard IN Parameters :
137: -- p_api_version IN NUMBER Required
138: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
139: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
140: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
141: -- Based on this flag, the API will set the default attributes.
142: -- p_module_type In VARCHAR2 Default NULL
143: -- This will be null.
136: -- Standard IN Parameters :
137: -- p_api_version IN NUMBER Required
138: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
139: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
140: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
141: -- Based on this flag, the API will set the default attributes.
142: -- p_module_type In VARCHAR2 Default NULL
143: -- This will be null.
144: -- Standard OUT Parameters :
152: --
153:
154: PROCEDURE Schedule_Visit (
155: p_api_version IN NUMBER,
156: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
157: p_commit IN VARCHAR2 := Fnd_Api.g_false,
158: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
159: p_module_type IN VARCHAR2 := 'JSP',
160: p_x_schedule_visit_rec IN OUT NOCOPY Schedule_Visit_Rec,
153:
154: PROCEDURE Schedule_Visit (
155: p_api_version IN NUMBER,
156: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
157: p_commit IN VARCHAR2 := Fnd_Api.g_false,
158: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
159: p_module_type IN VARCHAR2 := 'JSP',
160: p_x_schedule_visit_rec IN OUT NOCOPY Schedule_Visit_Rec,
161: x_return_status OUT NOCOPY VARCHAR2,
154: PROCEDURE Schedule_Visit (
155: p_api_version IN NUMBER,
156: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
157: p_commit IN VARCHAR2 := Fnd_Api.g_false,
158: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
159: p_module_type IN VARCHAR2 := 'JSP',
160: p_x_schedule_visit_rec IN OUT NOCOPY Schedule_Visit_Rec,
161: x_return_status OUT NOCOPY VARCHAR2,
162: x_msg_count OUT NOCOPY NUMBER,
172: -- Parameters :
173: --
174: -- Standard IN Parameters :
175: -- p_api_version IN NUMBER Required
176: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
177: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
178: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
179: -- Based on this flag, the API will set the default attributes.
180: -- p_module_type In VARCHAR2 Default NULL
173: --
174: -- Standard IN Parameters :
175: -- p_api_version IN NUMBER Required
176: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
177: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
178: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
179: -- Based on this flag, the API will set the default attributes.
180: -- p_module_type In VARCHAR2 Default NULL
181: -- This will be null.
174: -- Standard IN Parameters :
175: -- p_api_version IN NUMBER Required
176: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
177: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
178: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
179: -- Based on this flag, the API will set the default attributes.
180: -- p_module_type In VARCHAR2 Default NULL
181: -- This will be null.
182: -- Standard OUT Parameters :
189: -- List of visit attributes
190: --
191: PROCEDURE Unschedule_Visit (
192: p_api_version IN NUMBER,
193: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
194: p_commit IN VARCHAR2 := Fnd_Api.g_false,
195: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
196: p_module_type IN VARCHAR2 := 'JSP',
197: p_x_schedule_visit_rec IN OUT NOCOPY Schedule_Visit_Rec,
190: --
191: PROCEDURE Unschedule_Visit (
192: p_api_version IN NUMBER,
193: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
194: p_commit IN VARCHAR2 := Fnd_Api.g_false,
195: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
196: p_module_type IN VARCHAR2 := 'JSP',
197: p_x_schedule_visit_rec IN OUT NOCOPY Schedule_Visit_Rec,
198: x_return_status OUT NOCOPY VARCHAR2,
191: PROCEDURE Unschedule_Visit (
192: p_api_version IN NUMBER,
193: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
194: p_commit IN VARCHAR2 := Fnd_Api.g_false,
195: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
196: p_module_type IN VARCHAR2 := 'JSP',
197: p_x_schedule_visit_rec IN OUT NOCOPY Schedule_Visit_Rec,
198: x_return_status OUT NOCOPY VARCHAR2,
199: x_msg_count OUT NOCOPY NUMBER,