DBA Data[Home] [Help]

APPS.IEX_WEBSWITCH_PVT dependencies on IEX_WEBSWITCH_PKG

Line 32: l_cgi_switch_rec IEX_WEBSWITCH_PKG.cgi_switch_rec_type;

28: l_msg_count NUMBER;
29: l_msg_data VARCHAR2(32767);
30:
31: -- added these for user hooks
32: l_cgi_switch_rec IEX_WEBSWITCH_PKG.cgi_switch_rec_type;
33: l_switch_data_rec IEX_WEBSWITCH_PKG.switch_data_rec_type;
34: l_cgi_switch_id NUMBER;
35: l_switch_data_id NUMBER;
36:

Line 33: l_switch_data_rec IEX_WEBSWITCH_PKG.switch_data_rec_type;

29: l_msg_data VARCHAR2(32767);
30:
31: -- added these for user hooks
32: l_cgi_switch_rec IEX_WEBSWITCH_PKG.cgi_switch_rec_type;
33: l_switch_data_rec IEX_WEBSWITCH_PKG.switch_data_rec_type;
34: l_cgi_switch_id NUMBER;
35: l_switch_data_id NUMBER;
36:
37: CURSOR c_cgi_switch IS SELECT CGI_SWITCH_ID

Line 159: IEX_WEBSWITCH_PKG.Create_WebSwitch(

155: l_cgi_switch_rec.cgi_switch_id := l_cgi_switch_id;
156: l_switch_data_rec.switch_data_id := l_switch_data_id;
157: l_switch_data_rec.cgi_switch_id := l_cgi_switch_id;
158:
159: IEX_WEBSWITCH_PKG.Create_WebSwitch(
160: p_api_version => p_api_version,
161: p_init_msg_list => p_init_msg_list,
162: p_commit => p_commit,
163: p_validation_level => p_validation_level,

Line 237: l_cgi_switch_rec IEX_WEBSWITCH_PKG.cgi_switch_rec_type;

233: l_return_status VARCHAR2(1);
234: l_msg_count NUMBER;
235: l_msg_data VARCHAR2(32767);
236: -- added these for user hooks
237: l_cgi_switch_rec IEX_WEBSWITCH_PKG.cgi_switch_rec_type;
238: l_switch_data_rec IEX_WEBSWITCH_PKG.switch_data_rec_type;
239:
240: begin
241: -- Standard begin of API savepoint

Line 238: l_switch_data_rec IEX_WEBSWITCH_PKG.switch_data_rec_type;

234: l_msg_count NUMBER;
235: l_msg_data VARCHAR2(32767);
236: -- added these for user hooks
237: l_cgi_switch_rec IEX_WEBSWITCH_PKG.cgi_switch_rec_type;
238: l_switch_data_rec IEX_WEBSWITCH_PKG.switch_data_rec_type;
239:
240: begin
241: -- Standard begin of API savepoint
242: SAVEPOINT Update_WebSwitch_PVT;

Line 333: IEX_WEBSWITCH_PKG.Update_WebSwitch(

329: l_switch_data_rec.attribute14 := p_switch_data_rec.attribute14;
330: l_switch_data_rec.attribute15 := p_switch_data_rec.attribute15;
331:
332:
333: IEX_WEBSWITCH_PKG.Update_WebSwitch(
334: p_api_version => p_api_version,
335: p_init_msg_list => p_init_msg_list,
336: p_commit => p_commit,
337: p_validation_level => p_validation_level,