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_REMOTE_INVOKE_PKG dependencies on FND_ID_FLEX_SEGMENTS

Line 46: l_r_segment_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE;

42: p_count IN OUT NOCOPY Number)
43: IS
44: v_R_COACursor t_RefCur;
45: v_R_SQL varchar2(3000);
46: l_r_segment_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE;
47: l_r_column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;
48: l_r_display_size FND_ID_FLEX_SEGMENTS.DISPLAY_SIZE%TYPE;
49: l_app_id FND_ID_FLEX_SEGMENTS.APPLICATION_ID%TYPE;
50: l_gl_short_name FND_ID_FLEX_SEGMENTS.ID_FLEX_CODE%TYPE;

Line 47: l_r_column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;

43: IS
44: v_R_COACursor t_RefCur;
45: v_R_SQL varchar2(3000);
46: l_r_segment_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE;
47: l_r_column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;
48: l_r_display_size FND_ID_FLEX_SEGMENTS.DISPLAY_SIZE%TYPE;
49: l_app_id FND_ID_FLEX_SEGMENTS.APPLICATION_ID%TYPE;
50: l_gl_short_name FND_ID_FLEX_SEGMENTS.ID_FLEX_CODE%TYPE;
51: l_r_index number;

Line 48: l_r_display_size FND_ID_FLEX_SEGMENTS.DISPLAY_SIZE%TYPE;

44: v_R_COACursor t_RefCur;
45: v_R_SQL varchar2(3000);
46: l_r_segment_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE;
47: l_r_column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;
48: l_r_display_size FND_ID_FLEX_SEGMENTS.DISPLAY_SIZE%TYPE;
49: l_app_id FND_ID_FLEX_SEGMENTS.APPLICATION_ID%TYPE;
50: l_gl_short_name FND_ID_FLEX_SEGMENTS.ID_FLEX_CODE%TYPE;
51: l_r_index number;
52: l_chart coa_table;

Line 49: l_app_id FND_ID_FLEX_SEGMENTS.APPLICATION_ID%TYPE;

45: v_R_SQL varchar2(3000);
46: l_r_segment_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE;
47: l_r_column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;
48: l_r_display_size FND_ID_FLEX_SEGMENTS.DISPLAY_SIZE%TYPE;
49: l_app_id FND_ID_FLEX_SEGMENTS.APPLICATION_ID%TYPE;
50: l_gl_short_name FND_ID_FLEX_SEGMENTS.ID_FLEX_CODE%TYPE;
51: l_r_index number;
52: l_chart coa_table;
53: BEGIN

Line 50: l_gl_short_name FND_ID_FLEX_SEGMENTS.ID_FLEX_CODE%TYPE;

46: l_r_segment_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE;
47: l_r_column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;
48: l_r_display_size FND_ID_FLEX_SEGMENTS.DISPLAY_SIZE%TYPE;
49: l_app_id FND_ID_FLEX_SEGMENTS.APPLICATION_ID%TYPE;
50: l_gl_short_name FND_ID_FLEX_SEGMENTS.ID_FLEX_CODE%TYPE;
51: l_r_index number;
52: l_chart coa_table;
53: BEGIN
54: l_r_index := 1;

Line 62: 'FND_ID_FLEX_SEGMENTS s ' ||

58: v_R_SQL := 'SELECT s.SEGMENT_NUM, ' ||
59: 's.APPLICATION_COLUMN_NAME, ' ||
60: 's.DISPLAY_SIZE ' ||
61: 'FROM FND_FLEX_VALUE_SETS vs, ' ||
62: 'FND_ID_FLEX_SEGMENTS s ' ||
63: 'WHERE vs.flex_value_set_id = s.flex_value_set_id ' ||
64: 'AND s.ID_FLEX_NUM = :coa_id ' ||
65: 'AND s.application_id = :app_id ' ||
66: 'AND s.id_flex_code = :gl' ||

Line 95: l_r_segment_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE;

91: p_display_size IN OUT NOCOPY number)
92: IS
93: v_R_COACursor t_RefCur;
94: v_R_SQL varchar2(3000);
95: l_r_segment_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE;
96: l_r_column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;
97: l_r_display_size FND_ID_FLEX_SEGMENTS.DISPLAY_SIZE%TYPE;
98: l_app_id FND_ID_FLEX_SEGMENTS.APPLICATION_ID%TYPE;
99: l_gl_short_name FND_ID_FLEX_SEGMENTS.ID_FLEX_CODE%TYPE;

Line 96: l_r_column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;

92: IS
93: v_R_COACursor t_RefCur;
94: v_R_SQL varchar2(3000);
95: l_r_segment_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE;
96: l_r_column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;
97: l_r_display_size FND_ID_FLEX_SEGMENTS.DISPLAY_SIZE%TYPE;
98: l_app_id FND_ID_FLEX_SEGMENTS.APPLICATION_ID%TYPE;
99: l_gl_short_name FND_ID_FLEX_SEGMENTS.ID_FLEX_CODE%TYPE;
100: l_r_index number;

Line 97: l_r_display_size FND_ID_FLEX_SEGMENTS.DISPLAY_SIZE%TYPE;

93: v_R_COACursor t_RefCur;
94: v_R_SQL varchar2(3000);
95: l_r_segment_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE;
96: l_r_column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;
97: l_r_display_size FND_ID_FLEX_SEGMENTS.DISPLAY_SIZE%TYPE;
98: l_app_id FND_ID_FLEX_SEGMENTS.APPLICATION_ID%TYPE;
99: l_gl_short_name FND_ID_FLEX_SEGMENTS.ID_FLEX_CODE%TYPE;
100: l_r_index number;
101: l_chart coa_table;

Line 98: l_app_id FND_ID_FLEX_SEGMENTS.APPLICATION_ID%TYPE;

94: v_R_SQL varchar2(3000);
95: l_r_segment_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE;
96: l_r_column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;
97: l_r_display_size FND_ID_FLEX_SEGMENTS.DISPLAY_SIZE%TYPE;
98: l_app_id FND_ID_FLEX_SEGMENTS.APPLICATION_ID%TYPE;
99: l_gl_short_name FND_ID_FLEX_SEGMENTS.ID_FLEX_CODE%TYPE;
100: l_r_index number;
101: l_chart coa_table;
102: BEGIN

Line 99: l_gl_short_name FND_ID_FLEX_SEGMENTS.ID_FLEX_CODE%TYPE;

95: l_r_segment_num FND_ID_FLEX_SEGMENTS.SEGMENT_NUM%TYPE;
96: l_r_column_name FND_ID_FLEX_SEGMENTS.APPLICATION_COLUMN_NAME%TYPE;
97: l_r_display_size FND_ID_FLEX_SEGMENTS.DISPLAY_SIZE%TYPE;
98: l_app_id FND_ID_FLEX_SEGMENTS.APPLICATION_ID%TYPE;
99: l_gl_short_name FND_ID_FLEX_SEGMENTS.ID_FLEX_CODE%TYPE;
100: l_r_index number;
101: l_chart coa_table;
102: BEGIN
103: l_r_index := 1;

Line 110: 'FND_ID_FLEX_SEGMENTS s ' ||

106: v_R_SQL := 'SELECT s.SEGMENT_NUM, ' ||
107: 's.APPLICATION_COLUMN_NAME, ' ||
108: 's.DISPLAY_SIZE ' ||
109: 'FROM FND_FLEX_VALUE_SETS vs, ' ||
110: 'FND_ID_FLEX_SEGMENTS s ' ||
111: 'WHERE vs.flex_value_set_id = s.flex_value_set_id ' ||
112: 'AND s.ID_FLEX_NUM = :coa_id ' ||
113: 'AND s.application_id = :app_id ' ||
114: 'AND s.id_flex_code = :gl_name' ||

Line 182: l_app_id FND_ID_FLEX_SEGMENTS.APPLICATION_ID%TYPE;

178: ) return number
179: IS
180: l_resp_id number;
181: v_SQL1 varchar2(500);
182: l_app_id FND_ID_FLEX_SEGMENTS.APPLICATION_ID%TYPE;
183: begin
184: l_app_id := 101;
185: v_SQL1 := 'select responsibility_id from fnd_responsibility_tl' ||
186: ' where responsibility_name = :name' ||

Line 355: l_app_id FND_ID_FLEX_SEGMENTS.APPLICATION_ID%TYPE;

351: select user_id
352: from fnd_user
353: where user_name = p_user_name;
354: return_value boolean;
355: l_app_id FND_ID_FLEX_SEGMENTS.APPLICATION_ID%TYPE;
356: BEGIN
357: return_value := FALSE;
358: open user_id_cursor;
359: fetch user_id_cursor into user_id;

Line 385: l_app_id FND_ID_FLEX_SEGMENTS.APPLICATION_ID%TYPE;

381: IS
382: l_count number;
383: v_SelectSQL2 varchar2(1000);
384: l_error_code number;
385: l_app_id FND_ID_FLEX_SEGMENTS.APPLICATION_ID%TYPE;
386: begin
387: l_error_code := 0;
388: l_app_id := 101;
389: l_count := 0;