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 891: l_segments FND_FLEX_EXT.SEGMENTARRAY;

887:
888: overlay_segments_failure EXCEPTION;
889: l_ccid NUMBER := p_ccid;
890: l_chart_of_accounts_id NUMBER;
891: l_segments FND_FLEX_EXT.SEGMENTARRAY;
892: l_partial_segments FND_FLEX_EXT.SEGMENTARRAY;
893: l_num_segments NUMBER;
894: l_account_segment_num NUMBER;
895: l_balancing_segment_num NUMBER;

Line 892: l_partial_segments FND_FLEX_EXT.SEGMENTARRAY;

888: overlay_segments_failure EXCEPTION;
889: l_ccid NUMBER := p_ccid;
890: l_chart_of_accounts_id NUMBER;
891: l_segments FND_FLEX_EXT.SEGMENTARRAY;
892: l_partial_segments FND_FLEX_EXT.SEGMENTARRAY;
893: l_num_segments NUMBER;
894: l_account_segment_num NUMBER;
895: l_balancing_segment_num NUMBER;
896: l_cost_center_segment_num NUMBER;

Line 927: l_segment_delimiter := FND_FLEX_EXT.GET_DELIMITER(

923:
924: debug_info := 'Get segment delimiter';
925:
926:
927: l_segment_delimiter := FND_FLEX_EXT.GET_DELIMITER(
928: 'SQLGL',
929: 'GL#',
930: l_chart_of_accounts_id);
931:

Line 944: l_result := FND_FLEX_EXT.GET_SEGMENTS(

940:
941: IF (l_ccid IS NOT NULL) Then
942:
943: debug_info := 'Get segment array';
944: l_result := FND_FLEX_EXT.GET_SEGMENTS(
945: 'SQLGL',
946: 'GL#',
947: l_chart_of_accounts_id,
948: l_ccid,

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

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

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

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

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

1099:
1100: -- Get Concat Segments Back
1101: -- from seg array
1102:
1103: l_overlayed_segments := FND_FLEX_EXT.Concatenate_Segments(l_num_segments,
1104: l_segments,
1105: l_segment_delimiter);
1106:
1107: IF (NOT l_result) THEN

Line 1279: l_segments FND_FLEX_EXT.SEGMENTARRAY;

1275:
1276: overlay_segments_failure EXCEPTION;
1277: l_ccid NUMBER := p_ccid;
1278: l_chart_of_accounts_id NUMBER;
1279: l_segments FND_FLEX_EXT.SEGMENTARRAY;
1280: l_partial_segments FND_FLEX_EXT.SEGMENTARRAY;
1281: l_num_segments NUMBER;
1282: l_account_segment_num NUMBER;
1283: l_balancing_segment_num NUMBER;

Line 1280: l_partial_segments FND_FLEX_EXT.SEGMENTARRAY;

1276: overlay_segments_failure EXCEPTION;
1277: l_ccid NUMBER := p_ccid;
1278: l_chart_of_accounts_id NUMBER;
1279: l_segments FND_FLEX_EXT.SEGMENTARRAY;
1280: l_partial_segments FND_FLEX_EXT.SEGMENTARRAY;
1281: l_num_segments NUMBER;
1282: l_account_segment_num NUMBER;
1283: l_balancing_segment_num NUMBER;
1284: l_cost_center_segment_num NUMBER;

Line 1315: l_segment_delimiter := FND_FLEX_EXT.GET_DELIMITER(

1311:
1312: debug_info := 'Get segment delimiter';
1313:
1314:
1315: l_segment_delimiter := FND_FLEX_EXT.GET_DELIMITER(
1316: 'SQLGL',
1317: 'GL#',
1318: l_chart_of_accounts_id);
1319:

Line 1332: l_result := FND_FLEX_EXT.GET_SEGMENTS(

1328:
1329: IF (l_ccid IS NOT NULL) Then
1330:
1331: debug_info := 'Get segment array';
1332: l_result := FND_FLEX_EXT.GET_SEGMENTS(
1333: 'SQLGL',
1334: 'GL#',
1335: l_chart_of_accounts_id,
1336: l_ccid,

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

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

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

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

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

1487:
1488: -- Get Concat Segments Back
1489: -- from seg array
1490:
1491: l_overlayed_segments := FND_FLEX_EXT.Concatenate_Segments(l_num_segments,
1492: l_segments,
1493: l_segment_delimiter);
1494:
1495: IF (NOT l_result) THEN

Line 1649: l_segments FND_FLEX_EXT.SEGMENTARRAY;

1645:
1646: RETURN BOOLEAN IS
1647:
1648: l_chart_of_accounts_id NUMBER;
1649: l_segments FND_FLEX_EXT.SEGMENTARRAY;
1650: l_num_segments NUMBER;
1651: l_segment_delimiter VARCHAR2(1);
1652: current_calling_sequence VARCHAR2(2000);
1653: debug_info VARCHAR2(500);

Line 1673: l_segment_delimiter := FND_FLEX_EXT.GET_DELIMITER(

1669: WHERE set_of_books_id = p_set_of_books_id;
1670:
1671: debug_info := 'Get Segment Delimiter';
1672:
1673: l_segment_delimiter := FND_FLEX_EXT.GET_DELIMITER(
1674: 'SQLGL',
1675: 'GL#',
1676: l_chart_of_accounts_id);
1677:

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

1681: p_error_message:= FND_MESSAGE.GET;
1682: END IF;
1683:
1684: debug_info := 'Break Segments';
1685: l_num_segments := FND_FLEX_EXT.breakup_segments(p_concatenated_segments,
1686: l_segment_delimiter,
1687: l_segments); --OUT
1688:
1689: p_partial_segments_flag := 'N';

Line 1951: l_return_val := FND_FLEX_EXT.GET_SEGS(

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

Line 2234: l_base_segments FND_FLEX_EXT.SEGMENTARRAY ;

2230: ,P_Reason_Unbuilt_Flex OUT NOCOPY VARCHAR2
2231: ,P_calling_sequence IN VARCHAR2
2232: ) IS
2233:
2234: l_base_segments FND_FLEX_EXT.SEGMENTARRAY ;
2235: l_overlay_segments FND_FLEX_EXT.SEGMENTARRAY ;
2236: l_segments FND_FLEX_EXT.SEGMENTARRAY ;
2237: l_num_of_segments NUMBER ;
2238: l_result BOOLEAN ;

Line 2235: l_overlay_segments FND_FLEX_EXT.SEGMENTARRAY ;

2231: ,P_calling_sequence IN VARCHAR2
2232: ) IS
2233:
2234: l_base_segments FND_FLEX_EXT.SEGMENTARRAY ;
2235: l_overlay_segments FND_FLEX_EXT.SEGMENTARRAY ;
2236: l_segments FND_FLEX_EXT.SEGMENTARRAY ;
2237: l_num_of_segments NUMBER ;
2238: l_result BOOLEAN ;
2239: l_curr_calling_sequence VARCHAR2(2000);

Line 2236: l_segments FND_FLEX_EXT.SEGMENTARRAY ;

2232: ) IS
2233:
2234: l_base_segments FND_FLEX_EXT.SEGMENTARRAY ;
2235: l_overlay_segments FND_FLEX_EXT.SEGMENTARRAY ;
2236: l_segments FND_FLEX_EXT.SEGMENTARRAY ;
2237: l_num_of_segments NUMBER ;
2238: l_result BOOLEAN ;
2239: l_curr_calling_sequence VARCHAR2(2000);
2240: G_flex_qualifier_name VARCHAR2(100);

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

2278: l_curr_calling_sequence := 'AP_ACCOUNTING_MAIN_PKG.Build_Offset_Account<-'
2279: || P_calling_sequence;
2280:
2281: -- Get the segments of the two given accounts
2282: IF (NOT FND_FLEX_EXT.GET_SEGMENTS('SQLGL', 'GL#',
2283: l_chart_of_accts_id,
2284: P_base_ccid, l_num_of_segments,
2285: l_base_segments)
2286: ) THEN

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

2292:
2293: END IF;
2294:
2295:
2296: IF (NOT FND_FLEX_EXT.GET_SEGMENTS('SQLGL', 'GL#',
2297: l_chart_of_accts_id,
2298: P_overlay_ccid, l_num_of_segments,
2299: l_overlay_segments)
2300: ) THEN

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

2343:
2344: END LOOP;
2345:
2346: -- Get ccid fOR overlayed segments
2347: l_result := FND_FLEX_EXT.GET_COMBINATION_ID('SQLGL', 'GL#',
2348: l_chart_of_accts_id,
2349: P_accounting_date, l_num_of_segments,
2350: l_segments, P_result_ccid) ;
2351:

Line 2392: l_base_segments FND_FLEX_EXT.SEGMENTARRAY ;

2388: FUNCTION get_auto_offsets_segments
2389: (P_base_ccid IN NUMBER) return varchar2 is
2390:
2391:
2392: l_base_segments FND_FLEX_EXT.SEGMENTARRAY ;
2393: l_overlay_segments FND_FLEX_EXT.SEGMENTARRAY ;
2394: l_segments FND_FLEX_EXT.SEGMENTARRAY ;
2395: l_num_of_segments NUMBER ;
2396: l_result BOOLEAN ;

Line 2393: l_overlay_segments FND_FLEX_EXT.SEGMENTARRAY ;

2389: (P_base_ccid IN NUMBER) return varchar2 is
2390:
2391:
2392: l_base_segments FND_FLEX_EXT.SEGMENTARRAY ;
2393: l_overlay_segments FND_FLEX_EXT.SEGMENTARRAY ;
2394: l_segments FND_FLEX_EXT.SEGMENTARRAY ;
2395: l_num_of_segments NUMBER ;
2396: l_result BOOLEAN ;
2397: l_curr_calling_sequence VARCHAR2(2000);

Line 2394: l_segments FND_FLEX_EXT.SEGMENTARRAY ;

2390:
2391:
2392: l_base_segments FND_FLEX_EXT.SEGMENTARRAY ;
2393: l_overlay_segments FND_FLEX_EXT.SEGMENTARRAY ;
2394: l_segments FND_FLEX_EXT.SEGMENTARRAY ;
2395: l_num_of_segments NUMBER ;
2396: l_result BOOLEAN ;
2397: l_curr_calling_sequence VARCHAR2(2000);
2398: G_flex_qualifier_name VARCHAR2(100);

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

2447:
2448: -----------------------------------------------------------------------------------------
2449: -- Get the segments of the given account
2450:
2451: IF (NOT FND_FLEX_EXT.GET_SEGMENTS('SQLGL', 'GL#',
2452: l_chart_of_accts_id,
2453: P_base_ccid, l_num_of_segments,
2454: l_base_segments)
2455: ) THEN

Line 2518: l_base_segments FND_FLEX_EXT.SEGMENTARRAY ;

2514: P_chart_of_accts_id IN GL_SETS_OF_BOOKS.chart_of_accounts_id%TYPE
2515: ) return varchar2 is
2516:
2517:
2518: l_base_segments FND_FLEX_EXT.SEGMENTARRAY ;
2519: l_overlay_segments FND_FLEX_EXT.SEGMENTARRAY ;
2520: l_segments FND_FLEX_EXT.SEGMENTARRAY ;
2521: l_result BOOLEAN ;
2522: l_curr_calling_sequence VARCHAR2(2000);

Line 2519: l_overlay_segments FND_FLEX_EXT.SEGMENTARRAY ;

2515: ) return varchar2 is
2516:
2517:
2518: l_base_segments FND_FLEX_EXT.SEGMENTARRAY ;
2519: l_overlay_segments FND_FLEX_EXT.SEGMENTARRAY ;
2520: l_segments FND_FLEX_EXT.SEGMENTARRAY ;
2521: l_result BOOLEAN ;
2522: l_curr_calling_sequence VARCHAR2(2000);
2523: l_return_segments varchar2(200) := null;

Line 2520: l_segments FND_FLEX_EXT.SEGMENTARRAY ;

2516:
2517:
2518: l_base_segments FND_FLEX_EXT.SEGMENTARRAY ;
2519: l_overlay_segments FND_FLEX_EXT.SEGMENTARRAY ;
2520: l_segments FND_FLEX_EXT.SEGMENTARRAY ;
2521: l_result BOOLEAN ;
2522: l_curr_calling_sequence VARCHAR2(2000);
2523: l_return_segments varchar2(200) := null;
2524: l_num_of_segments NUMBER;

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

2528:
2529: -----------------------------------------------------------------------------------------
2530: -- Get the segments of the given account
2531:
2532: IF (NOT FND_FLEX_EXT.GET_SEGMENTS('SQLGL', 'GL#',
2533: P_chart_of_accts_id,
2534: P_base_ccid, l_num_of_segments,
2535: l_base_segments)
2536: ) THEN