[Home] [Help]
303: -- 115.95.11510.3 DVickers 18-JUL-2003 insert category_name if
304: -- user_category_name is null
305: -- 115.96 Scchakra 16-JUL-2003 Bug 2982582. Added code in install_att
306: -- to install startup data in table
307: -- pay_monetary_units_tl.
308: -- 115.97 DVickers 30-SEP-2003 Added distinct to create_zz_leg_rule
309: -- 115.98 DVickers 02-OCT-2003 Added 4 new cols to
310: -- HR_S_LEGISLATIVE_FIELD_INFO
311: -- 115.99 DVickers 02-SEP-2003 Added CATEGORY as well
6622: -- PAY_INPUT_VALUES_F_TL
6623: -- PAY_PAYMENT_TYPES_TL
6624: -- PER_ASSIGNMENT_STATUS_TYPES_TL
6625: -- PER_ASSIGNMENT_INFO_TYPES_TL
6626: -- PAY_MONETARY_UNITS_TL
6627: -- PAY_BALANCE_CATEGORIES_F_TL
6628:
6629:
6630: PROCEDURE install_pbtt
7355: --
7356: PROCEDURE install_pmut
7357: ----------------------
7358: IS
7359: -- Seeds the PAY_MONETARY_UNITS_TL table.
7360:
7361: CURSOR c_monetary_units IS
7362: select
7363: M.MONETARY_UNIT_ID,
7376: and B.INSTALLED_FLAG = 'B'
7377: and NVL(TO_CHAR(M.BUSINESS_GROUP_ID),'Null Value')='Null Value'
7378: and not exists (
7379: select '1'
7380: from PAY_MONETARY_UNITS_TL pmut
7381: where pmut.monetary_unit_id =
7382: m.monetary_unit_id
7383: and pmut.language = l.language_code);
7384:
7390: FOR l_rec IN c_monetary_units LOOP
7391:
7392: -- Insert all selected rows into the TL table.
7393: -- If the row exist in the TL table then it will be ignored.
7394: insert into PAY_MONETARY_UNITS_TL
7395: (
7396: MONETARY_UNIT_ID,
7397: LANGUAGE,
7398: SOURCE_LANG,
7415: l_rec.CREATION_DATE
7416: from dual
7417: where not exists (
7418: select '1'
7419: from PAY_MONETARY_UNITS_TL pmut
7420: where pmut.monetary_unit_id =
7421: l_rec.monetary_unit_id
7422: and pmut.language = l_rec.trans_lang);
7423: