DBA Data[Home] [Help]

APPS.PAY_CONTINUOUS_CALC dependencies on PAY_LINK_INPUT_VALUES_F

Line 3588: /* name : PAY_LINK_INPUT_VALUES_F_aru

3584: --
3585: end PERSONAL_PAYMENT_METHODS_F_aru;
3586: --
3587: /* PAY_LINK_INPUT_VALUES */
3588: /* name : PAY_LINK_INPUT_VALUES_F_aru
3589: purpose : This is procedure that records any updates
3590: on link_input_values.
3591: */
3592: procedure PAY_LINK_INPUT_VALUES_F_aru(

Line 3592: procedure PAY_LINK_INPUT_VALUES_F_aru(

3588: /* name : PAY_LINK_INPUT_VALUES_F_aru
3589: purpose : This is procedure that records any updates
3590: on link_input_values.
3591: */
3592: procedure PAY_LINK_INPUT_VALUES_F_aru(
3593: p_business_group_id in number,
3594: p_legislation_code in varchar2,
3595: p_effective_date in date,
3596: p_old_COSTED_FLAG in VARCHAR2,

Line 3631: 'PAY_LINK_INPUT_VALUES_F',

3627: and p_old_EFFECTIVE_START_DATE = p_new_EFFECTIVE_START_DATE) then
3628: --
3629: pay_continuous_calc.event_update(p_business_group_id,
3630: p_legislation_code,
3631: 'PAY_LINK_INPUT_VALUES_F',
3632: 'COSTED_FLAG',
3633: p_old_COSTED_FLAG,
3634: p_new_COSTED_FLAG,
3635: p_effective_date

Line 3640: 'PAY_LINK_INPUT_VALUES_F',

3636: );
3637: --
3638: pay_continuous_calc.event_update(p_business_group_id,
3639: p_legislation_code,
3640: 'PAY_LINK_INPUT_VALUES_F',
3641: 'DEFAULT_VALUE',
3642: p_old_DEFAULT_VALUE,
3643: p_new_DEFAULT_VALUE,
3644: p_effective_date

Line 3649: 'PAY_LINK_INPUT_VALUES_F',

3645: );
3646: --
3647: pay_continuous_calc.event_update(p_business_group_id,
3648: p_legislation_code,
3649: 'PAY_LINK_INPUT_VALUES_F',
3650: 'ELEMENT_LINK_ID',
3651: p_old_ELEMENT_LINK_ID,
3652: p_new_ELEMENT_LINK_ID,
3653: p_effective_date

Line 3658: 'PAY_LINK_INPUT_VALUES_F',

3654: );
3655: --
3656: pay_continuous_calc.event_update(p_business_group_id,
3657: p_legislation_code,
3658: 'PAY_LINK_INPUT_VALUES_F',
3659: 'INPUT_VALUE_ID',
3660: p_old_INPUT_VALUE_ID,
3661: p_new_INPUT_VALUE_ID,
3662: p_effective_date

Line 3667: 'PAY_LINK_INPUT_VALUES_F',

3663: );
3664: --
3665: pay_continuous_calc.event_update(p_business_group_id,
3666: p_legislation_code,
3667: 'PAY_LINK_INPUT_VALUES_F',
3668: 'LINK_INPUT_VALUE_ID',
3669: p_old_LINK_INPUT_VALUE_ID,
3670: p_new_LINK_INPUT_VALUE_ID,
3671: p_effective_date

Line 3676: 'PAY_LINK_INPUT_VALUES_F',

3672: );
3673: --
3674: pay_continuous_calc.event_update(p_business_group_id,
3675: p_legislation_code,
3676: 'PAY_LINK_INPUT_VALUES_F',
3677: 'MAX_VALUE',
3678: p_old_MAX_VALUE,
3679: p_new_MAX_VALUE,
3680: p_effective_date

Line 3685: 'PAY_LINK_INPUT_VALUES_F',

3681: );
3682: --
3683: pay_continuous_calc.event_update(p_business_group_id,
3684: p_legislation_code,
3685: 'PAY_LINK_INPUT_VALUES_F',
3686: 'MIN_VALUE',
3687: p_old_MIN_VALUE,
3688: p_new_MIN_VALUE,
3689: p_effective_date

Line 3694: 'PAY_LINK_INPUT_VALUES_F',

3690: );
3691: --
3692: pay_continuous_calc.event_update(p_business_group_id,
3693: p_legislation_code,
3694: 'PAY_LINK_INPUT_VALUES_F',
3695: 'WARNING_OR_ERROR',
3696: p_old_WARNING_OR_ERROR,
3697: p_new_WARNING_OR_ERROR,
3698: p_effective_date

Line 3703: 'PAY_LINK_INPUT_VALUES_F',

3699: );
3700: --
3701: pay_continuous_calc.event_update(p_business_group_id,
3702: p_legislation_code,
3703: 'PAY_LINK_INPUT_VALUES_F',
3704: 'WARNING_OR_ERROR',
3705: p_old_WARNING_OR_ERROR,
3706: p_new_WARNING_OR_ERROR,
3707: p_effective_date

Line 3714: 'PAY_LINK_INPUT_VALUES_F',

3710: /* OK it must be a date track change */
3711: --
3712: pay_continuous_calc.event_update(p_business_group_id,
3713: p_legislation_code,
3714: 'PAY_LINK_INPUT_VALUES_F',
3715: 'EFFECTIVE_END_DATE',
3716: p_old_EFFECTIVE_END_DATE,
3717: p_new_EFFECTIVE_END_DATE,
3718: p_new_effective_end_date,

Line 3725: 'PAY_LINK_INPUT_VALUES_F',

3721: );
3722: --
3723: pay_continuous_calc.event_update(p_business_group_id,
3724: p_legislation_code,
3725: 'PAY_LINK_INPUT_VALUES_F',
3726: 'EFFECTIVE_START_DATE',
3727: p_old_EFFECTIVE_START_DATE,
3728: p_new_EFFECTIVE_START_DATE,
3729: p_new_effective_start_date,

Line 3762: end PAY_LINK_INPUT_VALUES_F_aru;

3758: end if;
3759: pay_continuous_calc.g_event_list.sz := 0;
3760: end;
3761: --
3762: end PAY_LINK_INPUT_VALUES_F_aru;
3763: --
3764: /* Used generator to build this procedure, but removed some of that table values.
3765: */
3766: /* PAY_ELEMENT_LINKS */

Line 11357: pay_link_input_values_f pliv,

11353: peev.screen_entry_value
11354: from pay_element_entries_f pee,
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

Line 11427: pay_link_input_values_f pliv,

11423: peev.screen_entry_value
11424: from pay_element_entries_f pee,
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