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_GLOBAL

Line 1138: SELECT DECODE(vs.flex_value, 'T', 'O', substrb( fnd_global.newline

1134: BEGIN
1135:
1136: IF g_sped_qualifier_position IS NOT NULL THEN
1137: BEGIN
1138: SELECT DECODE(vs.flex_value, 'T', 'O', substrb( fnd_global.newline
1139: ||vs.compiled_value_attributes
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 ))

Line 1140: ||fnd_global.newline, instrb( fnd_global.newline

1136: IF g_sped_qualifier_position IS NOT NULL THEN
1137: BEGIN
1138: SELECT DECODE(vs.flex_value, 'T', 'O', substrb( fnd_global.newline
1139: ||vs.compiled_value_attributes
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

Line 1142: ||fnd_global.newline, fnd_global.newline,1,g_sped_qualifier_position)+1, 1 ))

1138: SELECT DECODE(vs.flex_value, 'T', 'O', substrb( fnd_global.newline
1139: ||vs.compiled_value_attributes
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

Line 1161: SELECT DECODE(vs.flex_value, 'T', 'O', substrb( fnd_global.newline

1157: IF l_sped_code IS NULL OR l_sped_code = 'N' THEN
1158:
1159: BEGIN
1160:
1161: SELECT DECODE(vs.flex_value, 'T', 'O', substrb( fnd_global.newline
1162: ||vs.compiled_value_attributes
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 ))

Line 1163: ||fnd_global.newline, instrb( fnd_global.newline

1159: BEGIN
1160:
1161: SELECT DECODE(vs.flex_value, 'T', 'O', substrb( fnd_global.newline
1162: ||vs.compiled_value_attributes
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

Line 1165: ||fnd_global.newline, fnd_global.newline,1,g_account_qualifier_position)+1, 1 ))

1161: SELECT DECODE(vs.flex_value, 'T', 'O', substrb( fnd_global.newline
1162: ||vs.compiled_value_attributes
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:

Line 3807: AND nvl(DECODE(b.flex_value, ''T'', ''O'', substrb( fnd_global.newline

3803: ' AND b.flex_value_set_id = c.flex_value_set_id
3804: AND b.flex_value >= a.child_flex_value_low
3805: AND b.flex_value <= a.child_flex_value_high
3806: AND a.flex_value_set_id = b.flex_value_set_id
3807: AND nvl(DECODE(b.flex_value, ''T'', ''O'', substrb( fnd_global.newline
3808: ||b.compiled_value_attributes
3809: ||fnd_global.newline, instrb( fnd_global.newline
3810: ||b.compiled_value_attributes
3811: ||fnd_global.newline, fnd_global.newline,1,'|| g_exclusion_qualifier_position||')+1, 1 )),''N'') <> ''Y'') V

Line 3809: ||fnd_global.newline, instrb( fnd_global.newline

3805: AND b.flex_value <= a.child_flex_value_high
3806: AND a.flex_value_set_id = b.flex_value_set_id
3807: AND nvl(DECODE(b.flex_value, ''T'', ''O'', substrb( fnd_global.newline
3808: ||b.compiled_value_attributes
3809: ||fnd_global.newline, instrb( fnd_global.newline
3810: ||b.compiled_value_attributes
3811: ||fnd_global.newline, fnd_global.newline,1,'|| g_exclusion_qualifier_position||')+1, 1 )),''N'') <> ''Y'') V
3812: WHERE V.summary_flag= ''Y''
3813: OR exists (SELECT 1

Line 3811: ||fnd_global.newline, fnd_global.newline,1,'|| g_exclusion_qualifier_position||')+1, 1 )),''N'') <> ''Y'') V

3807: AND nvl(DECODE(b.flex_value, ''T'', ''O'', substrb( fnd_global.newline
3808: ||b.compiled_value_attributes
3809: ||fnd_global.newline, instrb( fnd_global.newline
3810: ||b.compiled_value_attributes
3811: ||fnd_global.newline, fnd_global.newline,1,'|| g_exclusion_qualifier_position||')+1, 1 )),''N'') <> ''Y'') V
3812: WHERE V.summary_flag= ''Y''
3813: OR exists (SELECT 1
3814: FROM gl_code_combinations glcc
3815: WHERE glcc.chart_of_accounts_id = '||g_chart_of_accounts_id||

Line 3826: ' AND nvl(DECODE(b.flex_value, ''T'', ''O'', substrb( fnd_global.newline

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
3829: ||b.compiled_value_attributes
3830: ||fnd_global.newline, fnd_global.newline,1,'|| g_exclusion_qualifier_position||')+1, 1 )),''N'') <> ''Y''

Line 3828: ||fnd_global.newline, instrb( fnd_global.newline

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
3829: ||b.compiled_value_attributes
3830: ||fnd_global.newline, fnd_global.newline,1,'|| g_exclusion_qualifier_position||')+1, 1 )),''N'') <> ''Y''
3831: AND NOT EXISTS (SELECT 1 FROM fnd_flex_value_norm_hierarchy a
3832: WHERE a.flex_value_set_id = '||g_account_value_set_id||

Line 3830: ||fnd_global.newline, fnd_global.newline,1,'|| g_exclusion_qualifier_position||')+1, 1 )),''N'') <> ''Y''

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
3829: ||b.compiled_value_attributes
3830: ||fnd_global.newline, fnd_global.newline,1,'|| g_exclusion_qualifier_position||')+1, 1 )),''N'') <> ''Y''
3831: AND NOT EXISTS (SELECT 1 FROM fnd_flex_value_norm_hierarchy a
3832: WHERE a.flex_value_set_id = '||g_account_value_set_id||
3833: ' AND b.flex_value >= a.child_flex_value_low
3834: AND b.flex_value <= a.child_flex_value_high))';

Line 6013: SELECT DISTINCT DECODE(DECODE(vs.flex_value, 'T', 'O', substrb( fnd_global.newline

6009: EXIT WHEN acct_cur%NOTFOUND;
6010:
6011: BEGIN
6012:
6013: SELECT DISTINCT DECODE(DECODE(vs.flex_value, 'T', 'O', substrb( fnd_global.newline
6014: ||vs.compiled_value_attributes
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)

Line 6015: ||fnd_global.newline, instrb( fnd_global.newline

6011: BEGIN
6012:
6013: SELECT DISTINCT DECODE(DECODE(vs.flex_value, 'T', 'O', substrb( fnd_global.newline
6014: ||vs.compiled_value_attributes
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

Line 6017: ||fnd_global.newline, fnd_global.newline,1,g_account_qualifier_position)+1, 1 )),'A',1,'L',2,'O',2,null)

6013: SELECT DISTINCT DECODE(DECODE(vs.flex_value, 'T', 'O', substrb( fnd_global.newline
6014: ||vs.compiled_value_attributes
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;

Line 9140: non_printable_chars:= non_printable_chars||fnd_global.local_chr(i);

9136: printable_chars := null;
9137: non_printable_chars := '|';
9138:
9139: for i in 0 .. 31 loop --ASCII characters 0 to 31 are non printable characters
9140: non_printable_chars:= non_printable_chars||fnd_global.local_chr(i);
9141: end loop;
9142: for i in 32 .. 123 loop -- printable characters
9143: printable_chars := printable_chars||fnd_global.local_chr(i);
9144: end loop;

Line 9143: printable_chars := printable_chars||fnd_global.local_chr(i);

9139: for i in 0 .. 31 loop --ASCII characters 0 to 31 are non printable characters
9140: non_printable_chars:= non_printable_chars||fnd_global.local_chr(i);
9141: end loop;
9142: for i in 32 .. 123 loop -- printable characters
9143: printable_chars := printable_chars||fnd_global.local_chr(i);
9144: end loop;
9145:
9146: /*ASCII characters 32 to 126 are printable characters. But as we even want to remove pipe,don't include chr(124) */
9147:

Line 9148: printable_chars := printable_chars||fnd_global.local_chr(125)||fnd_global.local_chr(126);

9144: end loop;
9145:
9146: /*ASCII characters 32 to 126 are printable characters. But as we even want to remove pipe,don't include chr(124) */
9147:
9148: printable_chars := printable_chars||fnd_global.local_chr(125)||fnd_global.local_chr(126);
9149:
9150: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Removing non printable characters');
9151:
9152: UPDATE jl_br_sped_extr_data_t