2992:
2993:
2994:
2995:
2996:
2998:
2999:
3000:
2993:
2994:
2995:
2996:
2997:
2999:
3000:
3001: */
3459: );
3460: end if;
3461: --
3462: insert_database_item (l_element_name,
3463: 'STANDARD_LINK' || p_date_p,
3464: 'T', -- data type
3465: 'nvl(hr_general.decode_lookup(''YES_NO'',ELINK.STANDARD_LINK_FLAG),hr_general.decode_lookup(''YES_NO'',ETYPE.STANDARD_LINK_FLAG))',
3466: 'N', -- null allowed
3467: 'standard link meaning from lookup table Yes = standard, No = discretionary',
3461: --
3462: insert_database_item (l_element_name,
3463: 'STANDARD_LINK' || p_date_p,
3464: 'T', -- data type
3465: 'nvl(hr_general.decode_lookup(''YES_NO'',ELINK.STANDARD_LINK_FLAG),hr_general.decode_lookup(''YES_NO'',ETYPE.STANDARD_LINK_FLAG))',
3466: 'N', -- null allowed
3467: 'standard link meaning from lookup table Yes = standard, No = discretionary',
3468: l_user_entity_id,
3469: l_full_mls,
3463: 'STANDARD_LINK' || p_date_p,
3464: 'T', -- data type
3465: 'nvl(hr_general.decode_lookup(''YES_NO'',ELINK.STANDARD_LINK_FLAG),hr_general.decode_lookup(''YES_NO'',ETYPE.STANDARD_LINK_FLAG))',
3466: 'N', -- null allowed
3467: 'standard link meaning from lookup table Yes = standard, No = discretionary',
3468: l_user_entity_id,
3469: l_full_mls,
3470: l_base_dbi_name);
3471: if l_full_mls then
3475: ,p_startup_mode => l_startup_mode
3476: ,p_user_name => l_base_dbi_name
3477: ,p_user_entity_id => l_user_entity_id
3478: ,p_prefixes => l_dbi_prefixes
3479: ,p_suffix => 'STANDARD_LINK'
3480: ,p_date_p => p_date_p
3481: );
3482: end if;
3483: --
3481: );
3482: end if;
3483: --
3484: insert_database_item (l_element_name,
3485: 'STANDARD_LINK_CODE' || p_date_p,
3486: 'T', -- data type
3487: 'nvl (ELINK.standard_link_flag, ETYPE.standard_link_flag)',
3488: 'N', -- null allowed
3489: 'standard link value held on the database Y = standard, N = discretionary',
3483: --
3484: insert_database_item (l_element_name,
3485: 'STANDARD_LINK_CODE' || p_date_p,
3486: 'T', -- data type
3487: 'nvl (ELINK.standard_link_flag, ETYPE.standard_link_flag)',
3488: 'N', -- null allowed
3489: 'standard link value held on the database Y = standard, N = discretionary',
3490: l_user_entity_id,
3491: l_full_mls,
3485: 'STANDARD_LINK_CODE' || p_date_p,
3486: 'T', -- data type
3487: 'nvl (ELINK.standard_link_flag, ETYPE.standard_link_flag)',
3488: 'N', -- null allowed
3489: 'standard link value held on the database Y = standard, N = discretionary',
3490: l_user_entity_id,
3491: l_full_mls,
3492: l_base_dbi_name);
3493: if l_full_mls then
3497: ,p_startup_mode => l_startup_mode
3498: ,p_user_name => l_base_dbi_name
3499: ,p_user_entity_id => l_user_entity_id
3500: ,p_prefixes => l_dbi_prefixes
3501: ,p_suffix => 'STANDARD_LINK_CODE'
3502: ,p_date_p => p_date_p
3503: );
3504: end if;
3505: --
6556: the ff_user_entities table, the title of the descriptive flex is used
6557: instead, holding it in the user_entity_name column.
6558: --
6559: It is intended that this flexfield creation procedure be run from the
6560: Standard Report Submission (SRS) form.
6561: */
6562: procedure create_flexfield_dict
6563: (
6564: p_title in varchar2
6678: the ff_user_entities table, the title of the descriptive flex is used
6679: instead, holding it in the user_entity_name column.
6680: --
6681: It is intended that this flexfield creation procedure be run from the
6682: Standard Report Submission (SRS) form.
6683: */
6684: procedure create_dev_desc_flex_dict
6685: (
6686: p_title in varchar2,
7378: POS_KF_
7379: GROUP_KF_
7380: --
7381: It is intended that this flexfield creation procedure be run from the
7382: Standard Report Submission (SRS) form.
7383: */
7384: procedure create_keyflex_dict
7385: (
7386: p_business_group_id in number,
7633: The routine has been enhanced to loop around to create dbitems
7634: for each of the legislations which use the flex_num passed in.
7635: NOTES
7636: It is intended that this creation procedure be run from the
7637: Standard Report Submission (SRS) form.
7638: */
7639: procedure create_scl_flex_dict
7640: (
7641: p_id_flex_num in number
9454: ,p_user_entity_id => l_ueid
9455: ,p_suffix => 'QUALIFYING_AGE'
9456: );
9457:
9458: -- STANDARD_LINK --
9459: update_dbis
9460: (p_element_type_id => p_element_type_id
9461: ,p_leg_code => l_leg_code
9462: ,p_bg_id => l_bg_id
9465: ,p_date_p => l_date_p
9466: ,p_startup_mode => l_startup_mode
9467: ,p_languages => p_languages
9468: ,p_user_entity_id => l_ueid
9469: ,p_suffix => 'STANDARD_LINK'
9470: );
9471:
9472: -- STANDARD_LINK_CODE --
9473: update_dbis
9468: ,p_user_entity_id => l_ueid
9469: ,p_suffix => 'STANDARD_LINK'
9470: );
9471:
9472: -- STANDARD_LINK_CODE --
9473: update_dbis
9474: (p_element_type_id => p_element_type_id
9475: ,p_leg_code => l_leg_code
9476: ,p_bg_id => l_bg_id
9479: ,p_date_p => l_date_p
9480: ,p_startup_mode => l_startup_mode
9481: ,p_languages => p_languages
9482: ,p_user_entity_id => l_ueid
9483: ,p_suffix => 'STANDARD_LINK_CODE'
9484: );
9485:
9486: -- COSTABLE_TYPE --
9487: update_dbis