96: -- Parameters :
97: --
98: -- Standard IN Parameters :
99: -- p_api_version IN NUMBER Required
100: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
101: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
102: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
103: -- Based on this flag, the API will set the default attributes.
104: -- p_module_type In VARCHAR2 Default NULL
97: --
98: -- Standard IN Parameters :
99: -- p_api_version IN NUMBER Required
100: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
101: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
102: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
103: -- Based on this flag, the API will set the default attributes.
104: -- p_module_type In VARCHAR2 Default NULL
105: -- This will be null.
98: -- Standard IN Parameters :
99: -- p_api_version IN NUMBER Required
100: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
101: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
102: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
103: -- Based on this flag, the API will set the default attributes.
104: -- p_module_type In VARCHAR2 Default NULL
105: -- This will be null.
106: -- Standard OUT Parameters :
115: --
116:
117: PROCEDURE Assign_Sch_Visit_Spaces (
118: p_api_version IN NUMBER,
119: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
120: p_commit IN VARCHAR2 := Fnd_Api.g_false,
121: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
122: p_module_type IN VARCHAR2 := 'JSP',
123: p_x_space_assignment_tbl IN OUT NOCOPY Space_Assignment_Tbl,
116:
117: PROCEDURE Assign_Sch_Visit_Spaces (
118: p_api_version IN NUMBER,
119: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
120: p_commit IN VARCHAR2 := Fnd_Api.g_false,
121: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
122: p_module_type IN VARCHAR2 := 'JSP',
123: p_x_space_assignment_tbl IN OUT NOCOPY Space_Assignment_Tbl,
124: p_x_schedule_visit_rec IN OUT NOCOPY Schedule_Visit_Rec,
117: PROCEDURE Assign_Sch_Visit_Spaces (
118: p_api_version IN NUMBER,
119: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
120: p_commit IN VARCHAR2 := Fnd_Api.g_false,
121: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
122: p_module_type IN VARCHAR2 := 'JSP',
123: p_x_space_assignment_tbl IN OUT NOCOPY Space_Assignment_Tbl,
124: p_x_schedule_visit_rec IN OUT NOCOPY Schedule_Visit_Rec,
125: x_return_status OUT NOCOPY VARCHAR2,
136: -- Parameters :
137: --
138: -- Standard IN Parameters :
139: -- p_api_version IN NUMBER Required
140: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
141: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
142: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
143: -- Based on this flag, the API will set the default attributes.
144: -- p_module_type In VARCHAR2 Default NULL
137: --
138: -- Standard IN Parameters :
139: -- p_api_version IN NUMBER Required
140: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
141: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
142: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
143: -- Based on this flag, the API will set the default attributes.
144: -- p_module_type In VARCHAR2 Default NULL
145: -- This will be null.
138: -- Standard IN Parameters :
139: -- p_api_version IN NUMBER Required
140: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
141: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
142: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
143: -- Based on this flag, the API will set the default attributes.
144: -- p_module_type In VARCHAR2 Default NULL
145: -- This will be null.
146: -- Standard OUT Parameters :
154: --
155:
156: PROCEDURE Schedule_Visit (
157: p_api_version IN NUMBER,
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 := 'JSP',
162: p_x_schedule_visit_rec IN OUT NOCOPY Schedule_Visit_Rec,
155:
156: PROCEDURE Schedule_Visit (
157: p_api_version IN NUMBER,
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 := 'JSP',
162: p_x_schedule_visit_rec IN OUT NOCOPY Schedule_Visit_Rec,
163: x_return_status OUT NOCOPY VARCHAR2,
156: PROCEDURE Schedule_Visit (
157: p_api_version IN NUMBER,
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 := 'JSP',
162: p_x_schedule_visit_rec IN OUT NOCOPY Schedule_Visit_Rec,
163: x_return_status OUT NOCOPY VARCHAR2,
164: x_msg_count OUT NOCOPY NUMBER,
174: -- Parameters :
175: --
176: -- Standard IN Parameters :
177: -- p_api_version IN NUMBER Required
178: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
179: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
180: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
181: -- Based on this flag, the API will set the default attributes.
182: -- p_module_type In VARCHAR2 Default NULL
175: --
176: -- Standard IN Parameters :
177: -- p_api_version IN NUMBER Required
178: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
179: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
180: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
181: -- Based on this flag, the API will set the default attributes.
182: -- p_module_type In VARCHAR2 Default NULL
183: -- This will be null.
176: -- Standard IN Parameters :
177: -- p_api_version IN NUMBER Required
178: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
179: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
180: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
181: -- Based on this flag, the API will set the default attributes.
182: -- p_module_type In VARCHAR2 Default NULL
183: -- This will be null.
184: -- Standard OUT Parameters :
191: -- List of visit attributes
192: --
193: PROCEDURE Unschedule_Visit (
194: p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
196: p_commit IN VARCHAR2 := Fnd_Api.g_false,
197: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
198: p_module_type IN VARCHAR2 := 'JSP',
199: p_x_schedule_visit_rec IN OUT NOCOPY Schedule_Visit_Rec,
192: --
193: PROCEDURE Unschedule_Visit (
194: p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
196: p_commit IN VARCHAR2 := Fnd_Api.g_false,
197: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
198: p_module_type IN VARCHAR2 := 'JSP',
199: p_x_schedule_visit_rec IN OUT NOCOPY Schedule_Visit_Rec,
200: x_return_status OUT NOCOPY VARCHAR2,
193: PROCEDURE Unschedule_Visit (
194: p_api_version IN NUMBER,
195: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
196: p_commit IN VARCHAR2 := Fnd_Api.g_false,
197: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
198: p_module_type IN VARCHAR2 := 'JSP',
199: p_x_schedule_visit_rec IN OUT NOCOPY Schedule_Visit_Rec,
200: x_return_status OUT NOCOPY VARCHAR2,
201: x_msg_count OUT NOCOPY NUMBER,