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

Line 2069: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;

2065: , x_flex_sql OUT NOCOPY VARCHAR2
2066: )
2067: IS
2068:
2069: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;
2070: l_structure_rec FND_FLEX_KEY_API.structure_type;
2071: l_segment_rec FND_FLEX_KEY_API.segment_type;
2072: l_segment_tbl FND_FLEX_KEY_API.segment_list;
2073:

Line 2070: l_structure_rec FND_FLEX_KEY_API.structure_type;

2066: )
2067: IS
2068:
2069: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;
2070: l_structure_rec FND_FLEX_KEY_API.structure_type;
2071: l_segment_rec FND_FLEX_KEY_API.segment_type;
2072: l_segment_tbl FND_FLEX_KEY_API.segment_list;
2073:
2074: l_appl_short_name VARCHAR2(8);

Line 2071: l_segment_rec FND_FLEX_KEY_API.segment_type;

2067: IS
2068:
2069: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;
2070: l_structure_rec FND_FLEX_KEY_API.structure_type;
2071: l_segment_rec FND_FLEX_KEY_API.segment_type;
2072: l_segment_tbl FND_FLEX_KEY_API.segment_list;
2073:
2074: l_appl_short_name VARCHAR2(8);
2075: l_flex_code VARCHAR2(8);

Line 2072: l_segment_tbl FND_FLEX_KEY_API.segment_list;

2068:
2069: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;
2070: l_structure_rec FND_FLEX_KEY_API.structure_type;
2071: l_segment_rec FND_FLEX_KEY_API.segment_type;
2072: l_segment_tbl FND_FLEX_KEY_API.segment_list;
2073:
2074: l_appl_short_name VARCHAR2(8);
2075: l_flex_code VARCHAR2(8);
2076: l_structure_code NUMBER;

Line 2142: -- Call FND_FLEX_KEY_API to get flexfield information

2138: END IF;
2139:
2140: d_progress := 50;
2141:
2142: -- Call FND_FLEX_KEY_API to get flexfield information
2143: FND_FLEX_KEY_API.set_session_mode('customer_data');
2144:
2145: d_progress := 60;
2146:

Line 2143: FND_FLEX_KEY_API.set_session_mode('customer_data');

2139:
2140: d_progress := 50;
2141:
2142: -- Call FND_FLEX_KEY_API to get flexfield information
2143: FND_FLEX_KEY_API.set_session_mode('customer_data');
2144:
2145: d_progress := 60;
2146:
2147: -- Retrieve flexfield sgements

Line 2148: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield(l_appl_short_name,l_flex_code);

2144:
2145: d_progress := 60;
2146:
2147: -- Retrieve flexfield sgements
2148: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield(l_appl_short_name,l_flex_code);
2149: d_progress := 65;
2150: l_structure_rec := FND_FLEX_KEY_API.find_structure(l_flexfield_rec, l_structure_code);
2151:
2152: d_progress := 70;

Line 2150: l_structure_rec := FND_FLEX_KEY_API.find_structure(l_flexfield_rec, l_structure_code);

2146:
2147: -- Retrieve flexfield sgements
2148: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield(l_appl_short_name,l_flex_code);
2149: d_progress := 65;
2150: l_structure_rec := FND_FLEX_KEY_API.find_structure(l_flexfield_rec, l_structure_code);
2151:
2152: d_progress := 70;
2153:
2154: FND_FLEX_KEY_API.get_segments(

Line 2154: FND_FLEX_KEY_API.get_segments(

2150: l_structure_rec := FND_FLEX_KEY_API.find_structure(l_flexfield_rec, l_structure_code);
2151:
2152: d_progress := 70;
2153:
2154: FND_FLEX_KEY_API.get_segments(
2155: flexfield => l_flexfield_rec
2156: , structure => l_structure_rec
2157: , nsegments => l_segment_number
2158: , segments => l_segment_tbl

Line 2170: l_segment_rec := FND_FLEX_KEY_API.find_segment(l_flexfield_rec,l_structure_rec,l_segment_tbl(l_idx));

2166: LOOP
2167:
2168: d_progress := 90;
2169:
2170: l_segment_rec := FND_FLEX_KEY_API.find_segment(l_flexfield_rec,l_structure_rec,l_segment_tbl(l_idx));
2171:
2172: l_segment := 'NVL(' || l_table_alias || '.' || l_segment_rec.column_name || ', ''0'')';
2173:
2174: x_flex_sql := x_flex_sql || ' AND '|| l_segment || ' BETWEEN '