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 749: l_segment_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE;

745: v_R_ledgerSQL varchar2(300);
746: l_index number;
747: l_r_index number;
748: p_count number;
749: l_segment_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE;
750: l_column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;
751: l_display_size FND_ID_FLEX_SEGMENTS.DISPLAY_SIZE%TYPE;
752: l_r_segment_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE;
753: l_r_column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;

Line 750: l_column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;

746: l_index number;
747: l_r_index number;
748: p_count number;
749: l_segment_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE;
750: l_column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;
751: l_display_size FND_ID_FLEX_SEGMENTS.DISPLAY_SIZE%TYPE;
752: l_r_segment_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE;
753: l_r_column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;
754: l_r_display_size FND_ID_FLEX_SEGMENTS.DISPLAY_SIZE%TYPE;

Line 751: l_display_size FND_ID_FLEX_SEGMENTS.DISPLAY_SIZE%TYPE;

747: l_r_index number;
748: p_count number;
749: l_segment_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE;
750: l_column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;
751: l_display_size FND_ID_FLEX_SEGMENTS.DISPLAY_SIZE%TYPE;
752: l_r_segment_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE;
753: l_r_column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;
754: l_r_display_size FND_ID_FLEX_SEGMENTS.DISPLAY_SIZE%TYPE;
755: l_app_id FND_ID_FLEX_SEGMENTS.APPLICATION_ID%TYPE;

Line 752: l_r_segment_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE;

748: p_count number;
749: l_segment_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE;
750: l_column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;
751: l_display_size FND_ID_FLEX_SEGMENTS.DISPLAY_SIZE%TYPE;
752: l_r_segment_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE;
753: l_r_column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;
754: l_r_display_size FND_ID_FLEX_SEGMENTS.DISPLAY_SIZE%TYPE;
755: l_app_id FND_ID_FLEX_SEGMENTS.APPLICATION_ID%TYPE;
756: l_gl_short_name FND_ID_FLEX_SEGMENTS.ID_FLEX_CODE%TYPE;

Line 753: l_r_column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;

749: l_segment_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE;
750: l_column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;
751: l_display_size FND_ID_FLEX_SEGMENTS.DISPLAY_SIZE%TYPE;
752: l_r_segment_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE;
753: l_r_column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;
754: l_r_display_size FND_ID_FLEX_SEGMENTS.DISPLAY_SIZE%TYPE;
755: l_app_id FND_ID_FLEX_SEGMENTS.APPLICATION_ID%TYPE;
756: l_gl_short_name FND_ID_FLEX_SEGMENTS.ID_FLEX_CODE%TYPE;
757: result varchar2(100);

Line 754: l_r_display_size FND_ID_FLEX_SEGMENTS.DISPLAY_SIZE%TYPE;

750: l_column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;
751: l_display_size FND_ID_FLEX_SEGMENTS.DISPLAY_SIZE%TYPE;
752: l_r_segment_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE;
753: l_r_column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;
754: l_r_display_size FND_ID_FLEX_SEGMENTS.DISPLAY_SIZE%TYPE;
755: l_app_id FND_ID_FLEX_SEGMENTS.APPLICATION_ID%TYPE;
756: l_gl_short_name FND_ID_FLEX_SEGMENTS.ID_FLEX_CODE%TYPE;
757: result varchar2(100);
758: dblink varchar2(100);

Line 755: l_app_id FND_ID_FLEX_SEGMENTS.APPLICATION_ID%TYPE;

751: l_display_size FND_ID_FLEX_SEGMENTS.DISPLAY_SIZE%TYPE;
752: l_r_segment_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE;
753: l_r_column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;
754: l_r_display_size FND_ID_FLEX_SEGMENTS.DISPLAY_SIZE%TYPE;
755: l_app_id FND_ID_FLEX_SEGMENTS.APPLICATION_ID%TYPE;
756: l_gl_short_name FND_ID_FLEX_SEGMENTS.ID_FLEX_CODE%TYPE;
757: result varchar2(100);
758: dblink varchar2(100);
759: l_access_set_name varchar2(30);

Line 756: l_gl_short_name FND_ID_FLEX_SEGMENTS.ID_FLEX_CODE%TYPE;

752: l_r_segment_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE;
753: l_r_column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;
754: l_r_display_size FND_ID_FLEX_SEGMENTS.DISPLAY_SIZE%TYPE;
755: l_app_id FND_ID_FLEX_SEGMENTS.APPLICATION_ID%TYPE;
756: l_gl_short_name FND_ID_FLEX_SEGMENTS.ID_FLEX_CODE%TYPE;
757: result varchar2(100);
758: dblink varchar2(100);
759: l_access_set_name varchar2(30);
760: BEGIN

Line 778: 'FND_ID_FLEX_SEGMENTS s ' ||

774: v_SQL := 'SELECT s.SEGMENT_NUM, ' ||
775: 's.APPLICATION_COLUMN_NAME, ' ||
776: 's.DISPLAY_SIZE ' ||
777: 'FROM FND_FLEX_VALUE_SETS vs, ' ||
778: 'FND_ID_FLEX_SEGMENTS s ' ||
779: 'WHERE vs.flex_value_set_id = s.flex_value_set_id ' ||
780: 'AND s.ID_FLEX_NUM = :coa_id ' ||
781: 'AND s.application_id = :app_id ' ||
782: 'AND s.id_flex_code = :gl' ||