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 FND_ID_FLEX_SEGMENTS

Line 1586: p_acct_segment OUT NOCOPY fnd_id_flex_segments.application_column_name%TYPE,

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,
1590: p_error_code OUT NOCOPY NUMBER,

Line 1587: p_acct_value_set_id OUT NOCOPY fnd_id_flex_segments.flex_value_set_id%TYPE,

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,
1590: p_error_code OUT NOCOPY NUMBER,
1591: p_error_desc OUT NOCOPY VARCHAR2

Line 1588: p_bal_segment OUT NOCOPY fnd_id_flex_segments.application_column_name%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,
1590: p_error_code OUT NOCOPY NUMBER,
1591: p_error_desc OUT NOCOPY VARCHAR2
1592: )

Line 1702: FROM fnd_id_flex_segments

1698: IF (p_error_code = g_SUCCESS) THEN
1699: BEGIN
1700: SELECT flex_value_set_id
1701: INTO p_acct_value_set_id
1702: FROM fnd_id_flex_segments
1703: WHERE application_column_name = p_acct_segment
1704: AND application_id = l_application_id
1705: AND id_flex_code = l_id_flex_code
1706: AND id_flex_num = p_chart_of_accounts_id

Line 1712: l_location := l_module_name||'select_fnd_id_flex_segments';

1708: EXCEPTION
1709: WHEN OTHERS THEN
1710: p_error_code := g_FAILURE;
1711: p_error_desc := SQLERRM;
1712: l_location := l_module_name||'select_fnd_id_flex_segments';
1713: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
1714: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
1715: END;
1716: END IF;

Line 1751: p_acct_segment IN fnd_id_flex_segments.application_column_name%TYPE,

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
1755: )

Line 1752: p_bal_segment IN fnd_id_flex_segments.application_column_name%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
1755: )
1756: IS

Line 5082: l_acct_segment fnd_id_flex_segments.application_column_name%TYPE;

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;
5086: BEGIN

Line 5083: l_acct_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE;

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;
5086: BEGIN
5087: l_module_name := g_module_name || '.extract';

Line 5084: l_bal_segment fnd_id_flex_segments.application_column_name%TYPE;

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;
5086: BEGIN
5087: l_module_name := g_module_name || '.extract';
5088: p_retcode := g_SUCCESS;