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.XLA_AE_CODE_COMBINATION_PKG dependencies on FND_FLEX_EXT

Line 363: RETURN FND_FLEX_EXT.SegmentArray

359: , p_application_short_name IN VARCHAR2
360: , p_id_flex_code IN VARCHAR2
361: , p_id_flex_num IN NUMBER
362: )
363: RETURN FND_FLEX_EXT.SegmentArray
364: ;
365:
366: PROCEDURE cache_combination_id(
367: p_combination_id IN NUMBER

Line 1083: | Set the FND_FLEX_EXT.SegmentArray varaibles. |

1079: | Private procedure |
1080: | |
1081: | InitSegmentArray |
1082: | |
1083: | Set the FND_FLEX_EXT.SegmentArray varaibles. |
1084: | |
1085: +------------------------------------------------------------------*/
1086:
1087: FUNCTION init_SegmentArray(

Line 1123: RETURN FND_FLEX_EXT.SegmentArray

1119: , p_application_short_name IN VARCHAR2
1120: , p_id_flex_code IN VARCHAR2
1121: , p_id_flex_num IN NUMBER
1122: )
1123: RETURN FND_FLEX_EXT.SegmentArray
1124: IS
1125: l_position NUMBER;
1126: l_SegmentArray FND_FLEX_EXT.SegmentArray;
1127: l_log_module VARCHAR2(240);

Line 1126: l_SegmentArray FND_FLEX_EXT.SegmentArray;

1122: )
1123: RETURN FND_FLEX_EXT.SegmentArray
1124: IS
1125: l_position NUMBER;
1126: l_SegmentArray FND_FLEX_EXT.SegmentArray;
1127: l_log_module VARCHAR2(240);
1128: l_id_flex_num NUMBER;
1129: l_id INTEGER; -- index for flexfield
1130: --

Line 1303: l_SegmentArray FND_FLEX_EXT.SegmentArray;

1299: , p_id_flex_num IN NUMBER
1300: )
1301: IS
1302: l_ConcatKey VARCHAR2(4000);
1303: l_SegmentArray FND_FLEX_EXT.SegmentArray;
1304: l_SegmentNumber PLS_INTEGER;
1305: l_message VARCHAR2(4000);
1306: l_log_module VARCHAR2(240);
1307: l_position NUMBER;

Line 1461: (p_msg => '-> CALL FND_FLEX_EXT.get_segments API'

1457: ELSE
1458: --key flexfield
1459: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1460: trace
1461: (p_msg => '-> CALL FND_FLEX_EXT.get_segments API'
1462: ,p_level => C_LEVEL_STATEMENT
1463: ,p_module => l_log_module);
1464: END IF;
1465:

Line 1466: IF FND_FLEX_EXT.get_segments(application_short_name => p_application_short_name ,

1462: ,p_level => C_LEVEL_STATEMENT
1463: ,p_module => l_log_module);
1464: END IF;
1465:
1466: IF FND_FLEX_EXT.get_segments(application_short_name => p_application_short_name ,
1467: key_flex_code => p_id_flex_code ,
1468: structure_number => l_id_flex_num ,
1469: combination_id => p_combination_id ,
1470: n_segments => l_SegmentNumber ,

Line 1546: l_message := SUBSTR(FND_FLEX_EXT.get_message,1,4000);

1542: g_array_combination_id(l_position).flexfield_application_id := p_flex_application_id ;
1543: g_array_combination_id(l_position).id_flex_code := p_id_flex_code ;
1544: g_array_combination_id(l_position).combination_status := 'N';
1545:
1546: l_message := SUBSTR(FND_FLEX_EXT.get_message,1,4000);
1547:
1548: l_ConcatKey := FND_FLEX_EXT.concatenate_segments(
1549: n_segments => l_SegmentNumber,
1550: segments => l_SegmentArray,

Line 1548: l_ConcatKey := FND_FLEX_EXT.concatenate_segments(

1544: g_array_combination_id(l_position).combination_status := 'N';
1545:
1546: l_message := SUBSTR(FND_FLEX_EXT.get_message,1,4000);
1547:
1548: l_ConcatKey := FND_FLEX_EXT.concatenate_segments(
1549: n_segments => l_SegmentNumber,
1550: segments => l_SegmentArray,
1551: delimiter => FND_FLEX_EXT.get_delimiter(
1552: application_short_name => p_application_short_name,

Line 1551: delimiter => FND_FLEX_EXT.get_delimiter(

1547:
1548: l_ConcatKey := FND_FLEX_EXT.concatenate_segments(
1549: n_segments => l_SegmentNumber,
1550: segments => l_SegmentArray,
1551: delimiter => FND_FLEX_EXT.get_delimiter(
1552: application_short_name => p_application_short_name,
1553: key_flex_code => p_id_flex_code,
1554: structure_number => nvl(p_id_flex_num,l_id_flex_num)
1555: ));

Line 1601: l_SegmentArray FND_FLEX_EXT.SegmentArray;

1597: , p_id_flex_num IN NUMBER)
1598: RETURN VARCHAR2
1599: IS
1600: l_ConcatKey VARCHAR2(4000); -- key flex concateneted value
1601: l_SegmentArray FND_FLEX_EXT.SegmentArray;
1602: l_SegmentNumber PLS_INTEGER;
1603: l_log_module VARCHAR2(240);
1604: l_position NUMBER;
1605: l_id_flex_num NUMBER;

Line 1648: IF FND_FLEX_EXT.get_segments(application_short_name => p_application_short_name ,

1644: END IF;
1645:
1646: END IF;
1647:
1648: IF FND_FLEX_EXT.get_segments(application_short_name => p_application_short_name ,
1649: key_flex_code => p_id_flex_code ,
1650: structure_number => l_id_flex_num ,
1651: combination_id => p_combination_id ,
1652: n_segments => l_SegmentNumber ,

Line 1656: l_ConcatKey := FND_FLEX_EXT.concatenate_segments(

1652: n_segments => l_SegmentNumber ,
1653: segments => l_SegmentArray )
1654: THEN
1655:
1656: l_ConcatKey := FND_FLEX_EXT.concatenate_segments(
1657: n_segments => l_SegmentNumber,
1658: segments => l_SegmentArray,
1659: delimiter => FND_FLEX_EXT.get_delimiter(
1660: application_short_name => p_application_short_name,

Line 1659: delimiter => FND_FLEX_EXT.get_delimiter(

1655:
1656: l_ConcatKey := FND_FLEX_EXT.concatenate_segments(
1657: n_segments => l_SegmentNumber,
1658: segments => l_SegmentArray,
1659: delimiter => FND_FLEX_EXT.get_delimiter(
1660: application_short_name => p_application_short_name,
1661: key_flex_code => p_id_flex_code,
1662: structure_number => l_id_flex_num
1663: )

Line 2651: l_SegmentArray FND_FLEX_EXT.SegmentArray;

2647: PROCEDURE get_ccid_errors
2648: IS
2649: l_ConcatKey VARCHAR2(2000); -- key flex concateneted value
2650: --
2651: l_SegmentArray FND_FLEX_EXT.SegmentArray;
2652: l_SegmentNumber PLS_INTEGER;
2653: l_message VARCHAR2(4000);
2654: l_Ccid NUMBER;
2655: l_log_module VARCHAR2(240);

Line 2752: (p_msg => '-> CALL FND_FLEX_EXT.get_combination_id API'

2748: l_SegmentNumber := l_SegmentArray.COUNT;
2749:
2750: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2751: trace
2752: (p_msg => '-> CALL FND_FLEX_EXT.get_combination_id API'
2753: ,p_level => C_LEVEL_STATEMENT
2754: ,p_module => l_log_module);
2755:
2756: END IF;

Line 2758: IF FND_FLEX_EXT.get_combination_id(

2754: ,p_module => l_log_module);
2755:
2756: END IF;
2757:
2758: IF FND_FLEX_EXT.get_combination_id(
2759: application_short_name => 'SQLGL',
2760: key_flex_code => 'GL#',
2761: structure_number => ccid_rec.coa_id,
2762: validation_date => sysdate,

Line 2771: l_message:= SUBSTR(FND_FLEX_EXT.get_message,1,2000);

2767:
2768: --
2769: -- get FND error message
2770: --
2771: l_message:= SUBSTR(FND_FLEX_EXT.get_message,1,2000);
2772: --
2773: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2774:
2775: trace

Line 2781: (p_msg => '-> CALL FND_FLEX_EXT.concatenate_segments API'

2777: ,p_level => C_LEVEL_STATEMENT
2778: ,p_module => l_log_module);
2779:
2780: trace
2781: (p_msg => '-> CALL FND_FLEX_EXT.concatenate_segments API'
2782: ,p_level => C_LEVEL_STATEMENT
2783: ,p_module => l_log_module);
2784:
2785: END IF;

Line 2789: l_ConcatKey := FND_FLEX_EXT.concatenate_segments(

2785: END IF;
2786: --
2787: -- Concatenates segments from segment array
2788: --
2789: l_ConcatKey := FND_FLEX_EXT.concatenate_segments(
2790: n_segments => l_SegmentNumber,
2791: segments => l_SegmentArray,
2792: delimiter => FND_FLEX_EXT.get_delimiter(
2793: application_short_name => 'SQLGL',

Line 2792: delimiter => FND_FLEX_EXT.get_delimiter(

2788: --
2789: l_ConcatKey := FND_FLEX_EXT.concatenate_segments(
2790: n_segments => l_SegmentNumber,
2791: segments => l_SegmentArray,
2792: delimiter => FND_FLEX_EXT.get_delimiter(
2793: application_short_name => 'SQLGL',
2794: key_flex_code => 'GL#',
2795: structure_number => ccid_rec.coa_id
2796: )

Line 2877: | AOL API FND_FLEX_EXT.get_combination_id. |

2873: | GetCcid |
2874: | |
2875: | Call AOL routine to create the new ccid, when the ccid does |
2876: | not exist in the gl_code_combinations table. It calls the |
2877: | AOL API FND_FLEX_EXT.get_combination_id. |
2878: | |
2879: +-------------------------------------------------------------*/
2880:
2881: FUNCTION GetCcid(

Line 2918: l_SegmentArray FND_FLEX_EXT.SegmentArray;

2914: RETURN NUMBER
2915: IS
2916: l_ConcatKey VARCHAR2(4000); -- key flex concateneted value
2917: --
2918: l_SegmentArray FND_FLEX_EXT.SegmentArray;
2919: l_SegmentNumber PLS_INTEGER;
2920: l_Ccid NUMBER;
2921: l_sql_stmt VARCHAR2(10000);
2922: l_message VARCHAR2(4000);

Line 3031: (p_msg => '-> CALL FND_FLEX_EXT.get_combination_id API'

3027:
3028: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3029:
3030: trace
3031: (p_msg => '-> CALL FND_FLEX_EXT.get_combination_id API'
3032: ,p_level => C_LEVEL_STATEMENT
3033: ,p_module => l_log_module);
3034:
3035: END IF;

Line 3037: IF FND_FLEX_EXT.get_combination_id(

3033: ,p_module => l_log_module);
3034:
3035: END IF;
3036:
3037: IF FND_FLEX_EXT.get_combination_id(
3038: application_short_name => 'SQLGL',
3039: key_flex_code => 'GL#',
3040: structure_number => p_chart_of_accounts_id,
3041: validation_date => sysdate,