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.CN_PLAN_ELEMENT_PVT dependencies on FND_FLEX_KEY_API

Line 1132: kff fnd_flex_key_api.flexfield_type;

1128: p_account_input IN VARCHAR2,
1129: x_ccid OUT NOCOPY NUMBER
1130: )
1131: IS
1132: kff fnd_flex_key_api.flexfield_type;
1133: str fnd_flex_key_api.structure_type;
1134: seg fnd_flex_key_api.segment_type;
1135: seg_list fnd_flex_key_api.segment_list;
1136: j NUMBER;

Line 1133: str fnd_flex_key_api.structure_type;

1129: x_ccid OUT NOCOPY NUMBER
1130: )
1131: IS
1132: kff fnd_flex_key_api.flexfield_type;
1133: str fnd_flex_key_api.structure_type;
1134: seg fnd_flex_key_api.segment_type;
1135: seg_list fnd_flex_key_api.segment_list;
1136: j NUMBER;
1137: i NUMBER;

Line 1134: seg fnd_flex_key_api.segment_type;

1130: )
1131: IS
1132: kff fnd_flex_key_api.flexfield_type;
1133: str fnd_flex_key_api.structure_type;
1134: seg fnd_flex_key_api.segment_type;
1135: seg_list fnd_flex_key_api.segment_list;
1136: j NUMBER;
1137: i NUMBER;
1138: nsegs NUMBER;

Line 1135: seg_list fnd_flex_key_api.segment_list;

1131: IS
1132: kff fnd_flex_key_api.flexfield_type;
1133: str fnd_flex_key_api.structure_type;
1134: seg fnd_flex_key_api.segment_type;
1135: seg_list fnd_flex_key_api.segment_list;
1136: j NUMBER;
1137: i NUMBER;
1138: nsegs NUMBER;
1139: l_count NUMBER;

Line 1159: fnd_flex_key_api.set_session_mode ('customer_data');

1155: FROM gl_sets_of_books gsb,
1156: cn_repositories cr
1157: WHERE cr.set_of_books_id = gsb.set_of_books_id;
1158:
1159: fnd_flex_key_api.set_session_mode ('customer_data');
1160: kff := fnd_flex_key_api.find_flexfield ('SQLGL', 'GL#');
1161: str := fnd_flex_key_api.find_structure (kff, l_chart_of_accounts_id);
1162: fnd_flex_key_api.get_segments (kff, str, TRUE, nsegs, seg_list);
1163: --

Line 1160: kff := fnd_flex_key_api.find_flexfield ('SQLGL', 'GL#');

1156: cn_repositories cr
1157: WHERE cr.set_of_books_id = gsb.set_of_books_id;
1158:
1159: fnd_flex_key_api.set_session_mode ('customer_data');
1160: kff := fnd_flex_key_api.find_flexfield ('SQLGL', 'GL#');
1161: str := fnd_flex_key_api.find_structure (kff, l_chart_of_accounts_id);
1162: fnd_flex_key_api.get_segments (kff, str, TRUE, nsegs, seg_list);
1163: --
1164: -- The segments in the seg_list array are sorted in display order.

Line 1161: str := fnd_flex_key_api.find_structure (kff, l_chart_of_accounts_id);

1157: WHERE cr.set_of_books_id = gsb.set_of_books_id;
1158:
1159: fnd_flex_key_api.set_session_mode ('customer_data');
1160: kff := fnd_flex_key_api.find_flexfield ('SQLGL', 'GL#');
1161: str := fnd_flex_key_api.find_structure (kff, l_chart_of_accounts_id);
1162: fnd_flex_key_api.get_segments (kff, str, TRUE, nsegs, seg_list);
1163: --
1164: -- The segments in the seg_list array are sorted in display order.
1165: -- i.e. sorted by segment number.

Line 1162: fnd_flex_key_api.get_segments (kff, str, TRUE, nsegs, seg_list);

1158:
1159: fnd_flex_key_api.set_session_mode ('customer_data');
1160: kff := fnd_flex_key_api.find_flexfield ('SQLGL', 'GL#');
1161: str := fnd_flex_key_api.find_structure (kff, l_chart_of_accounts_id);
1162: fnd_flex_key_api.get_segments (kff, str, TRUE, nsegs, seg_list);
1163: --
1164: -- The segments in the seg_list array are sorted in display order.
1165: -- i.e. sorted by segment number.
1166: --

Line 1172: seg := fnd_flex_key_api.find_segment (kff, str, seg_list (i));

1168: where_stmt := ' ';
1169:
1170: FOR i IN 1 .. nsegs
1171: LOOP
1172: seg := fnd_flex_key_api.find_segment (kff, str, seg_list (i));
1173: segment_descr := segment_descr || seg.segment_name;
1174: where_stmt := where_stmt || seg.column_name;
1175:
1176: IF i <> nsegs

Line 1236: seg := fnd_flex_key_api.find_segment (kff, str, seg_list (i));

1232: where_stmt := ' ';
1233:
1234: FOR i IN 1 .. nsegs
1235: LOOP
1236: seg := fnd_flex_key_api.find_segment (kff, str, seg_list (i));
1237: segment_descr := segment_descr || seg.segment_name;
1238: where_stmt := where_stmt || seg.column_name;
1239:
1240: IF i <> nsegs