[Home] [Help]
345: get_legislation_code.
346: scchakra 115.64 11-FEB-2003 Bug 2637573. Modified
347: create_dev_desc_flex_dict to create DB items
348: for routes defined in table
349: pay_route_to_descr_flexs. Created a new
350: function get_legislation_code.
351: divicker 115.63 03-FEB-2003 bugfix 2782128
352: divicker 115.62 31-JAN-2003 Ensure BG items related to legcode are also picked
353: up for processing in legislative striping mode
464: canonical numbers in balances database items.
465: cborrett 04-DEC-1998 Added generation of context sensitive
466: dbitems in procedure CREATE_FLEXFIELD_DICT().
467: Replaced hardcoded routes in CREATE_FLEXFIELD_DICT()
468: with cursor against new table pay_route_to_descr_flexs.
469: alogue 08-JAN-1999 Change in create_desc_flex to create
470: CURRENCY_CODE dbitem for Org Pay Method
471: descriptive flex.
472: arundell 06-JAN-1999 Changes in insert_database_item to support
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;
6588: --
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
6717: and rtd.descriptive_flex_context_code = p_context;
6747: if nvl(l_legislation_code,'N') <> 'M' then
6748: --
6749: -- Bug 2637573 - Code added to check if any Developer DF contexts are
6750: -- seeded. If yes, then the DB items are created using the routes in
6751: -- table pay_route_to_descr_flexs.
6752: --
6753: open c_routes;
6754: loop
6755: --