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 2391: kff fnd_flex_key_api.flexfield_type;

2387: p_org_id IN NUMBER,
2388: x_account_structure OUT NOCOPY varchar2,
2389: x_code_combinations OUT NOCOPY code_combination_tbl) IS
2390:
2391: kff fnd_flex_key_api.flexfield_type;
2392: str fnd_flex_key_api.structure_type;
2393: seg fnd_flex_key_api.segment_type;
2394: seg_list fnd_flex_key_api.segment_list;
2395: j number;

Line 2392: str fnd_flex_key_api.structure_type;

2388: x_account_structure OUT NOCOPY varchar2,
2389: x_code_combinations OUT NOCOPY code_combination_tbl) IS
2390:
2391: kff fnd_flex_key_api.flexfield_type;
2392: str fnd_flex_key_api.structure_type;
2393: seg fnd_flex_key_api.segment_type;
2394: seg_list fnd_flex_key_api.segment_list;
2395: j number;
2396: i number;

Line 2393: seg fnd_flex_key_api.segment_type;

2389: x_code_combinations OUT NOCOPY code_combination_tbl) IS
2390:
2391: kff fnd_flex_key_api.flexfield_type;
2392: str fnd_flex_key_api.structure_type;
2393: seg fnd_flex_key_api.segment_type;
2394: seg_list fnd_flex_key_api.segment_list;
2395: j number;
2396: i number;
2397: nsegs number;

Line 2394: seg_list fnd_flex_key_api.segment_list;

2390:
2391: kff fnd_flex_key_api.flexfield_type;
2392: str fnd_flex_key_api.structure_type;
2393: seg fnd_flex_key_api.segment_type;
2394: seg_list fnd_flex_key_api.segment_list;
2395: j number;
2396: i number;
2397: nsegs number;
2398: segment_descr varchar2(2000);

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

2415: cn_repositories_all cr
2416: WHERE cr.set_of_books_id = gsb.set_of_books_id
2417: AND cr.org_id = p_org_id;
2418:
2419: fnd_flex_key_api.set_session_mode('customer_data');
2420: kff := fnd_flex_key_api.find_flexfield('SQLGL','GL#');
2421: str := fnd_flex_key_api.find_structure(kff, l_chart_of_accounts_id);
2422: fnd_flex_key_api.get_segments(kff, str, TRUE, nsegs, seg_list);
2423:

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

2416: WHERE cr.set_of_books_id = gsb.set_of_books_id
2417: AND cr.org_id = p_org_id;
2418:
2419: fnd_flex_key_api.set_session_mode('customer_data');
2420: kff := fnd_flex_key_api.find_flexfield('SQLGL','GL#');
2421: str := fnd_flex_key_api.find_structure(kff, l_chart_of_accounts_id);
2422: fnd_flex_key_api.get_segments(kff, str, TRUE, nsegs, seg_list);
2423:
2424: -- The segments in the seg_list array are sorted in display order.

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

2417: AND cr.org_id = p_org_id;
2418:
2419: fnd_flex_key_api.set_session_mode('customer_data');
2420: kff := fnd_flex_key_api.find_flexfield('SQLGL','GL#');
2421: str := fnd_flex_key_api.find_structure(kff, l_chart_of_accounts_id);
2422: fnd_flex_key_api.get_segments(kff, str, TRUE, nsegs, seg_list);
2423:
2424: -- The segments in the seg_list array are sorted in display order.
2425: -- i.e. sorted by segment number.

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

2418:
2419: fnd_flex_key_api.set_session_mode('customer_data');
2420: kff := fnd_flex_key_api.find_flexfield('SQLGL','GL#');
2421: str := fnd_flex_key_api.find_structure(kff, l_chart_of_accounts_id);
2422: fnd_flex_key_api.get_segments(kff, str, TRUE, nsegs, seg_list);
2423:
2424: -- The segments in the seg_list array are sorted in display order.
2425: -- i.e. sorted by segment number.
2426: sql_stmt := 'SELECT ';

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

2424: -- The segments in the seg_list array are sorted in display order.
2425: -- i.e. sorted by segment number.
2426: sql_stmt := 'SELECT ';
2427: for i in 1..nsegs loop
2428: seg := fnd_flex_key_api.find_segment(kff, str, seg_list(i));
2429: segment_descr := segment_descr || seg.segment_name;
2430: sql_stmt := sql_stmt || seg.column_name;
2431: If i <> nsegs
2432: then

Line 2480: kff fnd_flex_key_api.flexfield_type;

2476: (p_ccid IN varchar2,
2477: p_org_id IN NUMBER,
2478: x_code_combination OUT NOCOPY varchar2) IS
2479:
2480: kff fnd_flex_key_api.flexfield_type;
2481: str fnd_flex_key_api.structure_type;
2482: seg fnd_flex_key_api.segment_type;
2483: seg_list fnd_flex_key_api.segment_list;
2484: j number;

Line 2481: str fnd_flex_key_api.structure_type;

2477: p_org_id IN NUMBER,
2478: x_code_combination OUT NOCOPY varchar2) IS
2479:
2480: kff fnd_flex_key_api.flexfield_type;
2481: str fnd_flex_key_api.structure_type;
2482: seg fnd_flex_key_api.segment_type;
2483: seg_list fnd_flex_key_api.segment_list;
2484: j number;
2485: i number;

Line 2482: seg fnd_flex_key_api.segment_type;

2478: x_code_combination OUT NOCOPY varchar2) IS
2479:
2480: kff fnd_flex_key_api.flexfield_type;
2481: str fnd_flex_key_api.structure_type;
2482: seg fnd_flex_key_api.segment_type;
2483: seg_list fnd_flex_key_api.segment_list;
2484: j number;
2485: i number;
2486: nsegs number;

Line 2483: seg_list fnd_flex_key_api.segment_list;

2479:
2480: kff fnd_flex_key_api.flexfield_type;
2481: str fnd_flex_key_api.structure_type;
2482: seg fnd_flex_key_api.segment_type;
2483: seg_list fnd_flex_key_api.segment_list;
2484: j number;
2485: i number;
2486: nsegs number;
2487: segment_descr varchar2(2000);

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

2504: cn_repositories_all cr
2505: WHERE cr.set_of_books_id = gsb.set_of_books_id
2506: AND org_id = p_org_id;
2507:
2508: fnd_flex_key_api.set_session_mode('customer_data');
2509: kff := fnd_flex_key_api.find_flexfield('SQLGL','GL#');
2510: str := fnd_flex_key_api.find_structure(kff, l_chart_of_accounts_id);
2511: fnd_flex_key_api.get_segments(kff, str, TRUE, nsegs, seg_list);
2512:

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

2505: WHERE cr.set_of_books_id = gsb.set_of_books_id
2506: AND org_id = p_org_id;
2507:
2508: fnd_flex_key_api.set_session_mode('customer_data');
2509: kff := fnd_flex_key_api.find_flexfield('SQLGL','GL#');
2510: str := fnd_flex_key_api.find_structure(kff, l_chart_of_accounts_id);
2511: fnd_flex_key_api.get_segments(kff, str, TRUE, nsegs, seg_list);
2512:
2513: -- The segments in the seg_list array are sorted in display order.

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

2506: AND org_id = p_org_id;
2507:
2508: fnd_flex_key_api.set_session_mode('customer_data');
2509: kff := fnd_flex_key_api.find_flexfield('SQLGL','GL#');
2510: str := fnd_flex_key_api.find_structure(kff, l_chart_of_accounts_id);
2511: fnd_flex_key_api.get_segments(kff, str, TRUE, nsegs, seg_list);
2512:
2513: -- The segments in the seg_list array are sorted in display order.
2514: -- i.e. sorted by segment number.

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

2507:
2508: fnd_flex_key_api.set_session_mode('customer_data');
2509: kff := fnd_flex_key_api.find_flexfield('SQLGL','GL#');
2510: str := fnd_flex_key_api.find_structure(kff, l_chart_of_accounts_id);
2511: fnd_flex_key_api.get_segments(kff, str, TRUE, nsegs, seg_list);
2512:
2513: -- The segments in the seg_list array are sorted in display order.
2514: -- i.e. sorted by segment number.
2515: sql_stmt := 'SELECT ';

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

2513: -- The segments in the seg_list array are sorted in display order.
2514: -- i.e. sorted by segment number.
2515: sql_stmt := 'SELECT ';
2516: for i in 1..nsegs loop
2517: seg := fnd_flex_key_api.find_segment(kff, str, seg_list(i));
2518: segment_descr := segment_descr || seg.segment_name;
2519: sql_stmt := sql_stmt || seg.column_name;
2520: If i <> nsegs
2521: then

Line 2561: kff fnd_flex_key_api.flexfield_type;

2557: --| ---------------------------------------------------------------------=
2558: FUNCTION get_ccid_disp_func
2559: (p_ccid IN varchar2, p_org_id IN NUMBER ) RETURN VARCHAR2 IS
2560:
2561: kff fnd_flex_key_api.flexfield_type;
2562: str fnd_flex_key_api.structure_type;
2563: seg fnd_flex_key_api.segment_type;
2564: seg_list fnd_flex_key_api.segment_list;
2565: j number;

Line 2562: str fnd_flex_key_api.structure_type;

2558: FUNCTION get_ccid_disp_func
2559: (p_ccid IN varchar2, p_org_id IN NUMBER ) RETURN VARCHAR2 IS
2560:
2561: kff fnd_flex_key_api.flexfield_type;
2562: str fnd_flex_key_api.structure_type;
2563: seg fnd_flex_key_api.segment_type;
2564: seg_list fnd_flex_key_api.segment_list;
2565: j number;
2566: i number;

Line 2563: seg fnd_flex_key_api.segment_type;

2559: (p_ccid IN varchar2, p_org_id IN NUMBER ) RETURN VARCHAR2 IS
2560:
2561: kff fnd_flex_key_api.flexfield_type;
2562: str fnd_flex_key_api.structure_type;
2563: seg fnd_flex_key_api.segment_type;
2564: seg_list fnd_flex_key_api.segment_list;
2565: j number;
2566: i number;
2567: nsegs number;

Line 2564: seg_list fnd_flex_key_api.segment_list;

2560:
2561: kff fnd_flex_key_api.flexfield_type;
2562: str fnd_flex_key_api.structure_type;
2563: seg fnd_flex_key_api.segment_type;
2564: seg_list fnd_flex_key_api.segment_list;
2565: j number;
2566: i number;
2567: nsegs number;
2568: segment_descr varchar2(2000);

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

2589: cn_repositories_all cr
2590: WHERE cr.set_of_books_id = gsb.set_of_books_id
2591: AND org_id = p_org_id;
2592:
2593: fnd_flex_key_api.set_session_mode('customer_data');
2594: kff := fnd_flex_key_api.find_flexfield('SQLGL','GL#');
2595: str := fnd_flex_key_api.find_structure(kff, l_chart_of_accounts_id);
2596: fnd_flex_key_api.get_segments(kff, str, TRUE, nsegs, seg_list);
2597:

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

2590: WHERE cr.set_of_books_id = gsb.set_of_books_id
2591: AND org_id = p_org_id;
2592:
2593: fnd_flex_key_api.set_session_mode('customer_data');
2594: kff := fnd_flex_key_api.find_flexfield('SQLGL','GL#');
2595: str := fnd_flex_key_api.find_structure(kff, l_chart_of_accounts_id);
2596: fnd_flex_key_api.get_segments(kff, str, TRUE, nsegs, seg_list);
2597:
2598: -- The segments in the seg_list array are sorted in display order.

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

2591: AND org_id = p_org_id;
2592:
2593: fnd_flex_key_api.set_session_mode('customer_data');
2594: kff := fnd_flex_key_api.find_flexfield('SQLGL','GL#');
2595: str := fnd_flex_key_api.find_structure(kff, l_chart_of_accounts_id);
2596: fnd_flex_key_api.get_segments(kff, str, TRUE, nsegs, seg_list);
2597:
2598: -- The segments in the seg_list array are sorted in display order.
2599: -- i.e. sorted by segment number.

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

2592:
2593: fnd_flex_key_api.set_session_mode('customer_data');
2594: kff := fnd_flex_key_api.find_flexfield('SQLGL','GL#');
2595: str := fnd_flex_key_api.find_structure(kff, l_chart_of_accounts_id);
2596: fnd_flex_key_api.get_segments(kff, str, TRUE, nsegs, seg_list);
2597:
2598: -- The segments in the seg_list array are sorted in display order.
2599: -- i.e. sorted by segment number.
2600: sql_stmt := 'SELECT ';

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

2598: -- The segments in the seg_list array are sorted in display order.
2599: -- i.e. sorted by segment number.
2600: sql_stmt := 'SELECT ';
2601: for i in 1..nsegs loop
2602: seg := fnd_flex_key_api.find_segment(kff, str, seg_list(i));
2603: segment_descr := segment_descr || seg.segment_name;
2604: sql_stmt := sql_stmt || seg.column_name;
2605: If i <> nsegs
2606: then