APPS.EGO_VALID_INSTANCE_SET_GRANTS dependencies on DBMS_SQL

Line 125: cursor_select := DBMS_SQL.OPEN_CURSOR;

121: query_to_exec := query_to_exec || prim_key_str || ') IN (' || p_parent_obj_sql || '))';
122: END IF;
123: END IF;
124: -- R12C Security Changes
125: cursor_select := DBMS_SQL.OPEN_CURSOR;
126: DBMS_SQL.PARSE(cursor_select, query_to_exec, DBMS_SQL.NATIVE);
127: IF p_bind1 IS NOT NULL THEN
128: DBMS_SQL.BIND_VARIABLE(cursor_select, ':id1', p_bind1);
129: END IF;

Line 126: DBMS_SQL.PARSE(cursor_select, query_to_exec, DBMS_SQL.NATIVE);

122: END IF;
123: END IF;
124: -- R12C Security Changes
125: cursor_select := DBMS_SQL.OPEN_CURSOR;
126: DBMS_SQL.PARSE(cursor_select, query_to_exec, DBMS_SQL.NATIVE);
127: IF p_bind1 IS NOT NULL THEN
128: DBMS_SQL.BIND_VARIABLE(cursor_select, ':id1', p_bind1);
129: END IF;
130: IF p_bind2 IS NOT NULL THEN

Line 128: DBMS_SQL.BIND_VARIABLE(cursor_select, ':id1', p_bind1);

124: -- R12C Security Changes
125: cursor_select := DBMS_SQL.OPEN_CURSOR;
126: DBMS_SQL.PARSE(cursor_select, query_to_exec, DBMS_SQL.NATIVE);
127: IF p_bind1 IS NOT NULL THEN
128: DBMS_SQL.BIND_VARIABLE(cursor_select, ':id1', p_bind1);
129: END IF;
130: IF p_bind2 IS NOT NULL THEN
131: DBMS_SQL.BIND_VARIABLE(cursor_select, ':id2', p_bind2);
132: END IF;

Line 131: DBMS_SQL.BIND_VARIABLE(cursor_select, ':id2', p_bind2);

127: IF p_bind1 IS NOT NULL THEN
128: DBMS_SQL.BIND_VARIABLE(cursor_select, ':id1', p_bind1);
129: END IF;
130: IF p_bind2 IS NOT NULL THEN
131: DBMS_SQL.BIND_VARIABLE(cursor_select, ':id2', p_bind2);
132: END IF;
133: IF p_bind3 IS NOT NULL THEN
134: DBMS_SQL.BIND_VARIABLE(cursor_select, ':id3', p_bind3);
135: END IF;

Line 134: DBMS_SQL.BIND_VARIABLE(cursor_select, ':id3', p_bind3);

130: IF p_bind2 IS NOT NULL THEN
131: DBMS_SQL.BIND_VARIABLE(cursor_select, ':id2', p_bind2);
132: END IF;
133: IF p_bind3 IS NOT NULL THEN
134: DBMS_SQL.BIND_VARIABLE(cursor_select, ':id3', p_bind3);
135: END IF;
136: IF p_bind4 IS NOT NULL THEN
137: DBMS_SQL.BIND_VARIABLE(cursor_select, ':id4', p_bind4);
138: END IF;

Line 137: DBMS_SQL.BIND_VARIABLE(cursor_select, ':id4', p_bind4);

133: IF p_bind3 IS NOT NULL THEN
134: DBMS_SQL.BIND_VARIABLE(cursor_select, ':id3', p_bind3);
135: END IF;
136: IF p_bind4 IS NOT NULL THEN
137: DBMS_SQL.BIND_VARIABLE(cursor_select, ':id4', p_bind4);
138: END IF;
139: IF p_bind5 IS NOT NULL THEN
140: DBMS_SQL.BIND_VARIABLE(cursor_select, ':id5', p_bind5);
141: END IF;

Line 140: DBMS_SQL.BIND_VARIABLE(cursor_select, ':id5', p_bind5);

136: IF p_bind4 IS NOT NULL THEN
137: DBMS_SQL.BIND_VARIABLE(cursor_select, ':id4', p_bind4);
138: END IF;
139: IF p_bind5 IS NOT NULL THEN
140: DBMS_SQL.BIND_VARIABLE(cursor_select, ':id5', p_bind5);
141: END IF;
142: cursor_execute := DBMS_SQL.EXECUTE(cursor_select);
143: IF DBMS_SQL.FETCH_ROWS(cursor_select) > 0 THEN
144: IF i = 1 THEN

Line 142: cursor_execute := DBMS_SQL.EXECUTE(cursor_select);

138: END IF;
139: IF p_bind5 IS NOT NULL THEN
140: DBMS_SQL.BIND_VARIABLE(cursor_select, ':id5', p_bind5);
141: END IF;
142: cursor_execute := DBMS_SQL.EXECUTE(cursor_select);
143: IF DBMS_SQL.FETCH_ROWS(cursor_select) > 0 THEN
144: IF i = 1 THEN
145: inst_set_ids := to_char(inst_set_preds_rec.instance_set_id);
146: i := 2;

Line 143: IF DBMS_SQL.FETCH_ROWS(cursor_select) > 0 THEN

139: IF p_bind5 IS NOT NULL THEN
140: DBMS_SQL.BIND_VARIABLE(cursor_select, ':id5', p_bind5);
141: END IF;
142: cursor_execute := DBMS_SQL.EXECUTE(cursor_select);
143: IF DBMS_SQL.FETCH_ROWS(cursor_select) > 0 THEN
144: IF i = 1 THEN
145: inst_set_ids := to_char(inst_set_preds_rec.instance_set_id);
146: i := 2;
147: ELSE

Line 151: DBMS_SQL.CLOSE_CURSOR(cursor_select);

147: ELSE
148: inst_set_ids := inst_set_ids || ',' || inst_set_preds_rec.instance_set_id;
149: END IF;
150: END IF;
151: DBMS_SQL.CLOSE_CURSOR(cursor_select);
152: END LOOP;
153: IF inst_set_ids IS NOT NULL THEN
154: x_inst_set_ids := inst_set_ids; /**** list of valid inst_set_ids ****/
155: ELSE