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

Line 895: l_segments FND_FLEX_EXT.SEGMENTARRAY;

891:
892: overlay_segments_failure EXCEPTION;
893: l_ccid NUMBER := p_ccid;
894: l_chart_of_accounts_id NUMBER;
895: l_segments FND_FLEX_EXT.SEGMENTARRAY;
896: l_partial_segments FND_FLEX_EXT.SEGMENTARRAY;
897: l_num_segments NUMBER;
898: l_account_segment_num NUMBER;
899: l_balancing_segment_num NUMBER;

Line 896: l_partial_segments FND_FLEX_EXT.SEGMENTARRAY;

892: overlay_segments_failure EXCEPTION;
893: l_ccid NUMBER := p_ccid;
894: l_chart_of_accounts_id NUMBER;
895: l_segments FND_FLEX_EXT.SEGMENTARRAY;
896: l_partial_segments FND_FLEX_EXT.SEGMENTARRAY;
897: l_num_segments NUMBER;
898: l_account_segment_num NUMBER;
899: l_balancing_segment_num NUMBER;
900: l_cost_center_segment_num NUMBER;

Line 931: l_segment_delimiter := FND_FLEX_EXT.GET_DELIMITER(

927:
928: debug_info := 'Get segment delimiter';
929:
930:
931: l_segment_delimiter := FND_FLEX_EXT.GET_DELIMITER(
932: 'SQLGL',
933: 'GL#',
934: l_chart_of_accounts_id);
935:

Line 948: l_result := FND_FLEX_EXT.GET_SEGMENTS(

944:
945: IF (l_ccid IS NOT NULL) Then
946:
947: debug_info := 'Get segment array';
948: l_result := FND_FLEX_EXT.GET_SEGMENTS(
949: 'SQLGL',
950: 'GL#',
951: l_chart_of_accounts_id,
952: l_ccid,

Line 965: l_overlayed_segments := FND_FLEX_EXT.Concatenate_Segments(l_num_segments,

961: END IF; -- l_ccid not null
962: --
963: -- Get concatenated segments from ccid
964: IF (nvl(p_ccid_to_segs,'N') = 'Y') Then
965: l_overlayed_segments := FND_FLEX_EXT.Concatenate_Segments(l_num_segments,
966: l_segments,
967: l_segment_delimiter);
968:
969: IF (NOT l_result) THEN

Line 987: l_partial_num_segments := FND_FLEX_EXT.breakup_segments(p_concatenated_segments,

983: IF (p_concatenated_segments IS NOT NULL) THEN
984:
985: debug_info := 'Get Partial segment array';
986:
987: l_partial_num_segments := FND_FLEX_EXT.breakup_segments(p_concatenated_segments,
988: l_segment_delimiter,
989: l_partial_segments); --OUT
990:
991: END IF;

Line 1107: l_overlayed_segments := FND_FLEX_EXT.Concatenate_Segments(l_num_segments,

1103:
1104: -- Get Concat Segments Back
1105: -- from seg array
1106:
1107: l_overlayed_segments := FND_FLEX_EXT.Concatenate_Segments(l_num_segments,
1108: l_segments,
1109: l_segment_delimiter);
1110:
1111: IF (NOT l_result) THEN

Line 1283: l_segments FND_FLEX_EXT.SEGMENTARRAY;

1279:
1280: overlay_segments_failure EXCEPTION;
1281: l_ccid NUMBER := p_ccid;
1282: l_chart_of_accounts_id NUMBER;
1283: l_segments FND_FLEX_EXT.SEGMENTARRAY;
1284: l_partial_segments FND_FLEX_EXT.SEGMENTARRAY;
1285: l_num_segments NUMBER;
1286: l_account_segment_num NUMBER;
1287: l_balancing_segment_num NUMBER;

Line 1284: l_partial_segments FND_FLEX_EXT.SEGMENTARRAY;

1280: overlay_segments_failure EXCEPTION;
1281: l_ccid NUMBER := p_ccid;
1282: l_chart_of_accounts_id NUMBER;
1283: l_segments FND_FLEX_EXT.SEGMENTARRAY;
1284: l_partial_segments FND_FLEX_EXT.SEGMENTARRAY;
1285: l_num_segments NUMBER;
1286: l_account_segment_num NUMBER;
1287: l_balancing_segment_num NUMBER;
1288: l_cost_center_segment_num NUMBER;

Line 1319: l_segment_delimiter := FND_FLEX_EXT.GET_DELIMITER(

1315:
1316: debug_info := 'Get segment delimiter';
1317:
1318:
1319: l_segment_delimiter := FND_FLEX_EXT.GET_DELIMITER(
1320: 'SQLGL',
1321: 'GL#',
1322: l_chart_of_accounts_id);
1323:

Line 1336: l_result := FND_FLEX_EXT.GET_SEGMENTS(

1332:
1333: IF (l_ccid IS NOT NULL) Then
1334:
1335: debug_info := 'Get segment array';
1336: l_result := FND_FLEX_EXT.GET_SEGMENTS(
1337: 'SQLGL',
1338: 'GL#',
1339: l_chart_of_accounts_id,
1340: l_ccid,

Line 1353: l_overlayed_segments := FND_FLEX_EXT.Concatenate_Segments(l_num_segments,

1349: END IF; -- l_ccid not null
1350: --
1351: -- Get concatenated segments from ccid
1352: IF (nvl(p_ccid_to_segs,'N') = 'Y') Then
1353: l_overlayed_segments := FND_FLEX_EXT.Concatenate_Segments(l_num_segments,
1354: l_segments,
1355: l_segment_delimiter);
1356:
1357: IF (NOT l_result) THEN

Line 1375: l_partial_num_segments := FND_FLEX_EXT.breakup_segments(p_concatenated_segments,

1371: IF (p_concatenated_segments IS NOT NULL) THEN
1372:
1373: debug_info := 'Get Partial segment array';
1374:
1375: l_partial_num_segments := FND_FLEX_EXT.breakup_segments(p_concatenated_segments,
1376: l_segment_delimiter,
1377: l_partial_segments); --OUT
1378:
1379: END IF;

Line 1495: l_overlayed_segments := FND_FLEX_EXT.Concatenate_Segments(l_num_segments,

1491:
1492: -- Get Concat Segments Back
1493: -- from seg array
1494:
1495: l_overlayed_segments := FND_FLEX_EXT.Concatenate_Segments(l_num_segments,
1496: l_segments,
1497: l_segment_delimiter);
1498:
1499: IF (NOT l_result) THEN

Line 1653: l_segments FND_FLEX_EXT.SEGMENTARRAY;

1649:
1650: RETURN BOOLEAN IS
1651:
1652: l_chart_of_accounts_id NUMBER;
1653: l_segments FND_FLEX_EXT.SEGMENTARRAY;
1654: l_num_segments NUMBER;
1655: l_segment_delimiter VARCHAR2(1);
1656: current_calling_sequence VARCHAR2(2000);
1657: debug_info VARCHAR2(500);

Line 1677: l_segment_delimiter := FND_FLEX_EXT.GET_DELIMITER(

1673: WHERE set_of_books_id = p_set_of_books_id;
1674:
1675: debug_info := 'Get Segment Delimiter';
1676:
1677: l_segment_delimiter := FND_FLEX_EXT.GET_DELIMITER(
1678: 'SQLGL',
1679: 'GL#',
1680: l_chart_of_accounts_id);
1681:

Line 1689: l_num_segments := FND_FLEX_EXT.breakup_segments(p_concatenated_segments,

1685: p_error_message:= FND_MESSAGE.GET;
1686: END IF;
1687:
1688: debug_info := 'Break Segments';
1689: l_num_segments := FND_FLEX_EXT.breakup_segments(p_concatenated_segments,
1690: l_segment_delimiter,
1691: l_segments); --OUT
1692:
1693: p_partial_segments_flag := 'N';

Line 1955: l_return_val := FND_FLEX_EXT.GET_SEGS(

1951: debug_info := 'Calling fnd function to validate ccid';
1952:
1953: if p_ccid <> -1 then
1954:
1955: l_return_val := FND_FLEX_EXT.GET_SEGS(
1956: APPLICATION_SHORT_NAME => 'SQLGL',
1957: KEY_FLEX_CODE => 'GL#',
1958: STRUCTURE_NUMBER => P_CHART_OF_ACCOUNTS_ID,
1959: COMBINATION_ID => P_CCID);

Line 2238: l_base_segments FND_FLEX_EXT.SEGMENTARRAY ;

2234: ,P_Reason_Unbuilt_Flex OUT NOCOPY VARCHAR2
2235: ,P_calling_sequence IN VARCHAR2
2236: ) IS
2237:
2238: l_base_segments FND_FLEX_EXT.SEGMENTARRAY ;
2239: l_overlay_segments FND_FLEX_EXT.SEGMENTARRAY ;
2240: l_segments FND_FLEX_EXT.SEGMENTARRAY ;
2241: l_num_of_segments NUMBER ;
2242: l_result BOOLEAN ;

Line 2239: l_overlay_segments FND_FLEX_EXT.SEGMENTARRAY ;

2235: ,P_calling_sequence IN VARCHAR2
2236: ) IS
2237:
2238: l_base_segments FND_FLEX_EXT.SEGMENTARRAY ;
2239: l_overlay_segments FND_FLEX_EXT.SEGMENTARRAY ;
2240: l_segments FND_FLEX_EXT.SEGMENTARRAY ;
2241: l_num_of_segments NUMBER ;
2242: l_result BOOLEAN ;
2243: l_curr_calling_sequence VARCHAR2(2000);

Line 2240: l_segments FND_FLEX_EXT.SEGMENTARRAY ;

2236: ) IS
2237:
2238: l_base_segments FND_FLEX_EXT.SEGMENTARRAY ;
2239: l_overlay_segments FND_FLEX_EXT.SEGMENTARRAY ;
2240: l_segments FND_FLEX_EXT.SEGMENTARRAY ;
2241: l_num_of_segments NUMBER ;
2242: l_result BOOLEAN ;
2243: l_curr_calling_sequence VARCHAR2(2000);
2244: G_flex_qualifier_name VARCHAR2(100);

Line 2287: IF (NOT FND_FLEX_EXT.GET_SEGMENTS('SQLGL', 'GL#',

2283: l_curr_calling_sequence := 'AP_ACCOUNTING_MAIN_PKG.Build_Offset_Account<-'
2284: || P_calling_sequence;
2285:
2286: -- Get the segments of the two given accounts
2287: IF (NOT FND_FLEX_EXT.GET_SEGMENTS('SQLGL', 'GL#',
2288: l_chart_of_accts_id,
2289: P_base_ccid, l_num_of_segments,
2290: l_base_segments)
2291: ) THEN

Line 2301: IF (NOT FND_FLEX_EXT.GET_SEGMENTS('SQLGL', 'GL#',

2297:
2298: END IF;
2299:
2300:
2301: IF (NOT FND_FLEX_EXT.GET_SEGMENTS('SQLGL', 'GL#',
2302: l_chart_of_accts_id,
2303: P_overlay_ccid, l_num_of_segments,
2304: l_overlay_segments)
2305: ) THEN

Line 2352: l_result := FND_FLEX_EXT.GET_COMBINATION_ID('SQLGL', 'GL#',

2348:
2349: END LOOP;
2350:
2351: -- Get ccid fOR overlayed segments
2352: l_result := FND_FLEX_EXT.GET_COMBINATION_ID('SQLGL', 'GL#',
2353: l_chart_of_accts_id,
2354: P_accounting_date, l_num_of_segments,
2355: l_segments, P_result_ccid) ;
2356:

Line 2397: l_base_segments FND_FLEX_EXT.SEGMENTARRAY ;

2393: FUNCTION get_auto_offsets_segments
2394: (P_base_ccid IN NUMBER) return varchar2 is
2395:
2396:
2397: l_base_segments FND_FLEX_EXT.SEGMENTARRAY ;
2398: l_overlay_segments FND_FLEX_EXT.SEGMENTARRAY ;
2399: l_segments FND_FLEX_EXT.SEGMENTARRAY ;
2400: l_num_of_segments NUMBER ;
2401: l_result BOOLEAN ;

Line 2398: l_overlay_segments FND_FLEX_EXT.SEGMENTARRAY ;

2394: (P_base_ccid IN NUMBER) return varchar2 is
2395:
2396:
2397: l_base_segments FND_FLEX_EXT.SEGMENTARRAY ;
2398: l_overlay_segments FND_FLEX_EXT.SEGMENTARRAY ;
2399: l_segments FND_FLEX_EXT.SEGMENTARRAY ;
2400: l_num_of_segments NUMBER ;
2401: l_result BOOLEAN ;
2402: l_curr_calling_sequence VARCHAR2(2000);

Line 2399: l_segments FND_FLEX_EXT.SEGMENTARRAY ;

2395:
2396:
2397: l_base_segments FND_FLEX_EXT.SEGMENTARRAY ;
2398: l_overlay_segments FND_FLEX_EXT.SEGMENTARRAY ;
2399: l_segments FND_FLEX_EXT.SEGMENTARRAY ;
2400: l_num_of_segments NUMBER ;
2401: l_result BOOLEAN ;
2402: l_curr_calling_sequence VARCHAR2(2000);
2403: G_flex_qualifier_name VARCHAR2(100);

Line 2456: IF (NOT FND_FLEX_EXT.GET_SEGMENTS('SQLGL', 'GL#',

2452:
2453: -----------------------------------------------------------------------------------------
2454: -- Get the segments of the given account
2455:
2456: IF (NOT FND_FLEX_EXT.GET_SEGMENTS('SQLGL', 'GL#',
2457: l_chart_of_accts_id,
2458: P_base_ccid, l_num_of_segments,
2459: l_base_segments)
2460: ) THEN

Line 2523: l_base_segments FND_FLEX_EXT.SEGMENTARRAY ;

2519: P_chart_of_accts_id IN GL_SETS_OF_BOOKS.chart_of_accounts_id%TYPE
2520: ) return varchar2 is
2521:
2522:
2523: l_base_segments FND_FLEX_EXT.SEGMENTARRAY ;
2524: l_overlay_segments FND_FLEX_EXT.SEGMENTARRAY ;
2525: l_segments FND_FLEX_EXT.SEGMENTARRAY ;
2526: l_result BOOLEAN ;
2527: l_curr_calling_sequence VARCHAR2(2000);

Line 2524: l_overlay_segments FND_FLEX_EXT.SEGMENTARRAY ;

2520: ) return varchar2 is
2521:
2522:
2523: l_base_segments FND_FLEX_EXT.SEGMENTARRAY ;
2524: l_overlay_segments FND_FLEX_EXT.SEGMENTARRAY ;
2525: l_segments FND_FLEX_EXT.SEGMENTARRAY ;
2526: l_result BOOLEAN ;
2527: l_curr_calling_sequence VARCHAR2(2000);
2528: l_return_segments varchar2(200) := null;

Line 2525: l_segments FND_FLEX_EXT.SEGMENTARRAY ;

2521:
2522:
2523: l_base_segments FND_FLEX_EXT.SEGMENTARRAY ;
2524: l_overlay_segments FND_FLEX_EXT.SEGMENTARRAY ;
2525: l_segments FND_FLEX_EXT.SEGMENTARRAY ;
2526: l_result BOOLEAN ;
2527: l_curr_calling_sequence VARCHAR2(2000);
2528: l_return_segments varchar2(200) := null;
2529: l_num_of_segments NUMBER;

Line 2537: IF (NOT FND_FLEX_EXT.GET_SEGMENTS('SQLGL', 'GL#',

2533:
2534: -----------------------------------------------------------------------------------------
2535: -- Get the segments of the given account
2536:
2537: IF (NOT FND_FLEX_EXT.GET_SEGMENTS('SQLGL', 'GL#',
2538: P_chart_of_accts_id,
2539: P_base_ccid, l_num_of_segments,
2540: l_base_segments)
2541: ) THEN