DBA Data[Home] [Help]

APPS.AP_CARD_UTILITY_PKG dependencies on FND_FLEX_EXT

Line 42: l_segments FND_FLEX_EXT.SEGMENTARRAY;

38: P_CALLING_SEQUENCE IN VARCHAR2,
39: P_EMPLOYEE_ID IN NUMBER,
40: P_CCID OUT NOCOPY VARCHAR )
41: IS
42: l_segments FND_FLEX_EXT.SEGMENTARRAY;
43: l_code_combination_id NUMBER;
44: l_num_segments NUMBER;
45: l_flex_segment_number NUMBER;
46: l_cc_flex_segment_number NUMBER;

Line 114: l_flex_segment_delimiter := FND_FLEX_EXT.GET_DELIMITER(

110: ----------------------------------------
111: l_debug_info := 'Get Segment Delimiter';
112: ----------------------------------------
113:
114: l_flex_segment_delimiter := FND_FLEX_EXT.GET_DELIMITER(
115: 'SQLGL',
116: 'GL#',
117: l_chart_of_accounts_id);
118:

Line 160: IF (NOT FND_FLEX_EXT.GET_SEGMENTS(

156: l_debug_info := 'Get ccid account segments';
157: -----------------------------------------------------------------
158: if (nvl(P_CODE_COMBINATION_ID,-1) <> -1) then
159:
160: IF (NOT FND_FLEX_EXT.GET_SEGMENTS(
161: 'SQLGL',
162: 'GL#',
163: l_chart_of_accounts_id,
164: P_CODE_COMBINATION_ID,

Line 193: l_concatenated_segments := FND_FLEX_EXT.concatenate_segments(l_num_segments,

189:
190: --------------------------------------------------------------
191: l_debug_info := 'Retrieve new ccid with overlaid segments';
192:
193: l_concatenated_segments := FND_FLEX_EXT.concatenate_segments(l_num_segments,
194: l_segments,
195: l_flex_segment_delimiter);
196:
197: IF (NOT AP_CARD_UTILITY_PKG.GET_COMBINATION_ID(

Line 222: p_segments IN fnd_flex_ext.SegmentArray,

218: p_key_flex_code IN VARCHAR2,
219: p_structure_number IN NUMBER,
220: p_validation_date IN DATE,
221: p_n_segments IN NUMBER,
222: p_segments IN fnd_flex_ext.SegmentArray,
223: p_concatSegments IN VARCHAR2,
224: p_combination_id OUT NOCOPY NUMBER,
225: p_return_error_message IN OUT NOCOPY VARCHAR2) RETURN BOOLEAN IS
226: -------------------------------------------------------------------------------

Line 444: L_DEFAULT_EMP_SEGMENTS FND_FLEX_EXT.SEGMENTARRAY;

440: L_DEFAULT_EMP_CCID NUMBER;
441: L_FLEX_SEGMENT_DELIMITER VARCHAR2(1);
442: L_FLEX_SEGMENT_NUMBER NUMBER;
443: L_NUM_SEGMENTS NUMBER;
444: L_DEFAULT_EMP_SEGMENTS FND_FLEX_EXT.SEGMENTARRAY;
445: L_CONCATENATED_SEGMENTS VARCHAR2(2000);
446: L_APPCOL_NAME FND_ID_FLEX_SEGMENTS_VL.APPLICATION_COLUMN_NAME%TYPE;
447: L_SEG_NAME FND_ID_FLEX_SEGMENTS_VL.SEGMENT_NAME%TYPE;
448: L_PROMPT FND_ID_FLEX_SEGMENTS_VL.FORM_LEFT_PROMPT%TYPE;

Line 494: l_flex_segment_delimiter := FND_FLEX_EXT.GET_DELIMITER(

490: l_chart_of_accounts_id := l_ou_chart_of_accounts_id;
491:
492: -- Get the character used as the segment delimiter. This would be
493: -- used to prepare the concatenated segment from segment array to a string.
494: l_flex_segment_delimiter := FND_FLEX_EXT.GET_DELIMITER(
495: 'SQLGL',
496: 'GL#',
497: l_chart_of_accounts_id);
498:

Line 513: if (NOT FND_FLEX_EXT.GET_SEGMENTS(

509: end if;
510:
511: -- Get the segment array and number of segments for the employee
512: -- code combination id.
513: if (NOT FND_FLEX_EXT.GET_SEGMENTS(
514: 'SQLGL',
515: 'GL#',
516: l_chart_of_accounts_id,
517: l_default_emp_ccid,

Line 562: l_concatenated_segments := FND_FLEX_EXT.concatenate_segments(l_num_segments,

558:
559: -- Get the concatenated segments with all segments set to null, except the
560: -- costcenter, Concatenates segments from segment array
561: -- (l_default_emp_segments) to a string(l_concatenated_segments).
562: l_concatenated_segments := FND_FLEX_EXT.concatenate_segments(l_num_segments,
563: l_default_emp_segments,
564: l_flex_segment_delimiter);
565:
566: /* -----------------------------------------------------------------------+