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 1818: insert_cursor := dbms_sql.open_cursor;

1814: dbms_output.put_line(buf10);
1815: */
1816:
1817: -- OPEN the insert cursor
1818: insert_cursor := dbms_sql.open_cursor;
1819:
1820: if (g_print_debug) then
1821: fa_debug_pkg.add('insert_ret_earnings',
1822: 'Open cursor',

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

1822: 'Open cursor',
1823: 'success');
1824: end if;
1825: -- parse the insert smt
1826: dbms_sql.parse(insert_cursor, G_insert_buf, dbms_sql.v7);
1827:
1828: if (g_print_debug) then
1829: fa_debug_pkg.add('insert_ret_earnings',
1830: 'Parse cursor',

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

1832: end if;
1833:
1834: -- bind all input variables
1835:
1836: dbms_sql.bind_variable(insert_cursor, ':category',G_category_name );
1837: dbms_sql.bind_variable(insert_cursor, ':status', G_status);
1838: dbms_sql.bind_variable(insert_cursor, ':actual_flag', G_actual_flag);
1839: dbms_sql.bind_variable(insert_cursor, ':fcurrency', G_from_currency);
1840: dbms_sql.bind_variable(insert_cursor, ':date_created', sysdate);

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

1833:
1834: -- bind all input variables
1835:
1836: dbms_sql.bind_variable(insert_cursor, ':category',G_category_name );
1837: dbms_sql.bind_variable(insert_cursor, ':status', G_status);
1838: dbms_sql.bind_variable(insert_cursor, ':actual_flag', G_actual_flag);
1839: dbms_sql.bind_variable(insert_cursor, ':fcurrency', G_from_currency);
1840: dbms_sql.bind_variable(insert_cursor, ':date_created', sysdate);
1841: dbms_sql.bind_variable(insert_cursor, ':acc_date',G_accounting_date);

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

1834: -- bind all input variables
1835:
1836: dbms_sql.bind_variable(insert_cursor, ':category',G_category_name );
1837: dbms_sql.bind_variable(insert_cursor, ':status', G_status);
1838: dbms_sql.bind_variable(insert_cursor, ':actual_flag', G_actual_flag);
1839: dbms_sql.bind_variable(insert_cursor, ':fcurrency', G_from_currency);
1840: dbms_sql.bind_variable(insert_cursor, ':date_created', sysdate);
1841: dbms_sql.bind_variable(insert_cursor, ':acc_date',G_accounting_date);
1842: dbms_sql.bind_variable(insert_cursor, ':source',G_source_name );

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

1835:
1836: dbms_sql.bind_variable(insert_cursor, ':category',G_category_name );
1837: dbms_sql.bind_variable(insert_cursor, ':status', G_status);
1838: dbms_sql.bind_variable(insert_cursor, ':actual_flag', G_actual_flag);
1839: dbms_sql.bind_variable(insert_cursor, ':fcurrency', G_from_currency);
1840: dbms_sql.bind_variable(insert_cursor, ':date_created', sysdate);
1841: dbms_sql.bind_variable(insert_cursor, ':acc_date',G_accounting_date);
1842: dbms_sql.bind_variable(insert_cursor, ':source',G_source_name );
1843: dbms_sql.bind_variable(insert_cursor, ':group_id', G_group_id);

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

1836: dbms_sql.bind_variable(insert_cursor, ':category',G_category_name );
1837: dbms_sql.bind_variable(insert_cursor, ':status', G_status);
1838: dbms_sql.bind_variable(insert_cursor, ':actual_flag', G_actual_flag);
1839: dbms_sql.bind_variable(insert_cursor, ':fcurrency', G_from_currency);
1840: dbms_sql.bind_variable(insert_cursor, ':date_created', sysdate);
1841: dbms_sql.bind_variable(insert_cursor, ':acc_date',G_accounting_date);
1842: dbms_sql.bind_variable(insert_cursor, ':source',G_source_name );
1843: dbms_sql.bind_variable(insert_cursor, ':group_id', G_group_id);
1844: dbms_sql.bind_variable(insert_cursor, ':rsob_id', p_rsob_id);

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

1837: dbms_sql.bind_variable(insert_cursor, ':status', G_status);
1838: dbms_sql.bind_variable(insert_cursor, ':actual_flag', G_actual_flag);
1839: dbms_sql.bind_variable(insert_cursor, ':fcurrency', G_from_currency);
1840: dbms_sql.bind_variable(insert_cursor, ':date_created', sysdate);
1841: dbms_sql.bind_variable(insert_cursor, ':acc_date',G_accounting_date);
1842: dbms_sql.bind_variable(insert_cursor, ':source',G_source_name );
1843: dbms_sql.bind_variable(insert_cursor, ':group_id', G_group_id);
1844: dbms_sql.bind_variable(insert_cursor, ':rsob_id', p_rsob_id);
1845: dbms_sql.bind_variable(insert_cursor, ':coa_id', G_coa_id);

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

1838: dbms_sql.bind_variable(insert_cursor, ':actual_flag', G_actual_flag);
1839: dbms_sql.bind_variable(insert_cursor, ':fcurrency', G_from_currency);
1840: dbms_sql.bind_variable(insert_cursor, ':date_created', sysdate);
1841: dbms_sql.bind_variable(insert_cursor, ':acc_date',G_accounting_date);
1842: dbms_sql.bind_variable(insert_cursor, ':source',G_source_name );
1843: dbms_sql.bind_variable(insert_cursor, ':group_id', G_group_id);
1844: dbms_sql.bind_variable(insert_cursor, ':rsob_id', p_rsob_id);
1845: dbms_sql.bind_variable(insert_cursor, ':coa_id', G_coa_id);
1846: dbms_sql.bind_variable(insert_cursor, ':re_ccid', G_re_ccid);

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

1839: dbms_sql.bind_variable(insert_cursor, ':fcurrency', G_from_currency);
1840: dbms_sql.bind_variable(insert_cursor, ':date_created', sysdate);
1841: dbms_sql.bind_variable(insert_cursor, ':acc_date',G_accounting_date);
1842: dbms_sql.bind_variable(insert_cursor, ':source',G_source_name );
1843: dbms_sql.bind_variable(insert_cursor, ':group_id', G_group_id);
1844: dbms_sql.bind_variable(insert_cursor, ':rsob_id', p_rsob_id);
1845: dbms_sql.bind_variable(insert_cursor, ':coa_id', G_coa_id);
1846: dbms_sql.bind_variable(insert_cursor, ':re_ccid', G_re_ccid);
1847:

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

1840: dbms_sql.bind_variable(insert_cursor, ':date_created', sysdate);
1841: dbms_sql.bind_variable(insert_cursor, ':acc_date',G_accounting_date);
1842: dbms_sql.bind_variable(insert_cursor, ':source',G_source_name );
1843: dbms_sql.bind_variable(insert_cursor, ':group_id', G_group_id);
1844: dbms_sql.bind_variable(insert_cursor, ':rsob_id', p_rsob_id);
1845: dbms_sql.bind_variable(insert_cursor, ':coa_id', G_coa_id);
1846: dbms_sql.bind_variable(insert_cursor, ':re_ccid', G_re_ccid);
1847:
1848: l_row_count := dbms_sql.execute(insert_cursor);

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

1841: dbms_sql.bind_variable(insert_cursor, ':acc_date',G_accounting_date);
1842: dbms_sql.bind_variable(insert_cursor, ':source',G_source_name );
1843: dbms_sql.bind_variable(insert_cursor, ':group_id', G_group_id);
1844: dbms_sql.bind_variable(insert_cursor, ':rsob_id', p_rsob_id);
1845: dbms_sql.bind_variable(insert_cursor, ':coa_id', G_coa_id);
1846: dbms_sql.bind_variable(insert_cursor, ':re_ccid', G_re_ccid);
1847:
1848: l_row_count := dbms_sql.execute(insert_cursor);
1849:

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

1842: dbms_sql.bind_variable(insert_cursor, ':source',G_source_name );
1843: dbms_sql.bind_variable(insert_cursor, ':group_id', G_group_id);
1844: dbms_sql.bind_variable(insert_cursor, ':rsob_id', p_rsob_id);
1845: dbms_sql.bind_variable(insert_cursor, ':coa_id', G_coa_id);
1846: dbms_sql.bind_variable(insert_cursor, ':re_ccid', G_re_ccid);
1847:
1848: l_row_count := dbms_sql.execute(insert_cursor);
1849:
1850: if (g_print_debug) then

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

1844: dbms_sql.bind_variable(insert_cursor, ':rsob_id', p_rsob_id);
1845: dbms_sql.bind_variable(insert_cursor, ':coa_id', G_coa_id);
1846: dbms_sql.bind_variable(insert_cursor, ':re_ccid', G_re_ccid);
1847:
1848: l_row_count := dbms_sql.execute(insert_cursor);
1849:
1850: if (g_print_debug) then
1851: fa_debug_pkg.add('insert_ret_earnings',
1852: 'Number of retained earnings rows inserted',

Line 1855: dbms_sql.close_cursor(insert_cursor);

1851: fa_debug_pkg.add('insert_ret_earnings',
1852: 'Number of retained earnings rows inserted',
1853: l_row_count);
1854: end if;
1855: dbms_sql.close_cursor(insert_cursor);
1856:
1857: if (g_print_debug) then
1858: fa_debug_pkg.add('calculate_balances',
1859: 'Inserting retained earnings in GL_INTERFACE',