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.JL_BR_SPED_DATA_EXTRACT_PKG dependencies on FND_FLEX_VALUES

Line 13: PROCEDURE register_I051(p_account_flex_value fnd_flex_values.flex_value%TYPE );

9: g_state_insc_tax zx_registrations.tax%TYPE;
10: g_municipal_insc_tax_regime zx_registrations.tax_regime_code%TYPE;
11: g_municipal_insc_tax zx_registrations.tax%TYPE;
12:
13: PROCEDURE register_I051(p_account_flex_value fnd_flex_values.flex_value%TYPE );
14: PROCEDURE register_I052(p_account_flex_value fnd_flex_values.flex_value%TYPE );
15: PROCEDURE register_I250(p_journal_header_id gl_je_headers.je_header_id%TYPE,
16: p_journal_name gl_je_headers.name%TYPE,
17: p_journal_source gl_je_headers.je_source%TYPE,

Line 14: PROCEDURE register_I052(p_account_flex_value fnd_flex_values.flex_value%TYPE );

10: g_municipal_insc_tax_regime zx_registrations.tax_regime_code%TYPE;
11: g_municipal_insc_tax zx_registrations.tax%TYPE;
12:
13: PROCEDURE register_I051(p_account_flex_value fnd_flex_values.flex_value%TYPE );
14: PROCEDURE register_I052(p_account_flex_value fnd_flex_values.flex_value%TYPE );
15: PROCEDURE register_I250(p_journal_header_id gl_je_headers.je_header_id%TYPE,
16: p_journal_name gl_je_headers.name%TYPE,
17: p_journal_source gl_je_headers.je_source%TYPE,
18: p_je_category gl_je_headers.je_category%TYPE);

Line 1121: FUNCTION get_account_type(p_flex_Value_id fnd_flex_values.flex_value_id%TYPE) RETURN VARCHAR2 AS

1117: END IF;
1118:
1119: END get_segment_value;
1120:
1121: FUNCTION get_account_type(p_flex_Value_id fnd_flex_values.flex_value_id%TYPE) RETURN VARCHAR2 AS
1122: /* This function returns the Account Type for flex value .
1123: For the flex value if there is sped account type other than 'Not applibale' then this function
1124: returns the corresponding sped account code, otherwise it will return account code for the
1125: GL_ACCOUNT_TYPE*/

Line 1144: FROM fnd_flex_values vs

1140: ||fnd_global.newline, instrb( fnd_global.newline
1141: ||vs.compiled_value_attributes
1142: ||fnd_global.newline, fnd_global.newline,1,g_sped_qualifier_position)+1, 1 ))
1143: INTO l_sped_code
1144: FROM fnd_flex_values vs
1145: WHERE flex_value_id=p_flex_Value_id;
1146: EXCEPTION
1147: WHEN NO_DATA_FOUND THEN
1148: l_sped_code := null;

Line 1167: FROM fnd_flex_values vs

1163: ||fnd_global.newline, instrb( fnd_global.newline
1164: ||vs.compiled_value_attributes
1165: ||fnd_global.newline, fnd_global.newline,1,g_account_qualifier_position)+1, 1 ))
1166: INTO l_acct_code
1167: FROM fnd_flex_values vs
1168: WHERE flex_value_id=p_flex_value_id;
1169:
1170: EXCEPTION
1171: WHEN NO_DATA_FOUND THEN

Line 3735: fnd_flex_values.last_update_date%TYPE INDEX BY BINARY_INTEGER;

3731: PROCEDURE register_I050 AS
3732: l_api_name CONSTANT VARCHAR2(30) :='REGISTER_I050';
3733:
3734: TYPE tab_fv_last_update_date IS TABLE OF
3735: fnd_flex_values.last_update_date%TYPE INDEX BY BINARY_INTEGER;
3736:
3737: TYPE tab_fv_account_type IS TABLE OF
3738: VARCHAR2(10) INDEX BY BINARY_INTEGER;
3739:

Line 3747: fnd_flex_values.flex_value%TYPE INDEX BY BINARY_INTEGER;

3743: TYPE tab_fv_value_level IS TABLE OF
3744: NUMBER INDEX BY BINARY_INTEGER;
3745:
3746: TYPE tab_fv_flex_value IS TABLE OF
3747: fnd_flex_values.flex_value%TYPE INDEX BY BINARY_INTEGER;
3748:
3749: TYPE tab_fv_flex_value_id IS TABLE OF
3750: fnd_flex_values.flex_value_id%TYPE INDEX BY BINARY_INTEGER;
3751:

Line 3750: fnd_flex_values.flex_value_id%TYPE INDEX BY BINARY_INTEGER;

3746: TYPE tab_fv_flex_value IS TABLE OF
3747: fnd_flex_values.flex_value%TYPE INDEX BY BINARY_INTEGER;
3748:
3749: TYPE tab_fv_flex_value_id IS TABLE OF
3750: fnd_flex_values.flex_value_id%TYPE INDEX BY BINARY_INTEGER;
3751:
3752: TYPE tab_fv_description IS TABLE OF
3753: VARCHAR2(250) INDEX BY BINARY_INTEGER;
3754:

Line 3768: l_fv_last_update_date fnd_flex_values.last_update_date%TYPE;

3764:
3765: l_childs_exist NUMBER := 0;
3766: l_prev_level1_parent VARCHAR2(10) := '-1';
3767:
3768: l_fv_last_update_date fnd_flex_values.last_update_date%TYPE;
3769: l_fv_id fnd_flex_values.flex_value_id%TYPE;
3770: l_fv_summary_flag VARCHAR2(10);
3771: l_fv_description VARCHAR2(250);
3772:

Line 3769: l_fv_id fnd_flex_values.flex_value_id%TYPE;

3765: l_childs_exist NUMBER := 0;
3766: l_prev_level1_parent VARCHAR2(10) := '-1';
3767:
3768: l_fv_last_update_date fnd_flex_values.last_update_date%TYPE;
3769: l_fv_id fnd_flex_values.flex_value_id%TYPE;
3770: l_fv_summary_flag VARCHAR2(10);
3771: l_fv_description VARCHAR2(250);
3772:
3773: BEGIN

Line 3796: FND_FLEX_VALUES_VL b, -- Valores do segmento

3792: ,a.parent_flex_value
3793: ,b.flex_value child_flex_value
3794: ,b.description
3795: FROM fnd_flex_value_norm_hierarchy a, -- Hierarquia compilada
3796: FND_FLEX_VALUES_VL b, -- Valores do segmento
3797: fnd_id_flex_segments c -- Segmentos da estrutura
3798: WHERE c.application_id = 101
3799: AND c.id_flex_code = ''GL#''
3800: AND c.id_flex_num = '||g_chart_of_accounts_id||

Line 3824: FROM FND_FLEX_VALUES_VL b

3820: )
3821: CONNECT BY V.parent_flex_value = PRIOR V.child_flex_value
3822: START WITH V.parent_flex_value IN
3823: ( SELECT b.flex_value
3824: FROM FND_FLEX_VALUES_VL b
3825: WHERE b.flex_value_set_id = '||g_account_value_set_id||
3826: ' AND nvl(DECODE(b.flex_value, ''T'', ''O'', substrb( fnd_global.newline
3827: ||b.compiled_value_attributes
3828: ||fnd_global.newline, instrb( fnd_global.newline

Line 3919: FROM FND_FLEX_VALUES_VL

3915: INTO l_fv_last_update_date
3916: ,l_fv_id
3917: ,l_fv_summary_flag
3918: ,l_fv_description
3919: FROM FND_FLEX_VALUES_VL
3920: WHERE flex_value = fv_parent_value(i)
3921: AND flex_value_set_id = g_account_value_set_id; -- GL Account segment value set id
3922: EXCEPTION
3923: WHEN OTHERS THEN

Line 4080: PROCEDURE register_I051(p_account_flex_value fnd_flex_values.flex_value%TYPE ) AS

4076: g_retcode := 2;
4077: return;
4078: END register_I050;
4079:
4080: PROCEDURE register_I051(p_account_flex_value fnd_flex_values.flex_value%TYPE ) AS
4081: l_institution_resp_code VARCHAR2(250);
4082: l_referential_account gl_cons_flex_hierarchies.parent_flex_value%TYPE;
4083: l_cnt NUMBER;
4084: l_api_name CONSTANT VARCHAR2(30) :='REGISTER_I051';

Line 4262: PROCEDURE register_I052(p_account_flex_value fnd_flex_values.flex_value%TYPE) AS

4258: g_retcode := 2;
4259: return;
4260: END register_I051;
4261:
4262: PROCEDURE register_I052(p_account_flex_value fnd_flex_values.flex_value%TYPE) AS
4263: l_bal_agglutination_code rg_report_axes_v.description%TYPE;
4264: l_income_agglutination_code rg_report_axes_v.description%TYPE;
4265: l_api_name CONSTANT VARCHAR2(30) :='REGISTER_I052';
4266: sql_stmt VARCHAR2(5000);

Line 4443: ','||g_last_update_login|| ' FROM fnd_flex_values_vl fv

4439: ,fv.description
4440: ,''|''
4441: ,'||g_created_by|| ','''||g_creation_date||''''||
4442: ','||g_last_updated_by|| ','''||g_last_update_date||''''||
4443: ','||g_last_update_login|| ' FROM fnd_flex_values_vl fv
4444: WHERE fv.flex_value_set_id = '||g_cost_center_value_set_id||
4445: ' AND EXISTS (SELECT 1
4446: FROM gl_code_combinations glcc
4447: WHERE glcc.chart_of_accounts_id = '||g_chart_of_accounts_id||

Line 5342: fnd_flex_values.flex_value%TYPE INDEX BY BINARY_INTEGER;

5338: TYPE tab_effective_date IS TABLE OF
5339: gl_je_lines.effective_date%TYPE INDEX BY BINARY_INTEGER;
5340:
5341: TYPE tab_flex_value IS TABLE OF
5342: fnd_flex_values.flex_value%TYPE INDEX BY BINARY_INTEGER;
5343:
5344: TYPE tab_num IS TABLE OF
5345: NUMBER INDEX BY BINARY_INTEGER;
5346:

Line 6019: FROM fnd_flex_values vs

6015: ||fnd_global.newline, instrb( fnd_global.newline
6016: ||vs.compiled_value_attributes
6017: ||fnd_global.newline, fnd_global.newline,1,g_account_qualifier_position)+1, 1 )),'A',1,'L',2,'O',2,null)
6018: INTO l_acct_type
6019: FROM fnd_flex_values vs
6020: WHERE flex_value_set_id = g_account_value_set_id
6021: AND flex_value BETWEEN acct_low AND acct_high;
6022:
6023: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'acct_type for axis_seq '||J100_rec.field8||' is '||l_acct_type);