APPS.CCT_UPGRADE_PKG dependencies on DUAL

Line 164: v_old_seq_stmt:='SELECT '||schema_name||'.'||old_sequence_name||'.NEXTVAL from dual';

160: BEGIN
161: SAVEPOINT CCTUPGSEQ;
162: BEGIN
163: v_cursorID:=DBMS_SQL.OPEN_CURSOR;
164: v_old_seq_stmt:='SELECT '||schema_name||'.'||old_sequence_name||'.NEXTVAL from dual';
165: --dbms_output.put_line(v_old_seq_stmt);
166: DBMS_SQL.PARSE(v_cursorID,v_old_seq_stmt,DBMS_SQL.V7);
167: --dbms_output.put_line('after parsing');
168: DBMS_SQL.DEFINE_COLUMN(v_cursorID,1,l_old_seq_val,10);

Line 241: v_old_seq_stmt:='SELECT '||schema_name||'.'||old_sequence_name||'.NEXTVAL from dual';

237: -- Getting the Old Sequence value
238:
239: BEGIN
240: v_cursorID:=DBMS_SQL.OPEN_CURSOR;
241: v_old_seq_stmt:='SELECT '||schema_name||'.'||old_sequence_name||'.NEXTVAL from dual';
242: --dbms_output.put_line(v_old_seq_stmt);
243: DBMS_SQL.PARSE(v_cursorID,v_old_seq_stmt,DBMS_SQL.V7);
244: --dbms_output.put_line('after parsing');
245: DBMS_SQL.DEFINE_COLUMN(v_cursorID,1,l_old_seq_val,10);

Line 269: v_new_seq_stmt:='SELECT '||schema_name||'.'||sequence_name||'.NEXTVAL from dual';

265: -- Getting the New Sequence value
266:
267: BEGIN
268: v_cursorID1:=DBMS_SQL.OPEN_CURSOR;
269: v_new_seq_stmt:='SELECT '||schema_name||'.'||sequence_name||'.NEXTVAL from dual';
270: --dbms_output.put_line(v_new_seq_stmt);
271: DBMS_SQL.PARSE(v_cursorID1,v_new_seq_stmt,DBMS_SQL.V7);
272: --dbms_output.put_line('after parsing');
273: DBMS_SQL.DEFINE_COLUMN(v_cursorID1,1,l_new_seq_val,10);

Line 363: and owner=(Select user from dual);

359: CURSOR c1 IS
360: SELECT column_name
361: FROM all_tab_columns
362: WHERE table_name = old_table_name
363: and owner=(Select user from dual);
364:
365: l_string VARCHAR2 (8000) ;
366:
367: l_table_name VARCHAR2 (40);

Line 928: v_old_seq_stmt:='SELECT '||schema_name||'.'||sequence_name||'.NEXTVAL from dual';

924:
925: -- Getting the Current Sequence value
926: BEGIN
927: v_cursorID:=DBMS_SQL.OPEN_CURSOR;
928: v_old_seq_stmt:='SELECT '||schema_name||'.'||sequence_name||'.NEXTVAL from dual';
929: --dbms_output.put_line(v_old_seq_stmt);
930: DBMS_SQL.PARSE(v_cursorID,v_old_seq_stmt,DBMS_SQL.V7);
931: --dbms_output.put_line('after parsing');
932: DBMS_SQL.DEFINE_COLUMN(v_cursorID,1,l_seq_val,10);

Line 1024: from dual;

1020: target_val number:=2000;
1021: Begin
1022: Select cct_interaction_keys_s.nextval
1023: into current_val
1024: from dual;
1025:
1026: while (current_val 1027: Select cct_interaction_keys_s.nextval
1028: into current_val

Line 1029: from dual;

1025:
1026: while (current_val 1027: Select cct_interaction_keys_s.nextval
1028: into current_val
1029: from dual;
1030: end loop;
1031: end;
1032: END cct_upgrade_pkg;