APPS.AST_WEBSWITCH_PVT dependencies on AST_CGI_SWITCHES

Line 32: CURSOR c1 IS SELECT 'X' FROM ast_cgi_switches

28: l_return_status VARCHAR2(1);
29: l_msg_count NUMBER;
30: l_msg_data VARCHAR2(32767);
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;

Line 111: INSERT INTO ast_cgi_switches(

107: OPEN c1;
108: FETCH c1 INTO l_dummy;
109: IF c1%notfound THEN
110:
111: INSERT INTO ast_cgi_switches(
112: cgi_switch_id,
113: query_string_id,
114: enabled_flag,
115: object_version_number,

Line 446: UPDATE ast_cgi_switches

442: -- Initialize API return status to success
443: x_return_status := FND_API.G_RET_STS_SUCCESS;
444:
445: -- API body
446: UPDATE ast_cgi_switches
447: SET
448: switch_code = p_cgi_switch_rec.switch_code,
449: switch_type = p_cgi_switch_rec.switch_type,
450: enabled_flag = p_cgi_switch_rec.enabled_flag,

Line 703: FROM ast_cgi_switches

699: -- API body
700: DECLARE
701: v_dummy CHAR(1);
702: CURSOR c1 IS SELECT 'X'
703: FROM ast_cgi_switches
704: WHERE cgi_switch_id = p_cgi_switch_rec.cgi_switch_id
705: FOR UPDATE;
706: BEGIN
707: OPEN c1;

Line 926: DELETE FROM ast_cgi_switches

922: END IF;
923:
924:
925: IF p_cgi_switch_rec.cgi_switch_id IS NOT NULL THEN
926: DELETE FROM ast_cgi_switches
927: WHERE cgi_switch_id = p_cgi_switch_rec.cgi_switch_id;
928: END IF;
929:
930: