eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EDW_GL_ACCT_M_T dependencies on DBMS_SQL

Line 97: l_cursor_id:=DBMS_SQL.OPEN_CURSOR;

93: FROM '||g_vbh_temp_table_name||'
94: where child is not null
95: START WITH parent =:m2
96: CONNECT BY parent=PRIOR child)';
97: l_cursor_id:=DBMS_SQL.OPEN_CURSOR;
98: DBMS_SQL.parse(l_cursor_id,l_select_stmt,DBMS_SQL.V7);
99: DBMS_SQL.bind_variable(l_cursor_id,':m1',p_acct_name1);
100: DBMS_SQL.bind_variable(l_cursor_id,':m2',p_acct_name2);
101: DBMS_SQL.define_column(l_cursor_id,1,l_count);

Line 98: DBMS_SQL.parse(l_cursor_id,l_select_stmt,DBMS_SQL.V7);

94: where child is not null
95: START WITH parent =:m2
96: CONNECT BY parent=PRIOR child)';
97: l_cursor_id:=DBMS_SQL.OPEN_CURSOR;
98: DBMS_SQL.parse(l_cursor_id,l_select_stmt,DBMS_SQL.V7);
99: DBMS_SQL.bind_variable(l_cursor_id,':m1',p_acct_name1);
100: DBMS_SQL.bind_variable(l_cursor_id,':m2',p_acct_name2);
101: DBMS_SQL.define_column(l_cursor_id,1,l_count);
102: l_rows_selected:=DBMS_SQL.execute(l_cursor_id);

Line 99: DBMS_SQL.bind_variable(l_cursor_id,':m1',p_acct_name1);

95: START WITH parent =:m2
96: CONNECT BY parent=PRIOR child)';
97: l_cursor_id:=DBMS_SQL.OPEN_CURSOR;
98: DBMS_SQL.parse(l_cursor_id,l_select_stmt,DBMS_SQL.V7);
99: DBMS_SQL.bind_variable(l_cursor_id,':m1',p_acct_name1);
100: DBMS_SQL.bind_variable(l_cursor_id,':m2',p_acct_name2);
101: DBMS_SQL.define_column(l_cursor_id,1,l_count);
102: l_rows_selected:=DBMS_SQL.execute(l_cursor_id);
103: l_rows_fetched:=DBMS_SQL.fetch_rows(l_cursor_id);

Line 100: DBMS_SQL.bind_variable(l_cursor_id,':m2',p_acct_name2);

96: CONNECT BY parent=PRIOR child)';
97: l_cursor_id:=DBMS_SQL.OPEN_CURSOR;
98: DBMS_SQL.parse(l_cursor_id,l_select_stmt,DBMS_SQL.V7);
99: DBMS_SQL.bind_variable(l_cursor_id,':m1',p_acct_name1);
100: DBMS_SQL.bind_variable(l_cursor_id,':m2',p_acct_name2);
101: DBMS_SQL.define_column(l_cursor_id,1,l_count);
102: l_rows_selected:=DBMS_SQL.execute(l_cursor_id);
103: l_rows_fetched:=DBMS_SQL.fetch_rows(l_cursor_id);
104: DBMS_SQL.column_value (l_cursor_id,1,l_count);

Line 101: DBMS_SQL.define_column(l_cursor_id,1,l_count);

97: l_cursor_id:=DBMS_SQL.OPEN_CURSOR;
98: DBMS_SQL.parse(l_cursor_id,l_select_stmt,DBMS_SQL.V7);
99: DBMS_SQL.bind_variable(l_cursor_id,':m1',p_acct_name1);
100: DBMS_SQL.bind_variable(l_cursor_id,':m2',p_acct_name2);
101: DBMS_SQL.define_column(l_cursor_id,1,l_count);
102: l_rows_selected:=DBMS_SQL.execute(l_cursor_id);
103: l_rows_fetched:=DBMS_SQL.fetch_rows(l_cursor_id);
104: DBMS_SQL.column_value (l_cursor_id,1,l_count);
105: DBMS_SQL.close_cursor(l_cursor_id);

Line 102: l_rows_selected:=DBMS_SQL.execute(l_cursor_id);

98: DBMS_SQL.parse(l_cursor_id,l_select_stmt,DBMS_SQL.V7);
99: DBMS_SQL.bind_variable(l_cursor_id,':m1',p_acct_name1);
100: DBMS_SQL.bind_variable(l_cursor_id,':m2',p_acct_name2);
101: DBMS_SQL.define_column(l_cursor_id,1,l_count);
102: l_rows_selected:=DBMS_SQL.execute(l_cursor_id);
103: l_rows_fetched:=DBMS_SQL.fetch_rows(l_cursor_id);
104: DBMS_SQL.column_value (l_cursor_id,1,l_count);
105: DBMS_SQL.close_cursor(l_cursor_id);
106:

Line 103: l_rows_fetched:=DBMS_SQL.fetch_rows(l_cursor_id);

99: DBMS_SQL.bind_variable(l_cursor_id,':m1',p_acct_name1);
100: DBMS_SQL.bind_variable(l_cursor_id,':m2',p_acct_name2);
101: DBMS_SQL.define_column(l_cursor_id,1,l_count);
102: l_rows_selected:=DBMS_SQL.execute(l_cursor_id);
103: l_rows_fetched:=DBMS_SQL.fetch_rows(l_cursor_id);
104: DBMS_SQL.column_value (l_cursor_id,1,l_count);
105: DBMS_SQL.close_cursor(l_cursor_id);
106:
107: if l_count=0 then

Line 104: DBMS_SQL.column_value (l_cursor_id,1,l_count);

100: DBMS_SQL.bind_variable(l_cursor_id,':m2',p_acct_name2);
101: DBMS_SQL.define_column(l_cursor_id,1,l_count);
102: l_rows_selected:=DBMS_SQL.execute(l_cursor_id);
103: l_rows_fetched:=DBMS_SQL.fetch_rows(l_cursor_id);
104: DBMS_SQL.column_value (l_cursor_id,1,l_count);
105: DBMS_SQL.close_cursor(l_cursor_id);
106:
107: if l_count=0 then
108: p_result:=false;

Line 105: DBMS_SQL.close_cursor(l_cursor_id);

101: DBMS_SQL.define_column(l_cursor_id,1,l_count);
102: l_rows_selected:=DBMS_SQL.execute(l_cursor_id);
103: l_rows_fetched:=DBMS_SQL.fetch_rows(l_cursor_id);
104: DBMS_SQL.column_value (l_cursor_id,1,l_count);
105: DBMS_SQL.close_cursor(l_cursor_id);
106:
107: if l_count=0 then
108: p_result:=false;
109: else

Line 115: DBMS_SQL.close_cursor(l_cursor_id);

111: end if ;
112: exception
113: when others then
114: p_result:=false;
115: DBMS_SQL.close_cursor(l_cursor_id);
116:
117: if(sqlcode = -1436) then
118: edw_log.put_line('Error :'||
119: 'When checking precedence between ' || p_acct_name1 || ' and ' ||

Line 224: l_CursorID := DBMS_SQL.OPEN_CURSOR;

220: l_UpdateStmt VARCHAR2(500);
221: l_RowsUpdated integer;
222:
223: BEGIN
224: l_CursorID := DBMS_SQL.OPEN_CURSOR;
225: l_UpdateStmt :=
226: 'UPDATE '||g_vbh_temp_table_name||'
227: SET child_type= :b_acct_type
228: WHERE child =:b_acct_name';

Line 229: DBMS_SQL.PARSE(l_CursorID,l_UpdateStmt,DBMS_SQL.V7);

225: l_UpdateStmt :=
226: 'UPDATE '||g_vbh_temp_table_name||'
227: SET child_type= :b_acct_type
228: WHERE child =:b_acct_name';
229: DBMS_SQL.PARSE(l_CursorID,l_UpdateStmt,DBMS_SQL.V7);
230: DBMS_SQL.BIND_VARIABLE(l_CursorID, ':b_acct_type',p_acct_type);
231: DBMS_SQL.BIND_VARIABLE(l_CursorID, ':b_acct_name',p_acct_name);
232:
233: l_RowsUpdated := DBMS_SQL.EXECUTE(l_CursorID);

Line 230: DBMS_SQL.BIND_VARIABLE(l_CursorID, ':b_acct_type',p_acct_type);

226: 'UPDATE '||g_vbh_temp_table_name||'
227: SET child_type= :b_acct_type
228: WHERE child =:b_acct_name';
229: DBMS_SQL.PARSE(l_CursorID,l_UpdateStmt,DBMS_SQL.V7);
230: DBMS_SQL.BIND_VARIABLE(l_CursorID, ':b_acct_type',p_acct_type);
231: DBMS_SQL.BIND_VARIABLE(l_CursorID, ':b_acct_name',p_acct_name);
232:
233: l_RowsUpdated := DBMS_SQL.EXECUTE(l_CursorID);
234: DBMS_SQL.CLOSE_CURSOR(l_CursorID);

Line 231: DBMS_SQL.BIND_VARIABLE(l_CursorID, ':b_acct_name',p_acct_name);

227: SET child_type= :b_acct_type
228: WHERE child =:b_acct_name';
229: DBMS_SQL.PARSE(l_CursorID,l_UpdateStmt,DBMS_SQL.V7);
230: DBMS_SQL.BIND_VARIABLE(l_CursorID, ':b_acct_type',p_acct_type);
231: DBMS_SQL.BIND_VARIABLE(l_CursorID, ':b_acct_name',p_acct_name);
232:
233: l_RowsUpdated := DBMS_SQL.EXECUTE(l_CursorID);
234: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
235: l_CursorID := DBMS_SQL.OPEN_CURSOR;

Line 233: l_RowsUpdated := DBMS_SQL.EXECUTE(l_CursorID);

229: DBMS_SQL.PARSE(l_CursorID,l_UpdateStmt,DBMS_SQL.V7);
230: DBMS_SQL.BIND_VARIABLE(l_CursorID, ':b_acct_type',p_acct_type);
231: DBMS_SQL.BIND_VARIABLE(l_CursorID, ':b_acct_name',p_acct_name);
232:
233: l_RowsUpdated := DBMS_SQL.EXECUTE(l_CursorID);
234: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
235: l_CursorID := DBMS_SQL.OPEN_CURSOR;
236: l_UpdateStmt :=
237: 'UPDATE '|| g_vbh_temp_table_name||'

Line 234: DBMS_SQL.CLOSE_CURSOR(l_CursorID);

230: DBMS_SQL.BIND_VARIABLE(l_CursorID, ':b_acct_type',p_acct_type);
231: DBMS_SQL.BIND_VARIABLE(l_CursorID, ':b_acct_name',p_acct_name);
232:
233: l_RowsUpdated := DBMS_SQL.EXECUTE(l_CursorID);
234: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
235: l_CursorID := DBMS_SQL.OPEN_CURSOR;
236: l_UpdateStmt :=
237: 'UPDATE '|| g_vbh_temp_table_name||'
238: SET parent_type= :b_acct_type

Line 235: l_CursorID := DBMS_SQL.OPEN_CURSOR;

231: DBMS_SQL.BIND_VARIABLE(l_CursorID, ':b_acct_name',p_acct_name);
232:
233: l_RowsUpdated := DBMS_SQL.EXECUTE(l_CursorID);
234: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
235: l_CursorID := DBMS_SQL.OPEN_CURSOR;
236: l_UpdateStmt :=
237: 'UPDATE '|| g_vbh_temp_table_name||'
238: SET parent_type= :b_acct_type
239: WHERE parent =:b_acct_name';

Line 241: DBMS_SQL.PARSE(l_CursorID,l_UpdateStmt,DBMS_SQL.V7);

237: 'UPDATE '|| g_vbh_temp_table_name||'
238: SET parent_type= :b_acct_type
239: WHERE parent =:b_acct_name';
240:
241: DBMS_SQL.PARSE(l_CursorID,l_UpdateStmt,DBMS_SQL.V7);
242: DBMS_SQL.BIND_VARIABLE(l_CursorID, ':b_acct_type',p_acct_type);
243: DBMS_SQL.BIND_VARIABLE(l_CursorID, ':b_acct_name',p_acct_name);
244:
245: l_RowsUpdated:= DBMS_SQL.EXECUTE(l_CursorID);

Line 242: DBMS_SQL.BIND_VARIABLE(l_CursorID, ':b_acct_type',p_acct_type);

238: SET parent_type= :b_acct_type
239: WHERE parent =:b_acct_name';
240:
241: DBMS_SQL.PARSE(l_CursorID,l_UpdateStmt,DBMS_SQL.V7);
242: DBMS_SQL.BIND_VARIABLE(l_CursorID, ':b_acct_type',p_acct_type);
243: DBMS_SQL.BIND_VARIABLE(l_CursorID, ':b_acct_name',p_acct_name);
244:
245: l_RowsUpdated:= DBMS_SQL.EXECUTE(l_CursorID);
246: DBMS_SQL.CLOSE_CURSOR(l_CursorID);

Line 243: DBMS_SQL.BIND_VARIABLE(l_CursorID, ':b_acct_name',p_acct_name);

239: WHERE parent =:b_acct_name';
240:
241: DBMS_SQL.PARSE(l_CursorID,l_UpdateStmt,DBMS_SQL.V7);
242: DBMS_SQL.BIND_VARIABLE(l_CursorID, ':b_acct_type',p_acct_type);
243: DBMS_SQL.BIND_VARIABLE(l_CursorID, ':b_acct_name',p_acct_name);
244:
245: l_RowsUpdated:= DBMS_SQL.EXECUTE(l_CursorID);
246: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
247: exception

Line 245: l_RowsUpdated:= DBMS_SQL.EXECUTE(l_CursorID);

241: DBMS_SQL.PARSE(l_CursorID,l_UpdateStmt,DBMS_SQL.V7);
242: DBMS_SQL.BIND_VARIABLE(l_CursorID, ':b_acct_type',p_acct_type);
243: DBMS_SQL.BIND_VARIABLE(l_CursorID, ':b_acct_name',p_acct_name);
244:
245: l_RowsUpdated:= DBMS_SQL.EXECUTE(l_CursorID);
246: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
247: exception
248: when others then
249: DBMS_SQL.close_cursor(l_CursorID);

Line 246: DBMS_SQL.CLOSE_CURSOR(l_CursorID);

242: DBMS_SQL.BIND_VARIABLE(l_CursorID, ':b_acct_type',p_acct_type);
243: DBMS_SQL.BIND_VARIABLE(l_CursorID, ':b_acct_name',p_acct_name);
244:
245: l_RowsUpdated:= DBMS_SQL.EXECUTE(l_CursorID);
246: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
247: exception
248: when others then
249: DBMS_SQL.close_cursor(l_CursorID);
250: edw_log.put_line('Error:'||

Line 249: DBMS_SQL.close_cursor(l_CursorID);

245: l_RowsUpdated:= DBMS_SQL.EXECUTE(l_CursorID);
246: DBMS_SQL.CLOSE_CURSOR(l_CursorID);
247: exception
248: when others then
249: DBMS_SQL.close_cursor(l_CursorID);
250: edw_log.put_line('Error:'||
251: 'when updating table '|| g_vbh_temp_table_name||' for '||
252: p_acct_name||' '||sqlcode||' : '||sqlerrm);
253: raise;

Line 387: l_cursor_id:=DBMS_SQL.open_cursor;

383: l_insert_stmt varchar2(5000);
384: l_rows_inserted integer :=0;
385:
386: begin
387: l_cursor_id:=DBMS_SQL.open_cursor;
388: l_insert_stmt:='INSERT INTO '|| g_dimension_name||'(L1_pk ,l1_pk_key,l1_name,l1_description
389: ,l1_type,type_pk,type_name,all_name,all_pk,
390: H102_pk ,H103_pk ,H104_pk ,H105_pk ,H106_pk ,H107_pk ,H108_pk ,
391: H102_name ,H103_name ,H104_name ,H105_name ,H106_name ,H107_name ,H108_name ,

Line 441: DBMS_SQL.parse(l_cursor_id,l_insert_stmt,DBMS_SQL.V7);

437: ''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',''NA_EDW'',
438: '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',
439: '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',sysdate,sysdate)';
440:
441: DBMS_SQL.parse(l_cursor_id,l_insert_stmt,DBMS_SQL.V7);
442: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':b_pk',p_pk);
443: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':b_pk_key' , p_pk_key);
444: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':b_name' , p_name);
445: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':b_desc' , p_desc);

Line 442: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':b_pk',p_pk);

438: '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',
439: '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',sysdate,sysdate)';
440:
441: DBMS_SQL.parse(l_cursor_id,l_insert_stmt,DBMS_SQL.V7);
442: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':b_pk',p_pk);
443: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':b_pk_key' , p_pk_key);
444: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':b_name' , p_name);
445: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':b_desc' , p_desc);
446: l_rows_inserted :=DBMS_SQL.EXECUTE(l_cursor_id);

Line 443: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':b_pk_key' , p_pk_key);

439: '''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''','''|| g_na_edw||''',sysdate,sysdate)';
440:
441: DBMS_SQL.parse(l_cursor_id,l_insert_stmt,DBMS_SQL.V7);
442: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':b_pk',p_pk);
443: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':b_pk_key' , p_pk_key);
444: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':b_name' , p_name);
445: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':b_desc' , p_desc);
446: l_rows_inserted :=DBMS_SQL.EXECUTE(l_cursor_id);
447: DBMS_SQL.close_cursor(l_cursor_id);

Line 444: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':b_name' , p_name);

440:
441: DBMS_SQL.parse(l_cursor_id,l_insert_stmt,DBMS_SQL.V7);
442: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':b_pk',p_pk);
443: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':b_pk_key' , p_pk_key);
444: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':b_name' , p_name);
445: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':b_desc' , p_desc);
446: l_rows_inserted :=DBMS_SQL.EXECUTE(l_cursor_id);
447: DBMS_SQL.close_cursor(l_cursor_id);
448: exception

Line 445: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':b_desc' , p_desc);

441: DBMS_SQL.parse(l_cursor_id,l_insert_stmt,DBMS_SQL.V7);
442: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':b_pk',p_pk);
443: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':b_pk_key' , p_pk_key);
444: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':b_name' , p_name);
445: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':b_desc' , p_desc);
446: l_rows_inserted :=DBMS_SQL.EXECUTE(l_cursor_id);
447: DBMS_SQL.close_cursor(l_cursor_id);
448: exception
449: when others then

Line 446: l_rows_inserted :=DBMS_SQL.EXECUTE(l_cursor_id);

442: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':b_pk',p_pk);
443: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':b_pk_key' , p_pk_key);
444: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':b_name' , p_name);
445: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':b_desc' , p_desc);
446: l_rows_inserted :=DBMS_SQL.EXECUTE(l_cursor_id);
447: DBMS_SQL.close_cursor(l_cursor_id);
448: exception
449: when others then
450: edw_log.put_line('Error:'||

Line 447: DBMS_SQL.close_cursor(l_cursor_id);

443: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':b_pk_key' , p_pk_key);
444: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':b_name' , p_name);
445: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':b_desc' , p_desc);
446: l_rows_inserted :=DBMS_SQL.EXECUTE(l_cursor_id);
447: DBMS_SQL.close_cursor(l_cursor_id);
448: exception
449: when others then
450: edw_log.put_line('Error:'||
451: 'When inserting the default value into '|| g_dimension_name

Line 624: l_cursor_id:=DBMS_SQL.open_cursor;

620: ' select l1_pk, l1_pk_key, l1_name, l1_description from '||g_dimension_name ||
621: ' a where not exists ' ||
622: ' (select b.l1_pk from ' || g_global_temp_table || ' b where a.l1_pk = b.l1_pk)';
623: VBHDEBUG('Executing ' || l_insert_stmt);
624: l_cursor_id:=DBMS_SQL.open_cursor;
625: DBMS_SQL.parse(l_cursor_id,l_insert_stmt,DBMS_SQL.V7);
626: l_rows_inserted :=DBMS_SQL.EXECUTE(l_cursor_id);
627: DBMS_SQL.close_cursor(l_cursor_id);
628: -- issue commit safely, after the backup is done.

Line 625: DBMS_SQL.parse(l_cursor_id,l_insert_stmt,DBMS_SQL.V7);

621: ' a where not exists ' ||
622: ' (select b.l1_pk from ' || g_global_temp_table || ' b where a.l1_pk = b.l1_pk)';
623: VBHDEBUG('Executing ' || l_insert_stmt);
624: l_cursor_id:=DBMS_SQL.open_cursor;
625: DBMS_SQL.parse(l_cursor_id,l_insert_stmt,DBMS_SQL.V7);
626: l_rows_inserted :=DBMS_SQL.EXECUTE(l_cursor_id);
627: DBMS_SQL.close_cursor(l_cursor_id);
628: -- issue commit safely, after the backup is done.
629: commit;

Line 626: l_rows_inserted :=DBMS_SQL.EXECUTE(l_cursor_id);

622: ' (select b.l1_pk from ' || g_global_temp_table || ' b where a.l1_pk = b.l1_pk)';
623: VBHDEBUG('Executing ' || l_insert_stmt);
624: l_cursor_id:=DBMS_SQL.open_cursor;
625: DBMS_SQL.parse(l_cursor_id,l_insert_stmt,DBMS_SQL.V7);
626: l_rows_inserted :=DBMS_SQL.EXECUTE(l_cursor_id);
627: DBMS_SQL.close_cursor(l_cursor_id);
628: -- issue commit safely, after the backup is done.
629: commit;
630: VBHDEBUG('Inserted ' || l_rows_inserted || ' rows');

Line 627: DBMS_SQL.close_cursor(l_cursor_id);

623: VBHDEBUG('Executing ' || l_insert_stmt);
624: l_cursor_id:=DBMS_SQL.open_cursor;
625: DBMS_SQL.parse(l_cursor_id,l_insert_stmt,DBMS_SQL.V7);
626: l_rows_inserted :=DBMS_SQL.EXECUTE(l_cursor_id);
627: DBMS_SQL.close_cursor(l_cursor_id);
628: -- issue commit safely, after the backup is done.
629: commit;
630: VBHDEBUG('Inserted ' || l_rows_inserted || ' rows');
631: exception

Line 731: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_type', p_type);

727: cur_check_error t_cur_check_error;
728: BEGIN
729:
730: IF p_hierachy_no <= 4 THEN
731: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_type', p_type);
732: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level2' , p_level2);
733: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level2_name',p_level2_name);
734: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level2_type',p_level2_type);
735: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level2_desc',p_level2_desc);

Line 732: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level2' , p_level2);

728: BEGIN
729:
730: IF p_hierachy_no <= 4 THEN
731: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_type', p_type);
732: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level2' , p_level2);
733: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level2_name',p_level2_name);
734: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level2_type',p_level2_type);
735: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level2_desc',p_level2_desc);
736: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level3' , p_level3);

Line 733: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level2_name',p_level2_name);

729:
730: IF p_hierachy_no <= 4 THEN
731: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_type', p_type);
732: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level2' , p_level2);
733: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level2_name',p_level2_name);
734: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level2_type',p_level2_type);
735: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level2_desc',p_level2_desc);
736: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level3' , p_level3);
737: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level3_name',p_level3_name);

Line 734: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level2_type',p_level2_type);

730: IF p_hierachy_no <= 4 THEN
731: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_type', p_type);
732: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level2' , p_level2);
733: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level2_name',p_level2_name);
734: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level2_type',p_level2_type);
735: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level2_desc',p_level2_desc);
736: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level3' , p_level3);
737: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level3_name',p_level3_name);
738: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level3_type',p_level3_type);

Line 735: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level2_desc',p_level2_desc);

731: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_type', p_type);
732: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level2' , p_level2);
733: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level2_name',p_level2_name);
734: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level2_type',p_level2_type);
735: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level2_desc',p_level2_desc);
736: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level3' , p_level3);
737: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level3_name',p_level3_name);
738: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level3_type',p_level3_type);
739: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level3_desc',p_level3_desc);

Line 736: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level3' , p_level3);

732: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level2' , p_level2);
733: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level2_name',p_level2_name);
734: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level2_type',p_level2_type);
735: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level2_desc',p_level2_desc);
736: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level3' , p_level3);
737: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level3_name',p_level3_name);
738: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level3_type',p_level3_type);
739: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level3_desc',p_level3_desc);
740: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level4' , p_level4);

Line 737: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level3_name',p_level3_name);

733: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level2_name',p_level2_name);
734: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level2_type',p_level2_type);
735: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level2_desc',p_level2_desc);
736: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level3' , p_level3);
737: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level3_name',p_level3_name);
738: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level3_type',p_level3_type);
739: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level3_desc',p_level3_desc);
740: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level4' , p_level4);
741: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level4_name',p_level4_name);

Line 738: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level3_type',p_level3_type);

734: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level2_type',p_level2_type);
735: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level2_desc',p_level2_desc);
736: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level3' , p_level3);
737: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level3_name',p_level3_name);
738: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level3_type',p_level3_type);
739: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level3_desc',p_level3_desc);
740: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level4' , p_level4);
741: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level4_name',p_level4_name);
742: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level4_type',p_level4_type);

Line 739: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level3_desc',p_level3_desc);

735: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level2_desc',p_level2_desc);
736: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level3' , p_level3);
737: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level3_name',p_level3_name);
738: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level3_type',p_level3_type);
739: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level3_desc',p_level3_desc);
740: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level4' , p_level4);
741: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level4_name',p_level4_name);
742: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level4_type',p_level4_type);
743: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level4_desc',p_level4_desc);

Line 740: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level4' , p_level4);

736: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level3' , p_level3);
737: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level3_name',p_level3_name);
738: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level3_type',p_level3_type);
739: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level3_desc',p_level3_desc);
740: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level4' , p_level4);
741: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level4_name',p_level4_name);
742: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level4_type',p_level4_type);
743: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level4_desc',p_level4_desc);
744: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level5' , p_level5);

Line 741: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level4_name',p_level4_name);

737: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level3_name',p_level3_name);
738: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level3_type',p_level3_type);
739: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level3_desc',p_level3_desc);
740: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level4' , p_level4);
741: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level4_name',p_level4_name);
742: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level4_type',p_level4_type);
743: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level4_desc',p_level4_desc);
744: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level5' , p_level5);
745: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level5_name',p_level5_name);

Line 742: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level4_type',p_level4_type);

738: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level3_type',p_level3_type);
739: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level3_desc',p_level3_desc);
740: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level4' , p_level4);
741: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level4_name',p_level4_name);
742: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level4_type',p_level4_type);
743: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level4_desc',p_level4_desc);
744: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level5' , p_level5);
745: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level5_name',p_level5_name);
746: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level5_type',p_level5_type);

Line 743: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level4_desc',p_level4_desc);

739: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level3_desc',p_level3_desc);
740: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level4' , p_level4);
741: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level4_name',p_level4_name);
742: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level4_type',p_level4_type);
743: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level4_desc',p_level4_desc);
744: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level5' , p_level5);
745: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level5_name',p_level5_name);
746: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level5_type',p_level5_type);
747: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level5_desc',p_level5_desc);

Line 744: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level5' , p_level5);

740: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level4' , p_level4);
741: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level4_name',p_level4_name);
742: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level4_type',p_level4_type);
743: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level4_desc',p_level4_desc);
744: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level5' , p_level5);
745: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level5_name',p_level5_name);
746: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level5_type',p_level5_type);
747: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level5_desc',p_level5_desc);
748: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level6' , p_level6);

Line 745: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level5_name',p_level5_name);

741: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level4_name',p_level4_name);
742: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level4_type',p_level4_type);
743: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level4_desc',p_level4_desc);
744: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level5' , p_level5);
745: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level5_name',p_level5_name);
746: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level5_type',p_level5_type);
747: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level5_desc',p_level5_desc);
748: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level6' , p_level6);
749: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level6_name',p_level6_name);

Line 746: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level5_type',p_level5_type);

742: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level4_type',p_level4_type);
743: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level4_desc',p_level4_desc);
744: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level5' , p_level5);
745: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level5_name',p_level5_name);
746: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level5_type',p_level5_type);
747: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level5_desc',p_level5_desc);
748: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level6' , p_level6);
749: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level6_name',p_level6_name);
750: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level6_type',p_level6_type);

Line 747: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level5_desc',p_level5_desc);

743: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level4_desc',p_level4_desc);
744: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level5' , p_level5);
745: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level5_name',p_level5_name);
746: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level5_type',p_level5_type);
747: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level5_desc',p_level5_desc);
748: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level6' , p_level6);
749: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level6_name',p_level6_name);
750: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level6_type',p_level6_type);
751: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level6_desc',p_level6_desc);

Line 748: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level6' , p_level6);

744: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level5' , p_level5);
745: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level5_name',p_level5_name);
746: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level5_type',p_level5_type);
747: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level5_desc',p_level5_desc);
748: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level6' , p_level6);
749: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level6_name',p_level6_name);
750: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level6_type',p_level6_type);
751: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level6_desc',p_level6_desc);
752: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level7' , p_level7);

Line 749: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level6_name',p_level6_name);

745: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level5_name',p_level5_name);
746: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level5_type',p_level5_type);
747: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level5_desc',p_level5_desc);
748: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level6' , p_level6);
749: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level6_name',p_level6_name);
750: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level6_type',p_level6_type);
751: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level6_desc',p_level6_desc);
752: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level7' , p_level7);
753: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level7_name',p_level7_name);

Line 750: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level6_type',p_level6_type);

746: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level5_type',p_level5_type);
747: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level5_desc',p_level5_desc);
748: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level6' , p_level6);
749: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level6_name',p_level6_name);
750: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level6_type',p_level6_type);
751: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level6_desc',p_level6_desc);
752: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level7' , p_level7);
753: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level7_name',p_level7_name);
754: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level7_type',p_level7_type);

Line 751: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level6_desc',p_level6_desc);

747: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level5_desc',p_level5_desc);
748: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level6' , p_level6);
749: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level6_name',p_level6_name);
750: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level6_type',p_level6_type);
751: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level6_desc',p_level6_desc);
752: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level7' , p_level7);
753: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level7_name',p_level7_name);
754: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level7_type',p_level7_type);
755: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level7_desc',p_level7_desc);

Line 752: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level7' , p_level7);

748: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level6' , p_level6);
749: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level6_name',p_level6_name);
750: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level6_type',p_level6_type);
751: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level6_desc',p_level6_desc);
752: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level7' , p_level7);
753: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level7_name',p_level7_name);
754: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level7_type',p_level7_type);
755: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level7_desc',p_level7_desc);
756: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level8' , p_level8);

Line 753: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level7_name',p_level7_name);

749: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level6_name',p_level6_name);
750: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level6_type',p_level6_type);
751: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level6_desc',p_level6_desc);
752: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level7' , p_level7);
753: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level7_name',p_level7_name);
754: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level7_type',p_level7_type);
755: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level7_desc',p_level7_desc);
756: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level8' , p_level8);
757: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level8_name',p_level8_name);

Line 754: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level7_type',p_level7_type);

750: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level6_type',p_level6_type);
751: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level6_desc',p_level6_desc);
752: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level7' , p_level7);
753: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level7_name',p_level7_name);
754: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level7_type',p_level7_type);
755: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level7_desc',p_level7_desc);
756: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level8' , p_level8);
757: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level8_name',p_level8_name);
758: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level8_type',p_level8_type);

Line 755: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level7_desc',p_level7_desc);

751: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level6_desc',p_level6_desc);
752: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level7' , p_level7);
753: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level7_name',p_level7_name);
754: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level7_type',p_level7_type);
755: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level7_desc',p_level7_desc);
756: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level8' , p_level8);
757: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level8_name',p_level8_name);
758: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level8_type',p_level8_type);
759: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level8_desc',p_level8_desc);

Line 756: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level8' , p_level8);

752: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level7' , p_level7);
753: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level7_name',p_level7_name);
754: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level7_type',p_level7_type);
755: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level7_desc',p_level7_desc);
756: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level8' , p_level8);
757: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level8_name',p_level8_name);
758: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level8_type',p_level8_type);
759: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level8_desc',p_level8_desc);
760: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level9' , p_level9);

Line 757: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level8_name',p_level8_name);

753: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level7_name',p_level7_name);
754: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level7_type',p_level7_type);
755: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level7_desc',p_level7_desc);
756: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level8' , p_level8);
757: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level8_name',p_level8_name);
758: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level8_type',p_level8_type);
759: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level8_desc',p_level8_desc);
760: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level9' , p_level9);
761: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level9_name',p_level9_name);

Line 758: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level8_type',p_level8_type);

754: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level7_type',p_level7_type);
755: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level7_desc',p_level7_desc);
756: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level8' , p_level8);
757: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level8_name',p_level8_name);
758: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level8_type',p_level8_type);
759: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level8_desc',p_level8_desc);
760: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level9' , p_level9);
761: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level9_name',p_level9_name);
762: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level9_type',p_level9_type);

Line 759: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level8_desc',p_level8_desc);

755: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level7_desc',p_level7_desc);
756: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level8' , p_level8);
757: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level8_name',p_level8_name);
758: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level8_type',p_level8_type);
759: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level8_desc',p_level8_desc);
760: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level9' , p_level9);
761: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level9_name',p_level9_name);
762: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level9_type',p_level9_type);
763: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level9_desc',p_level9_desc);

Line 760: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level9' , p_level9);

756: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level8' , p_level8);
757: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level8_name',p_level8_name);
758: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level8_type',p_level8_type);
759: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level8_desc',p_level8_desc);
760: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level9' , p_level9);
761: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level9_name',p_level9_name);
762: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level9_type',p_level9_type);
763: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level9_desc',p_level9_desc);
764: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level10' , p_level10);

Line 761: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level9_name',p_level9_name);

757: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level8_name',p_level8_name);
758: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level8_type',p_level8_type);
759: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level8_desc',p_level8_desc);
760: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level9' , p_level9);
761: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level9_name',p_level9_name);
762: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level9_type',p_level9_type);
763: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level9_desc',p_level9_desc);
764: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level10' , p_level10);
765: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level10_name',p_level10_name);

Line 762: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level9_type',p_level9_type);

758: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level8_type',p_level8_type);
759: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level8_desc',p_level8_desc);
760: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level9' , p_level9);
761: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level9_name',p_level9_name);
762: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level9_type',p_level9_type);
763: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level9_desc',p_level9_desc);
764: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level10' , p_level10);
765: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level10_name',p_level10_name);
766: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level10_type',p_level10_type);

Line 763: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level9_desc',p_level9_desc);

759: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level8_desc',p_level8_desc);
760: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level9' , p_level9);
761: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level9_name',p_level9_name);
762: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level9_type',p_level9_type);
763: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level9_desc',p_level9_desc);
764: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level10' , p_level10);
765: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level10_name',p_level10_name);
766: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level10_type',p_level10_type);
767: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level10_desc',p_level10_desc);

Line 764: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level10' , p_level10);

760: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level9' , p_level9);
761: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level9_name',p_level9_name);
762: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level9_type',p_level9_type);
763: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level9_desc',p_level9_desc);
764: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level10' , p_level10);
765: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level10_name',p_level10_name);
766: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level10_type',p_level10_type);
767: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level10_desc',p_level10_desc);
768: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level11' , p_level11);

Line 765: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level10_name',p_level10_name);

761: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level9_name',p_level9_name);
762: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level9_type',p_level9_type);
763: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level9_desc',p_level9_desc);
764: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level10' , p_level10);
765: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level10_name',p_level10_name);
766: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level10_type',p_level10_type);
767: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level10_desc',p_level10_desc);
768: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level11' , p_level11);
769: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level11_name',p_level11_name);

Line 766: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level10_type',p_level10_type);

762: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level9_type',p_level9_type);
763: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level9_desc',p_level9_desc);
764: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level10' , p_level10);
765: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level10_name',p_level10_name);
766: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level10_type',p_level10_type);
767: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level10_desc',p_level10_desc);
768: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level11' , p_level11);
769: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level11_name',p_level11_name);
770: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level11_type',p_level11_type);

Line 767: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level10_desc',p_level10_desc);

763: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level9_desc',p_level9_desc);
764: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level10' , p_level10);
765: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level10_name',p_level10_name);
766: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level10_type',p_level10_type);
767: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level10_desc',p_level10_desc);
768: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level11' , p_level11);
769: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level11_name',p_level11_name);
770: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level11_type',p_level11_type);
771: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level11_desc',p_level11_desc);

Line 768: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level11' , p_level11);

764: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level10' , p_level10);
765: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level10_name',p_level10_name);
766: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level10_type',p_level10_type);
767: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level10_desc',p_level10_desc);
768: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level11' , p_level11);
769: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level11_name',p_level11_name);
770: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level11_type',p_level11_type);
771: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level11_desc',p_level11_desc);
772: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level12' , p_level12);

Line 769: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level11_name',p_level11_name);

765: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level10_name',p_level10_name);
766: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level10_type',p_level10_type);
767: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level10_desc',p_level10_desc);
768: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level11' , p_level11);
769: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level11_name',p_level11_name);
770: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level11_type',p_level11_type);
771: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level11_desc',p_level11_desc);
772: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level12' , p_level12);
773: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level12_name',p_level12_name);

Line 770: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level11_type',p_level11_type);

766: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level10_type',p_level10_type);
767: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level10_desc',p_level10_desc);
768: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level11' , p_level11);
769: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level11_name',p_level11_name);
770: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level11_type',p_level11_type);
771: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level11_desc',p_level11_desc);
772: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level12' , p_level12);
773: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level12_name',p_level12_name);
774: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level12_type',p_level12_type);

Line 771: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level11_desc',p_level11_desc);

767: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level10_desc',p_level10_desc);
768: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level11' , p_level11);
769: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level11_name',p_level11_name);
770: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level11_type',p_level11_type);
771: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level11_desc',p_level11_desc);
772: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level12' , p_level12);
773: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level12_name',p_level12_name);
774: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level12_type',p_level12_type);
775: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level12_desc',p_level12_desc);

Line 772: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level12' , p_level12);

768: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level11' , p_level11);
769: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level11_name',p_level11_name);
770: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level11_type',p_level11_type);
771: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level11_desc',p_level11_desc);
772: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level12' , p_level12);
773: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level12_name',p_level12_name);
774: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level12_type',p_level12_type);
775: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level12_desc',p_level12_desc);
776: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level13' , p_level13);

Line 773: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level12_name',p_level12_name);

769: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level11_name',p_level11_name);
770: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level11_type',p_level11_type);
771: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level11_desc',p_level11_desc);
772: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level12' , p_level12);
773: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level12_name',p_level12_name);
774: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level12_type',p_level12_type);
775: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level12_desc',p_level12_desc);
776: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level13' , p_level13);
777: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level13_name',p_level13_name);

Line 774: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level12_type',p_level12_type);

770: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level11_type',p_level11_type);
771: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level11_desc',p_level11_desc);
772: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level12' , p_level12);
773: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level12_name',p_level12_name);
774: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level12_type',p_level12_type);
775: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level12_desc',p_level12_desc);
776: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level13' , p_level13);
777: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level13_name',p_level13_name);
778: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level13_type',p_level13_type);

Line 775: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level12_desc',p_level12_desc);

771: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level11_desc',p_level11_desc);
772: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level12' , p_level12);
773: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level12_name',p_level12_name);
774: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level12_type',p_level12_type);
775: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level12_desc',p_level12_desc);
776: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level13' , p_level13);
777: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level13_name',p_level13_name);
778: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level13_type',p_level13_type);
779: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level13_desc',p_level13_desc);

Line 776: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level13' , p_level13);

772: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level12' , p_level12);
773: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level12_name',p_level12_name);
774: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level12_type',p_level12_type);
775: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level12_desc',p_level12_desc);
776: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level13' , p_level13);
777: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level13_name',p_level13_name);
778: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level13_type',p_level13_type);
779: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level13_desc',p_level13_desc);
780: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level14' , p_level14);

Line 777: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level13_name',p_level13_name);

773: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level12_name',p_level12_name);
774: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level12_type',p_level12_type);
775: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level12_desc',p_level12_desc);
776: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level13' , p_level13);
777: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level13_name',p_level13_name);
778: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level13_type',p_level13_type);
779: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level13_desc',p_level13_desc);
780: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level14' , p_level14);
781: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level14_name',p_level14_name);

Line 778: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level13_type',p_level13_type);

774: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level12_type',p_level12_type);
775: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level12_desc',p_level12_desc);
776: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level13' , p_level13);
777: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level13_name',p_level13_name);
778: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level13_type',p_level13_type);
779: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level13_desc',p_level13_desc);
780: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level14' , p_level14);
781: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level14_name',p_level14_name);
782: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level14_type',p_level14_type);

Line 779: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level13_desc',p_level13_desc);

775: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level12_desc',p_level12_desc);
776: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level13' , p_level13);
777: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level13_name',p_level13_name);
778: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level13_type',p_level13_type);
779: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level13_desc',p_level13_desc);
780: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level14' , p_level14);
781: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level14_name',p_level14_name);
782: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level14_type',p_level14_type);
783: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level14_desc',p_level14_desc);

Line 780: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level14' , p_level14);

776: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level13' , p_level13);
777: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level13_name',p_level13_name);
778: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level13_type',p_level13_type);
779: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level13_desc',p_level13_desc);
780: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level14' , p_level14);
781: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level14_name',p_level14_name);
782: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level14_type',p_level14_type);
783: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level14_desc',p_level14_desc);
784: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level15' , p_level15);

Line 781: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level14_name',p_level14_name);

777: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level13_name',p_level13_name);
778: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level13_type',p_level13_type);
779: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level13_desc',p_level13_desc);
780: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level14' , p_level14);
781: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level14_name',p_level14_name);
782: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level14_type',p_level14_type);
783: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level14_desc',p_level14_desc);
784: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level15' , p_level15);
785: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level15_name',p_level15_name);

Line 782: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level14_type',p_level14_type);

778: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level13_type',p_level13_type);
779: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level13_desc',p_level13_desc);
780: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level14' , p_level14);
781: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level14_name',p_level14_name);
782: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level14_type',p_level14_type);
783: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level14_desc',p_level14_desc);
784: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level15' , p_level15);
785: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level15_name',p_level15_name);
786: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level15_type',p_level15_type);

Line 783: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level14_desc',p_level14_desc);

779: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level13_desc',p_level13_desc);
780: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level14' , p_level14);
781: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level14_name',p_level14_name);
782: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level14_type',p_level14_type);
783: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level14_desc',p_level14_desc);
784: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level15' , p_level15);
785: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level15_name',p_level15_name);
786: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level15_type',p_level15_type);
787: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level15_desc',p_level15_desc);

Line 784: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level15' , p_level15);

780: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level14' , p_level14);
781: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level14_name',p_level14_name);
782: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level14_type',p_level14_type);
783: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level14_desc',p_level14_desc);
784: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level15' , p_level15);
785: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level15_name',p_level15_name);
786: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level15_type',p_level15_type);
787: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level15_desc',p_level15_desc);
788: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_type_pk',p_type);

Line 785: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level15_name',p_level15_name);

781: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level14_name',p_level14_name);
782: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level14_type',p_level14_type);
783: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level14_desc',p_level14_desc);
784: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level15' , p_level15);
785: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level15_name',p_level15_name);
786: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level15_type',p_level15_type);
787: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level15_desc',p_level15_desc);
788: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_type_pk',p_type);
789: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_type_name',p_type);

Line 786: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level15_type',p_level15_type);

782: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level14_type',p_level14_type);
783: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level14_desc',p_level14_desc);
784: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level15' , p_level15);
785: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level15_name',p_level15_name);
786: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level15_type',p_level15_type);
787: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level15_desc',p_level15_desc);
788: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_type_pk',p_type);
789: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_type_name',p_type);
790: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_type_desc',p_type);

Line 787: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level15_desc',p_level15_desc);

783: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level14_desc',p_level14_desc);
784: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level15' , p_level15);
785: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level15_name',p_level15_name);
786: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level15_type',p_level15_type);
787: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level15_desc',p_level15_desc);
788: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_type_pk',p_type);
789: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_type_name',p_type);
790: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_type_desc',p_type);
791: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_all_pk', p_all_name );

Line 788: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_type_pk',p_type);

784: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level15' , p_level15);
785: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level15_name',p_level15_name);
786: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level15_type',p_level15_type);
787: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level15_desc',p_level15_desc);
788: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_type_pk',p_type);
789: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_type_name',p_type);
790: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_type_desc',p_type);
791: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_all_pk', p_all_name );
792: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_all_name',p_all_name);

Line 789: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_type_name',p_type);

785: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level15_name',p_level15_name);
786: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level15_type',p_level15_type);
787: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level15_desc',p_level15_desc);
788: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_type_pk',p_type);
789: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_type_name',p_type);
790: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_type_desc',p_type);
791: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_all_pk', p_all_name );
792: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_all_name',p_all_name);
793: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_all_desc',p_all_name);

Line 790: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_type_desc',p_type);

786: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level15_type',p_level15_type);
787: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level15_desc',p_level15_desc);
788: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_type_pk',p_type);
789: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_type_name',p_type);
790: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_type_desc',p_type);
791: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_all_pk', p_all_name );
792: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_all_name',p_all_name);
793: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_all_desc',p_all_name);
794: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_primarykey' ,p_pk);

Line 791: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_all_pk', p_all_name );

787: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_level15_desc',p_level15_desc);
788: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_type_pk',p_type);
789: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_type_name',p_type);
790: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_type_desc',p_type);
791: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_all_pk', p_all_name );
792: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_all_name',p_all_name);
793: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_all_desc',p_all_name);
794: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_primarykey' ,p_pk);
795:

Line 792: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_all_name',p_all_name);

788: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_type_pk',p_type);
789: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_type_name',p_type);
790: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_type_desc',p_type);
791: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_all_pk', p_all_name );
792: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_all_name',p_all_name);
793: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_all_desc',p_all_name);
794: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_primarykey' ,p_pk);
795:
796: p_RowsUpdated := DBMS_SQL.EXECUTE(p_CursorID);

Line 793: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_all_desc',p_all_name);

789: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_type_name',p_type);
790: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_type_desc',p_type);
791: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_all_pk', p_all_name );
792: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_all_name',p_all_name);
793: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_all_desc',p_all_name);
794: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_primarykey' ,p_pk);
795:
796: p_RowsUpdated := DBMS_SQL.EXECUTE(p_CursorID);
797:

Line 794: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_primarykey' ,p_pk);

790: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_type_desc',p_type);
791: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_all_pk', p_all_name );
792: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_all_name',p_all_name);
793: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_all_desc',p_all_name);
794: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_primarykey' ,p_pk);
795:
796: p_RowsUpdated := DBMS_SQL.EXECUTE(p_CursorID);
797:
798:

Line 796: p_RowsUpdated := DBMS_SQL.EXECUTE(p_CursorID);

792: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_all_name',p_all_name);
793: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_all_desc',p_all_name);
794: DBMS_SQL.BIND_VARIABLE(p_CursorID, ':b_primarykey' ,p_pk);
795:
796: p_RowsUpdated := DBMS_SQL.EXECUTE(p_CursorID);
797:
798:
799: IF p_RowsUpdated=0 THEN
800: begin

Line 872: l_cursor_id:=DBMS_SQL.OPEN_CURSOR;

868: ' where h115_pk = ''NA_EDW'' and h215_pk = ''NA_EDW''
869: and h315_pk = ''NA_EDW'' and h415_pk = ''NA_EDW''
870: order by l1_name';
871: VBHDEBUG('Executing : ' || l_select_stmt);
872: l_cursor_id:=DBMS_SQL.OPEN_CURSOR;
873: DBMS_SQL.parse(l_cursor_id,l_select_stmt,DBMS_SQL.V7);
874: DBMS_SQL.define_column(l_cursor_id,1,l_pk,240);
875: DBMS_SQL.define_column(l_cursor_id,2,l_name,80);
876: g_standalone:=DBMS_SQL.execute(l_cursor_id);

Line 873: DBMS_SQL.parse(l_cursor_id,l_select_stmt,DBMS_SQL.V7);

869: and h315_pk = ''NA_EDW'' and h415_pk = ''NA_EDW''
870: order by l1_name';
871: VBHDEBUG('Executing : ' || l_select_stmt);
872: l_cursor_id:=DBMS_SQL.OPEN_CURSOR;
873: DBMS_SQL.parse(l_cursor_id,l_select_stmt,DBMS_SQL.V7);
874: DBMS_SQL.define_column(l_cursor_id,1,l_pk,240);
875: DBMS_SQL.define_column(l_cursor_id,2,l_name,80);
876: g_standalone:=DBMS_SQL.execute(l_cursor_id);
877: g_standalone := 0;

Line 874: DBMS_SQL.define_column(l_cursor_id,1,l_pk,240);

870: order by l1_name';
871: VBHDEBUG('Executing : ' || l_select_stmt);
872: l_cursor_id:=DBMS_SQL.OPEN_CURSOR;
873: DBMS_SQL.parse(l_cursor_id,l_select_stmt,DBMS_SQL.V7);
874: DBMS_SQL.define_column(l_cursor_id,1,l_pk,240);
875: DBMS_SQL.define_column(l_cursor_id,2,l_name,80);
876: g_standalone:=DBMS_SQL.execute(l_cursor_id);
877: g_standalone := 0;
878: loop

Line 875: DBMS_SQL.define_column(l_cursor_id,2,l_name,80);

871: VBHDEBUG('Executing : ' || l_select_stmt);
872: l_cursor_id:=DBMS_SQL.OPEN_CURSOR;
873: DBMS_SQL.parse(l_cursor_id,l_select_stmt,DBMS_SQL.V7);
874: DBMS_SQL.define_column(l_cursor_id,1,l_pk,240);
875: DBMS_SQL.define_column(l_cursor_id,2,l_name,80);
876: g_standalone:=DBMS_SQL.execute(l_cursor_id);
877: g_standalone := 0;
878: loop
879: if DBMS_SQL.fetch_rows(l_cursor_id)=0 then

Line 876: g_standalone:=DBMS_SQL.execute(l_cursor_id);

872: l_cursor_id:=DBMS_SQL.OPEN_CURSOR;
873: DBMS_SQL.parse(l_cursor_id,l_select_stmt,DBMS_SQL.V7);
874: DBMS_SQL.define_column(l_cursor_id,1,l_pk,240);
875: DBMS_SQL.define_column(l_cursor_id,2,l_name,80);
876: g_standalone:=DBMS_SQL.execute(l_cursor_id);
877: g_standalone := 0;
878: loop
879: if DBMS_SQL.fetch_rows(l_cursor_id)=0 then
880: exit;

Line 879: if DBMS_SQL.fetch_rows(l_cursor_id)=0 then

875: DBMS_SQL.define_column(l_cursor_id,2,l_name,80);
876: g_standalone:=DBMS_SQL.execute(l_cursor_id);
877: g_standalone := 0;
878: loop
879: if DBMS_SQL.fetch_rows(l_cursor_id)=0 then
880: exit;
881: end if;
882: if g_standalone<= g_err_smp_size then
883: DBMS_SQL.column_value (l_cursor_id,1,l_pk);

Line 883: DBMS_SQL.column_value (l_cursor_id,1,l_pk);

879: if DBMS_SQL.fetch_rows(l_cursor_id)=0 then
880: exit;
881: end if;
882: if g_standalone<= g_err_smp_size then
883: DBMS_SQL.column_value (l_cursor_id,1,l_pk);
884: DBMS_SQL.column_value (l_cursor_id,2,l_name);
885: VBHDEBUG('Stand alone value : '||'pk:'||l_pk||' name:'||l_name);
886: end if;
887: g_standalone := g_standalone + 1;

Line 884: DBMS_SQL.column_value (l_cursor_id,2,l_name);

880: exit;
881: end if;
882: if g_standalone<= g_err_smp_size then
883: DBMS_SQL.column_value (l_cursor_id,1,l_pk);
884: DBMS_SQL.column_value (l_cursor_id,2,l_name);
885: VBHDEBUG('Stand alone value : '||'pk:'||l_pk||' name:'||l_name);
886: end if;
887: g_standalone := g_standalone + 1;
888: end loop;

Line 889: DBMS_SQL.close_cursor(l_cursor_id);

885: VBHDEBUG('Stand alone value : '||'pk:'||l_pk||' name:'||l_name);
886: end if;
887: g_standalone := g_standalone + 1;
888: end loop;
889: DBMS_SQL.close_cursor(l_cursor_id);
890: exception
891: when others then
892: edw_log.put_line( 'Error : When checking stand alone node. '||sqlcode||' : '||sqlerrm);
893: raise;

Line 935: DBMS_SQL.CLOSE_CURSOR(p_CursorID);

931: end;
932:
933: PROCEDURE CLOSE_UPDATE( p_CursorID IN OUT NOCOPY INTEGER) IS
934: BEGIN
935: DBMS_SQL.CLOSE_CURSOR(p_CursorID);
936: VBHDEBUG('Closed the update statement cursor');
937: VBHDEBUG(' ');
938: END;
939:

Line 946: l_CursorID := DBMS_SQL.OPEN_CURSOR;

942: IS
943: l_CursorID INTEGER;
944: l_UpdateStmt varchar2(4000);
945: BEGIN
946: l_CursorID := DBMS_SQL.OPEN_CURSOR;
947: l_UpdateStmt :=
948: 'UPDATE '|| g_dimension_name||'
949: SET LAST_UPDATE_DATE=sysdate,
950: l1_type=:b_type,'

Line 1015: DBMS_SQL.PARSE(l_CursorID,l_UpdateStmt,DBMS_SQL.V7);

1011: ||' all_name =:b_all_name,'
1012: ||' all_description =:b_all_desc'
1013: ||' WHERE l1_pk= :b_primarykey AND h'||p_hierachy_no||'02_pk = ''NA_EDW''';
1014:
1015: DBMS_SQL.PARSE(l_CursorID,l_UpdateStmt,DBMS_SQL.V7);
1016: VBHDEBUG('Parsed the update statement for hierarchy ' || p_hierachy_no );
1017: return l_CursorID;
1018: END PARSE_UPDATE;
1019: