493: l_sql_stmt := l_sql_stmt || ' AND LNG.INSTALLED_FLAG IN (''I'',''B'')';
494:
495:
496: l_debug_stmt := l_sql_stmt;
497: l_cursor := DBMS_SQL.Open_Cursor;
498: DBMS_SQL.Parse(l_cursor, l_sql_stmt, DBMS_SQL.native);
499: l_ignore := DBMS_SQL.Execute(l_cursor);
500: DBMS_SQL.Close_Cursor(l_cursor);
501: End Loop;
494:
495:
496: l_debug_stmt := l_sql_stmt;
497: l_cursor := DBMS_SQL.Open_Cursor;
498: DBMS_SQL.Parse(l_cursor, l_sql_stmt, DBMS_SQL.native);
499: l_ignore := DBMS_SQL.Execute(l_cursor);
500: DBMS_SQL.Close_Cursor(l_cursor);
501: End Loop;
502:
495:
496: l_debug_stmt := l_sql_stmt;
497: l_cursor := DBMS_SQL.Open_Cursor;
498: DBMS_SQL.Parse(l_cursor, l_sql_stmt, DBMS_SQL.native);
499: l_ignore := DBMS_SQL.Execute(l_cursor);
500: DBMS_SQL.Close_Cursor(l_cursor);
501: End Loop;
502:
503: end if; -- is_cross_template
496: l_debug_stmt := l_sql_stmt;
497: l_cursor := DBMS_SQL.Open_Cursor;
498: DBMS_SQL.Parse(l_cursor, l_sql_stmt, DBMS_SQL.native);
499: l_ignore := DBMS_SQL.Execute(l_cursor);
500: DBMS_SQL.Close_Cursor(l_cursor);
501: End Loop;
502:
503: end if; -- is_cross_template
504:
527: l_sql_stmt := l_sql_stmt || ' AND FEM_ALIAS.LANGUAGE =userenv(''LANG'')';
528: l_sql_stmt := l_sql_stmt || ' AND LNG.INSTALLED_FLAG IN (''I'',''B'')';
529:
530: l_debug_stmt := l_sql_stmt;
531: l_cursor := DBMS_SQL.Open_Cursor;
532: DBMS_SQL.Parse(l_cursor, l_sql_stmt, DBMS_SQL.native);
533: l_ignore := DBMS_SQL.Execute(l_cursor);
534: DBMS_SQL.Close_Cursor(l_cursor);
535:
528: l_sql_stmt := l_sql_stmt || ' AND LNG.INSTALLED_FLAG IN (''I'',''B'')';
529:
530: l_debug_stmt := l_sql_stmt;
531: l_cursor := DBMS_SQL.Open_Cursor;
532: DBMS_SQL.Parse(l_cursor, l_sql_stmt, DBMS_SQL.native);
533: l_ignore := DBMS_SQL.Execute(l_cursor);
534: DBMS_SQL.Close_Cursor(l_cursor);
535:
536: End Loop;
529:
530: l_debug_stmt := l_sql_stmt;
531: l_cursor := DBMS_SQL.Open_Cursor;
532: DBMS_SQL.Parse(l_cursor, l_sql_stmt, DBMS_SQL.native);
533: l_ignore := DBMS_SQL.Execute(l_cursor);
534: DBMS_SQL.Close_Cursor(l_cursor);
535:
536: End Loop;
537:
530: l_debug_stmt := l_sql_stmt;
531: l_cursor := DBMS_SQL.Open_Cursor;
532: DBMS_SQL.Parse(l_cursor, l_sql_stmt, DBMS_SQL.native);
533: l_ignore := DBMS_SQL.Execute(l_cursor);
534: DBMS_SQL.Close_Cursor(l_cursor);
535:
536: End Loop;
537:
538: -- Insert records into BSC_D_ACCOUNT and BSC_D_SUBACCOUNT
564: l_sql_stmt := l_sql_stmt || ' AND FEM_ALIAS.LANGUAGE =userenv(''LANG'')';
565: l_sql_stmt := l_sql_stmt || ' AND LNG.INSTALLED_FLAG IN (''I'',''B'')';
566:
567: l_debug_stmt := l_sql_stmt;
568: l_cursor := DBMS_SQL.Open_Cursor;
569: DBMS_SQL.Parse(l_cursor, l_sql_stmt, DBMS_SQL.native);
570: l_ignore := DBMS_SQL.Execute(l_cursor);
571: DBMS_SQL.Close_Cursor(l_cursor);
572:
565: l_sql_stmt := l_sql_stmt || ' AND LNG.INSTALLED_FLAG IN (''I'',''B'')';
566:
567: l_debug_stmt := l_sql_stmt;
568: l_cursor := DBMS_SQL.Open_Cursor;
569: DBMS_SQL.Parse(l_cursor, l_sql_stmt, DBMS_SQL.native);
570: l_ignore := DBMS_SQL.Execute(l_cursor);
571: DBMS_SQL.Close_Cursor(l_cursor);
572:
573: -- FEM_ALIAS translation -Same itemns from maccount
566:
567: l_debug_stmt := l_sql_stmt;
568: l_cursor := DBMS_SQL.Open_Cursor;
569: DBMS_SQL.Parse(l_cursor, l_sql_stmt, DBMS_SQL.native);
570: l_ignore := DBMS_SQL.Execute(l_cursor);
571: DBMS_SQL.Close_Cursor(l_cursor);
572:
573: -- FEM_ALIAS translation -Same itemns from maccount
574: l_sql_stmt := 'INSERT INTO BSC_D_SUBACCOUNT ' ||
567: l_debug_stmt := l_sql_stmt;
568: l_cursor := DBMS_SQL.Open_Cursor;
569: DBMS_SQL.Parse(l_cursor, l_sql_stmt, DBMS_SQL.native);
570: l_ignore := DBMS_SQL.Execute(l_cursor);
571: DBMS_SQL.Close_Cursor(l_cursor);
572:
573: -- FEM_ALIAS translation -Same itemns from maccount
574: l_sql_stmt := 'INSERT INTO BSC_D_SUBACCOUNT ' ||
575: ' (CODE,LANGUAGE,SOURCE_LANG,USER_CODE,NAME,ACCOUNT_CODE,ACCOUNT_CODE_USR) ' ||
594: l_sql_stmt := l_sql_stmt || ' AND LNG.INSTALLED_FLAG IN (''I'',''B'')';
595:
596:
597: l_debug_stmt := l_sql_stmt;
598: l_cursor := DBMS_SQL.Open_Cursor;
599: DBMS_SQL.Parse(l_cursor, l_sql_stmt, DBMS_SQL.native);
600: l_ignore := DBMS_SQL.Execute(l_cursor);
601: DBMS_SQL.Close_Cursor(l_cursor);
602:
595:
596:
597: l_debug_stmt := l_sql_stmt;
598: l_cursor := DBMS_SQL.Open_Cursor;
599: DBMS_SQL.Parse(l_cursor, l_sql_stmt, DBMS_SQL.native);
600: l_ignore := DBMS_SQL.Execute(l_cursor);
601: DBMS_SQL.Close_Cursor(l_cursor);
602:
603: End Loop; -- i_acct_ind
596:
597: l_debug_stmt := l_sql_stmt;
598: l_cursor := DBMS_SQL.Open_Cursor;
599: DBMS_SQL.Parse(l_cursor, l_sql_stmt, DBMS_SQL.native);
600: l_ignore := DBMS_SQL.Execute(l_cursor);
601: DBMS_SQL.Close_Cursor(l_cursor);
602:
603: End Loop; -- i_acct_ind
604:
597: l_debug_stmt := l_sql_stmt;
598: l_cursor := DBMS_SQL.Open_Cursor;
599: DBMS_SQL.Parse(l_cursor, l_sql_stmt, DBMS_SQL.native);
600: l_ignore := DBMS_SQL.Execute(l_cursor);
601: DBMS_SQL.Close_Cursor(l_cursor);
602:
603: End Loop; -- i_acct_ind
604:
605: --