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 4033: -- INSTALLATION PROCEDURE FOR : PAY_PAYMENT_TYPES

4029:
4030: END install_leg_field;
4031:
4032: --****************************************************************************
4033: -- INSTALLATION PROCEDURE FOR : PAY_PAYMENT_TYPES
4034: --****************************************************************************
4035:
4036:
4037: PROCEDURE install_payment_types (p_phase IN number)

Line 4109: from pay_payment_types a

4105:
4106:
4107: select distinct null
4108: into l_null_return
4109: from pay_payment_types a
4110: where exists
4111: (select null
4112: from hr_s_payment_types b
4113: where a.payment_type_id = b.payment_type_id

Line 4138: from pay_payment_types;

4134: from hr_s_payment_types;
4135:
4136: select max(payment_type_id)
4137: into v_max_live
4138: from pay_payment_types;
4139:
4140: select pay_payment_types_s.nextval
4141: into v_sequence_number
4142: from dual;

Line 4140: select pay_payment_types_s.nextval

4136: select max(payment_type_id)
4137: into v_max_live
4138: from pay_payment_types;
4139:
4140: select pay_payment_types_s.nextval
4141: into v_sequence_number
4142: from dual;
4143:
4144: IF (v_sequence_number BETWEEN v_min_delivered AND v_max_delivered)

Line 4149: hr_legislation.munge_sequence('PAY_PAYMENT_TYPES_S',

4145: OR (v_sequence_number < v_max_live) THEN
4146:
4147: IF v_max_live > v_max_delivered THEN
4148:
4149: hr_legislation.munge_sequence('PAY_PAYMENT_TYPES_S',
4150: v_sequence_number,
4151: v_max_live);
4152: ELSE
4153:

Line 4154: hr_legislation.munge_sequence('PAY_PAYMENT_TYPES_S',

4150: v_sequence_number,
4151: v_max_live);
4152: ELSE
4153:
4154: hr_legislation.munge_sequence('PAY_PAYMENT_TYPES_S',
4155: v_sequence_number,
4156: v_max_delivered);
4157: END IF;
4158: END IF;

Line 4176: insert_hr_stu_exceptions ('pay_payment_types'

4172: -- not be raised more than once.
4173:
4174: rollback to new_payment_type_name;
4175:
4176: insert_hr_stu_exceptions ('pay_payment_types'
4177: , stu_rec.c_surrogate_key
4178: , exception_type
4179: , stu_rec.c_true_key);
4180:

Line 4195: from pay_payment_types

4191: BEGIN
4192:
4193: select distinct payment_type_id
4194: into l_new_surrogate_key
4195: from pay_payment_types
4196: where payment_type_name = stu_rec.c_true_key
4197: and ((territory_code is NULL and stu_rec.territory_code is NULL)
4198: or stu_rec.territory_code= territory_code);
4199:

Line 4203: select pay_payment_types_s.nextval

4199:
4200:
4201: EXCEPTION WHEN NO_DATA_FOUND THEN
4202:
4203: select pay_payment_types_s.nextval
4204: into l_new_surrogate_key
4205: from dual;
4206: END;
4207:

Line 4249: update pay_payment_types

4245: IF p_phase = 1 THEN
4246: return;
4247: END IF;
4248:
4249: update pay_payment_types
4250: set payment_type_id = stu_rec.c_surrogate_key
4251: , currency_code = stu_rec.currency_code
4252: , category = stu_rec.category
4253: , allow_as_default = stu_rec.allow_as_default

Line 4272: insert into pay_payment_types

4268:
4269: -- Row does not exist so insert
4270:
4271: BEGIN
4272: insert into pay_payment_types
4273: (payment_type_id
4274: ,territory_code
4275: ,currency_code
4276: ,category

Line 6623: -- PAY_PAYMENT_TYPES_TL

6619: -- PAY_BALANCE_TYPES_TL
6620: -- PAY_ELEMENT_CLASSIFICATIONS_TL
6621: -- PAY_ELEMENT_TYPES_F_TL
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

Line 7088: -- Seeds the PAY_PAYMENT_TYPES_TL table.

7084:
7085: PROCEDURE install_pptt
7086: ----------------------
7087: IS
7088: -- Seeds the PAY_PAYMENT_TYPES_TL table.
7089:
7090: CURSOR c_input_values IS
7091: select
7092: PT.PAYMENT_TYPE_ID,

Line 7102: from PAY_PAYMENT_TYPES PT,

7098: PT.LAST_UPDATED_BY,
7099: PT.LAST_UPDATE_LOGIN,
7100: PT.CREATED_BY,
7101: PT.CREATION_DATE
7102: from PAY_PAYMENT_TYPES PT,
7103: FND_LANGUAGES L,
7104: FND_LANGUAGES B
7105: where L.INSTALLED_FLAG in ('I', 'B')
7106: and B.INSTALLED_FLAG = 'B'

Line 7109: from PAY_PAYMENT_TYPES_TL PTT

7105: where L.INSTALLED_FLAG in ('I', 'B')
7106: and B.INSTALLED_FLAG = 'B'
7107: and not exists (
7108: select '1'
7109: from PAY_PAYMENT_TYPES_TL PTT
7110: where PTT.PAYMENT_TYPE_ID = PT.PAYMENT_TYPE_ID
7111: and PTT.language = l.language_code);
7112:
7113: l_counter NUMBER(3) := 0;

Line 7122: insert into PAY_PAYMENT_TYPES_TL

7118: FOR l_rec IN c_input_values LOOP
7119:
7120: -- Insert all selected rows into the TL table.
7121: -- If the row exist in the TL table then it will be ignored.
7122: insert into PAY_PAYMENT_TYPES_TL
7123: (
7124: PAYMENT_TYPE_ID,
7125: PAYMENT_TYPE_NAME,
7126: DESCRIPTION,

Line 7149: from PAY_PAYMENT_TYPES_TL PTT

7145: l_rec.CREATION_DATE
7146: from dual
7147: where not exists (
7148: select '1'
7149: from PAY_PAYMENT_TYPES_TL PTT
7150: where PTT.PAYMENT_TYPE_ID = l_rec.PAYMENT_TYPE_ID
7151: and PTT.language = l_rec.trans_lang);
7152:
7153: l_counter := l_counter + 1;