APPS.AST_WEBSWITCH_PVT dependencies on AST_SWITCH_DATA

Line 35: CURSOR c2 IS SELECT 'X' FROM ast_switch_data

31:
32: CURSOR c1 IS SELECT 'X' FROM ast_cgi_switches
33: WHERE cgi_switch_id = p_cgi_switch_rec.cgi_switch_id;
34:
35: CURSOR c2 IS SELECT 'X' FROM ast_switch_data
36: WHERE switch_data_id = p_switch_data_rec.switch_data_id;
37:
38: l_dummy char(1);
39:

Line 181: INSERT INTO ast_switch_data(

177:
178: OPEN c2;
179: FETCH c2 INTO l_dummy;
180: IF c2%notfound THEN
181: INSERT INTO ast_switch_data(
182: switch_data_id,
183: cgi_switch_id,
184: enabled_flag,
185: object_version_number,

Line 476: UPDATE ast_switch_data

472: attribute15 = p_cgi_switch_rec.attribute15
473: WHERE query_string_id = p_cgi_switch_rec.query_string_id
474: AND cgi_switch_id = p_cgi_switch_rec.cgi_switch_id;
475:
476: UPDATE ast_switch_data
477: SET
478: first_name_yn = p_switch_data_rec.first_name_yn,
479: last_name_yn = p_switch_data_rec.last_name_yn,
480: address_yn = p_switch_data_rec.address_yn,

Line 715: FROM ast_switch_data

711:
712: DECLARE
713: v_dummy Char(1);
714: CURSOR c1 IS SELECT 'X'
715: FROM ast_switch_data
716: WHERE switch_data_id = p_switch_data_rec.switch_data_id
717: FOR UPDATE;
718: BEGIN
719: OPEN c1;

Line 920: DELETE FROM ast_switch_data

916: x_return_status := FND_API.G_RET_STS_SUCCESS;
917:
918: -- API body
919: IF p_switch_data_rec.switch_data_id IS NOT NULL THEN
920: DELETE FROM ast_switch_data
921: WHERE switch_data_id = p_switch_data_rec.switch_data_id;
922: END IF;
923:
924: