DBA Data[Home] [Help]

APPS.PAY_CONTINUOUS_CALC dependencies on PAY_INPUT_VALUES_F

Line 4073: /* name : PAY_INPUT_VALUES_F_aru

4069: --
4070: end PAY_ELEMENT_LINKS_F_aru;
4071: --
4072: /* PAY_INPUT_VALUES */
4073: /* name : PAY_INPUT_VALUES_F_aru
4074: purpose : This is procedure that records any updates
4075: on input_values.
4076: */
4077: procedure PAY_INPUT_VALUES_F_aru(

Line 4077: procedure PAY_INPUT_VALUES_F_aru(

4073: /* name : PAY_INPUT_VALUES_F_aru
4074: purpose : This is procedure that records any updates
4075: on input_values.
4076: */
4077: procedure PAY_INPUT_VALUES_F_aru(
4078: p_business_group_id in number,
4079: p_legislation_code in varchar2,
4080: p_effective_date in date ,
4081: p_old_DEFAULT_VALUE in VARCHAR2,

Line 4128: 'PAY_INPUT_VALUES_F',

4124: and p_old_EFFECTIVE_START_DATE = p_new_EFFECTIVE_START_DATE) then
4125: --
4126: pay_continuous_calc.event_update(p_business_group_id,
4127: p_legislation_code,
4128: 'PAY_INPUT_VALUES_F',
4129: 'DEFAULT_VALUE',
4130: p_old_DEFAULT_VALUE,
4131: p_new_DEFAULT_VALUE,
4132: p_effective_date

Line 4137: 'PAY_INPUT_VALUES_F',

4133: );
4134: --
4135: pay_continuous_calc.event_update(p_business_group_id,
4136: p_legislation_code,
4137: 'PAY_INPUT_VALUES_F',
4138: 'DISPLAY_SEQUENCE',
4139: p_old_DISPLAY_SEQUENCE,
4140: p_new_DISPLAY_SEQUENCE,
4141: p_effective_date

Line 4146: 'PAY_INPUT_VALUES_F',

4142: );
4143: --
4144: pay_continuous_calc.event_update(p_business_group_id,
4145: p_legislation_code,
4146: 'PAY_INPUT_VALUES_F',
4147: 'ELEMENT_TYPE_ID',
4148: p_old_ELEMENT_TYPE_ID,
4149: p_new_ELEMENT_TYPE_ID,
4150: p_effective_date

Line 4155: 'PAY_INPUT_VALUES_F',

4151: );
4152: --
4153: pay_continuous_calc.event_update(p_business_group_id,
4154: p_legislation_code,
4155: 'PAY_INPUT_VALUES_F',
4156: 'FORMULA_ID',
4157: p_old_FORMULA_ID,
4158: p_new_FORMULA_ID,
4159: p_effective_date

Line 4164: 'PAY_INPUT_VALUES_F',

4160: );
4161: --
4162: pay_continuous_calc.event_update(p_business_group_id,
4163: p_legislation_code,
4164: 'PAY_INPUT_VALUES_F',
4165: 'GENERATE_DB_ITEMS_FLAG',
4166: p_old_GENERATE_DB_ITEMS_FLAG,
4167: p_new_GENERATE_DB_ITEMS_FLAG,
4168: p_effective_date

Line 4173: 'PAY_INPUT_VALUES_F',

4169: );
4170: --
4171: pay_continuous_calc.event_update(p_business_group_id,
4172: p_legislation_code,
4173: 'PAY_INPUT_VALUES_F',
4174: 'HOT_DEFAULT_FLAG',
4175: p_old_HOT_DEFAULT_FLAG,
4176: p_new_HOT_DEFAULT_FLAG,
4177: p_effective_date

Line 4182: 'PAY_INPUT_VALUES_F',

4178: );
4179: --
4180: pay_continuous_calc.event_update(p_business_group_id,
4181: p_legislation_code,
4182: 'PAY_INPUT_VALUES_F',
4183: 'INPUT_VALUE_ID',
4184: p_old_INPUT_VALUE_ID,
4185: p_new_INPUT_VALUE_ID,
4186: p_effective_date

Line 4191: 'PAY_INPUT_VALUES_F',

4187: );
4188: --
4189: pay_continuous_calc.event_update(p_business_group_id,
4190: p_legislation_code,
4191: 'PAY_INPUT_VALUES_F',
4192: 'LEGISLATION_SUBGROUP',
4193: p_old_LEGISLATION_SUBGROUP,
4194: p_new_LEGISLATION_SUBGROUP,
4195: p_effective_date

Line 4200: 'PAY_INPUT_VALUES_F',

4196: );
4197: --
4198: pay_continuous_calc.event_update(p_business_group_id,
4199: p_legislation_code,
4200: 'PAY_INPUT_VALUES_F',
4201: 'LOOKUP_TYPE',
4202: p_old_LOOKUP_TYPE,
4203: p_new_LOOKUP_TYPE,
4204: p_effective_date

Line 4209: 'PAY_INPUT_VALUES_F',

4205: );
4206: --
4207: pay_continuous_calc.event_update(p_business_group_id,
4208: p_legislation_code,
4209: 'PAY_INPUT_VALUES_F',
4210: 'MANDATORY_FLAG',
4211: p_old_MANDATORY_FLAG,
4212: p_new_MANDATORY_FLAG,
4213: p_effective_date

Line 4218: 'PAY_INPUT_VALUES_F',

4214: );
4215: --
4216: pay_continuous_calc.event_update(p_business_group_id,
4217: p_legislation_code,
4218: 'PAY_INPUT_VALUES_F',
4219: 'MAX_VALUE',
4220: p_old_MAX_VALUE,
4221: p_new_MAX_VALUE,
4222: p_effective_date

Line 4227: 'PAY_INPUT_VALUES_F',

4223: );
4224: --
4225: pay_continuous_calc.event_update(p_business_group_id,
4226: p_legislation_code,
4227: 'PAY_INPUT_VALUES_F',
4228: 'MIN_VALUE',
4229: p_old_MIN_VALUE,
4230: p_new_MIN_VALUE,
4231: p_effective_date

Line 4236: 'PAY_INPUT_VALUES_F',

4232: );
4233: --
4234: pay_continuous_calc.event_update(p_business_group_id,
4235: p_legislation_code,
4236: 'PAY_INPUT_VALUES_F',
4237: 'UOM',
4238: p_old_UOM,
4239: p_new_UOM,
4240: p_effective_date

Line 4245: 'PAY_INPUT_VALUES_F',

4241: );
4242: --
4243: pay_continuous_calc.event_update(p_business_group_id,
4244: p_legislation_code,
4245: 'PAY_INPUT_VALUES_F',
4246: 'WARNING_OR_ERROR',
4247: p_old_WARNING_OR_ERROR,
4248: p_new_WARNING_OR_ERROR,
4249: p_effective_date

Line 4254: 'PAY_INPUT_VALUES_F',

4250: );
4251: --
4252: pay_continuous_calc.event_update(p_business_group_id,
4253: p_legislation_code,
4254: 'PAY_INPUT_VALUES_F',
4255: 'WARNING_OR_ERROR',
4256: p_old_WARNING_OR_ERROR,
4257: p_new_WARNING_OR_ERROR,
4258: p_effective_date

Line 4265: 'PAY_INPUT_VALUES_F',

4261: /* OK it must be a date track change */
4262: --
4263: pay_continuous_calc.event_update(p_business_group_id,
4264: p_legislation_code,
4265: 'PAY_INPUT_VALUES_F',
4266: 'EFFECTIVE_END_DATE',
4267: p_old_EFFECTIVE_END_DATE,
4268: p_new_EFFECTIVE_END_DATE,
4269: p_new_effective_end_date,

Line 4276: 'PAY_INPUT_VALUES_F',

4272: );
4273: --
4274: pay_continuous_calc.event_update(p_business_group_id,
4275: p_legislation_code,
4276: 'PAY_INPUT_VALUES_F',
4277: 'EFFECTIVE_START_DATE',
4278: p_old_EFFECTIVE_START_DATE,
4279: p_new_EFFECTIVE_START_DATE,
4280: p_new_effective_start_date,

Line 4313: end PAY_INPUT_VALUES_F_aru;

4309: end if;
4310: pay_continuous_calc.g_event_list.sz := 0;
4311: end;
4312: --
4313: end PAY_INPUT_VALUES_F_aru;
4314: --
4315: /* Used generator to build this procedure, but removed some of that table values.
4316: */
4317: /* PAY_ALL_PAYROLLS */

Line 11327: pay_input_values_f piv

11323: pay_element_entry_values_f peev,
11324: pay_element_links_f pel,
11325: pay_link_input_values_f pliv,
11326: pay_element_types_f pet,
11327: pay_input_values_f piv
11328: where pee.element_entry_id = p_element_entry_id
11329: and pee.element_entry_id = peev.element_entry_id
11330: and peev.input_value_id = p_surrogate_key
11331: and pee.element_link_id = pel.element_link_id

Line 11397: pay_input_values_f piv

11393: pay_element_entry_values_f peev,
11394: pay_element_links_f pel,
11395: pay_link_input_values_f pliv,
11396: pay_element_types_f pet,
11397: pay_input_values_f piv
11398: where pee.element_entry_id = p_element_entry_id
11399: and pee.element_entry_id = peev.element_entry_id
11400: and peev.input_value_id = pliv.input_value_id
11401: and pee.element_link_id = pel.element_link_id