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 1431: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,

1427: -- CHECK_REPORT_DEFINTIONS
1428: ----------------------------------------------------------------------
1429: PROCEDURE check_report_definitions
1430: (
1431: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,
1432: p_error_code OUT NOCOPY NUMBER,
1433: p_error_desc OUT NOCOPY VARCHAR2
1434: )
1435: IS

Line 1474: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,

1470: -- GET_RUN_DATE
1471: ----------------------------------------------------------------------
1472: PROCEDURE get_run_date
1473: (
1474: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,
1475: p_previous_run_date OUT NOCOPY fv_sf224_run.last_run_date%TYPE,
1476: p_error_code OUT NOCOPY NUMBER,
1477: p_error_desc OUT NOCOPY VARCHAR2
1478: )

Line 1534: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,

1530: -- SET_RUN_DATE
1531: ----------------------------------------------------------------------
1532: PROCEDURE set_run_date
1533: (
1534: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,
1535: p_error_code OUT NOCOPY NUMBER,
1536: p_error_desc OUT NOCOPY VARCHAR2
1537: )
1538: IS

Line 1604: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,

1600: -- INITIALIZE_PROGRAM_VARIABLES
1601: ----------------------------------------------------------------------
1602: PROCEDURE initialize_program_variables
1603: (
1604: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,
1605: p_currency_code OUT NOCOPY gl_sets_of_books.currency_code%TYPE,
1606: p_chart_of_accounts_id OUT NOCOPY gl_sets_of_books.chart_of_accounts_id%TYPE,
1607: p_acct_segment OUT NOCOPY fnd_id_flex_segments.application_column_name%TYPE,
1608: p_acct_value_set_id OUT NOCOPY fnd_id_flex_segments.flex_value_set_id%TYPE,

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

1601: ----------------------------------------------------------------------
1602: PROCEDURE initialize_program_variables
1603: (
1604: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,
1605: p_currency_code OUT NOCOPY gl_sets_of_books.currency_code%TYPE,
1606: p_chart_of_accounts_id OUT NOCOPY gl_sets_of_books.chart_of_accounts_id%TYPE,
1607: p_acct_segment OUT NOCOPY fnd_id_flex_segments.application_column_name%TYPE,
1608: p_acct_value_set_id OUT NOCOPY fnd_id_flex_segments.flex_value_set_id%TYPE,
1609: p_bal_segment OUT NOCOPY fnd_id_flex_segments.application_column_name%TYPE,

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

1602: PROCEDURE initialize_program_variables
1603: (
1604: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,
1605: p_currency_code OUT NOCOPY gl_sets_of_books.currency_code%TYPE,
1606: p_chart_of_accounts_id OUT NOCOPY gl_sets_of_books.chart_of_accounts_id%TYPE,
1607: p_acct_segment OUT NOCOPY fnd_id_flex_segments.application_column_name%TYPE,
1608: p_acct_value_set_id OUT NOCOPY fnd_id_flex_segments.flex_value_set_id%TYPE,
1609: p_bal_segment OUT NOCOPY fnd_id_flex_segments.application_column_name%TYPE,
1610: p_accomplish_attribute OUT NOCOPY fv_system_parameters.sf224_accomplish_date%TYPE,

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

1635:
1636: IF (p_error_code = g_SUCCESS) THEN
1637: BEGIN
1638: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1639: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Selecting from gl_sets_of_books');
1640: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'g_set_of_books_id='||p_set_of_books_id);
1641: END IF;
1642: SELECT gsob.chart_of_accounts_id,
1643: gsob.currency_code,

Line 1648: FROM gl_sets_of_books gsob

1644: gsob.period_set_name
1645: INTO p_chart_of_accounts_id,
1646: p_currency_code,
1647: l_period_set_name
1648: FROM gl_sets_of_books gsob
1649: WHERE set_of_books_id = p_set_of_books_id;
1650: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1651: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'p_chart_of_accounts_id='||p_chart_of_accounts_id);
1652: END IF;

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

1653: EXCEPTION
1654: WHEN OTHERS THEN
1655: p_error_code := g_FAILURE;
1656: p_error_desc := SQLERRM;
1657: l_location := l_module_name||'select_gl_sets_of_books';
1658: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
1659: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
1660: END;
1661: END IF;

Line 1768: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,

1764: -- INSERT_SF224_BATCHES
1765: ----------------------------------------------------------------------
1766: PROCEDURE insert_sf224_batches
1767: (
1768: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,
1769: p_previous_run_date IN fv_sf224_run.last_run_date%TYPE,
1770: p_current_run_date IN fv_sf224_run.last_run_date%TYPE,
1771: p_currency_code IN gl_sets_of_books.currency_code%TYPE,
1772: p_acct_segment IN fnd_id_flex_segments.application_column_name%TYPE,

Line 1771: p_currency_code IN gl_sets_of_books.currency_code%TYPE,

1767: (
1768: p_set_of_books_id IN gl_sets_of_books.set_of_books_id%TYPE,
1769: p_previous_run_date IN fv_sf224_run.last_run_date%TYPE,
1770: p_current_run_date IN fv_sf224_run.last_run_date%TYPE,
1771: p_currency_code IN gl_sets_of_books.currency_code%TYPE,
1772: p_acct_segment IN fnd_id_flex_segments.application_column_name%TYPE,
1773: p_bal_segment IN fnd_id_flex_segments.application_column_name%TYPE,
1774: p_error_code OUT NOCOPY NUMBER,
1775: p_error_desc OUT NOCOPY VARCHAR2

Line 5218: l_currency_code gl_sets_of_books.currency_code%TYPE;

5214: )
5215: IS
5216: l_module_name VARCHAR2(200);
5217: l_location VARCHAR2(200);
5218: l_currency_code gl_sets_of_books.currency_code%TYPE;
5219: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
5220: l_acct_segment fnd_id_flex_segments.application_column_name%TYPE;
5221: l_acct_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE;
5222: l_bal_segment fnd_id_flex_segments.application_column_name%TYPE;

Line 5219: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;

5215: IS
5216: l_module_name VARCHAR2(200);
5217: l_location VARCHAR2(200);
5218: l_currency_code gl_sets_of_books.currency_code%TYPE;
5219: l_chart_of_accounts_id gl_sets_of_books.chart_of_accounts_id%TYPE;
5220: l_acct_segment fnd_id_flex_segments.application_column_name%TYPE;
5221: l_acct_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE;
5222: l_bal_segment fnd_id_flex_segments.application_column_name%TYPE;
5223: l_previous_run_date DATE;