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.FV_SF224_TRANSACTIONS dependencies on GL_SETS_OF_BOOKS

Line 1410: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,

1406: -- CHECK_REPORT_DEFINTIONS
1407: ----------------------------------------------------------------------
1408: PROCEDURE check_report_definitions
1409: (
1410: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,
1411: p_error_code OUT NOCOPY NUMBER,
1412: p_error_desc OUT NOCOPY VARCHAR2
1413: )
1414: IS

Line 1453: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,

1449: -- GET_RUN_DATE
1450: ----------------------------------------------------------------------
1451: PROCEDURE get_run_date
1452: (
1453: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,
1454: p_previous_run_date OUT NOCOPY fv_sf224_run.last_run_date%TYPE,
1455: p_error_code OUT NOCOPY NUMBER,
1456: p_error_desc OUT NOCOPY VARCHAR2
1457: )

Line 1513: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,

1509: -- SET_RUN_DATE
1510: ----------------------------------------------------------------------
1511: PROCEDURE set_run_date
1512: (
1513: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,
1514: p_error_code OUT NOCOPY NUMBER,
1515: p_error_desc OUT NOCOPY VARCHAR2
1516: )
1517: IS

Line 1583: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,

1579: -- INITIALIZE_PROGRAM_VARIABLES
1580: ----------------------------------------------------------------------
1581: PROCEDURE initialize_program_variables
1582: (
1583: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,
1584: p_currency_code OUT NOCOPY gl_sets_of_books.currency_code%TYPE,
1585: p_chart_of_accounts_id OUT NOCOPY gl_sets_of_books.chart_of_accounts_id%TYPE,
1586: p_acct_segment OUT NOCOPY fnd_id_flex_segments.application_column_name%TYPE,
1587: p_acct_value_set_id OUT NOCOPY fnd_id_flex_segments.flex_value_set_id%TYPE,

Line 1584: p_currency_code OUT NOCOPY gl_sets_of_books.currency_code%TYPE,

1580: ----------------------------------------------------------------------
1581: PROCEDURE initialize_program_variables
1582: (
1583: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,
1584: p_currency_code OUT NOCOPY gl_sets_of_books.currency_code%TYPE,
1585: p_chart_of_accounts_id OUT NOCOPY gl_sets_of_books.chart_of_accounts_id%TYPE,
1586: p_acct_segment OUT NOCOPY fnd_id_flex_segments.application_column_name%TYPE,
1587: p_acct_value_set_id OUT NOCOPY fnd_id_flex_segments.flex_value_set_id%TYPE,
1588: p_bal_segment OUT NOCOPY fnd_id_flex_segments.application_column_name%TYPE,

Line 1585: p_chart_of_accounts_id OUT NOCOPY gl_sets_of_books.chart_of_accounts_id%TYPE,

1581: PROCEDURE initialize_program_variables
1582: (
1583: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,
1584: p_currency_code OUT NOCOPY gl_sets_of_books.currency_code%TYPE,
1585: p_chart_of_accounts_id OUT NOCOPY gl_sets_of_books.chart_of_accounts_id%TYPE,
1586: p_acct_segment OUT NOCOPY fnd_id_flex_segments.application_column_name%TYPE,
1587: p_acct_value_set_id OUT NOCOPY fnd_id_flex_segments.flex_value_set_id%TYPE,
1588: p_bal_segment OUT NOCOPY fnd_id_flex_segments.application_column_name%TYPE,
1589: p_accomplish_attribute OUT NOCOPY fv_system_parameters.sf224_accomplish_date%TYPE,

Line 1618: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Selecting from gl_sets_of_books');

1614:
1615: IF (p_error_code = g_SUCCESS) THEN
1616: BEGIN
1617: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1618: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Selecting from gl_sets_of_books');
1619: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'g_set_of_books_id='||p_set_of_books_id);
1620: END IF;
1621: SELECT gsob.chart_of_accounts_id,
1622: gsob.currency_code,

Line 1627: FROM gl_sets_of_books gsob

1623: gsob.period_set_name
1624: INTO p_chart_of_accounts_id,
1625: p_currency_code,
1626: l_period_set_name
1627: FROM gl_sets_of_books gsob
1628: WHERE set_of_books_id = p_set_of_books_id;
1629: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1630: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'p_chart_of_accounts_id='||p_chart_of_accounts_id);
1631: END IF;

Line 1636: l_location := l_module_name||'select_gl_sets_of_books';

1632: EXCEPTION
1633: WHEN OTHERS THEN
1634: p_error_code := g_FAILURE;
1635: p_error_desc := SQLERRM;
1636: l_location := l_module_name||'select_gl_sets_of_books';
1637: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
1638: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
1639: END;
1640: END IF;

Line 1747: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,

1743: -- INSERT_SF224_BATCHES
1744: ----------------------------------------------------------------------
1745: PROCEDURE insert_sf224_batches
1746: (
1747: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,
1748: p_previous_run_date IN fv_sf224_run.last_run_date%TYPE,
1749: p_current_run_date IN fv_sf224_run.last_run_date%TYPE,
1750: p_currency_code IN gl_sets_of_books.currency_code%TYPE,
1751: p_acct_segment IN fnd_id_flex_segments.application_column_name%TYPE,

Line 1750: p_currency_code IN gl_sets_of_books.currency_code%TYPE,

1746: (
1747: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,
1748: p_previous_run_date IN fv_sf224_run.last_run_date%TYPE,
1749: p_current_run_date IN fv_sf224_run.last_run_date%TYPE,
1750: p_currency_code IN gl_sets_of_books.currency_code%TYPE,
1751: p_acct_segment IN fnd_id_flex_segments.application_column_name%TYPE,
1752: p_bal_segment IN fnd_id_flex_segments.application_column_name%TYPE,
1753: p_error_code OUT NOCOPY NUMBER,
1754: p_error_desc OUT NOCOPY VARCHAR2

Line 5080: l_currency_code gl_sets_of_books.currency_code%TYPE;

5076: )
5077: IS
5078: l_module_name VARCHAR2(200);
5079: l_location VARCHAR2(200);
5080: l_currency_code gl_sets_of_books.currency_code%TYPE;
5081: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
5082: l_acct_segment fnd_id_flex_segments.application_column_name%TYPE;
5083: l_acct_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE;
5084: l_bal_segment fnd_id_flex_segments.application_column_name%TYPE;

Line 5081: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;

5077: IS
5078: l_module_name VARCHAR2(200);
5079: l_location VARCHAR2(200);
5080: l_currency_code gl_sets_of_books.currency_code%TYPE;
5081: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
5082: l_acct_segment fnd_id_flex_segments.application_column_name%TYPE;
5083: l_acct_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE;
5084: l_bal_segment fnd_id_flex_segments.application_column_name%TYPE;
5085: l_previous_run_date DATE;