[Home] [Help]
517: generating NLS database items.
518: alogue 13-AUG-1997 Business_group_id passed to delete_keyflex_dict
519: to fix bug 513364.
520: nbristow 25-JUL-1997 Changed all references of fn_descriptive_flexs
521: to fnd_descriptive_flexs_vl.
522: mwcallag 26-APR-1995 Entity name passed to delete_keyflex_dict to
523: fix bug 278064.
524: rfine 24-NOV-1994 Suppressed index on business_group_id
525: mwcallag 13-OCT-1994 Route PAYROLL_ACTION_FLEXFIELD_ROUTE deleted.
659: replace (replace (replace (ltrim(rtrim(upper(DF.title))),
660: ' ','_'),'''',''),'.','_') c_title,
661: DFC.created_by c_created_by,
662: DFC.last_update_login c_last_login
663: FROM fnd_descriptive_flexs_vl DF,
664: fnd_descr_flex_contexts DFC
665: WHERE DF.application_table_name = p_table_name
666: AND replace (ltrim (rtrim(DF.title)), '''','') = replace(p_title,'''','')
667: AND DF.application_id IN (800, 801, 804, 805, 808, 8301)
3008: p_effective_date in date,
3009: p_date_p in varchar2
3010: ) is
3011: cursor get_title is
3012: select title from fnd_descriptive_flexs_vl
3013: where descriptive_flexfield_name = 'Element Developer DF'
3014: and application_id = 801;
3015: --
3016: cursor c_language is
6579: cursor routes_c is
6580: select df.application_table_name,
6581: rtd.route_name,
6582: rtd.user_key
6583: from fnd_descriptive_flexs_vl df,
6584: pay_route_to_descr_flexs rtd
6585: where df.application_id = rtd.application_id
6586: and df.descriptive_flexfield_name = rtd.descriptive_flexfield_name
6587: and replace (ltrim (rtrim(df.title)), '''','') = p_title;
6591: --
6592: cursor bgrp_c (p_table_name varchar2) is
6593: select dfc.descriptive_flex_context_code bus_grp_id
6594: from fnd_descr_flex_contexts dfc,
6595: fnd_descriptive_flexs_vl df
6596: where dfc.application_id = df.application_id
6597: and dfc.descriptive_flexfield_name = df.descriptive_flexfield_name
6598: and df.application_table_name = p_table_name
6599: and replace (ltrim (rtrim(df.title)), '''','') = p_title
6695: (
6696: p_title in varchar2,
6697: p_context in varchar2
6698: ) is
6699: l_flexfield_name fnd_descriptive_flexs_vl.descriptive_flexfield_name%type;
6700: l_legislation_code hr_org_information_types.legislation_code%type;
6701: l_context hr_org_information_types.org_information_type%type;
6702: l_navigation_method hr_org_information_types.navigation_method%type;
6703: l_multi_occur_flag per_assignment_info_types.multiple_occurences_flag%type;
6708: cursor c_routes is
6709: select df.application_table_name,
6710: rtd.route_name,
6711: rtd.user_key
6712: from fnd_descriptive_flexs_vl df,
6713: pay_route_to_descr_flexs rtd
6714: where df.application_id = rtd.application_id
6715: and df.descriptive_flexfield_name = rtd.descriptive_flexfield_name
6716: and replace (ltrim (rtrim(df.title)), '''','') = p_title
6735: BEGIN
6736: --
6737: select descriptive_flexfield_name
6738: into l_flexfield_name
6739: from fnd_descriptive_flexs_vl
6740: where title = p_title
6741: and application_id between 800 and 801;
6742: --
6743: l_legislation_code := get_legislation_code(l_flexfield_name, p_context);
7038: (
7039: p_payment_id in number
7040: ) is
7041: cursor get_title is
7042: select rtrim(title,'.') from fnd_descriptive_flexs_vl
7043: where descriptive_flexfield_name = 'Paymeth Developer DF';
7044: --
7045: l_context pay_payment_types.payment_type_name%type;
7046: l_context_upper pay_payment_types.payment_type_name%type;
7109: (
7110: p_payment_id in number
7111: ) is
7112: cursor get_title is
7113: select rtrim(title,'.') from fnd_descriptive_flexs_vl
7114: where descriptive_flexfield_name = 'Personal PayMeth Developer DF';
7115:
7116: l_context pay_payment_types.payment_type_name%type;
7117: l_context_upper pay_payment_types.payment_type_name%type;