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.PSB_BUDGET_ACCOUNT_PVT dependencies on DBMS_SQL

Line 582: l_cursor_id := dbms_sql.open_cursor;

578: ' AND glcc.enabled_flag = ''Y''' ||
579: ' AND glcc.detail_budgeting_allowed_flag = ''Y''' ||
580: */
581:
582: l_cursor_id := dbms_sql.open_cursor;
583:
584: IF p_include_or_exclude_type = 'I' THEN
585: --
586: l_sql_insert := l_sql_insert ||

Line 596: dbms_sql.parse(l_cursor_id, l_sql_insert, dbms_sql.v7);

592: ' WHERE account_position_set_id = :account_set_id' ||
593: ' AND code_combination_id = glcc.code_combination_id )' ;
594:
595: -- Parsing the statement.
596: dbms_sql.parse(l_cursor_id, l_sql_insert, dbms_sql.v7);
597:
598: -- Binding variables.
599: dbms_sql.bind_variable(l_cursor_id, ':account_set_id',
600: g_account_set_id);

Line 599: dbms_sql.bind_variable(l_cursor_id, ':account_set_id',

595: -- Parsing the statement.
596: dbms_sql.parse(l_cursor_id, l_sql_insert, dbms_sql.v7);
597:
598: -- Binding variables.
599: dbms_sql.bind_variable(l_cursor_id, ':account_set_id',
600: g_account_set_id);
601: --
602: dbms_sql.bind_variable(l_cursor_id, ':set_of_books_id',
603: g_set_of_books_id);

Line 602: dbms_sql.bind_variable(l_cursor_id, ':set_of_books_id',

598: -- Binding variables.
599: dbms_sql.bind_variable(l_cursor_id, ':account_set_id',
600: g_account_set_id);
601: --
602: dbms_sql.bind_variable(l_cursor_id, ':set_of_books_id',
603: g_set_of_books_id);
604: --
605: dbms_sql.bind_variable(l_cursor_id, ':last_update_date',
606: g_current_date);

Line 605: dbms_sql.bind_variable(l_cursor_id, ':last_update_date',

601: --
602: dbms_sql.bind_variable(l_cursor_id, ':set_of_books_id',
603: g_set_of_books_id);
604: --
605: dbms_sql.bind_variable(l_cursor_id, ':last_update_date',
606: g_current_date);
607: --
608: dbms_sql.bind_variable(l_cursor_id, ':last_updated_by',
609: g_current_user_id);

Line 608: dbms_sql.bind_variable(l_cursor_id, ':last_updated_by',

604: --
605: dbms_sql.bind_variable(l_cursor_id, ':last_update_date',
606: g_current_date);
607: --
608: dbms_sql.bind_variable(l_cursor_id, ':last_updated_by',
609: g_current_user_id);
610: --
611: dbms_sql.bind_variable(l_cursor_id, ':last_update_login',
612: g_current_login_id);

Line 611: dbms_sql.bind_variable(l_cursor_id, ':last_update_login',

607: --
608: dbms_sql.bind_variable(l_cursor_id, ':last_updated_by',
609: g_current_user_id);
610: --
611: dbms_sql.bind_variable(l_cursor_id, ':last_update_login',
612: g_current_login_id);
613: --
614: dbms_sql.bind_variable(l_cursor_id, ':created_by',
615: g_current_user_id);

Line 614: dbms_sql.bind_variable(l_cursor_id, ':created_by',

610: --
611: dbms_sql.bind_variable(l_cursor_id, ':last_update_login',
612: g_current_login_id);
613: --
614: dbms_sql.bind_variable(l_cursor_id, ':created_by',
615: g_current_user_id);
616: --
617: dbms_sql.bind_variable(l_cursor_id, ':creation_date',
618: g_current_date);

Line 617: dbms_sql.bind_variable(l_cursor_id, ':creation_date',

613: --
614: dbms_sql.bind_variable(l_cursor_id, ':created_by',
615: g_current_user_id);
616: --
617: dbms_sql.bind_variable(l_cursor_id, ':creation_date',
618: g_current_date);
619: --
620: pd('Max Code = ' || to_char(g_max_code_combination_id));
621: --

Line 622: dbms_sql.bind_variable(l_cursor_id, ':max_code_combination_id',

618: g_current_date);
619: --
620: pd('Max Code = ' || to_char(g_max_code_combination_id));
621: --
622: dbms_sql.bind_variable(l_cursor_id, ':max_code_combination_id',
623: g_max_code_combination_id);
624: --
625: dbms_sql.bind_variable(l_cursor_id, ':chart_of_accounts_id',
626: g_chart_of_accounts_id);

Line 625: dbms_sql.bind_variable(l_cursor_id, ':chart_of_accounts_id',

621: --
622: dbms_sql.bind_variable(l_cursor_id, ':max_code_combination_id',
623: g_max_code_combination_id);
624: --
625: dbms_sql.bind_variable(l_cursor_id, ':chart_of_accounts_id',
626: g_chart_of_accounts_id);
627: --
628: dbms_sql.bind_variable(l_cursor_id, ':line_sequence_id',
629: p_line_sequence_id);

Line 628: dbms_sql.bind_variable(l_cursor_id, ':line_sequence_id',

624: --
625: dbms_sql.bind_variable(l_cursor_id, ':chart_of_accounts_id',
626: g_chart_of_accounts_id);
627: --
628: dbms_sql.bind_variable(l_cursor_id, ':line_sequence_id',
629: p_line_sequence_id);
630: ELSE
631: --
632: l_sql_delete := l_sql_delete || l_sql_tmp || ')';

Line 635: dbms_sql.parse(l_cursor_id, l_sql_delete, dbms_sql.v7);

631: --
632: l_sql_delete := l_sql_delete || l_sql_tmp || ')';
633:
634: -- Parsing the statement.
635: dbms_sql.parse(l_cursor_id, l_sql_delete, dbms_sql.v7);
636:
637: -- Binding variables.
638: dbms_sql.bind_variable(l_cursor_id, ':account_set_id',
639: g_account_set_id);

Line 638: dbms_sql.bind_variable(l_cursor_id, ':account_set_id',

634: -- Parsing the statement.
635: dbms_sql.parse(l_cursor_id, l_sql_delete, dbms_sql.v7);
636:
637: -- Binding variables.
638: dbms_sql.bind_variable(l_cursor_id, ':account_set_id',
639: g_account_set_id);
640: --
641: dbms_sql.bind_variable(l_cursor_id, ':max_code_combination_id',
642: g_max_code_combination_id);

Line 641: dbms_sql.bind_variable(l_cursor_id, ':max_code_combination_id',

637: -- Binding variables.
638: dbms_sql.bind_variable(l_cursor_id, ':account_set_id',
639: g_account_set_id);
640: --
641: dbms_sql.bind_variable(l_cursor_id, ':max_code_combination_id',
642: g_max_code_combination_id);
643: --
644: dbms_sql.bind_variable(l_cursor_id, ':chart_of_accounts_id',
645: g_chart_of_accounts_id);

Line 644: dbms_sql.bind_variable(l_cursor_id, ':chart_of_accounts_id',

640: --
641: dbms_sql.bind_variable(l_cursor_id, ':max_code_combination_id',
642: g_max_code_combination_id);
643: --
644: dbms_sql.bind_variable(l_cursor_id, ':chart_of_accounts_id',
645: g_chart_of_accounts_id);
646: --
647: dbms_sql.bind_variable(l_cursor_id, ':line_sequence_id',
648: p_line_sequence_id);

Line 647: dbms_sql.bind_variable(l_cursor_id, ':line_sequence_id',

643: --
644: dbms_sql.bind_variable(l_cursor_id, ':chart_of_accounts_id',
645: g_chart_of_accounts_id);
646: --
647: dbms_sql.bind_variable(l_cursor_id, ':line_sequence_id',
648: p_line_sequence_id);
649: --
650: END IF;
651: --

Line 652: l_rows_processed := dbms_sql.execute(l_cursor_id);

648: p_line_sequence_id);
649: --
650: END IF;
651: --
652: l_rows_processed := dbms_sql.execute(l_cursor_id);
653: --
654:
655: /* Used during debugging
656: pd( 'Set = ' || g_account_set_id || ' Line = ' ||

Line 663: dbms_sql.close_cursor(l_cursor_id);

659: l_rows_processed );
660: */
661:
662: pd( 'Processing Account Set = ' || g_account_set_id );
663: dbms_sql.close_cursor(l_cursor_id);
664:
665: pd('Make_Account_Assignments Done (T)');
666: RETURN (TRUE);
667:

Line 670: IF dbms_sql.is_open(l_cursor_id) THEN

666: RETURN (TRUE);
667:
668: EXCEPTION
669: WHEN OTHERS THEN
670: IF dbms_sql.is_open(l_cursor_id) THEN
671: dbms_sql.close_cursor(l_cursor_id);
672: END IF;
673: --
674: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN

Line 671: dbms_sql.close_cursor(l_cursor_id);

667:
668: EXCEPTION
669: WHEN OTHERS THEN
670: IF dbms_sql.is_open(l_cursor_id) THEN
671: dbms_sql.close_cursor(l_cursor_id);
672: END IF;
673: --
674: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
675: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,