DBA Data[Home] [Help]

APPS.FV_SF224_TRANSACTIONS dependencies on FND_ID_FLEX_SEGMENTS

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

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

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

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

Line 1609: p_bal_segment OUT NOCOPY fnd_id_flex_segments.application_column_name%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,
1611: p_error_code OUT NOCOPY NUMBER,
1612: p_error_desc OUT NOCOPY VARCHAR2
1613: )

Line 1723: FROM fnd_id_flex_segments

1719: IF (p_error_code = g_SUCCESS) THEN
1720: BEGIN
1721: SELECT flex_value_set_id
1722: INTO p_acct_value_set_id
1723: FROM fnd_id_flex_segments
1724: WHERE application_column_name = p_acct_segment
1725: AND application_id = l_application_id
1726: AND id_flex_code = l_id_flex_code
1727: AND id_flex_num = p_chart_of_accounts_id

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

1729: EXCEPTION
1730: WHEN OTHERS THEN
1731: p_error_code := g_FAILURE;
1732: p_error_desc := SQLERRM;
1733: l_location := l_module_name||'select_fnd_id_flex_segments';
1734: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
1735: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
1736: END;
1737: END IF;

Line 1772: p_acct_segment IN fnd_id_flex_segments.application_column_name%TYPE,

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

Line 1773: p_bal_segment IN fnd_id_flex_segments.application_column_name%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
1776: )
1777: IS

Line 5220: l_acct_segment fnd_id_flex_segments.application_column_name%TYPE;

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

Line 5221: l_acct_value_set_id fnd_id_flex_segments.flex_value_set_id%TYPE;

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

Line 5222: l_bal_segment fnd_id_flex_segments.application_column_name%TYPE;

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;
5224: BEGIN
5225: l_module_name := g_module_name || '.extract';
5226: p_retcode := g_SUCCESS;