DBA Data[Home] [Help]

APPS.PO_DOCUMENT_ACTION_CHECK dependencies on FND_FLEX_KEY_API

Line 2042: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;

2038: , x_flex_sql OUT NOCOPY VARCHAR2
2039: )
2040: IS
2041:
2042: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;
2043: l_structure_rec FND_FLEX_KEY_API.structure_type;
2044: l_segment_rec FND_FLEX_KEY_API.segment_type;
2045: l_segment_tbl FND_FLEX_KEY_API.segment_list;
2046:

Line 2043: l_structure_rec FND_FLEX_KEY_API.structure_type;

2039: )
2040: IS
2041:
2042: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;
2043: l_structure_rec FND_FLEX_KEY_API.structure_type;
2044: l_segment_rec FND_FLEX_KEY_API.segment_type;
2045: l_segment_tbl FND_FLEX_KEY_API.segment_list;
2046:
2047: l_appl_short_name VARCHAR2(8);

Line 2044: l_segment_rec FND_FLEX_KEY_API.segment_type;

2040: IS
2041:
2042: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;
2043: l_structure_rec FND_FLEX_KEY_API.structure_type;
2044: l_segment_rec FND_FLEX_KEY_API.segment_type;
2045: l_segment_tbl FND_FLEX_KEY_API.segment_list;
2046:
2047: l_appl_short_name VARCHAR2(8);
2048: l_flex_code VARCHAR2(8);

Line 2045: l_segment_tbl FND_FLEX_KEY_API.segment_list;

2041:
2042: l_flexfield_rec FND_FLEX_KEY_API.flexfield_type;
2043: l_structure_rec FND_FLEX_KEY_API.structure_type;
2044: l_segment_rec FND_FLEX_KEY_API.segment_type;
2045: l_segment_tbl FND_FLEX_KEY_API.segment_list;
2046:
2047: l_appl_short_name VARCHAR2(8);
2048: l_flex_code VARCHAR2(8);
2049: l_structure_code NUMBER;

Line 2115: -- Call FND_FLEX_KEY_API to get flexfield information

2111: END IF;
2112:
2113: d_progress := 50;
2114:
2115: -- Call FND_FLEX_KEY_API to get flexfield information
2116: FND_FLEX_KEY_API.set_session_mode('customer_data');
2117:
2118: d_progress := 60;
2119:

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

2112:
2113: d_progress := 50;
2114:
2115: -- Call FND_FLEX_KEY_API to get flexfield information
2116: FND_FLEX_KEY_API.set_session_mode('customer_data');
2117:
2118: d_progress := 60;
2119:
2120: -- Retrieve flexfield sgements

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

2117:
2118: d_progress := 60;
2119:
2120: -- Retrieve flexfield sgements
2121: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield(l_appl_short_name,l_flex_code);
2122: d_progress := 65;
2123: l_structure_rec := FND_FLEX_KEY_API.find_structure(l_flexfield_rec, l_structure_code);
2124:
2125: d_progress := 70;

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

2119:
2120: -- Retrieve flexfield sgements
2121: l_flexfield_rec := FND_FLEX_KEY_API.find_flexfield(l_appl_short_name,l_flex_code);
2122: d_progress := 65;
2123: l_structure_rec := FND_FLEX_KEY_API.find_structure(l_flexfield_rec, l_structure_code);
2124:
2125: d_progress := 70;
2126:
2127: FND_FLEX_KEY_API.get_segments(

Line 2127: FND_FLEX_KEY_API.get_segments(

2123: l_structure_rec := FND_FLEX_KEY_API.find_structure(l_flexfield_rec, l_structure_code);
2124:
2125: d_progress := 70;
2126:
2127: FND_FLEX_KEY_API.get_segments(
2128: flexfield => l_flexfield_rec
2129: , structure => l_structure_rec
2130: , nsegments => l_segment_number
2131: , segments => l_segment_tbl

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

2139: LOOP
2140:
2141: d_progress := 90;
2142:
2143: l_segment_rec := FND_FLEX_KEY_API.find_segment(l_flexfield_rec,l_structure_rec,l_segment_tbl(l_idx));
2144:
2145: l_segment := 'NVL(' || l_table_alias || '.' || l_segment_rec.column_name || ', ''0'')';
2146:
2147: x_flex_sql := x_flex_sql || ' AND '|| l_segment || ' BETWEEN '