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.GL_CI_DATA_TRANSFER_PKG dependencies on FND_ID_FLEX_SEGMENTS

Line 743: l_segment_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE;

739: v_R_ledgerSQL varchar2(300);
740: l_index number;
741: l_r_index number;
742: p_count number;
743: l_segment_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE;
744: l_column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;
745: l_display_size FND_ID_FLEX_SEGMENTS.DISPLAY_SIZE%TYPE;
746: l_r_segment_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE;
747: l_r_column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;

Line 744: l_column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;

740: l_index number;
741: l_r_index number;
742: p_count number;
743: l_segment_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE;
744: l_column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;
745: l_display_size FND_ID_FLEX_SEGMENTS.DISPLAY_SIZE%TYPE;
746: l_r_segment_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE;
747: l_r_column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;
748: l_r_display_size FND_ID_FLEX_SEGMENTS.DISPLAY_SIZE%TYPE;

Line 745: l_display_size FND_ID_FLEX_SEGMENTS.DISPLAY_SIZE%TYPE;

741: l_r_index number;
742: p_count number;
743: l_segment_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE;
744: l_column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;
745: l_display_size FND_ID_FLEX_SEGMENTS.DISPLAY_SIZE%TYPE;
746: l_r_segment_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE;
747: l_r_column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;
748: l_r_display_size FND_ID_FLEX_SEGMENTS.DISPLAY_SIZE%TYPE;
749: l_app_id FND_ID_FLEX_SEGMENTS.APPLICATION_ID%TYPE;

Line 746: l_r_segment_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE;

742: p_count number;
743: l_segment_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE;
744: l_column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;
745: l_display_size FND_ID_FLEX_SEGMENTS.DISPLAY_SIZE%TYPE;
746: l_r_segment_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE;
747: l_r_column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;
748: l_r_display_size FND_ID_FLEX_SEGMENTS.DISPLAY_SIZE%TYPE;
749: l_app_id FND_ID_FLEX_SEGMENTS.APPLICATION_ID%TYPE;
750: l_gl_short_name FND_ID_FLEX_SEGMENTS.ID_FLEX_CODE%TYPE;

Line 747: l_r_column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;

743: l_segment_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE;
744: l_column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;
745: l_display_size FND_ID_FLEX_SEGMENTS.DISPLAY_SIZE%TYPE;
746: l_r_segment_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE;
747: l_r_column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;
748: l_r_display_size FND_ID_FLEX_SEGMENTS.DISPLAY_SIZE%TYPE;
749: l_app_id FND_ID_FLEX_SEGMENTS.APPLICATION_ID%TYPE;
750: l_gl_short_name FND_ID_FLEX_SEGMENTS.ID_FLEX_CODE%TYPE;
751: result varchar2(100);

Line 748: l_r_display_size FND_ID_FLEX_SEGMENTS.DISPLAY_SIZE%TYPE;

744: l_column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;
745: l_display_size FND_ID_FLEX_SEGMENTS.DISPLAY_SIZE%TYPE;
746: l_r_segment_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE;
747: l_r_column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;
748: l_r_display_size FND_ID_FLEX_SEGMENTS.DISPLAY_SIZE%TYPE;
749: l_app_id FND_ID_FLEX_SEGMENTS.APPLICATION_ID%TYPE;
750: l_gl_short_name FND_ID_FLEX_SEGMENTS.ID_FLEX_CODE%TYPE;
751: result varchar2(100);
752: dblink varchar2(100);

Line 749: l_app_id FND_ID_FLEX_SEGMENTS.APPLICATION_ID%TYPE;

745: l_display_size FND_ID_FLEX_SEGMENTS.DISPLAY_SIZE%TYPE;
746: l_r_segment_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE;
747: l_r_column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;
748: l_r_display_size FND_ID_FLEX_SEGMENTS.DISPLAY_SIZE%TYPE;
749: l_app_id FND_ID_FLEX_SEGMENTS.APPLICATION_ID%TYPE;
750: l_gl_short_name FND_ID_FLEX_SEGMENTS.ID_FLEX_CODE%TYPE;
751: result varchar2(100);
752: dblink varchar2(100);
753: l_access_set_name varchar2(30);

Line 750: l_gl_short_name FND_ID_FLEX_SEGMENTS.ID_FLEX_CODE%TYPE;

746: l_r_segment_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE;
747: l_r_column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;
748: l_r_display_size FND_ID_FLEX_SEGMENTS.DISPLAY_SIZE%TYPE;
749: l_app_id FND_ID_FLEX_SEGMENTS.APPLICATION_ID%TYPE;
750: l_gl_short_name FND_ID_FLEX_SEGMENTS.ID_FLEX_CODE%TYPE;
751: result varchar2(100);
752: dblink varchar2(100);
753: l_access_set_name varchar2(30);
754: BEGIN

Line 772: 'FND_ID_FLEX_SEGMENTS s ' ||

768: v_SQL := 'SELECT s.SEGMENT_NUM, ' ||
769: 's.APPLICATION_COLUMN_NAME, ' ||
770: 's.DISPLAY_SIZE ' ||
771: 'FROM FND_FLEX_VALUE_SETS vs, ' ||
772: 'FND_ID_FLEX_SEGMENTS s ' ||
773: 'WHERE vs.flex_value_set_id = s.flex_value_set_id ' ||
774: 'AND s.ID_FLEX_NUM = :coa_id ' ||
775: 'AND s.application_id = :app_id ' ||
776: 'AND s.id_flex_code = :gl' ||