APPS.AHL_VWP_VISITS_STAGES_PVT dependencies on FND_API

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

97: -- Parameters :
98: --
99: -- Standard IN Parameters :
100: -- p_api_version IN NUMBER Required
101: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
102: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
103: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
104: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
105: -- p_module_type IN VARCHAR2 Default NULL.

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

98: --
99: -- Standard IN Parameters :
100: -- p_api_version IN NUMBER Required
101: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
102: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
103: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
104: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
105: -- p_module_type IN VARCHAR2 Default NULL.
106: --

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

99: -- Standard IN Parameters :
100: -- p_api_version IN NUMBER Required
101: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
102: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
103: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
104: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
105: -- p_module_type IN VARCHAR2 Default NULL.
106: --
107: -- Standard OUT Parameters :

Line 104: -- p_default IN VARCHAR2 Default FND_API.G_TRUE

100: -- p_api_version IN NUMBER Required
101: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
102: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
103: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
104: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
105: -- p_module_type IN VARCHAR2 Default NULL.
106: --
107: -- Standard OUT Parameters :
108: -- x_return_status OUT VARCHAR2 Required

Line 122: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

118: -- Initial Version 1.0
119: --------------------------------------------------------------------
120: PROCEDURE Update_Stages (
121: p_api_version IN NUMBER :=1.0,
122: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
123: p_commit IN VARCHAR2 := FND_API.g_false,
124: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
125: p_module_type IN VARCHAR2 := 'JSP',
126: p_visit_id IN NUMBER,

Line 123: p_commit IN VARCHAR2 := FND_API.g_false,

119: --------------------------------------------------------------------
120: PROCEDURE Update_Stages (
121: p_api_version IN NUMBER :=1.0,
122: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
123: p_commit IN VARCHAR2 := FND_API.g_false,
124: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
125: p_module_type IN VARCHAR2 := 'JSP',
126: p_visit_id IN NUMBER,
127: p_x_stages_tbl IN OUT NOCOPY Visit_Stages_Tbl_Type,

Line 124: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

120: PROCEDURE Update_Stages (
121: p_api_version IN NUMBER :=1.0,
122: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
123: p_commit IN VARCHAR2 := FND_API.g_false,
124: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
125: p_module_type IN VARCHAR2 := 'JSP',
126: p_visit_id IN NUMBER,
127: p_x_stages_tbl IN OUT NOCOPY Visit_Stages_Tbl_Type,
128: x_return_status OUT NOCOPY VARCHAR2,

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

137: -- Parameters :
138: --
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_default IN VARCHAR2 Default FND_API.G_TRUE
145: -- p_module_type IN VARCHAR2 Default NULL.

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

138: --
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_default IN VARCHAR2 Default FND_API.G_TRUE
145: -- p_module_type IN VARCHAR2 Default NULL.
146: --

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_default IN VARCHAR2 Default FND_API.G_TRUE
145: -- p_module_type IN VARCHAR2 Default NULL.
146: --
147: -- Standard OUT Parameters :

Line 144: -- p_default IN VARCHAR2 Default FND_API.G_TRUE

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_default IN VARCHAR2 Default FND_API.G_TRUE
145: -- p_module_type IN VARCHAR2 Default NULL.
146: --
147: -- Standard OUT Parameters :
148: -- x_return_status OUT VARCHAR2 Required

Line 163: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,

159: -- Initial Version 1.0
160: -------------------------------------------------------------------
161: PROCEDURE Get_Stages_Details (
162: p_api_version IN NUMBER,
163: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
164: p_commit IN VARCHAR2 := Fnd_Api.g_false,
165: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
166: p_module_type IN VARCHAR2 := 'JSP',
167: p_visit_id IN NUMBER,

Line 164: p_commit IN VARCHAR2 := Fnd_Api.g_false,

160: -------------------------------------------------------------------
161: PROCEDURE Get_Stages_Details (
162: p_api_version IN NUMBER,
163: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
164: p_commit IN VARCHAR2 := Fnd_Api.g_false,
165: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
166: p_module_type IN VARCHAR2 := 'JSP',
167: p_visit_id IN NUMBER,
168: p_start_row IN NUMBER,

Line 165: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,

161: PROCEDURE Get_Stages_Details (
162: p_api_version IN NUMBER,
163: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
164: p_commit IN VARCHAR2 := Fnd_Api.g_false,
165: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
166: p_module_type IN VARCHAR2 := 'JSP',
167: p_visit_id IN NUMBER,
168: p_start_row IN NUMBER,
169: p_rows_per_page IN NUMBER,

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

183: -- Parameters :
184: --
185: -- Standard IN Parameters :
186: -- p_api_version IN NUMBER Required
187: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
188: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
189: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
190: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
191: -- p_module_type IN VARCHAR2 Default NULL.

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

184: --
185: -- Standard IN Parameters :
186: -- p_api_version IN NUMBER Required
187: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
188: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
189: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
190: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
191: -- p_module_type IN VARCHAR2 Default NULL.
192: --

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

185: -- Standard IN Parameters :
186: -- p_api_version IN NUMBER Required
187: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
188: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
189: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
190: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
191: -- p_module_type IN VARCHAR2 Default NULL.
192: --
193: -- Standard OUT Parameters :

Line 190: -- p_default IN VARCHAR2 Default FND_API.G_TRUE

186: -- p_api_version IN NUMBER Required
187: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
188: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
189: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
190: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
191: -- p_module_type IN VARCHAR2 Default NULL.
192: --
193: -- Standard OUT Parameters :
194: -- x_return_status OUT VARCHAR2 Required

Line 207: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

203: -- Initial Version 1.0
204: --------------------------------------------------------------------
205: PROCEDURE Create_Stages (
206: p_api_version IN NUMBER :=1.0,
207: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
208: p_commit IN VARCHAR2 := FND_API.g_false,
209: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
210: p_module_type IN VARCHAR2 := 'JSP',
211: p_visit_id IN NUMBER,

Line 208: p_commit IN VARCHAR2 := FND_API.g_false,

204: --------------------------------------------------------------------
205: PROCEDURE Create_Stages (
206: p_api_version IN NUMBER :=1.0,
207: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
208: p_commit IN VARCHAR2 := FND_API.g_false,
209: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
210: p_module_type IN VARCHAR2 := 'JSP',
211: p_visit_id IN NUMBER,
212: x_return_status OUT NOCOPY VARCHAR2,

Line 209: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

205: PROCEDURE Create_Stages (
206: p_api_version IN NUMBER :=1.0,
207: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
208: p_commit IN VARCHAR2 := FND_API.g_false,
209: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
210: p_module_type IN VARCHAR2 := 'JSP',
211: p_visit_id IN NUMBER,
212: x_return_status OUT NOCOPY VARCHAR2,
213: x_msg_count OUT NOCOPY NUMBER,

Line 228: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,

224: -- will be called from delete visit and requires only visit_id
225: --------------------------------------------------------------------
226: PROCEDURE Delete_Stages (
227: p_api_version IN NUMBER,
228: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
229: p_commit IN VARCHAR2 := Fnd_Api.g_false,
230: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
231: p_module_type IN VARCHAR2 := 'JSP',
232:

Line 229: p_commit IN VARCHAR2 := Fnd_Api.g_false,

225: --------------------------------------------------------------------
226: PROCEDURE Delete_Stages (
227: p_api_version IN NUMBER,
228: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
229: p_commit IN VARCHAR2 := Fnd_Api.g_false,
230: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
231: p_module_type IN VARCHAR2 := 'JSP',
232:
233: p_visit_id IN NUMBER,

Line 230: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,

226: PROCEDURE Delete_Stages (
227: p_api_version IN NUMBER,
228: p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
229: p_commit IN VARCHAR2 := Fnd_Api.g_false,
230: p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
231: p_module_type IN VARCHAR2 := 'JSP',
232:
233: p_visit_id IN NUMBER,
234:

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

244: -- Parameters :
245: --
246: -- Standard IN Parameters :
247: -- p_api_version IN NUMBER Required
248: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
249: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
250: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
251: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
252: -- p_module_type IN VARCHAR2 Default NULL.

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

245: --
246: -- Standard IN Parameters :
247: -- p_api_version IN NUMBER Required
248: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
249: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
250: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
251: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
252: -- p_module_type IN VARCHAR2 Default NULL.
253: --

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

246: -- Standard IN Parameters :
247: -- p_api_version IN NUMBER Required
248: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
249: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
250: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
251: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
252: -- p_module_type IN VARCHAR2 Default NULL.
253: --
254: -- Standard OUT Parameters :

Line 251: -- p_default IN VARCHAR2 Default FND_API.G_TRUE

247: -- p_api_version IN NUMBER Required
248: -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
249: -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
250: -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
251: -- p_default IN VARCHAR2 Default FND_API.G_TRUE
252: -- p_module_type IN VARCHAR2 Default NULL.
253: --
254: -- Standard OUT Parameters :
255: -- x_return_status OUT VARCHAR2 Required

Line 268: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,

264: -- Initial Version 1.0
265: --------------------------------------------------------------------
266: PROCEDURE VALIDATE_STAGE_UPDATES(
267: p_api_version IN NUMBER,
268: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
269: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
270: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
271: p_default IN VARCHAR2 := Fnd_Api.G_TRUE,
272: p_module_type IN VARCHAR2 := NULL,

Line 269: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,

265: --------------------------------------------------------------------
266: PROCEDURE VALIDATE_STAGE_UPDATES(
267: p_api_version IN NUMBER,
268: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
269: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
270: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
271: p_default IN VARCHAR2 := Fnd_Api.G_TRUE,
272: p_module_type IN VARCHAR2 := NULL,
273:

Line 270: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,

266: PROCEDURE VALIDATE_STAGE_UPDATES(
267: p_api_version IN NUMBER,
268: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
269: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
270: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
271: p_default IN VARCHAR2 := Fnd_Api.G_TRUE,
272: p_module_type IN VARCHAR2 := NULL,
273:
274: p_visit_id IN NUMBER,

Line 271: p_default IN VARCHAR2 := Fnd_Api.G_TRUE,

267: p_api_version IN NUMBER,
268: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_FALSE,
269: p_commit IN VARCHAR2 := Fnd_Api.G_FALSE,
270: p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
271: p_default IN VARCHAR2 := Fnd_Api.G_TRUE,
272: p_module_type IN VARCHAR2 := NULL,
273:
274: p_visit_id IN NUMBER,
275: p_visit_task_id IN NUMBER,