APPS.PAY_COST_ALLOCATION_API dependencies on FND_ID_FLEX_SEGMENTS

Line 198: of fnd_id_flex_segments.application_column_name%type INDEX BY Binary_integer;

194:
195: type segment_no_array is table
196: of number(2) INDEX BY Binary_integer;
197: type application_column_array is table
198: of fnd_id_flex_segments.application_column_name%type INDEX BY Binary_integer;
199: type application_segment_array is table
200: of fnd_id_flex_segments.segment_name%type INDEX BY Binary_integer;
201: type required_flag_array is table
202: of fnd_id_flex_segments.required_flag%type INDEX BY Binary_integer;

Line 200: of fnd_id_flex_segments.segment_name%type INDEX BY Binary_integer;

196: of number(2) INDEX BY Binary_integer;
197: type application_column_array is table
198: of fnd_id_flex_segments.application_column_name%type INDEX BY Binary_integer;
199: type application_segment_array is table
200: of fnd_id_flex_segments.segment_name%type INDEX BY Binary_integer;
201: type required_flag_array is table
202: of fnd_id_flex_segments.required_flag%type INDEX BY Binary_integer;
203:
204: l_segment_no segment_no_array;

Line 202: of fnd_id_flex_segments.required_flag%type INDEX BY Binary_integer;

198: of fnd_id_flex_segments.application_column_name%type INDEX BY Binary_integer;
199: type application_segment_array is table
200: of fnd_id_flex_segments.segment_name%type INDEX BY Binary_integer;
201: type required_flag_array is table
202: of fnd_id_flex_segments.required_flag%type INDEX BY Binary_integer;
203:
204: l_segment_no segment_no_array;
205: l_application_column application_column_array;
206: l_application_segment application_segment_array;

Line 216: FROM FND_ID_FLEX_SEGMENTS fs,

212: SELECT substr(fs.application_column_name,8,2) segment_no,
213: fs.application_column_name application_column_name,
214: fs.segment_name application_segment_name,
215: fs.required_flag required_flag
216: FROM FND_ID_FLEX_SEGMENTS fs,
217: FND_SEGMENT_ATTRIBUTE_VALUES sa1
218: WHERE sa1.id_flex_num = p_cost_id_flex_num
219: and sa1.id_flex_code = 'COST'
220: and sa1.attribute_value = 'Y'

Line 377: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

373: -- Declare cursors and local variables
374: --
375: l_proc varchar2(72) := g_package||'CREATE_COST_ALLOCATION';
376: l_effective_date date;
377: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
378: -- bug no. 3829293.
379: -- l_cost_allocation_keyflex_id number(15);
380: l_cost_allocation_keyflex_id number(15):= -1;
381: --

Line 799: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

795: -- Declare cursors and local variables
796: --
797: l_proc varchar2(72) := g_package||'UPDATE_COST_ALLOCATION';
798: l_effective_date date;
799: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
800: l_cost_allocation_keyflex_id number;
801: l_combination_name varchar2(240);
802: l_object_version_number pay_cost_allocations_f.object_version_number%TYPE;
803: l_effective_start_date pay_cost_allocations_f.effective_start_date%TYPE;