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

Line 34: p_segment_info IN FND_FLEX_EXT.SEGMENTARRAY,

30: -- ## inserted into a PL/SQL Table.
31: --
32:
33: PROCEDURE insert_ccid (p_ccid IN NUMBER,
34: p_segment_info IN FND_FLEX_EXT.SEGMENTARRAY,
35: p_num_segments IN NUMBER)
36: IS
37: l_count number := 0;
38: l_segment_info FND_FLEX_EXT.SEGMENTARRAY;

Line 38: l_segment_info FND_FLEX_EXT.SEGMENTARRAY;

34: p_segment_info IN FND_FLEX_EXT.SEGMENTARRAY,
35: p_num_segments IN NUMBER)
36: IS
37: l_count number := 0;
38: l_segment_info FND_FLEX_EXT.SEGMENTARRAY;
39:
40: -- ========================= FND LOG ===========================
41: l_full_path VARCHAR2(1000) := g_path || 'insert_ccid.';
42: -- ========================= FND LOG ===========================

Line 129: x_segment_info IN OUT NOCOPY FND_FLEX_EXT.SEGMENTARRAY,

125: -- ## It also return ccid and the segment details if it exist in the table
126: --
127:
128: Function is_ccid_exists(x_ccid IN OUT NOCOPY NUMBER,
129: x_segment_info IN OUT NOCOPY FND_FLEX_EXT.SEGMENTARRAY,
130: x_number_of_segments OUT NOCOPY NUMBER) return BOOLEAN
131: IS
132:
133: l_count NUMBER;

Line 135: l_segment_info FND_FLEX_EXT.SEGMENTARRAY;

131: IS
132:
133: l_count NUMBER;
134: l_no_match NUMBER;
135: l_segment_info FND_FLEX_EXT.SEGMENTARRAY;
136:
137: -- ========================= FND LOG ===========================
138: l_full_path VARCHAR2(100) := g_path || 'is_ccid_exists.';
139: -- ========================= FND LOG ===========================

Line 328: l_primary_segments FND_FLEX_EXT.SEGMENTARRAY;

324: p_trx_type IN VARCHAR2,
325: P_ccid OUT NOCOPY NUMBER)
326: RETURN BOOLEAN IS
327:
328: l_primary_segments FND_FLEX_EXT.SEGMENTARRAY;
329: l_override_segments FND_FLEX_EXT.SEGMENTARRAY;
330: l_segments FND_FLEX_EXT.SEGMENTARRAY;
331: l_chart_of_accounts_id NUMBER;
332: l_num_segments NUMBER;

Line 329: l_override_segments FND_FLEX_EXT.SEGMENTARRAY;

325: P_ccid OUT NOCOPY NUMBER)
326: RETURN BOOLEAN IS
327:
328: l_primary_segments FND_FLEX_EXT.SEGMENTARRAY;
329: l_override_segments FND_FLEX_EXT.SEGMENTARRAY;
330: l_segments FND_FLEX_EXT.SEGMENTARRAY;
331: l_chart_of_accounts_id NUMBER;
332: l_num_segments NUMBER;
333: l_natural_account GL_CODE_COMBINATIONS.SEGMENT1%TYPE;

Line 330: l_segments FND_FLEX_EXT.SEGMENTARRAY;

326: RETURN BOOLEAN IS
327:
328: l_primary_segments FND_FLEX_EXT.SEGMENTARRAY;
329: l_override_segments FND_FLEX_EXT.SEGMENTARRAY;
330: l_segments FND_FLEX_EXT.SEGMENTARRAY;
331: l_chart_of_accounts_id NUMBER;
332: l_num_segments NUMBER;
333: l_natural_account GL_CODE_COMBINATIONS.SEGMENT1%TYPE;
334: l_mapped_account GL_CODE_COMBINATIONS.SEGMENT1%TYPE;

Line 427: psa_utils.debug_other_string(g_state_level,l_full_path,' Calling FND_FLEX_EXT.GET_SEGMENTS - primary segment array');

423:
424: END IF; -- end if for chart of accounts id is null
425:
426: -- ========================= FND LOG ===========================
427: psa_utils.debug_other_string(g_state_level,l_full_path,' Calling FND_FLEX_EXT.GET_SEGMENTS - primary segment array');
428: -- ========================= FND LOG ===========================
429:
430: -- Get Primary segment array
431: l_ccid := P_primary_ccid;

Line 443: IF (NOT FND_FLEX_EXT.GET_SEGMENTS(

439: -- ========================= FND LOG ===========================
440: psa_utils.debug_other_string(g_state_level,l_full_path,' is_ccid_exists -> FALSE' );
441: -- ========================= FND LOG ===========================
442:
443: IF (NOT FND_FLEX_EXT.GET_SEGMENTS(
444: APPLICATION_SHORT_NAME => 'SQLGL',
445: KEY_FLEX_CODE => 'GL#',
446: STRUCTURE_NUMBER => g_chart_of_accounts_id,
447: COMBINATION_ID => P_primary_ccid,

Line 474: psa_utils.debug_other_string(g_state_level,l_full_path,' Calling FND_FLEX_EXT.GET_SEGMENTS - override segment array ');

470: -- ========================= FND LOG ===========================
471: END IF;
472:
473: -- ========================= FND LOG ===========================
474: psa_utils.debug_other_string(g_state_level,l_full_path,' Calling FND_FLEX_EXT.GET_SEGMENTS - override segment array ');
475: -- ========================= FND LOG ===========================
476:
477: -- Get Override segment array
478: l_ccid := P_override_ccid ;

Line 490: IF (NOT FND_FLEX_EXT.GET_SEGMENTS(

486: -- ========================= FND LOG ===========================
487: psa_utils.debug_other_string(g_state_level,l_full_path,' is_ccid_exists -> FALSE' );
488: -- ========================= FND LOG ===========================
489:
490: IF (NOT FND_FLEX_EXT.GET_SEGMENTS(
491: APPLICATION_SHORT_NAME => 'SQLGL',
492: KEY_FLEX_CODE => 'GL#',
493: STRUCTURE_NUMBER => g_chart_of_accounts_id,
494: COMBINATION_ID => P_override_ccid,

Line 596: psa_utils.debug_other_string(g_state_level,l_full_path,' Calling FND_FLEX_EXT.GET_COMBINATION_ID - overridden segments' );

592: END IF;
593: END IF;
594:
595: -- ========================= FND LOG ===========================
596: psa_utils.debug_other_string(g_state_level,l_full_path,' Calling FND_FLEX_EXT.GET_COMBINATION_ID - overridden segments' );
597: -- ========================= FND LOG ===========================
598:
599: --
600: -- Get ccid for overridden segments

Line 618: IF (NOT FND_FLEX_EXT.GET_COMBINATION_ID(

614:
615: psa_utils.debug_other_string(g_state_level,l_full_path,'L_NUM_SEG'||l_segments.count);
616:
617:
618: IF (NOT FND_FLEX_EXT.GET_COMBINATION_ID(
619: APPLICATION_SHORT_NAME => 'SQLGL',
620: KEY_FLEX_CODE => 'GL#',
621: STRUCTURE_NUMBER => g_chart_of_accounts_id,
622: VALIDATION_DATE => SYSDATE,