[Home] [Help]
4101: --
4102: end PAY_ELEMENT_LINKS_F_aru;
4103: --
4104: /* PAY_INPUT_VALUES */
4105: /* name : PAY_INPUT_VALUES_F_aru
4106: purpose : This is procedure that records any updates
4107: on input_values.
4108: */
4109: procedure PAY_INPUT_VALUES_F_aru(
4105: /* name : PAY_INPUT_VALUES_F_aru
4106: purpose : This is procedure that records any updates
4107: on input_values.
4108: */
4109: procedure PAY_INPUT_VALUES_F_aru(
4110: p_business_group_id in number,
4111: p_legislation_code in varchar2,
4112: p_effective_date in date ,
4113: p_old_DEFAULT_VALUE in VARCHAR2,
4156: and p_old_EFFECTIVE_START_DATE = p_new_EFFECTIVE_START_DATE) then
4157: --
4158: pay_continuous_calc.event_update(p_business_group_id,
4159: p_legislation_code,
4160: 'PAY_INPUT_VALUES_F',
4161: 'DEFAULT_VALUE',
4162: p_old_DEFAULT_VALUE,
4163: p_new_DEFAULT_VALUE,
4164: p_effective_date
4165: );
4166: --
4167: pay_continuous_calc.event_update(p_business_group_id,
4168: p_legislation_code,
4169: 'PAY_INPUT_VALUES_F',
4170: 'DISPLAY_SEQUENCE',
4171: p_old_DISPLAY_SEQUENCE,
4172: p_new_DISPLAY_SEQUENCE,
4173: p_effective_date
4174: );
4175: --
4176: pay_continuous_calc.event_update(p_business_group_id,
4177: p_legislation_code,
4178: 'PAY_INPUT_VALUES_F',
4179: 'ELEMENT_TYPE_ID',
4180: p_old_ELEMENT_TYPE_ID,
4181: p_new_ELEMENT_TYPE_ID,
4182: p_effective_date
4183: );
4184: --
4185: pay_continuous_calc.event_update(p_business_group_id,
4186: p_legislation_code,
4187: 'PAY_INPUT_VALUES_F',
4188: 'FORMULA_ID',
4189: p_old_FORMULA_ID,
4190: p_new_FORMULA_ID,
4191: p_effective_date
4192: );
4193: --
4194: pay_continuous_calc.event_update(p_business_group_id,
4195: p_legislation_code,
4196: 'PAY_INPUT_VALUES_F',
4197: 'GENERATE_DB_ITEMS_FLAG',
4198: p_old_GENERATE_DB_ITEMS_FLAG,
4199: p_new_GENERATE_DB_ITEMS_FLAG,
4200: p_effective_date
4201: );
4202: --
4203: pay_continuous_calc.event_update(p_business_group_id,
4204: p_legislation_code,
4205: 'PAY_INPUT_VALUES_F',
4206: 'HOT_DEFAULT_FLAG',
4207: p_old_HOT_DEFAULT_FLAG,
4208: p_new_HOT_DEFAULT_FLAG,
4209: p_effective_date
4210: );
4211: --
4212: pay_continuous_calc.event_update(p_business_group_id,
4213: p_legislation_code,
4214: 'PAY_INPUT_VALUES_F',
4215: 'INPUT_VALUE_ID',
4216: p_old_INPUT_VALUE_ID,
4217: p_new_INPUT_VALUE_ID,
4218: p_effective_date
4219: );
4220: --
4221: pay_continuous_calc.event_update(p_business_group_id,
4222: p_legislation_code,
4223: 'PAY_INPUT_VALUES_F',
4224: 'LEGISLATION_SUBGROUP',
4225: p_old_LEGISLATION_SUBGROUP,
4226: p_new_LEGISLATION_SUBGROUP,
4227: p_effective_date
4228: );
4229: --
4230: pay_continuous_calc.event_update(p_business_group_id,
4231: p_legislation_code,
4232: 'PAY_INPUT_VALUES_F',
4233: 'LOOKUP_TYPE',
4234: p_old_LOOKUP_TYPE,
4235: p_new_LOOKUP_TYPE,
4236: p_effective_date
4237: );
4238: --
4239: pay_continuous_calc.event_update(p_business_group_id,
4240: p_legislation_code,
4241: 'PAY_INPUT_VALUES_F',
4242: 'MANDATORY_FLAG',
4243: p_old_MANDATORY_FLAG,
4244: p_new_MANDATORY_FLAG,
4245: p_effective_date
4246: );
4247: --
4248: pay_continuous_calc.event_update(p_business_group_id,
4249: p_legislation_code,
4250: 'PAY_INPUT_VALUES_F',
4251: 'MAX_VALUE',
4252: p_old_MAX_VALUE,
4253: p_new_MAX_VALUE,
4254: p_effective_date
4255: );
4256: --
4257: pay_continuous_calc.event_update(p_business_group_id,
4258: p_legislation_code,
4259: 'PAY_INPUT_VALUES_F',
4260: 'MIN_VALUE',
4261: p_old_MIN_VALUE,
4262: p_new_MIN_VALUE,
4263: p_effective_date
4264: );
4265: --
4266: pay_continuous_calc.event_update(p_business_group_id,
4267: p_legislation_code,
4268: 'PAY_INPUT_VALUES_F',
4269: 'UOM',
4270: p_old_UOM,
4271: p_new_UOM,
4272: p_effective_date
4273: );
4274: --
4275: pay_continuous_calc.event_update(p_business_group_id,
4276: p_legislation_code,
4277: 'PAY_INPUT_VALUES_F',
4278: 'WARNING_OR_ERROR',
4279: p_old_WARNING_OR_ERROR,
4280: p_new_WARNING_OR_ERROR,
4281: p_effective_date
4282: );
4283: --
4284: pay_continuous_calc.event_update(p_business_group_id,
4285: p_legislation_code,
4286: 'PAY_INPUT_VALUES_F',
4287: 'WARNING_OR_ERROR',
4288: p_old_WARNING_OR_ERROR,
4289: p_new_WARNING_OR_ERROR,
4290: p_effective_date
4293: /* OK it must be a date track change */
4294: --
4295: pay_continuous_calc.event_update(p_business_group_id,
4296: p_legislation_code,
4297: 'PAY_INPUT_VALUES_F',
4298: 'EFFECTIVE_END_DATE',
4299: p_old_EFFECTIVE_END_DATE,
4300: p_new_EFFECTIVE_END_DATE,
4301: p_new_effective_end_date,
4304: );
4305: --
4306: pay_continuous_calc.event_update(p_business_group_id,
4307: p_legislation_code,
4308: 'PAY_INPUT_VALUES_F',
4309: 'EFFECTIVE_START_DATE',
4310: p_old_EFFECTIVE_START_DATE,
4311: p_new_EFFECTIVE_START_DATE,
4312: p_new_effective_start_date,
4341: end if;
4342: pay_continuous_calc.g_event_list.sz := 0;
4343: end;
4344: --
4345: end PAY_INPUT_VALUES_F_aru;
4346: --
4347: /* Used generator to build this procedure, but removed some of that table values.
4348: */
4349: /* PAY_ALL_PAYROLLS */
11355: pay_element_entry_values_f peev,
11356: pay_element_links_f pel,
11357: pay_link_input_values_f pliv,
11358: pay_element_types_f pet,
11359: pay_input_values_f piv
11360: where pee.element_entry_id = p_element_entry_id
11361: and pee.element_entry_id = peev.element_entry_id
11362: and peev.input_value_id = p_surrogate_key
11363: and pee.element_link_id = pel.element_link_id
11425: pay_element_entry_values_f peev,
11426: pay_element_links_f pel,
11427: pay_link_input_values_f pliv,
11428: pay_element_types_f pet,
11429: pay_input_values_f piv
11430: where pee.element_entry_id = p_element_entry_id
11431: and pee.element_entry_id = peev.element_entry_id
11432: and peev.input_value_id = pliv.input_value_id
11433: and pee.element_link_id = pel.element_link_id