2995:
2996:
2997:
2998:
2999:
3001:
3002:
3003:
2996:
2997:
2998:
2999:
3000:
3002:
3003:
3004: */
3462: );
3463: end if;
3464: --
3465: insert_database_item (l_element_name,
3466: 'STANDARD_LINK' || p_date_p,
3467: 'T', -- data type
3468: 'nvl(hr_general.decode_lookup(''YES_NO'',ELINK.STANDARD_LINK_FLAG),hr_general.decode_lookup(''YES_NO'',ETYPE.STANDARD_LINK_FLAG))',
3469: 'N', -- null allowed
3470: 'standard link meaning from lookup table Yes = standard, No = discretionary',
3464: --
3465: insert_database_item (l_element_name,
3466: 'STANDARD_LINK' || p_date_p,
3467: 'T', -- data type
3468: 'nvl(hr_general.decode_lookup(''YES_NO'',ELINK.STANDARD_LINK_FLAG),hr_general.decode_lookup(''YES_NO'',ETYPE.STANDARD_LINK_FLAG))',
3469: 'N', -- null allowed
3470: 'standard link meaning from lookup table Yes = standard, No = discretionary',
3471: l_user_entity_id,
3472: l_full_mls,
3466: 'STANDARD_LINK' || p_date_p,
3467: 'T', -- data type
3468: 'nvl(hr_general.decode_lookup(''YES_NO'',ELINK.STANDARD_LINK_FLAG),hr_general.decode_lookup(''YES_NO'',ETYPE.STANDARD_LINK_FLAG))',
3469: 'N', -- null allowed
3470: 'standard link meaning from lookup table Yes = standard, No = discretionary',
3471: l_user_entity_id,
3472: l_full_mls,
3473: l_base_dbi_name);
3474: if l_full_mls then
3478: ,p_startup_mode => l_startup_mode
3479: ,p_user_name => l_base_dbi_name
3480: ,p_user_entity_id => l_user_entity_id
3481: ,p_prefixes => l_dbi_prefixes
3482: ,p_suffix => 'STANDARD_LINK'
3483: ,p_date_p => p_date_p
3484: );
3485: end if;
3486: --
3484: );
3485: end if;
3486: --
3487: insert_database_item (l_element_name,
3488: 'STANDARD_LINK_CODE' || p_date_p,
3489: 'T', -- data type
3490: 'nvl (ELINK.standard_link_flag, ETYPE.standard_link_flag)',
3491: 'N', -- null allowed
3492: 'standard link value held on the database Y = standard, N = discretionary',
3486: --
3487: insert_database_item (l_element_name,
3488: 'STANDARD_LINK_CODE' || p_date_p,
3489: 'T', -- data type
3490: 'nvl (ELINK.standard_link_flag, ETYPE.standard_link_flag)',
3491: 'N', -- null allowed
3492: 'standard link value held on the database Y = standard, N = discretionary',
3493: l_user_entity_id,
3494: l_full_mls,
3488: 'STANDARD_LINK_CODE' || p_date_p,
3489: 'T', -- data type
3490: 'nvl (ELINK.standard_link_flag, ETYPE.standard_link_flag)',
3491: 'N', -- null allowed
3492: 'standard link value held on the database Y = standard, N = discretionary',
3493: l_user_entity_id,
3494: l_full_mls,
3495: l_base_dbi_name);
3496: if l_full_mls then
3500: ,p_startup_mode => l_startup_mode
3501: ,p_user_name => l_base_dbi_name
3502: ,p_user_entity_id => l_user_entity_id
3503: ,p_prefixes => l_dbi_prefixes
3504: ,p_suffix => 'STANDARD_LINK_CODE'
3505: ,p_date_p => p_date_p
3506: );
3507: end if;
3508: --
6566: the ff_user_entities table, the title of the descriptive flex is used
6567: instead, holding it in the user_entity_name column.
6568: --
6569: It is intended that this flexfield creation procedure be run from the
6570: Standard Report Submission (SRS) form.
6571: */
6572: procedure create_flexfield_dict
6573: (
6574: p_title in varchar2
6688: the ff_user_entities table, the title of the descriptive flex is used
6689: instead, holding it in the user_entity_name column.
6690: --
6691: It is intended that this flexfield creation procedure be run from the
6692: Standard Report Submission (SRS) form.
6693: */
6694: procedure create_dev_desc_flex_dict
6695: (
6696: p_title in varchar2,
7455: POS_KF_
7456: GROUP_KF_
7457: --
7458: It is intended that this flexfield creation procedure be run from the
7459: Standard Report Submission (SRS) form.
7460: */
7461: procedure create_keyflex_dict
7462: (
7463: p_business_group_id in number,
7710: The routine has been enhanced to loop around to create dbitems
7711: for each of the legislations which use the flex_num passed in.
7712: NOTES
7713: It is intended that this creation procedure be run from the
7714: Standard Report Submission (SRS) form.
7715: */
7716: procedure create_scl_flex_dict
7717: (
7718: p_id_flex_num in number
9531: ,p_user_entity_id => l_ueid
9532: ,p_suffix => 'QUALIFYING_AGE'
9533: );
9534:
9535: -- STANDARD_LINK --
9536: update_dbis
9537: (p_element_type_id => p_element_type_id
9538: ,p_leg_code => l_leg_code
9539: ,p_bg_id => l_bg_id
9542: ,p_date_p => l_date_p
9543: ,p_startup_mode => l_startup_mode
9544: ,p_languages => p_languages
9545: ,p_user_entity_id => l_ueid
9546: ,p_suffix => 'STANDARD_LINK'
9547: );
9548:
9549: -- STANDARD_LINK_CODE --
9550: update_dbis
9545: ,p_user_entity_id => l_ueid
9546: ,p_suffix => 'STANDARD_LINK'
9547: );
9548:
9549: -- STANDARD_LINK_CODE --
9550: update_dbis
9551: (p_element_type_id => p_element_type_id
9552: ,p_leg_code => l_leg_code
9553: ,p_bg_id => l_bg_id
9556: ,p_date_p => l_date_p
9557: ,p_startup_mode => l_startup_mode
9558: ,p_languages => p_languages
9559: ,p_user_entity_id => l_ueid
9560: ,p_suffix => 'STANDARD_LINK_CODE'
9561: );
9562:
9563: -- COSTABLE_TYPE --
9564: update_dbis