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_API dependencies on FND_FLEX_KEY_API

Line 2369: kff fnd_flex_key_api.flexfield_type;

2365: p_org_id IN NUMBER,
2366: x_account_structure OUT NOCOPY varchar2,
2367: x_code_combinations OUT NOCOPY code_combination_tbl) IS
2368:
2369: kff fnd_flex_key_api.flexfield_type;
2370: str fnd_flex_key_api.structure_type;
2371: seg fnd_flex_key_api.segment_type;
2372: seg_list fnd_flex_key_api.segment_list;
2373: j number;

Line 2370: str fnd_flex_key_api.structure_type;

2366: x_account_structure OUT NOCOPY varchar2,
2367: x_code_combinations OUT NOCOPY code_combination_tbl) IS
2368:
2369: kff fnd_flex_key_api.flexfield_type;
2370: str fnd_flex_key_api.structure_type;
2371: seg fnd_flex_key_api.segment_type;
2372: seg_list fnd_flex_key_api.segment_list;
2373: j number;
2374: i number;

Line 2371: seg fnd_flex_key_api.segment_type;

2367: x_code_combinations OUT NOCOPY code_combination_tbl) IS
2368:
2369: kff fnd_flex_key_api.flexfield_type;
2370: str fnd_flex_key_api.structure_type;
2371: seg fnd_flex_key_api.segment_type;
2372: seg_list fnd_flex_key_api.segment_list;
2373: j number;
2374: i number;
2375: nsegs number;

Line 2372: seg_list fnd_flex_key_api.segment_list;

2368:
2369: kff fnd_flex_key_api.flexfield_type;
2370: str fnd_flex_key_api.structure_type;
2371: seg fnd_flex_key_api.segment_type;
2372: seg_list fnd_flex_key_api.segment_list;
2373: j number;
2374: i number;
2375: nsegs number;
2376: segment_descr varchar2(2000);

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

2393: cn_repositories_all cr
2394: WHERE cr.set_of_books_id = gsb.set_of_books_id
2395: AND cr.org_id = p_org_id;
2396:
2397: fnd_flex_key_api.set_session_mode('customer_data');
2398: kff := fnd_flex_key_api.find_flexfield('SQLGL','GL#');
2399: str := fnd_flex_key_api.find_structure(kff, l_chart_of_accounts_id);
2400: fnd_flex_key_api.get_segments(kff, str, TRUE, nsegs, seg_list);
2401:

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

2394: WHERE cr.set_of_books_id = gsb.set_of_books_id
2395: AND cr.org_id = p_org_id;
2396:
2397: fnd_flex_key_api.set_session_mode('customer_data');
2398: kff := fnd_flex_key_api.find_flexfield('SQLGL','GL#');
2399: str := fnd_flex_key_api.find_structure(kff, l_chart_of_accounts_id);
2400: fnd_flex_key_api.get_segments(kff, str, TRUE, nsegs, seg_list);
2401:
2402: -- The segments in the seg_list array are sorted in display order.

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

2395: AND cr.org_id = p_org_id;
2396:
2397: fnd_flex_key_api.set_session_mode('customer_data');
2398: kff := fnd_flex_key_api.find_flexfield('SQLGL','GL#');
2399: str := fnd_flex_key_api.find_structure(kff, l_chart_of_accounts_id);
2400: fnd_flex_key_api.get_segments(kff, str, TRUE, nsegs, seg_list);
2401:
2402: -- The segments in the seg_list array are sorted in display order.
2403: -- i.e. sorted by segment number.

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

2396:
2397: fnd_flex_key_api.set_session_mode('customer_data');
2398: kff := fnd_flex_key_api.find_flexfield('SQLGL','GL#');
2399: str := fnd_flex_key_api.find_structure(kff, l_chart_of_accounts_id);
2400: fnd_flex_key_api.get_segments(kff, str, TRUE, nsegs, seg_list);
2401:
2402: -- The segments in the seg_list array are sorted in display order.
2403: -- i.e. sorted by segment number.
2404: sql_stmt := 'SELECT ';

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

2402: -- The segments in the seg_list array are sorted in display order.
2403: -- i.e. sorted by segment number.
2404: sql_stmt := 'SELECT ';
2405: for i in 1..nsegs loop
2406: seg := fnd_flex_key_api.find_segment(kff, str, seg_list(i));
2407: segment_descr := segment_descr || seg.segment_name;
2408: sql_stmt := sql_stmt || seg.column_name;
2409: If i <> nsegs
2410: then

Line 2458: kff fnd_flex_key_api.flexfield_type;

2454: (p_ccid IN varchar2,
2455: p_org_id IN NUMBER,
2456: x_code_combination OUT NOCOPY varchar2) IS
2457:
2458: kff fnd_flex_key_api.flexfield_type;
2459: str fnd_flex_key_api.structure_type;
2460: seg fnd_flex_key_api.segment_type;
2461: seg_list fnd_flex_key_api.segment_list;
2462: j number;

Line 2459: str fnd_flex_key_api.structure_type;

2455: p_org_id IN NUMBER,
2456: x_code_combination OUT NOCOPY varchar2) IS
2457:
2458: kff fnd_flex_key_api.flexfield_type;
2459: str fnd_flex_key_api.structure_type;
2460: seg fnd_flex_key_api.segment_type;
2461: seg_list fnd_flex_key_api.segment_list;
2462: j number;
2463: i number;

Line 2460: seg fnd_flex_key_api.segment_type;

2456: x_code_combination OUT NOCOPY varchar2) IS
2457:
2458: kff fnd_flex_key_api.flexfield_type;
2459: str fnd_flex_key_api.structure_type;
2460: seg fnd_flex_key_api.segment_type;
2461: seg_list fnd_flex_key_api.segment_list;
2462: j number;
2463: i number;
2464: nsegs number;

Line 2461: seg_list fnd_flex_key_api.segment_list;

2457:
2458: kff fnd_flex_key_api.flexfield_type;
2459: str fnd_flex_key_api.structure_type;
2460: seg fnd_flex_key_api.segment_type;
2461: seg_list fnd_flex_key_api.segment_list;
2462: j number;
2463: i number;
2464: nsegs number;
2465: segment_descr varchar2(2000);

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

2482: cn_repositories_all cr
2483: WHERE cr.set_of_books_id = gsb.set_of_books_id
2484: AND org_id = p_org_id;
2485:
2486: fnd_flex_key_api.set_session_mode('customer_data');
2487: kff := fnd_flex_key_api.find_flexfield('SQLGL','GL#');
2488: str := fnd_flex_key_api.find_structure(kff, l_chart_of_accounts_id);
2489: fnd_flex_key_api.get_segments(kff, str, TRUE, nsegs, seg_list);
2490:

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

2483: WHERE cr.set_of_books_id = gsb.set_of_books_id
2484: AND org_id = p_org_id;
2485:
2486: fnd_flex_key_api.set_session_mode('customer_data');
2487: kff := fnd_flex_key_api.find_flexfield('SQLGL','GL#');
2488: str := fnd_flex_key_api.find_structure(kff, l_chart_of_accounts_id);
2489: fnd_flex_key_api.get_segments(kff, str, TRUE, nsegs, seg_list);
2490:
2491: -- The segments in the seg_list array are sorted in display order.

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

2484: AND org_id = p_org_id;
2485:
2486: fnd_flex_key_api.set_session_mode('customer_data');
2487: kff := fnd_flex_key_api.find_flexfield('SQLGL','GL#');
2488: str := fnd_flex_key_api.find_structure(kff, l_chart_of_accounts_id);
2489: fnd_flex_key_api.get_segments(kff, str, TRUE, nsegs, seg_list);
2490:
2491: -- The segments in the seg_list array are sorted in display order.
2492: -- i.e. sorted by segment number.

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

2485:
2486: fnd_flex_key_api.set_session_mode('customer_data');
2487: kff := fnd_flex_key_api.find_flexfield('SQLGL','GL#');
2488: str := fnd_flex_key_api.find_structure(kff, l_chart_of_accounts_id);
2489: fnd_flex_key_api.get_segments(kff, str, TRUE, nsegs, seg_list);
2490:
2491: -- The segments in the seg_list array are sorted in display order.
2492: -- i.e. sorted by segment number.
2493: sql_stmt := 'SELECT ';

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

2491: -- The segments in the seg_list array are sorted in display order.
2492: -- i.e. sorted by segment number.
2493: sql_stmt := 'SELECT ';
2494: for i in 1..nsegs loop
2495: seg := fnd_flex_key_api.find_segment(kff, str, seg_list(i));
2496: segment_descr := segment_descr || seg.segment_name;
2497: sql_stmt := sql_stmt || seg.column_name;
2498: If i <> nsegs
2499: then

Line 2539: kff fnd_flex_key_api.flexfield_type;

2535: --| ---------------------------------------------------------------------=
2536: FUNCTION get_ccid_disp_func
2537: (p_ccid IN varchar2, p_org_id IN NUMBER ) RETURN VARCHAR2 IS
2538:
2539: kff fnd_flex_key_api.flexfield_type;
2540: str fnd_flex_key_api.structure_type;
2541: seg fnd_flex_key_api.segment_type;
2542: seg_list fnd_flex_key_api.segment_list;
2543: j number;

Line 2540: str fnd_flex_key_api.structure_type;

2536: FUNCTION get_ccid_disp_func
2537: (p_ccid IN varchar2, p_org_id IN NUMBER ) RETURN VARCHAR2 IS
2538:
2539: kff fnd_flex_key_api.flexfield_type;
2540: str fnd_flex_key_api.structure_type;
2541: seg fnd_flex_key_api.segment_type;
2542: seg_list fnd_flex_key_api.segment_list;
2543: j number;
2544: i number;

Line 2541: seg fnd_flex_key_api.segment_type;

2537: (p_ccid IN varchar2, p_org_id IN NUMBER ) RETURN VARCHAR2 IS
2538:
2539: kff fnd_flex_key_api.flexfield_type;
2540: str fnd_flex_key_api.structure_type;
2541: seg fnd_flex_key_api.segment_type;
2542: seg_list fnd_flex_key_api.segment_list;
2543: j number;
2544: i number;
2545: nsegs number;

Line 2542: seg_list fnd_flex_key_api.segment_list;

2538:
2539: kff fnd_flex_key_api.flexfield_type;
2540: str fnd_flex_key_api.structure_type;
2541: seg fnd_flex_key_api.segment_type;
2542: seg_list fnd_flex_key_api.segment_list;
2543: j number;
2544: i number;
2545: nsegs number;
2546: segment_descr varchar2(2000);

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

2567: cn_repositories_all cr
2568: WHERE cr.set_of_books_id = gsb.set_of_books_id
2569: AND org_id = p_org_id;
2570:
2571: fnd_flex_key_api.set_session_mode('customer_data');
2572: kff := fnd_flex_key_api.find_flexfield('SQLGL','GL#');
2573: str := fnd_flex_key_api.find_structure(kff, l_chart_of_accounts_id);
2574: fnd_flex_key_api.get_segments(kff, str, TRUE, nsegs, seg_list);
2575:

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

2568: WHERE cr.set_of_books_id = gsb.set_of_books_id
2569: AND org_id = p_org_id;
2570:
2571: fnd_flex_key_api.set_session_mode('customer_data');
2572: kff := fnd_flex_key_api.find_flexfield('SQLGL','GL#');
2573: str := fnd_flex_key_api.find_structure(kff, l_chart_of_accounts_id);
2574: fnd_flex_key_api.get_segments(kff, str, TRUE, nsegs, seg_list);
2575:
2576: -- The segments in the seg_list array are sorted in display order.

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

2569: AND org_id = p_org_id;
2570:
2571: fnd_flex_key_api.set_session_mode('customer_data');
2572: kff := fnd_flex_key_api.find_flexfield('SQLGL','GL#');
2573: str := fnd_flex_key_api.find_structure(kff, l_chart_of_accounts_id);
2574: fnd_flex_key_api.get_segments(kff, str, TRUE, nsegs, seg_list);
2575:
2576: -- The segments in the seg_list array are sorted in display order.
2577: -- i.e. sorted by segment number.

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

2570:
2571: fnd_flex_key_api.set_session_mode('customer_data');
2572: kff := fnd_flex_key_api.find_flexfield('SQLGL','GL#');
2573: str := fnd_flex_key_api.find_structure(kff, l_chart_of_accounts_id);
2574: fnd_flex_key_api.get_segments(kff, str, TRUE, nsegs, seg_list);
2575:
2576: -- The segments in the seg_list array are sorted in display order.
2577: -- i.e. sorted by segment number.
2578: sql_stmt := 'SELECT ';

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

2576: -- The segments in the seg_list array are sorted in display order.
2577: -- i.e. sorted by segment number.
2578: sql_stmt := 'SELECT ';
2579: for i in 1..nsegs loop
2580: seg := fnd_flex_key_api.find_segment(kff, str, seg_list(i));
2581: segment_descr := segment_descr || seg.segment_name;
2582: sql_stmt := sql_stmt || seg.column_name;
2583: If i <> nsegs
2584: then