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

Line 1809: insert_cursor := dbms_sql.open_cursor;

1805: dbms_output.put_line(buf10);
1806: */
1807:
1808: -- OPEN the insert cursor
1809: insert_cursor := dbms_sql.open_cursor;
1810:
1811: if (g_print_debug) then
1812: fa_debug_pkg.add('insert_ret_earnings',
1813: 'Open cursor',

Line 1817: dbms_sql.parse(insert_cursor, G_insert_buf, dbms_sql.v7);

1813: 'Open cursor',
1814: 'success');
1815: end if;
1816: -- parse the insert smt
1817: dbms_sql.parse(insert_cursor, G_insert_buf, dbms_sql.v7);
1818:
1819: if (g_print_debug) then
1820: fa_debug_pkg.add('insert_ret_earnings',
1821: 'Parse cursor',

Line 1827: dbms_sql.bind_variable(insert_cursor, ':category',G_category_name );

1823: end if;
1824:
1825: -- bind all input variables
1826:
1827: dbms_sql.bind_variable(insert_cursor, ':category',G_category_name );
1828: dbms_sql.bind_variable(insert_cursor, ':status', G_status);
1829: dbms_sql.bind_variable(insert_cursor, ':actual_flag', G_actual_flag);
1830: dbms_sql.bind_variable(insert_cursor, ':fcurrency', G_from_currency);
1831: dbms_sql.bind_variable(insert_cursor, ':date_created', sysdate);

Line 1828: dbms_sql.bind_variable(insert_cursor, ':status', G_status);

1824:
1825: -- bind all input variables
1826:
1827: dbms_sql.bind_variable(insert_cursor, ':category',G_category_name );
1828: dbms_sql.bind_variable(insert_cursor, ':status', G_status);
1829: dbms_sql.bind_variable(insert_cursor, ':actual_flag', G_actual_flag);
1830: dbms_sql.bind_variable(insert_cursor, ':fcurrency', G_from_currency);
1831: dbms_sql.bind_variable(insert_cursor, ':date_created', sysdate);
1832: dbms_sql.bind_variable(insert_cursor, ':acc_date',G_accounting_date);

Line 1829: dbms_sql.bind_variable(insert_cursor, ':actual_flag', G_actual_flag);

1825: -- bind all input variables
1826:
1827: dbms_sql.bind_variable(insert_cursor, ':category',G_category_name );
1828: dbms_sql.bind_variable(insert_cursor, ':status', G_status);
1829: dbms_sql.bind_variable(insert_cursor, ':actual_flag', G_actual_flag);
1830: dbms_sql.bind_variable(insert_cursor, ':fcurrency', G_from_currency);
1831: dbms_sql.bind_variable(insert_cursor, ':date_created', sysdate);
1832: dbms_sql.bind_variable(insert_cursor, ':acc_date',G_accounting_date);
1833: dbms_sql.bind_variable(insert_cursor, ':source',G_source_name );

Line 1830: dbms_sql.bind_variable(insert_cursor, ':fcurrency', G_from_currency);

1826:
1827: dbms_sql.bind_variable(insert_cursor, ':category',G_category_name );
1828: dbms_sql.bind_variable(insert_cursor, ':status', G_status);
1829: dbms_sql.bind_variable(insert_cursor, ':actual_flag', G_actual_flag);
1830: dbms_sql.bind_variable(insert_cursor, ':fcurrency', G_from_currency);
1831: dbms_sql.bind_variable(insert_cursor, ':date_created', sysdate);
1832: dbms_sql.bind_variable(insert_cursor, ':acc_date',G_accounting_date);
1833: dbms_sql.bind_variable(insert_cursor, ':source',G_source_name );
1834: dbms_sql.bind_variable(insert_cursor, ':group_id', G_group_id);

Line 1831: dbms_sql.bind_variable(insert_cursor, ':date_created', sysdate);

1827: dbms_sql.bind_variable(insert_cursor, ':category',G_category_name );
1828: dbms_sql.bind_variable(insert_cursor, ':status', G_status);
1829: dbms_sql.bind_variable(insert_cursor, ':actual_flag', G_actual_flag);
1830: dbms_sql.bind_variable(insert_cursor, ':fcurrency', G_from_currency);
1831: dbms_sql.bind_variable(insert_cursor, ':date_created', sysdate);
1832: dbms_sql.bind_variable(insert_cursor, ':acc_date',G_accounting_date);
1833: dbms_sql.bind_variable(insert_cursor, ':source',G_source_name );
1834: dbms_sql.bind_variable(insert_cursor, ':group_id', G_group_id);
1835: dbms_sql.bind_variable(insert_cursor, ':rsob_id', p_rsob_id);

Line 1832: dbms_sql.bind_variable(insert_cursor, ':acc_date',G_accounting_date);

1828: dbms_sql.bind_variable(insert_cursor, ':status', G_status);
1829: dbms_sql.bind_variable(insert_cursor, ':actual_flag', G_actual_flag);
1830: dbms_sql.bind_variable(insert_cursor, ':fcurrency', G_from_currency);
1831: dbms_sql.bind_variable(insert_cursor, ':date_created', sysdate);
1832: dbms_sql.bind_variable(insert_cursor, ':acc_date',G_accounting_date);
1833: dbms_sql.bind_variable(insert_cursor, ':source',G_source_name );
1834: dbms_sql.bind_variable(insert_cursor, ':group_id', G_group_id);
1835: dbms_sql.bind_variable(insert_cursor, ':rsob_id', p_rsob_id);
1836: dbms_sql.bind_variable(insert_cursor, ':coa_id', G_coa_id);

Line 1833: dbms_sql.bind_variable(insert_cursor, ':source',G_source_name );

1829: dbms_sql.bind_variable(insert_cursor, ':actual_flag', G_actual_flag);
1830: dbms_sql.bind_variable(insert_cursor, ':fcurrency', G_from_currency);
1831: dbms_sql.bind_variable(insert_cursor, ':date_created', sysdate);
1832: dbms_sql.bind_variable(insert_cursor, ':acc_date',G_accounting_date);
1833: dbms_sql.bind_variable(insert_cursor, ':source',G_source_name );
1834: dbms_sql.bind_variable(insert_cursor, ':group_id', G_group_id);
1835: dbms_sql.bind_variable(insert_cursor, ':rsob_id', p_rsob_id);
1836: dbms_sql.bind_variable(insert_cursor, ':coa_id', G_coa_id);
1837: dbms_sql.bind_variable(insert_cursor, ':re_ccid', G_re_ccid);

Line 1834: dbms_sql.bind_variable(insert_cursor, ':group_id', G_group_id);

1830: dbms_sql.bind_variable(insert_cursor, ':fcurrency', G_from_currency);
1831: dbms_sql.bind_variable(insert_cursor, ':date_created', sysdate);
1832: dbms_sql.bind_variable(insert_cursor, ':acc_date',G_accounting_date);
1833: dbms_sql.bind_variable(insert_cursor, ':source',G_source_name );
1834: dbms_sql.bind_variable(insert_cursor, ':group_id', G_group_id);
1835: dbms_sql.bind_variable(insert_cursor, ':rsob_id', p_rsob_id);
1836: dbms_sql.bind_variable(insert_cursor, ':coa_id', G_coa_id);
1837: dbms_sql.bind_variable(insert_cursor, ':re_ccid', G_re_ccid);
1838:

Line 1835: dbms_sql.bind_variable(insert_cursor, ':rsob_id', p_rsob_id);

1831: dbms_sql.bind_variable(insert_cursor, ':date_created', sysdate);
1832: dbms_sql.bind_variable(insert_cursor, ':acc_date',G_accounting_date);
1833: dbms_sql.bind_variable(insert_cursor, ':source',G_source_name );
1834: dbms_sql.bind_variable(insert_cursor, ':group_id', G_group_id);
1835: dbms_sql.bind_variable(insert_cursor, ':rsob_id', p_rsob_id);
1836: dbms_sql.bind_variable(insert_cursor, ':coa_id', G_coa_id);
1837: dbms_sql.bind_variable(insert_cursor, ':re_ccid', G_re_ccid);
1838:
1839: l_row_count := dbms_sql.execute(insert_cursor);

Line 1836: dbms_sql.bind_variable(insert_cursor, ':coa_id', G_coa_id);

1832: dbms_sql.bind_variable(insert_cursor, ':acc_date',G_accounting_date);
1833: dbms_sql.bind_variable(insert_cursor, ':source',G_source_name );
1834: dbms_sql.bind_variable(insert_cursor, ':group_id', G_group_id);
1835: dbms_sql.bind_variable(insert_cursor, ':rsob_id', p_rsob_id);
1836: dbms_sql.bind_variable(insert_cursor, ':coa_id', G_coa_id);
1837: dbms_sql.bind_variable(insert_cursor, ':re_ccid', G_re_ccid);
1838:
1839: l_row_count := dbms_sql.execute(insert_cursor);
1840:

Line 1837: dbms_sql.bind_variable(insert_cursor, ':re_ccid', G_re_ccid);

1833: dbms_sql.bind_variable(insert_cursor, ':source',G_source_name );
1834: dbms_sql.bind_variable(insert_cursor, ':group_id', G_group_id);
1835: dbms_sql.bind_variable(insert_cursor, ':rsob_id', p_rsob_id);
1836: dbms_sql.bind_variable(insert_cursor, ':coa_id', G_coa_id);
1837: dbms_sql.bind_variable(insert_cursor, ':re_ccid', G_re_ccid);
1838:
1839: l_row_count := dbms_sql.execute(insert_cursor);
1840:
1841: if (g_print_debug) then

Line 1839: l_row_count := dbms_sql.execute(insert_cursor);

1835: dbms_sql.bind_variable(insert_cursor, ':rsob_id', p_rsob_id);
1836: dbms_sql.bind_variable(insert_cursor, ':coa_id', G_coa_id);
1837: dbms_sql.bind_variable(insert_cursor, ':re_ccid', G_re_ccid);
1838:
1839: l_row_count := dbms_sql.execute(insert_cursor);
1840:
1841: if (g_print_debug) then
1842: fa_debug_pkg.add('insert_ret_earnings',
1843: 'Number of retained earnings rows inserted',

Line 1846: dbms_sql.close_cursor(insert_cursor);

1842: fa_debug_pkg.add('insert_ret_earnings',
1843: 'Number of retained earnings rows inserted',
1844: l_row_count);
1845: end if;
1846: dbms_sql.close_cursor(insert_cursor);
1847:
1848: if (g_print_debug) then
1849: fa_debug_pkg.add('calculate_balances',
1850: 'Inserting retained earnings in GL_INTERFACE',