eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_LEGISLATION dependencies on PAY_PAYMENT_TYPES

Line 89: -- 310520 Change to update pay_payment_types rows

85: -- 70.24 rfine 27-Mar-96 n/a Removed call to the code which delivers
86: -- lookups. These are no longer delivered
87: -- by the HR mechanism: they're all
88: -- delivered by Datamerge.
89: -- 310520 Change to update pay_payment_types rows
90: -- if they already exist. This differs
91: -- from the previous functionality, which
92: -- only ever did inserts, no updates.
93: -- 70.25 rfine 01-Apr-96 n/a Fixed side-effect of previous fix to

Line 4279: -- INSTALLATION PROCEDURE FOR : PAY_PAYMENT_TYPES

4275:
4276: END install_leg_field;
4277:
4278: --****************************************************************************
4279: -- INSTALLATION PROCEDURE FOR : PAY_PAYMENT_TYPES
4280: --****************************************************************************
4281:
4282:
4283: PROCEDURE install_payment_types (p_phase IN number)

Line 4356: from pay_payment_types a

4352:
4353:
4354: select distinct null
4355: into l_null_return
4356: from pay_payment_types a
4357: where exists
4358: (select null
4359: from hr_s_payment_types b
4360: where a.payment_type_id = b.payment_type_id

Line 4385: from pay_payment_types;

4381: from hr_s_payment_types;
4382:
4383: select max(payment_type_id)
4384: into v_max_live
4385: from pay_payment_types;
4386:
4387: select pay_payment_types_s.nextval
4388: into v_sequence_number
4389: from dual;

Line 4387: select pay_payment_types_s.nextval

4383: select max(payment_type_id)
4384: into v_max_live
4385: from pay_payment_types;
4386:
4387: select pay_payment_types_s.nextval
4388: into v_sequence_number
4389: from dual;
4390:
4391: IF (v_sequence_number BETWEEN v_min_delivered AND v_max_delivered)

Line 4396: hr_legislation.munge_sequence('PAY_PAYMENT_TYPES_S',

4392: OR (v_sequence_number < v_max_live) THEN
4393:
4394: IF v_max_live > v_max_delivered THEN
4395:
4396: hr_legislation.munge_sequence('PAY_PAYMENT_TYPES_S',
4397: v_sequence_number,
4398: v_max_live);
4399: ELSE
4400:

Line 4401: hr_legislation.munge_sequence('PAY_PAYMENT_TYPES_S',

4397: v_sequence_number,
4398: v_max_live);
4399: ELSE
4400:
4401: hr_legislation.munge_sequence('PAY_PAYMENT_TYPES_S',
4402: v_sequence_number,
4403: v_max_delivered);
4404: END IF;
4405: END IF;

Line 4423: insert_hr_stu_exceptions ('pay_payment_types'

4419: -- not be raised more than once.
4420:
4421: rollback to new_payment_type_name;
4422:
4423: insert_hr_stu_exceptions ('pay_payment_types'
4424: , stu_rec.c_surrogate_key
4425: , exception_type
4426: , stu_rec.c_true_key);
4427:

Line 4442: from pay_payment_types

4438: BEGIN
4439:
4440: select distinct payment_type_id
4441: into l_new_surrogate_key
4442: from pay_payment_types
4443: where payment_type_name = stu_rec.c_true_key
4444: and ((territory_code is NULL and stu_rec.territory_code is NULL)
4445: or stu_rec.territory_code= territory_code);
4446:

Line 4450: select pay_payment_types_s.nextval

4446:
4447:
4448: EXCEPTION WHEN NO_DATA_FOUND THEN
4449:
4450: select pay_payment_types_s.nextval
4451: into l_new_surrogate_key
4452: from dual;
4453: END;
4454:

Line 4496: update pay_payment_types

4492: IF p_phase = 1 THEN
4493: return;
4494: END IF;
4495:
4496: update pay_payment_types
4497: set payment_type_id = stu_rec.c_surrogate_key
4498: , currency_code = stu_rec.currency_code
4499: , category = stu_rec.category
4500: , allow_as_default = stu_rec.allow_as_default

Line 4520: insert into pay_payment_types

4516:
4517: -- Row does not exist so insert
4518:
4519: BEGIN
4520: insert into pay_payment_types
4521: (payment_type_id
4522: ,territory_code
4523: ,currency_code
4524: ,category

Line 6873: -- PAY_PAYMENT_TYPES_TL

6869: -- PAY_BALANCE_TYPES_TL
6870: -- PAY_ELEMENT_CLASSIFICATIONS_TL
6871: -- PAY_ELEMENT_TYPES_F_TL
6872: -- PAY_INPUT_VALUES_F_TL
6873: -- PAY_PAYMENT_TYPES_TL
6874: -- PER_ASSIGNMENT_STATUS_TYPES_TL
6875: -- PER_ASSIGNMENT_INFO_TYPES_TL
6876: -- PAY_MONETARY_UNITS_TL
6877: -- PAY_BALANCE_CATEGORIES_F_TL

Line 7338: -- Seeds the PAY_PAYMENT_TYPES_TL table.

7334:
7335: PROCEDURE install_pptt
7336: ----------------------
7337: IS
7338: -- Seeds the PAY_PAYMENT_TYPES_TL table.
7339:
7340: CURSOR c_input_values IS
7341: select
7342: PT.PAYMENT_TYPE_ID,

Line 7352: from PAY_PAYMENT_TYPES PT,

7348: PT.LAST_UPDATED_BY,
7349: PT.LAST_UPDATE_LOGIN,
7350: PT.CREATED_BY,
7351: PT.CREATION_DATE
7352: from PAY_PAYMENT_TYPES PT,
7353: FND_LANGUAGES L,
7354: FND_LANGUAGES B
7355: where L.INSTALLED_FLAG in ('I', 'B')
7356: and B.INSTALLED_FLAG = 'B'

Line 7359: from PAY_PAYMENT_TYPES_TL PTT

7355: where L.INSTALLED_FLAG in ('I', 'B')
7356: and B.INSTALLED_FLAG = 'B'
7357: and not exists (
7358: select '1'
7359: from PAY_PAYMENT_TYPES_TL PTT
7360: where PTT.PAYMENT_TYPE_ID = PT.PAYMENT_TYPE_ID
7361: and PTT.language = l.language_code);
7362:
7363: l_counter NUMBER(3) := 0;

Line 7372: insert into PAY_PAYMENT_TYPES_TL

7368: FOR l_rec IN c_input_values LOOP
7369:
7370: -- Insert all selected rows into the TL table.
7371: -- If the row exist in the TL table then it will be ignored.
7372: insert into PAY_PAYMENT_TYPES_TL
7373: (
7374: PAYMENT_TYPE_ID,
7375: PAYMENT_TYPE_NAME,
7376: DESCRIPTION,

Line 7399: from PAY_PAYMENT_TYPES_TL PTT

7395: l_rec.CREATION_DATE
7396: from dual
7397: where not exists (
7398: select '1'
7399: from PAY_PAYMENT_TYPES_TL PTT
7400: where PTT.PAYMENT_TYPE_ID = l_rec.PAYMENT_TYPE_ID
7401: and PTT.language = l_rec.trans_lang);
7402:
7403: l_counter := l_counter + 1;