APPS.IBU_DYN_USER_GROUPS_PKG dependencies on DBMS_SQL

Line 201: cid := dbms_sql.open_cursor;

197: l_ins_qry := 'insert into ibu_usergroups_temp(source_id, category,creation_date, created_by, last_update_date, last_updated_by ) ';
198: l_ins_qry := l_ins_qry || l_q_str;
199: Log_Message(' Insert Temp table query = { ' || l_ins_qry || ' } ');
200:
201: cid := dbms_sql.open_cursor;
202:
203: -- Fixed Bug# 6641845
204: -- Delete the old records before inserting the new records in table ibu_usergroups_temp
205:

Line 206: dbms_sql.parse(cid, 'delete from ibu_usergroups_temp', dbms_sql.v7);

202:
203: -- Fixed Bug# 6641845
204: -- Delete the old records before inserting the new records in table ibu_usergroups_temp
205:
206: dbms_sql.parse(cid, 'delete from ibu_usergroups_temp', dbms_sql.v7);
207: l_rows_processed := dbms_sql.execute(cid);
208: Log_Message(' Insert Temp table rows deleted = ' || l_rows_processed);
209:
210: dbms_sql.parse(cid, l_ins_qry, dbms_sql.v7);

Line 207: l_rows_processed := dbms_sql.execute(cid);

203: -- Fixed Bug# 6641845
204: -- Delete the old records before inserting the new records in table ibu_usergroups_temp
205:
206: dbms_sql.parse(cid, 'delete from ibu_usergroups_temp', dbms_sql.v7);
207: l_rows_processed := dbms_sql.execute(cid);
208: Log_Message(' Insert Temp table rows deleted = ' || l_rows_processed);
209:
210: dbms_sql.parse(cid, l_ins_qry, dbms_sql.v7);
211: l_rows_processed := dbms_sql.execute(cid);

Line 210: dbms_sql.parse(cid, l_ins_qry, dbms_sql.v7);

206: dbms_sql.parse(cid, 'delete from ibu_usergroups_temp', dbms_sql.v7);
207: l_rows_processed := dbms_sql.execute(cid);
208: Log_Message(' Insert Temp table rows deleted = ' || l_rows_processed);
209:
210: dbms_sql.parse(cid, l_ins_qry, dbms_sql.v7);
211: l_rows_processed := dbms_sql.execute(cid);
212: Log_Message(' Insert Temp table rows inserted = ' || l_rows_processed);
213:
214: --dbms_sql.parse(cid, 'commit' , dbms_sql.v7);

Line 211: l_rows_processed := dbms_sql.execute(cid);

207: l_rows_processed := dbms_sql.execute(cid);
208: Log_Message(' Insert Temp table rows deleted = ' || l_rows_processed);
209:
210: dbms_sql.parse(cid, l_ins_qry, dbms_sql.v7);
211: l_rows_processed := dbms_sql.execute(cid);
212: Log_Message(' Insert Temp table rows inserted = ' || l_rows_processed);
213:
214: --dbms_sql.parse(cid, 'commit' , dbms_sql.v7);
215: dbms_sql.close_cursor(cid);

Line 214: --dbms_sql.parse(cid, 'commit' , dbms_sql.v7);

210: dbms_sql.parse(cid, l_ins_qry, dbms_sql.v7);
211: l_rows_processed := dbms_sql.execute(cid);
212: Log_Message(' Insert Temp table rows inserted = ' || l_rows_processed);
213:
214: --dbms_sql.parse(cid, 'commit' , dbms_sql.v7);
215: dbms_sql.close_cursor(cid);
216:
217: select count(*) into l_cnt from ibu_usergroups_temp;
218: Log_Message('Count in ibu_usergroups_temp = ' || to_char(l_cnt) );

Line 215: dbms_sql.close_cursor(cid);

211: l_rows_processed := dbms_sql.execute(cid);
212: Log_Message(' Insert Temp table rows inserted = ' || l_rows_processed);
213:
214: --dbms_sql.parse(cid, 'commit' , dbms_sql.v7);
215: dbms_sql.close_cursor(cid);
216:
217: select count(*) into l_cnt from ibu_usergroups_temp;
218: Log_Message('Count in ibu_usergroups_temp = ' || to_char(l_cnt) );
219: EXCEPTION

Line 222: dbms_sql.close_cursor(cid);

218: Log_Message('Count in ibu_usergroups_temp = ' || to_char(l_cnt) );
219: EXCEPTION
220: WHEN OTHERS THEN
221: Log_Message('Error in Insert_Temp_Table' ||TO_CHAR(SQLCODE)||': '||SQLERRM );
222: dbms_sql.close_cursor(cid);
223: raise;
224: End ;
225:
226: -- =================================================================================================================