DBA Data[Home] [Help]

APPS.BSC_DIM_TPLATE dependencies on DBMS_SQL

Line 497: l_cursor := DBMS_SQL.Open_Cursor;

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;

Line 498: DBMS_SQL.Parse(l_cursor, l_sql_stmt, DBMS_SQL.native);

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:

Line 499: l_ignore := DBMS_SQL.Execute(l_cursor);

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

Line 500: DBMS_SQL.Close_Cursor(l_cursor);

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:

Line 531: l_cursor := DBMS_SQL.Open_Cursor;

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:

Line 532: DBMS_SQL.Parse(l_cursor, l_sql_stmt, DBMS_SQL.native);

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;

Line 533: l_ignore := DBMS_SQL.Execute(l_cursor);

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:

Line 534: DBMS_SQL.Close_Cursor(l_cursor);

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

Line 568: l_cursor := DBMS_SQL.Open_Cursor;

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:

Line 569: DBMS_SQL.Parse(l_cursor, l_sql_stmt, DBMS_SQL.native);

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

Line 570: l_ignore := DBMS_SQL.Execute(l_cursor);

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 ' ||

Line 571: DBMS_SQL.Close_Cursor(l_cursor);

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) ' ||

Line 598: l_cursor := DBMS_SQL.Open_Cursor;

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:

Line 599: DBMS_SQL.Parse(l_cursor, l_sql_stmt, DBMS_SQL.native);

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

Line 600: l_ignore := DBMS_SQL.Execute(l_cursor);

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:

Line 601: DBMS_SQL.Close_Cursor(l_cursor);

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: --