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 369: RETURN FND_FLEX_EXT.SegmentArray

365: , p_application_short_name IN VARCHAR2
366: , p_id_flex_code IN VARCHAR2
367: , p_id_flex_num IN NUMBER
368: )
369: RETURN FND_FLEX_EXT.SegmentArray
370: ;
371:
372: PROCEDURE cache_combination_id(
373: p_combination_id IN NUMBER

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

1084: | Private procedure |
1085: | |
1086: | InitSegmentArray |
1087: | |
1088: | Set the FND_FLEX_EXT.SegmentArray varaibles. |
1089: | |
1090: +------------------------------------------------------------------*/
1091:
1092: FUNCTION init_SegmentArray(

Line 1128: RETURN FND_FLEX_EXT.SegmentArray

1124: , p_application_short_name IN VARCHAR2
1125: , p_id_flex_code IN VARCHAR2
1126: , p_id_flex_num IN NUMBER
1127: )
1128: RETURN FND_FLEX_EXT.SegmentArray
1129: IS
1130: l_position NUMBER;
1131: l_SegmentArray FND_FLEX_EXT.SegmentArray;
1132: l_log_module VARCHAR2(240);

Line 1131: l_SegmentArray FND_FLEX_EXT.SegmentArray;

1127: )
1128: RETURN FND_FLEX_EXT.SegmentArray
1129: IS
1130: l_position NUMBER;
1131: l_SegmentArray FND_FLEX_EXT.SegmentArray;
1132: l_log_module VARCHAR2(240);
1133: l_id_flex_num NUMBER;
1134: l_id INTEGER; -- index for flexfield
1135: --

Line 1308: l_SegmentArray FND_FLEX_EXT.SegmentArray;

1304: , p_id_flex_num IN NUMBER
1305: )
1306: IS
1307: l_ConcatKey VARCHAR2(4000);
1308: l_SegmentArray FND_FLEX_EXT.SegmentArray;
1309: l_SegmentNumber PLS_INTEGER;
1310: l_message VARCHAR2(4000);
1311: l_log_module VARCHAR2(240);
1312: l_position NUMBER;

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

1464: ELSE
1465: --key flexfield
1466: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1467: trace
1468: (p_msg => '-> CALL FND_FLEX_EXT.get_segments API'
1469: ,p_level => C_LEVEL_STATEMENT
1470: ,p_module => l_log_module);
1471: END IF;
1472:

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

1469: ,p_level => C_LEVEL_STATEMENT
1470: ,p_module => l_log_module);
1471: END IF;
1472:
1473: IF FND_FLEX_EXT.get_segments(application_short_name => p_application_short_name ,
1474: key_flex_code => p_id_flex_code ,
1475: structure_number => l_id_flex_num ,
1476: combination_id => p_combination_id ,
1477: n_segments => l_SegmentNumber ,

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

1549: g_array_combination_id(l_position).flexfield_application_id := p_flex_application_id ;
1550: g_array_combination_id(l_position).id_flex_code := p_id_flex_code ;
1551: g_array_combination_id(l_position).combination_status := 'N';
1552:
1553: l_message := SUBSTR(FND_FLEX_EXT.get_message,1,4000);
1554:
1555: l_ConcatKey := FND_FLEX_EXT.concatenate_segments(
1556: n_segments => l_SegmentNumber,
1557: segments => l_SegmentArray,

Line 1555: l_ConcatKey := FND_FLEX_EXT.concatenate_segments(

1551: g_array_combination_id(l_position).combination_status := 'N';
1552:
1553: l_message := SUBSTR(FND_FLEX_EXT.get_message,1,4000);
1554:
1555: l_ConcatKey := FND_FLEX_EXT.concatenate_segments(
1556: n_segments => l_SegmentNumber,
1557: segments => l_SegmentArray,
1558: delimiter => FND_FLEX_EXT.get_delimiter(
1559: application_short_name => p_application_short_name,

Line 1558: delimiter => FND_FLEX_EXT.get_delimiter(

1554:
1555: l_ConcatKey := FND_FLEX_EXT.concatenate_segments(
1556: n_segments => l_SegmentNumber,
1557: segments => l_SegmentArray,
1558: delimiter => FND_FLEX_EXT.get_delimiter(
1559: application_short_name => p_application_short_name,
1560: key_flex_code => p_id_flex_code,
1561: structure_number => nvl(p_id_flex_num,l_id_flex_num)
1562: ));

Line 1608: l_SegmentArray FND_FLEX_EXT.SegmentArray;

1604: , p_id_flex_num IN NUMBER)
1605: RETURN VARCHAR2
1606: IS
1607: l_ConcatKey VARCHAR2(4000); -- key flex concateneted value
1608: l_SegmentArray FND_FLEX_EXT.SegmentArray;
1609: l_SegmentNumber PLS_INTEGER;
1610: l_log_module VARCHAR2(240);
1611: l_position NUMBER;
1612: l_id_flex_num NUMBER;

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

1651: END IF;
1652:
1653: END IF;
1654:
1655: IF FND_FLEX_EXT.get_segments(application_short_name => p_application_short_name ,
1656: key_flex_code => p_id_flex_code ,
1657: structure_number => l_id_flex_num ,
1658: combination_id => p_combination_id ,
1659: n_segments => l_SegmentNumber ,

Line 1663: l_ConcatKey := FND_FLEX_EXT.concatenate_segments(

1659: n_segments => l_SegmentNumber ,
1660: segments => l_SegmentArray )
1661: THEN
1662:
1663: l_ConcatKey := FND_FLEX_EXT.concatenate_segments(
1664: n_segments => l_SegmentNumber,
1665: segments => l_SegmentArray,
1666: delimiter => FND_FLEX_EXT.get_delimiter(
1667: application_short_name => p_application_short_name,

Line 1666: delimiter => FND_FLEX_EXT.get_delimiter(

1662:
1663: l_ConcatKey := FND_FLEX_EXT.concatenate_segments(
1664: n_segments => l_SegmentNumber,
1665: segments => l_SegmentArray,
1666: delimiter => FND_FLEX_EXT.get_delimiter(
1667: application_short_name => p_application_short_name,
1668: key_flex_code => p_id_flex_code,
1669: structure_number => l_id_flex_num
1670: )

Line 2661: l_SegmentArray FND_FLEX_EXT.SegmentArray;

2657: PROCEDURE get_ccid_errors
2658: IS
2659: l_ConcatKey VARCHAR2(2000); -- key flex concateneted value
2660: --
2661: l_SegmentArray FND_FLEX_EXT.SegmentArray;
2662: l_SegmentNumber PLS_INTEGER;
2663: l_message VARCHAR2(4000);
2664: l_Ccid NUMBER;
2665: l_log_module VARCHAR2(240);

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

2758: l_SegmentNumber := l_SegmentArray.COUNT;
2759:
2760: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2761: trace
2762: (p_msg => '-> CALL FND_FLEX_EXT.get_combination_id API'
2763: ,p_level => C_LEVEL_STATEMENT
2764: ,p_module => l_log_module);
2765:
2766: END IF;

Line 2768: IF FND_FLEX_EXT.get_combination_id(

2764: ,p_module => l_log_module);
2765:
2766: END IF;
2767:
2768: IF FND_FLEX_EXT.get_combination_id(
2769: application_short_name => 'SQLGL',
2770: key_flex_code => 'GL#',
2771: structure_number => ccid_rec.coa_id,
2772: validation_date => sysdate,

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

2777:
2778: --
2779: -- get FND error message
2780: --
2781: l_message:= SUBSTR(FND_FLEX_EXT.get_message,1,2000);
2782: --
2783: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2784:
2785: trace

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

2787: ,p_level => C_LEVEL_STATEMENT
2788: ,p_module => l_log_module);
2789:
2790: trace
2791: (p_msg => '-> CALL FND_FLEX_EXT.concatenate_segments API'
2792: ,p_level => C_LEVEL_STATEMENT
2793: ,p_module => l_log_module);
2794:
2795: END IF;

Line 2799: l_ConcatKey := FND_FLEX_EXT.concatenate_segments(

2795: END IF;
2796: --
2797: -- Concatenates segments from segment array
2798: --
2799: l_ConcatKey := FND_FLEX_EXT.concatenate_segments(
2800: n_segments => l_SegmentNumber,
2801: segments => l_SegmentArray,
2802: delimiter => FND_FLEX_EXT.get_delimiter(
2803: application_short_name => 'SQLGL',

Line 2802: delimiter => FND_FLEX_EXT.get_delimiter(

2798: --
2799: l_ConcatKey := FND_FLEX_EXT.concatenate_segments(
2800: n_segments => l_SegmentNumber,
2801: segments => l_SegmentArray,
2802: delimiter => FND_FLEX_EXT.get_delimiter(
2803: application_short_name => 'SQLGL',
2804: key_flex_code => 'GL#',
2805: structure_number => ccid_rec.coa_id
2806: )

Line 2887: | AOL API FND_FLEX_EXT.get_combination_id. |

2883: | GetCcid |
2884: | |
2885: | Call AOL routine to create the new ccid, when the ccid does |
2886: | not exist in the gl_code_combinations table. It calls the |
2887: | AOL API FND_FLEX_EXT.get_combination_id. |
2888: | |
2889: +-------------------------------------------------------------*/
2890:
2891: FUNCTION GetCcid(

Line 2928: l_SegmentArray FND_FLEX_EXT.SegmentArray;

2924: RETURN NUMBER
2925: IS
2926: l_ConcatKey VARCHAR2(4000); -- key flex concateneted value
2927: --
2928: l_SegmentArray FND_FLEX_EXT.SegmentArray;
2929: l_SegmentNumber PLS_INTEGER;
2930: l_Ccid NUMBER;
2931: l_sql_stmt VARCHAR2(10000);
2932: l_message VARCHAR2(4000);

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

3037:
3038: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3039:
3040: trace
3041: (p_msg => '-> CALL FND_FLEX_EXT.get_combination_id API'
3042: ,p_level => C_LEVEL_STATEMENT
3043: ,p_module => l_log_module);
3044:
3045: END IF;

Line 3047: IF FND_FLEX_EXT.get_combination_id(

3043: ,p_module => l_log_module);
3044:
3045: END IF;
3046:
3047: IF FND_FLEX_EXT.get_combination_id(
3048: application_short_name => 'SQLGL',
3049: key_flex_code => 'GL#',
3050: structure_number => p_chart_of_accounts_id,
3051: validation_date => sysdate,