[Home] [Help]
7377: --
7378: cursor c1 is
7379: SELECT application_column_name c_def_text,
7380: replace (ltrim(rtrim(upper(segment_name))),' ','_') c_db_name
7381: FROM fnd_id_flex_segments
7382: WHERE application_id = p_applic_id
7383: AND id_flex_num = p_id_flex_num
7384: AND id_flex_code = p_id_flex_code;
7385: --
7445: GRADE for 'p_keyflex_name' pass in : 'GRD'
7446: GROUP for 'p_keyflex_name' pass in : 'GRP'
7447: --
7448: The database items use the segment name column from the foundation
7449: table 'fnd_id_flex_segments'. For a given key flexfield there
7450: could be several database items.
7451: The following database items are created:
7452: --
7453: GRADE_KF_
7607: routes in this table by using the route name, which is hard coded below.
7608: The parameter passed in is the id_flex_num of the keyflex.
7609: --
7610: The database items use the segment name column from the foundation
7611: table 'fnd_id_flex_segments'. For a given key flexfield there
7612: could be several database items.
7613: --
7614: The routine has been enhanced to loop around to create dbitems
7615: for each of the legislations which use the flex_num passed in.
7696: Legislation Keyflex database items. The parameter passed is is the
7697: id flex number.
7698: --
7699: The database items created use the name as defined in the column
7700: 'segment_name' from the foundation table 'fnd_id_flex_segments'.
7701: There are 3 levels of SCL keyflex:
7702: --
7703: ASSIGNMENT
7704: PAYROLL
7756: select SEG.application_column_name c_def_text,
7757: replace (ltrim(rtrim(upper(SEG.segment_name))),' ','_') c_db_name,
7758: SEG.created_by c_created_by,
7759: SEG.last_update_login c_last_login
7760: from fnd_id_flex_segments SEG
7761: , fnd_segment_attribute_values VALUE
7762: where SEG.application_id = 800
7763: and SEG.id_flex_code = 'SCL'
7764: and SEG.id_flex_num = p_id_flex_num