DBA Data[Home] [Help]

APPS.PAY_MISC_DYT_INCIDENT_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 18

   purpose : This is procedure that records any insert
             on performance review.
*/
PROCEDURE per_performance_reviews_ari(
                                         p_business_group_id in number,
                                         p_legislation_code in varchar2,
                                         p_person_id in number,
                                         p_performance_review_id in number,
                                         p_effective_start_date in date
                                        )
IS
  --
  cursor asgcur (p_person_id number) is
  select distinct assignment_id
    from per_all_assignments_f
   where person_id = p_person_id;
Line: 47

  pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERFORMANCE_REVIEWS',
                                     NULL,
                                     NULL,
                                     NULL,
                                     p_effective_start_date,
                                     p_effective_start_date,
                                     'I'
                                    );
Line: 77

             p_event_update_id       => pay_continuous_calc.g_event_list.event_update_id(cnt),
             p_business_group_id     => p_business_group_id,
             p_calculation_date      => pay_continuous_calc.g_event_list.calc_date(cnt),
             p_surrogate_key         => p_performance_review_id);
Line: 102

   purpose : This is procedure that records any changes for updates
             on per_performance_reviews CORRECTION only.
*/
procedure PER_PERFORMANCE_REVIEWS_aru(
    p_business_group_id in number,
    p_legislation_code in varchar2,
    p_effective_date in date ,
    p_old_ATTRIBUTE1 in VARCHAR2,
    p_new_ATTRIBUTE1 in VARCHAR2 ,
    p_old_ATTRIBUTE10 in VARCHAR2,
    p_new_ATTRIBUTE10 in VARCHAR2 ,
    p_old_ATTRIBUTE11 in VARCHAR2,
    p_new_ATTRIBUTE11 in VARCHAR2 ,
    p_old_ATTRIBUTE12 in VARCHAR2,
    p_new_ATTRIBUTE12 in VARCHAR2 ,
    p_old_ATTRIBUTE13 in VARCHAR2,
    p_new_ATTRIBUTE13 in VARCHAR2 ,
    p_old_ATTRIBUTE14 in VARCHAR2,
    p_new_ATTRIBUTE14 in VARCHAR2 ,
    p_old_ATTRIBUTE15 in VARCHAR2,
    p_new_ATTRIBUTE15 in VARCHAR2 ,
    p_old_ATTRIBUTE16 in VARCHAR2,
    p_new_ATTRIBUTE16 in VARCHAR2 ,
    p_old_ATTRIBUTE17 in VARCHAR2,
    p_new_ATTRIBUTE17 in VARCHAR2 ,
    p_old_ATTRIBUTE18 in VARCHAR2,
    p_new_ATTRIBUTE18 in VARCHAR2 ,
    p_old_ATTRIBUTE19 in VARCHAR2,
    p_new_ATTRIBUTE19 in VARCHAR2 ,
    p_old_ATTRIBUTE2 in VARCHAR2,
    p_new_ATTRIBUTE2 in VARCHAR2 ,
    p_old_ATTRIBUTE20 in VARCHAR2,
    p_new_ATTRIBUTE20 in VARCHAR2 ,
    p_old_ATTRIBUTE21 in VARCHAR2,
    p_new_ATTRIBUTE21 in VARCHAR2 ,
    p_old_ATTRIBUTE22 in VARCHAR2,
    p_new_ATTRIBUTE22 in VARCHAR2 ,
    p_old_ATTRIBUTE23 in VARCHAR2,
    p_new_ATTRIBUTE23 in VARCHAR2 ,
    p_old_ATTRIBUTE24 in VARCHAR2,
    p_new_ATTRIBUTE24 in VARCHAR2,
    p_old_ATTRIBUTE25 in VARCHAR2,
    p_new_ATTRIBUTE25 in VARCHAR2 ,
    p_old_ATTRIBUTE26 in VARCHAR2,
    p_new_ATTRIBUTE26 in VARCHAR2 ,
    p_old_ATTRIBUTE27 in VARCHAR2,
    p_new_ATTRIBUTE27 in VARCHAR2 ,
    p_old_ATTRIBUTE28 in VARCHAR2,
    p_new_ATTRIBUTE28 in VARCHAR2 ,
    p_old_ATTRIBUTE29 in VARCHAR2,
    p_new_ATTRIBUTE29 in VARCHAR2 ,
    p_old_ATTRIBUTE3 in VARCHAR2,
    p_new_ATTRIBUTE3 in VARCHAR2 ,
    p_old_ATTRIBUTE30 in VARCHAR2,
    p_new_ATTRIBUTE30 in VARCHAR2 ,
    p_old_ATTRIBUTE4 in VARCHAR2,
    p_new_ATTRIBUTE4 in VARCHAR2 ,
    p_old_ATTRIBUTE5 in VARCHAR2,
    p_new_ATTRIBUTE5 in VARCHAR2 ,
    p_old_ATTRIBUTE6 in VARCHAR2,
    p_new_ATTRIBUTE6 in VARCHAR2 ,
    p_old_ATTRIBUTE7 in VARCHAR2,
    p_new_ATTRIBUTE7 in VARCHAR2 ,
    p_old_ATTRIBUTE8 in VARCHAR2,
    p_new_ATTRIBUTE8 in VARCHAR2 ,
    p_old_ATTRIBUTE9 in VARCHAR2,
    p_new_ATTRIBUTE9 in VARCHAR2 ,
    p_old_ATTRIBUTE_CATEGORY in VARCHAR2,
    p_new_ATTRIBUTE_CATEGORY in VARCHAR2 ,
    p_old_EVENT_ID in NUMBER,
    p_new_EVENT_ID in NUMBER ,
    p_old_NEXT_PERF_REVIEW_DATE in DATE,
    p_new_NEXT_PERF_REVIEW_DATE in DATE ,
    p_old_PERFORMANCE_RATING in VARCHAR2,
    p_new_PERFORMANCE_RATING in VARCHAR2 ,
    p_old_PERFORMANCE_REVIEW_ID in NUMBER,
    p_new_PERFORMANCE_REVIEW_ID in NUMBER ,
    p_old_PERSON_ID in NUMBER,
    p_new_PERSON_ID in NUMBER ,
    p_old_REVIEW_DATE in DATE,
    p_new_REVIEW_DATE in DATE
)
is
--
  cursor asgcur (p_person_id number) is
  select distinct assignment_id
    from per_all_assignments_f
   where person_id = p_person_id;
Line: 205

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERFORMANCE_REVIEWS',
                                     'ATTRIBUTE1',
                                     p_old_ATTRIBUTE1,
                                     p_new_ATTRIBUTE1,
                                     p_effective_date
                                  );
Line: 214

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERFORMANCE_REVIEWS',
                                     'ATTRIBUTE10',
                                     p_old_ATTRIBUTE10,
                                     p_new_ATTRIBUTE10,
                                     p_effective_date
                                  );
Line: 223

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERFORMANCE_REVIEWS',
                                     'ATTRIBUTE11',
                                     p_old_ATTRIBUTE11,
                                     p_new_ATTRIBUTE11,
                                     p_effective_date
                                  );
Line: 232

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERFORMANCE_REVIEWS',
                                     'ATTRIBUTE12',
                                     p_old_ATTRIBUTE12,
                                     p_new_ATTRIBUTE12,
                                     p_effective_date
                                  );
Line: 241

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERFORMANCE_REVIEWS',
                                     'ATTRIBUTE13',
                                     p_old_ATTRIBUTE13,
                                     p_new_ATTRIBUTE13,
                                     p_effective_date
                                  );
Line: 250

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERFORMANCE_REVIEWS',
                                     'ATTRIBUTE14',
                                     p_old_ATTRIBUTE14,
                                     p_new_ATTRIBUTE14,
                                     p_effective_date
                                  );
Line: 259

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERFORMANCE_REVIEWS',
                                     'ATTRIBUTE15',
                                     p_old_ATTRIBUTE15,
                                     p_new_ATTRIBUTE15,
                                     p_effective_date
                                  );
Line: 268

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERFORMANCE_REVIEWS',
                                     'ATTRIBUTE16',
                                     p_old_ATTRIBUTE16,
                                     p_new_ATTRIBUTE16,
                                     p_effective_date
                                  );
Line: 277

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERFORMANCE_REVIEWS',
                                     'ATTRIBUTE17',
                                     p_old_ATTRIBUTE17,
                                     p_new_ATTRIBUTE17,
                                     p_effective_date
                                  );
Line: 286

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERFORMANCE_REVIEWS',
                                     'ATTRIBUTE18',
                                     p_old_ATTRIBUTE18,
                                     p_new_ATTRIBUTE18,
                                     p_effective_date
                                  );
Line: 295

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERFORMANCE_REVIEWS',
                                     'ATTRIBUTE19',
                                     p_old_ATTRIBUTE19,
                                     p_new_ATTRIBUTE19,
                                     p_effective_date
                                  );
Line: 304

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERFORMANCE_REVIEWS',
                                     'ATTRIBUTE2',
                                     p_old_ATTRIBUTE2,
                                     p_new_ATTRIBUTE2,
                                     p_effective_date
                                  );
Line: 313

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERFORMANCE_REVIEWS',
                                     'ATTRIBUTE20',
                                     p_old_ATTRIBUTE20,
                                     p_new_ATTRIBUTE20,
                                     p_effective_date
                                  );
Line: 322

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERFORMANCE_REVIEWS',
                                     'ATTRIBUTE21',
                                     p_old_ATTRIBUTE21,
                                     p_new_ATTRIBUTE21,
                                     p_effective_date
                                  );
Line: 331

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERFORMANCE_REVIEWS',
                                     'ATTRIBUTE22',
                                     p_old_ATTRIBUTE22,
                                     p_new_ATTRIBUTE22,
                                     p_effective_date
                                  );
Line: 340

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERFORMANCE_REVIEWS',
                                     'ATTRIBUTE23',
                                     p_old_ATTRIBUTE23,
                                     p_new_ATTRIBUTE23,
                                     p_effective_date
                                  );
Line: 349

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERFORMANCE_REVIEWS',
                                     'ATTRIBUTE24',
                                     p_old_ATTRIBUTE24,
                                     p_new_ATTRIBUTE24,
                                     p_effective_date
                                  );
Line: 358

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERFORMANCE_REVIEWS',
                                     'ATTRIBUTE25',
                                     p_old_ATTRIBUTE25,
                                     p_new_ATTRIBUTE25,
                                     p_effective_date
                                  );
Line: 367

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERFORMANCE_REVIEWS',
                                     'ATTRIBUTE26',
                                     p_old_ATTRIBUTE26,
                                     p_new_ATTRIBUTE26,
                                     p_effective_date
                                  );
Line: 376

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERFORMANCE_REVIEWS',
                                     'ATTRIBUTE27',
                                     p_old_ATTRIBUTE27,
                                     p_new_ATTRIBUTE27,
                                     p_effective_date
                                  );
Line: 385

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERFORMANCE_REVIEWS',
                                     'ATTRIBUTE28',
                                     p_old_ATTRIBUTE28,
                                     p_new_ATTRIBUTE28,
                                     p_effective_date
                                  );
Line: 395

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERFORMANCE_REVIEWS',
                                     'ATTRIBUTE29',
                                     p_old_ATTRIBUTE29,
                                     p_new_ATTRIBUTE29,
                                     p_effective_date
                                  );
Line: 404

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERFORMANCE_REVIEWS',
                                     'ATTRIBUTE3',
                                     p_old_ATTRIBUTE3,
                                     p_new_ATTRIBUTE3,
                                     p_effective_date
                                  );
Line: 413

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERFORMANCE_REVIEWS',
                                     'ATTRIBUTE30',
                                     p_old_ATTRIBUTE30,
                                     p_new_ATTRIBUTE30,
                                     p_effective_date
                                  );
Line: 422

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERFORMANCE_REVIEWS',
                                     'ATTRIBUTE4',
                                     p_old_ATTRIBUTE4,
                                     p_new_ATTRIBUTE4,
                                     p_effective_date
                                  );
Line: 431

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERFORMANCE_REVIEWS',
                                     'ATTRIBUTE5',
                                     p_old_ATTRIBUTE5,
                                     p_new_ATTRIBUTE5,
                                     p_effective_date
                                  );
Line: 440

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERFORMANCE_REVIEWS',
                                     'ATTRIBUTE6',
                                     p_old_ATTRIBUTE6,
                                     p_new_ATTRIBUTE6,
                                     p_effective_date
                                  );
Line: 449

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERFORMANCE_REVIEWS',
                                     'ATTRIBUTE7',
                                     p_old_ATTRIBUTE7,
                                     p_new_ATTRIBUTE7,
                                     p_effective_date
                                  );
Line: 458

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERFORMANCE_REVIEWS',
                                     'ATTRIBUTE8',
                                     p_old_ATTRIBUTE8,
                                     p_new_ATTRIBUTE8,
                                     p_effective_date
                                  );
Line: 467

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERFORMANCE_REVIEWS',
                                     'ATTRIBUTE9',
                                     p_old_ATTRIBUTE9,
                                     p_new_ATTRIBUTE9,
                                     p_effective_date
                                  );
Line: 476

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERFORMANCE_REVIEWS',
                                     'ATTRIBUTE_CATEGORY',
                                     p_old_ATTRIBUTE_CATEGORY,
                                     p_new_ATTRIBUTE_CATEGORY,
                                     p_effective_date
                                  );
Line: 485

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERFORMANCE_REVIEWS',
                                     'EVENT_ID',
                                     p_old_EVENT_ID,
                                     p_new_EVENT_ID,
                                     p_effective_date
                                  );
Line: 494

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERFORMANCE_REVIEWS',
                                     'NEXT_PERF_REVIEW_DATE',
                                     p_old_NEXT_PERF_REVIEW_DATE,
                                     p_new_NEXT_PERF_REVIEW_DATE,
                                     p_effective_date
                                  );
Line: 503

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERFORMANCE_REVIEWS',
                                     'PERFORMANCE_RATING',
                                     p_old_PERFORMANCE_RATING,
                                     p_new_PERFORMANCE_RATING,
                                     p_effective_date
                                  );
Line: 512

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERFORMANCE_REVIEWS',
                                     'PERFORMANCE_REVIEW_ID',
                                     p_old_PERFORMANCE_REVIEW_ID,
                                     p_new_PERFORMANCE_REVIEW_ID,
                                     p_effective_date
                                  );
Line: 521

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERFORMANCE_REVIEWS',
                                     'PERSON_ID',
                                     p_old_PERSON_ID,
                                     p_new_PERSON_ID,
                                     p_effective_date
                                  );
Line: 530

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERFORMANCE_REVIEWS',
                                     'REVIEW_DATE',
                                     p_old_REVIEW_DATE,
                                     p_new_REVIEW_DATE,
                                     p_effective_date
                                  );
Line: 558

            p_event_update_id       => pay_continuous_calc.g_event_list.event_update_id(cnt),
            p_business_group_id     => p_business_group_id,
            p_calculation_date      => pay_continuous_calc.g_event_list.calc_date(cnt),
            p_surrogate_key         => p_new_performance_review_id
           );
Line: 581

   purpose : This is procedure that records any deletes
             on per_performance_reviews.
*/
  procedure per_performance_reviews_ard(
                       p_business_group_id in number,
                       p_legislation_code in varchar2,
                       p_person_id in number,
                       p_effective_start_date in date,
                       p_performance_review_id in number
                       )
  is
  --
  cursor asgcur (p_person_id number) is
  select distinct assignment_id
    from per_all_assignments_f
   where person_id = p_person_id;
Line: 610

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERFORMANCE_REVIEWS',
                                     NULL,
                                     NULL,
                                     NULL,
                                     p_effective_start_date,
                                     p_effective_start_date,
                                     'D'
                                    );
Line: 637

                         p_event_update_id       => pay_continuous_calc.g_event_list.event_update_id(cnt),
                         p_surrogate_key         => p_performance_review_id,
                         p_calculation_date      => pay_continuous_calc.g_event_list.calc_date(cnt),
                         p_business_group_id     => p_business_group_id
                         );
Line: 663

   purpose : This is procedure that records any insert
             on performance review.
*/
  procedure per_appraisals_ari(
                                         p_business_group_id in number,
                                         p_legislation_code in varchar2,
                                         p_appraisee_person_id in number,
                                         p_appraisal_id in number,
                                         p_effective_start_date in date
                                        )
  is
  --
  cursor asgcur (p_person_id number) is
  select distinct assignment_id
    from per_all_assignments_f
   where person_id = p_person_id;
Line: 691

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     NULL,
                                     NULL,
                                     NULL,
                                     p_effective_start_date,
                                     p_effective_start_date,
                                     'I'
                                    );
Line: 718

             p_event_update_id       => pay_continuous_calc.g_event_list.event_update_id(cnt),
             p_business_group_id     => p_business_group_id,
             p_calculation_date      => pay_continuous_calc.g_event_list.calc_date(cnt),
             p_surrogate_key         => p_appraisal_id);
Line: 853

  select distinct assignment_id
    from per_all_assignments_f
   where person_id = p_person_id;
Line: 868

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'APPRAISAL_ID',
                                     p_old_APPRAISAL_ID,
                                     p_new_APPRAISAL_ID,
                                     p_effective_date
                                  );
Line: 877

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'APPRAISAL_PERIOD_END_DATE',
                                     p_old_APPRAISAL_PERIOD_END_DAT,
                                     p_new_APPRAISAL_PERIOD_END_DAT,
                                     p_effective_date
                                  );
Line: 886

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'APPRAISAL_PERIOD_START_DATE',
                                     p_old_APPRAISAL_PERIOD_START_D,
                                     p_new_APPRAISAL_PERIOD_START_D,
                                     p_effective_date
                                  );
Line: 895

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'APPRAISAL_TEMPLATE_ID',
                                     p_old_APPRAISAL_TEMPLATE_ID,
                                     p_new_APPRAISAL_TEMPLATE_ID,
                                     p_effective_date
                                  );
Line: 904

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'APPRAISEE_PERSON_ID',
                                     p_old_APPRAISEE_PERSON_ID,
                                     p_new_APPRAISEE_PERSON_ID,
                                     p_effective_date
                                  );
Line: 913

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'APPRAISER_PERSON_ID',
                                     p_old_APPRAISER_PERSON_ID,
                                     p_new_APPRAISER_PERSON_ID,
                                     p_effective_date
                                  );
Line: 922

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'ATTRIBUTE1',
                                     p_old_ATTRIBUTE1,
                                     p_new_ATTRIBUTE1,
                                     p_effective_date
                                  );
Line: 931

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'ATTRIBUTE10',
                                     p_old_ATTRIBUTE10,
                                     p_new_ATTRIBUTE10,
                                     p_effective_date
                                  );
Line: 940

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'ATTRIBUTE11',
                                     p_old_ATTRIBUTE11,
                                     p_new_ATTRIBUTE11,
                                     p_effective_date
                                  );
Line: 949

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'ATTRIBUTE12',
                                     p_old_ATTRIBUTE12,
                                     p_new_ATTRIBUTE12,
                                     p_effective_date
                                  );
Line: 958

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'ATTRIBUTE13',
                                     p_old_ATTRIBUTE13,
                                     p_new_ATTRIBUTE13,
                                     p_effective_date
                                  );
Line: 967

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'ATTRIBUTE14',
                                     p_old_ATTRIBUTE14,
                                     p_new_ATTRIBUTE14,
                                     p_effective_date
                                  );
Line: 976

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'ATTRIBUTE15',
                                     p_old_ATTRIBUTE15,
                                     p_new_ATTRIBUTE15,
                                     p_effective_date
                                  );
Line: 985

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'ATTRIBUTE16',
                                     p_old_ATTRIBUTE16,
                                     p_new_ATTRIBUTE16,
                                     p_effective_date
                                  );
Line: 994

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'ATTRIBUTE17',
                                     p_old_ATTRIBUTE17,
                                     p_new_ATTRIBUTE17,
                                     p_effective_date
                                  );
Line: 1003

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'ATTRIBUTE18',
                                     p_old_ATTRIBUTE18,
                                     p_new_ATTRIBUTE18,
                                     p_effective_date
                                  );
Line: 1012

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'ATTRIBUTE19',
                                     p_old_ATTRIBUTE19,
                                     p_new_ATTRIBUTE19,
                                     p_effective_date
                                  );
Line: 1021

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'ATTRIBUTE2',
                                     p_old_ATTRIBUTE2,
                                     p_new_ATTRIBUTE2,
                                     p_effective_date
                                  );
Line: 1030

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'ATTRIBUTE20',
                                     p_old_ATTRIBUTE20,
                                     p_new_ATTRIBUTE20,
                                     p_effective_date
                                  );
Line: 1039

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'ATTRIBUTE3',
                                     p_old_ATTRIBUTE3,
                                     p_new_ATTRIBUTE3,
                                     p_effective_date
                                  );
Line: 1048

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'ATTRIBUTE4',
                                     p_old_ATTRIBUTE4,
                                     p_new_ATTRIBUTE4,
                                     p_effective_date
                                  );
Line: 1057

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'ATTRIBUTE5',
                                     p_old_ATTRIBUTE5,
                                     p_new_ATTRIBUTE5,
                                     p_effective_date
                                  );
Line: 1066

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'ATTRIBUTE6',
                                     p_old_ATTRIBUTE6,
                                     p_new_ATTRIBUTE6,
                                     p_effective_date
                                  );
Line: 1075

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'ATTRIBUTE7',
                                     p_old_ATTRIBUTE7,
                                     p_new_ATTRIBUTE7,
                                     p_effective_date
                                  );
Line: 1084

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'ATTRIBUTE8',
                                     p_old_ATTRIBUTE8,
                                     p_new_ATTRIBUTE8,
                                     p_effective_date
                                  );
Line: 1093

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'ATTRIBUTE9',
                                     p_old_ATTRIBUTE9,
                                     p_new_ATTRIBUTE9,
                                     p_effective_date
                                  );
Line: 1102

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'ATTRIBUTE_CATEGORY',
                                     p_old_ATTRIBUTE_CATEGORY,
                                     p_new_ATTRIBUTE_CATEGORY,
                                     p_effective_date
                                  );
Line: 1111

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'BUSINESS_GROUP_ID',
                                     p_old_BUSINESS_GROUP_ID,
                                     p_new_BUSINESS_GROUP_ID,
                                     p_effective_date
                                  );
Line: 1120

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'COMMENTS',
                                     p_old_COMMENTS,
                                     p_new_COMMENTS,
                                     p_effective_date
                                  );
Line: 1129

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'GROUP_DATE',
                                     p_old_GROUP_DATE,
                                     p_new_GROUP_DATE,
                                     p_effective_date
                                  );
Line: 1138

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'GROUP_INITIATOR_ID',
                                     p_old_GROUP_INITIATOR_ID,
                                     p_new_GROUP_INITIATOR_ID,
                                     p_effective_date
                                  );
Line: 1147

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'NEXT_APPRAISAL_DATE',
                                     p_old_NEXT_APPRAISAL_DATE,
                                     p_new_NEXT_APPRAISAL_DATE,
                                     p_effective_date
                                  );
Line: 1156

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'OPEN',
                                     p_old_OPEN,
                                     p_new_OPEN,
                                     p_effective_date
                                  );
Line: 1165

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'OVERALL_PERFORMANCE_LEVEL_ID',
                                     p_old_OVERALL_PERFORMANCE_LEVE,
                                     p_new_OVERALL_PERFORMANCE_LEVE,
                                     p_effective_date
                                  );
Line: 1174

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'STATUS',
                                     p_old_STATUS,
                                     p_new_STATUS,
                                     p_effective_date
                                  );
Line: 1183

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'TYPE',
                                     p_old_TYPE,
                                     p_new_TYPE,
                                     p_effective_date
                                  );
Line: 1194

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'SYSTEM_TYPE',
                                     p_new_system_type,
                                     p_old_system_type,
                                     p_effective_date
                                    );
Line: 1203

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'APPRAISAL_SYSTEM_STATUS',
                                     p_new_appraisal_system_status,
                                     p_old_appraisal_system_status,
                                     p_effective_date
                                     );
Line: 1212

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'SYSTEM_PARAMS',
                                     p_new_system_params,
                                     p_old_system_params,
                                     p_effective_date
                                    );
Line: 1221

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'APPRAISEE_ACCESS',
                                     p_new_appraisee_access,
                                     p_old_appraisee_access,
                                     p_effective_date
                                    );
Line: 1230

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'MAIN_APPRAISER_ID',
                                     p_new_main_appraiser_id,
                                     p_old_main_appraiser_id,
                                     p_effective_date
                                    );
Line: 1239

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'ASSIGNMENT_ID',
                                     p_new_assignment_id,
                                     p_old_assignment_id,
                                     p_effective_date
                                    );
Line: 1248

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'ASSIGNMENT_START_DATE',
                                     p_new_assignment_start_date,
                                     p_old_assignment_start_date,
                                     p_effective_date
                                    );
Line: 1257

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'ASSIGNMENT_BUSINESS_GROUP_ID',
                                     p_new_asg_business_group_id,
                                     p_old_asg_business_group_id,
                                     p_effective_date
                                    );
Line: 1266

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'ASSIGNMENT_ORGANIZATION_ID',
                                     p_new_asg_organization_id,
                                     p_old_asg_organization_id,
                                     p_effective_date
                                    );
Line: 1275

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'ASSIGNMENT_JOB_ID',
                                     p_new_assignment_job_id,
                                     p_old_assignment_job_id,
                                     p_effective_date
                                    );
Line: 1284

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'ASSIGNMENT_POSITION_ID',
                                     p_new_assignment_position_id,
                                     p_old_assignment_position_id,
                                     p_effective_date
                                    );
Line: 1293

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'ASSIGNMENT_GRADE_ID',
                                     p_new_assignment_grade_id,
                                     p_old_assignment_grade_id,
                                     p_effective_date
                                    );
Line: 1302

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'POTENTIAL_READINESS_LEVEL',
                                     p_new_ptntl_readiness_level,
                                     p_old_ptntl_readiness_level,
                                     p_effective_date
                                    );
Line: 1311

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'POTENTIAL_SHORT_TERM_WORKOPP',
                                     p_new_ptntl_short_term_workopp,
                                     p_old_ptntl_short_term_workopp,
                                     p_effective_date
                                    );
Line: 1320

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'POTENTIAL_LONG_TERM_WORKOPP',
                                     p_new_ptntl_long_term_workopp,
                                     p_old_ptntl_long_term_workopp,
                                     p_effective_date
                                    );
Line: 1329

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'POTENTIAL_DETAILS',
                                     p_new_potential_details,
                                     p_old_potential_details,
                                     p_effective_date
                                    );
Line: 1338

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'EVENT_ID',
                                     p_new_event_id,
                                     p_old_event_id,
                                     p_effective_date
                                    );
Line: 1350

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     'APPRAISAL_DATE',
                                     p_old_APPRAISAL_DATE,
                                     p_new_APPRAISAL_DATE,
                                     p_new_appraisal_date,
                                     least(p_old_appraisal_date,
                                           p_new_appraisal_date)
                                  );
Line: 1380

             p_event_update_id       => pay_continuous_calc.g_event_list.event_update_id(cnt),
             p_business_group_id     => p_business_group_id,
             p_calculation_date      => pay_continuous_calc.g_event_list.calc_date(cnt),
             p_surrogate_key         => p_new_appraisal_id
           );
Line: 1401

   purpose : This is procedure that records any deletes
             on per_appraisals.
*/
  procedure per_appraisals_ard(
                       p_business_group_id in number,
                       p_legislation_code in varchar2,
                       p_appraisee_person_id in number,
                       p_effective_start_date in date,
                       p_appraisal_id in number
                       )
  is
  --
  cursor asgcur (p_person_id number) is
  select distinct assignment_id
    from per_all_assignments_f
   where person_id = p_person_id;
Line: 1430

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_APPRAISALS',
                                     NULL,
                                     NULL,
                                     NULL,
                                     p_effective_start_date,
                                     p_effective_start_date,
                                     'D'
                                    );
Line: 1457

                         p_event_update_id       => pay_continuous_calc.g_event_list.event_update_id(cnt),
                         p_surrogate_key         => p_appraisal_id,
                         p_calculation_date      => pay_continuous_calc.g_event_list.calc_date(cnt),
                         p_business_group_id     => p_business_group_id
                         );
Line: 1485

   purpose : This is procedure that records any insert
             on performance review.
*/
PROCEDURE per_person_type_usages_f_ari(  p_business_group_id    in number,
                                         p_legislation_code     in varchar2,
                                         p_person_id            in number,
                                         p_person_type_usage_id in number,
                                         p_effective_start_date in date
                                        )
IS
  --
  cursor asgcur (p_person_id number) is
  select distinct assignment_id
    from per_all_assignments_f
   where person_id = p_person_id;
Line: 1513

  pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERSON_TYPE_USAGES_F',
                                     NULL,
                                     NULL,
                                     NULL,
                                     p_effective_start_date,
                                     p_effective_start_date,
                                     'I'
                                    );
Line: 1543

             p_event_update_id       => pay_continuous_calc.g_event_list.event_update_id(cnt),
             p_business_group_id     => p_business_group_id,
             p_calculation_date      => pay_continuous_calc.g_event_list.calc_date(cnt),
             p_surrogate_key         => p_person_type_usage_id);
Line: 1565

   purpose : This is procedure that records any changes for updates
             on PER_PERSON_TYPE_USAGES_F CORRECTION only.
*/

procedure PER_PERSON_TYPE_USAGES_F_aru(
    p_business_group_id in number,
    p_legislation_code in varchar2,
    p_effective_date in date,
    p_old_ATTRIBUTE1 in VARCHAR2,
    p_new_ATTRIBUTE1 in VARCHAR2,
    p_old_ATTRIBUTE2 in VARCHAR2,
    p_new_ATTRIBUTE2 in VARCHAR2,
    p_old_ATTRIBUTE3 in VARCHAR2,
    p_new_ATTRIBUTE3 in VARCHAR2,
    p_old_ATTRIBUTE4 in VARCHAR2,
    p_new_ATTRIBUTE4 in VARCHAR2,
    p_old_ATTRIBUTE5 in VARCHAR2,
    p_new_ATTRIBUTE5 in VARCHAR2,
    p_old_ATTRIBUTE6 in VARCHAR2,
    p_new_ATTRIBUTE6 in VARCHAR2,
    p_old_ATTRIBUTE7 in VARCHAR2,
    p_new_ATTRIBUTE7 in VARCHAR2,
    p_old_ATTRIBUTE8 in VARCHAR2,
    p_new_ATTRIBUTE8 in VARCHAR2,
    p_old_ATTRIBUTE9 in VARCHAR2,
    p_new_ATTRIBUTE9 in VARCHAR2,
    p_old_ATTRIBUTE10 in VARCHAR2,
    p_new_ATTRIBUTE10 in VARCHAR2,
    p_old_ATTRIBUTE11 in VARCHAR2,
    p_new_ATTRIBUTE11 in VARCHAR2,
    p_old_ATTRIBUTE12 in VARCHAR2,
    p_new_ATTRIBUTE12 in VARCHAR2,
    p_old_ATTRIBUTE13 in VARCHAR2,
    p_new_ATTRIBUTE13 in VARCHAR2,
    p_old_ATTRIBUTE14 in VARCHAR2,
    p_new_ATTRIBUTE14 in VARCHAR2,
    p_old_ATTRIBUTE15 in VARCHAR2,
    p_new_ATTRIBUTE15 in VARCHAR2,
    p_old_ATTRIBUTE16 in VARCHAR2,
    p_new_ATTRIBUTE16 in VARCHAR2,
    p_old_ATTRIBUTE17 in VARCHAR2,
    p_new_ATTRIBUTE17 in VARCHAR2,
    p_old_ATTRIBUTE18 in VARCHAR2,
    p_new_ATTRIBUTE18 in VARCHAR2,
    p_old_ATTRIBUTE19 in VARCHAR2,
    p_new_ATTRIBUTE19 in VARCHAR2,
    p_old_ATTRIBUTE20 in VARCHAR2,
    p_new_ATTRIBUTE20 in VARCHAR2,
    p_old_ATTRIBUTE_CATEGORY in VARCHAR2,
    p_new_ATTRIBUTE_CATEGORY in VARCHAR2,
    p_old_PERSON_ID in NUMBER,
    p_new_PERSON_ID in NUMBER,
    p_old_PERSON_TYPE_ID in NUMBER,
    p_new_PERSON_TYPE_ID in NUMBER,
    p_old_PERSON_TYPE_USAGE_ID in NUMBER,
    p_new_PERSON_TYPE_USAGE_ID in NUMBER,
    p_old_PROGRAM_APPLICATION_ID in NUMBER,
    p_new_PROGRAM_APPLICATION_ID in NUMBER,
    p_old_PROGRAM_ID in NUMBER,
    p_new_PROGRAM_ID in NUMBER,
    p_old_PROGRAM_UPDATE_DATE in DATE,
    p_new_PROGRAM_UPDATE_DATE in DATE,
    p_old_REQUEST_ID in NUMBER,
    p_new_REQUEST_ID in NUMBER,
    p_old_EFFECTIVE_END_DATE in DATE,
    p_new_EFFECTIVE_END_DATE in DATE,
    p_old_EFFECTIVE_START_DATE in DATE,
    p_new_EFFECTIVE_START_DATE in DATE
)
is
  --
  cursor asgcur (p_person_id number) is
  select distinct assignment_id
    from per_all_assignments_f
   where person_id = p_person_id;
Line: 1656

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERSON_TYPE_USAGES_F',
                                     'ATTRIBUTE1',
                                     p_old_ATTRIBUTE1,
                                     p_new_ATTRIBUTE1,
                                     p_effective_date
                                  );
Line: 1665

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERSON_TYPE_USAGES_F',
                                     'ATTRIBUTE10',
                                     p_old_ATTRIBUTE10,
                                     p_new_ATTRIBUTE10,
                                     p_effective_date
                                  );
Line: 1674

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERSON_TYPE_USAGES_F',
                                     'ATTRIBUTE11',
                                     p_old_ATTRIBUTE11,
                                     p_new_ATTRIBUTE11,
                                     p_effective_date
                                  );
Line: 1683

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERSON_TYPE_USAGES_F',
                                     'ATTRIBUTE12',
                                     p_old_ATTRIBUTE12,
                                     p_new_ATTRIBUTE12,
                                     p_effective_date
                                  );
Line: 1692

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERSON_TYPE_USAGES_F',
                                     'ATTRIBUTE13',
                                     p_old_ATTRIBUTE13,
                                     p_new_ATTRIBUTE13,
                                     p_effective_date
                                  );
Line: 1701

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERSON_TYPE_USAGES_F',
                                     'ATTRIBUTE14',
                                     p_old_ATTRIBUTE14,
                                     p_new_ATTRIBUTE14,
                                     p_effective_date
                                  );
Line: 1710

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERSON_TYPE_USAGES_F',
                                     'ATTRIBUTE15',
                                     p_old_ATTRIBUTE15,
                                     p_new_ATTRIBUTE15,
                                     p_effective_date
                                  );
Line: 1719

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERSON_TYPE_USAGES_F',
                                     'ATTRIBUTE16',
                                     p_old_ATTRIBUTE16,
                                     p_new_ATTRIBUTE16,
                                     p_effective_date
                                  );
Line: 1728

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERSON_TYPE_USAGES_F',
                                     'ATTRIBUTE17',
                                     p_old_ATTRIBUTE17,
                                     p_new_ATTRIBUTE17,
                                     p_effective_date
                                  );
Line: 1737

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERSON_TYPE_USAGES_F',
                                     'ATTRIBUTE18',
                                     p_old_ATTRIBUTE18,
                                     p_new_ATTRIBUTE18,
                                     p_effective_date
                                  );
Line: 1746

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERSON_TYPE_USAGES_F',
                                     'ATTRIBUTE19',
                                     p_old_ATTRIBUTE19,
                                     p_new_ATTRIBUTE19,
                                     p_effective_date
                                  );
Line: 1755

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERSON_TYPE_USAGES_F',
                                     'ATTRIBUTE2',
                                     p_old_ATTRIBUTE2,
                                     p_new_ATTRIBUTE2,
                                     p_effective_date
                                  );
Line: 1764

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERSON_TYPE_USAGES_F',
                                     'ATTRIBUTE20',
                                     p_old_ATTRIBUTE20,
                                     p_new_ATTRIBUTE20,
                                     p_effective_date
                                  );
Line: 1773

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERSON_TYPE_USAGES_F',
                                     'ATTRIBUTE3',
                                     p_old_ATTRIBUTE3,
                                     p_new_ATTRIBUTE3,
                                     p_effective_date
                                  );
Line: 1782

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERSON_TYPE_USAGES_F',
                                     'ATTRIBUTE4',
                                     p_old_ATTRIBUTE4,
                                     p_new_ATTRIBUTE4,
                                     p_effective_date
                                  );
Line: 1791

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERSON_TYPE_USAGES_F',
                                     'ATTRIBUTE5',
                                     p_old_ATTRIBUTE5,
                                     p_new_ATTRIBUTE5,
                                     p_effective_date
                                  );
Line: 1800

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERSON_TYPE_USAGES_F',
                                     'ATTRIBUTE6',
                                     p_old_ATTRIBUTE6,
                                     p_new_ATTRIBUTE6,
                                     p_effective_date
                                  );
Line: 1809

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERSON_TYPE_USAGES_F',
                                     'ATTRIBUTE7',
                                     p_old_ATTRIBUTE7,
                                     p_new_ATTRIBUTE7,
                                     p_effective_date
                                  );
Line: 1818

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERSON_TYPE_USAGES_F',
                                     'ATTRIBUTE8',
                                     p_old_ATTRIBUTE8,
                                     p_new_ATTRIBUTE8,
                                     p_effective_date
                                  );
Line: 1827

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERSON_TYPE_USAGES_F',
                                     'ATTRIBUTE9',
                                     p_old_ATTRIBUTE9,
                                     p_new_ATTRIBUTE9,
                                     p_effective_date
                                  );
Line: 1836

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERSON_TYPE_USAGES_F',
                                     'ATTRIBUTE_CATEGORY',
                                     p_old_ATTRIBUTE_CATEGORY,
                                     p_new_ATTRIBUTE_CATEGORY,
                                     p_effective_date
                                  );
Line: 1845

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERSON_TYPE_USAGES_F',
                                     'PERSON_ID',
                                     p_old_PERSON_ID,
                                     p_new_PERSON_ID,
                                     p_effective_date
                                  );
Line: 1854

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERSON_TYPE_USAGES_F',
                                     'PERSON_TYPE_ID',
                                     p_old_PERSON_TYPE_ID,
                                     p_new_PERSON_TYPE_ID,
                                     p_effective_date
                                  );
Line: 1863

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERSON_TYPE_USAGES_F',
                                     'PERSON_TYPE_USAGE_ID',
                                     p_old_PERSON_TYPE_USAGE_ID,
                                     p_new_PERSON_TYPE_USAGE_ID,
                                     p_effective_date
                                  );
Line: 1872

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERSON_TYPE_USAGES_F',
                                     'PROGRAM_APPLICATION_ID',
                                     p_old_PROGRAM_APPLICATION_ID,
                                     p_new_PROGRAM_APPLICATION_ID,
                                     p_effective_date
                                  );
Line: 1881

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERSON_TYPE_USAGES_F',
                                     'PROGRAM_ID',
                                     p_old_PROGRAM_ID,
                                     p_new_PROGRAM_ID,
                                     p_effective_date
                                  );
Line: 1890

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERSON_TYPE_USAGES_F',
                                     'PROGRAM_UPDATE_DATE',
                                     p_old_PROGRAM_UPDATE_DATE,
                                     p_new_PROGRAM_UPDATE_DATE,
                                     p_effective_date
                                  );
Line: 1899

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERSON_TYPE_USAGES_F',
                                     'REQUEST_ID',
                                     p_old_REQUEST_ID,
                                     p_new_REQUEST_ID,
                                     p_effective_date
                                  );
Line: 1908

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERSON_TYPE_USAGES_F',
                                     'REQUEST_ID',
                                     p_old_REQUEST_ID,
                                     p_new_REQUEST_ID,
                                     p_effective_date
                                  );
Line: 1919

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERSON_TYPE_USAGES_F',
                                     'EFFECTIVE_END_DATE',
                                     p_old_EFFECTIVE_END_DATE,
                                     p_new_EFFECTIVE_END_DATE,
                                     p_new_effective_end_date,
                                     least(p_old_effective_end_date,
                                           p_new_effective_end_date)
                                  );
Line: 1930

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERSON_TYPE_USAGES_F',
                                     'EFFECTIVE_START_DATE',
                                     p_old_EFFECTIVE_START_DATE,
                                     p_new_EFFECTIVE_START_DATE,
                                     p_new_effective_start_date,
                                     least(p_old_effective_start_date,
                                           p_new_effective_start_date)
                                  );
Line: 1960

             p_event_update_id       => pay_continuous_calc.g_event_list.event_update_id(cnt),
             p_business_group_id     => p_business_group_id,
             p_calculation_date      => pay_continuous_calc.g_event_list.calc_date(cnt),
             p_surrogate_key         => p_new_person_type_usage_id
           );
Line: 1976

   purpose : This is procedure that records any deletes
             on per_person_type_usages_f.
*/
  procedure per_person_type_usages_f_ard(
                       p_business_group_id in number,
                       p_legislation_code in varchar2,
                       p_person_id in number,
                       p_effective_start_date in date,
                       p_person_type_usage_id in number
                       )
  is
  --
  cursor asgcur (p_person_id number) is
  select distinct assignment_id
    from per_all_assignments_f
   where person_id = p_person_id;
Line: 2005

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERSON_TYPE_USAGES_F',
                                     NULL,
                                     NULL,
                                     NULL,
                                     p_effective_start_date,
                                     p_effective_start_date,
                                     'D'
                                    );
Line: 2032

                         p_event_update_id       => pay_continuous_calc.g_event_list.event_update_id(cnt),
                         p_surrogate_key         => p_person_type_usage_id,
                         p_calculation_date      => pay_continuous_calc.g_event_list.calc_date(cnt),
                         p_business_group_id     => p_business_group_id
                         );
Line: 2061

   purpose : This is procedure that records any changes for updates
             on per_performance_reviews CORRECTION only.
*/
procedure PER_ASSIGNMENT_EXTRA_INFO_aru(
    p_business_group_id in number,
    p_legislation_code in varchar2,
    p_effective_date in date ,
    p_old_AEI_ATTRIBUTE1 in VARCHAR2,
    p_new_AEI_ATTRIBUTE1 in VARCHAR2 ,
    p_old_AEI_ATTRIBUTE10 in VARCHAR2,
    p_new_AEI_ATTRIBUTE10 in VARCHAR2 ,
    p_old_AEI_ATTRIBUTE11 in VARCHAR2,
    p_new_AEI_ATTRIBUTE11 in VARCHAR2 ,
    p_old_AEI_ATTRIBUTE12 in VARCHAR2,
    p_new_AEI_ATTRIBUTE12 in VARCHAR2 ,
    p_old_AEI_ATTRIBUTE13 in VARCHAR2,
    p_new_AEI_ATTRIBUTE13 in VARCHAR2 ,
    p_old_AEI_ATTRIBUTE14 in VARCHAR2,
    p_new_AEI_ATTRIBUTE14 in VARCHAR2 ,
    p_old_AEI_ATTRIBUTE15 in VARCHAR2,
    p_new_AEI_ATTRIBUTE15 in VARCHAR2 ,
    p_old_AEI_ATTRIBUTE16 in VARCHAR2,
    p_new_AEI_ATTRIBUTE16 in VARCHAR2 ,
    p_old_AEI_ATTRIBUTE17 in VARCHAR2,
    p_new_AEI_ATTRIBUTE17 in VARCHAR2 ,
    p_old_AEI_ATTRIBUTE18 in VARCHAR2,
    p_new_AEI_ATTRIBUTE18 in VARCHAR2 ,
    p_old_AEI_ATTRIBUTE19 in VARCHAR2,
    p_new_AEI_ATTRIBUTE19 in VARCHAR2 ,
    p_old_AEI_ATTRIBUTE2 in VARCHAR2,
    p_new_AEI_ATTRIBUTE2 in VARCHAR2 ,
    p_old_AEI_ATTRIBUTE20 in VARCHAR2,
    p_new_AEI_ATTRIBUTE20 in VARCHAR2 ,
    p_old_AEI_ATTRIBUTE3 in VARCHAR2,
    p_new_AEI_ATTRIBUTE3 in VARCHAR2 ,
    p_old_AEI_ATTRIBUTE4 in VARCHAR2,
    p_new_AEI_ATTRIBUTE4 in VARCHAR2 ,
    p_old_AEI_ATTRIBUTE5 in VARCHAR2,
    p_new_AEI_ATTRIBUTE5 in VARCHAR2 ,
    p_old_AEI_ATTRIBUTE6 in VARCHAR2,
    p_new_AEI_ATTRIBUTE6 in VARCHAR2 ,
    p_old_AEI_ATTRIBUTE7 in VARCHAR2,
    p_new_AEI_ATTRIBUTE7 in VARCHAR2 ,
    p_old_AEI_ATTRIBUTE8 in VARCHAR2,
    p_new_AEI_ATTRIBUTE8 in VARCHAR2 ,
    p_old_AEI_ATTRIBUTE9 in VARCHAR2,
    p_new_AEI_ATTRIBUTE9 in VARCHAR2 ,
    p_old_AEI_ATTRIBUTE_CATEGORY in VARCHAR2,
    p_new_AEI_ATTRIBUTE_CATEGORY in VARCHAR2 ,
    p_old_AEI_INFORMATION1 in VARCHAR2,
    p_new_AEI_INFORMATION1 in VARCHAR2 ,
    p_old_AEI_INFORMATION10 in VARCHAR2,
    p_new_AEI_INFORMATION10 in VARCHAR2 ,
    p_old_AEI_INFORMATION11 in VARCHAR2,
    p_new_AEI_INFORMATION11 in VARCHAR2 ,
    p_old_AEI_INFORMATION12 in VARCHAR2,
    p_new_AEI_INFORMATION12 in VARCHAR2 ,
    p_old_AEI_INFORMATION13 in VARCHAR2,
    p_new_AEI_INFORMATION13 in VARCHAR2 ,
    p_old_AEI_INFORMATION14 in VARCHAR2,
    p_new_AEI_INFORMATION14 in VARCHAR2 ,
    p_old_AEI_INFORMATION15 in VARCHAR2,
    p_new_AEI_INFORMATION15 in VARCHAR2 ,
    p_old_AEI_INFORMATION16 in VARCHAR2,
    p_new_AEI_INFORMATION16 in VARCHAR2 ,
    p_old_AEI_INFORMATION17 in VARCHAR2,
    p_new_AEI_INFORMATION17 in VARCHAR2 ,
    p_old_AEI_INFORMATION18 in VARCHAR2,
    p_new_AEI_INFORMATION18 in VARCHAR2 ,
    p_old_AEI_INFORMATION19 in VARCHAR2,
    p_new_AEI_INFORMATION19 in VARCHAR2 ,
    p_old_AEI_INFORMATION2 in VARCHAR2,
    p_new_AEI_INFORMATION2 in VARCHAR2 ,
    p_old_AEI_INFORMATION20 in VARCHAR2,
    p_new_AEI_INFORMATION20 in VARCHAR2 ,
    p_old_AEI_INFORMATION21 in VARCHAR2,
    p_new_AEI_INFORMATION21 in VARCHAR2 ,
    p_old_AEI_INFORMATION22 in VARCHAR2,
    p_new_AEI_INFORMATION22 in VARCHAR2 ,
    p_old_AEI_INFORMATION23 in VARCHAR2,
    p_new_AEI_INFORMATION23 in VARCHAR2 ,
    p_old_AEI_INFORMATION24 in VARCHAR2,
    p_new_AEI_INFORMATION24 in VARCHAR2 ,
    p_old_AEI_INFORMATION25 in VARCHAR2,
    p_new_AEI_INFORMATION25 in VARCHAR2 ,
    p_old_AEI_INFORMATION26 in VARCHAR2,
    p_new_AEI_INFORMATION26 in VARCHAR2 ,
    p_old_AEI_INFORMATION27 in VARCHAR2,
    p_new_AEI_INFORMATION27 in VARCHAR2 ,
    p_old_AEI_INFORMATION28 in VARCHAR2,
    p_new_AEI_INFORMATION28 in VARCHAR2 ,
    p_old_AEI_INFORMATION29 in VARCHAR2,
    p_new_AEI_INFORMATION29 in VARCHAR2 ,
    p_old_AEI_INFORMATION3 in VARCHAR2,
    p_new_AEI_INFORMATION3 in VARCHAR2 ,
    p_old_AEI_INFORMATION30 in VARCHAR2,
    p_new_AEI_INFORMATION30 in VARCHAR2 ,
    p_old_AEI_INFORMATION4 in VARCHAR2,
    p_new_AEI_INFORMATION4 in VARCHAR2 ,
    p_old_AEI_INFORMATION5 in VARCHAR2,
    p_new_AEI_INFORMATION5 in VARCHAR2 ,
    p_old_AEI_INFORMATION6 in VARCHAR2,
    p_new_AEI_INFORMATION6 in VARCHAR2 ,
    p_old_AEI_INFORMATION7 in VARCHAR2,
    p_new_AEI_INFORMATION7 in VARCHAR2 ,
    p_old_AEI_INFORMATION8 in VARCHAR2,
    p_new_AEI_INFORMATION8 in VARCHAR2 ,
    p_old_AEI_INFORMATION9 in VARCHAR2,
    p_new_AEI_INFORMATION9 in VARCHAR2 ,
    p_old_AEI_INFORMATION_CATEGORY in VARCHAR2,
    p_new_AEI_INFORMATION_CATEGORY in VARCHAR2 ,
    p_old_ASSIGNMENT_EXTRA_INFO_ID in NUMBER,
    p_new_ASSIGNMENT_EXTRA_INFO_ID in NUMBER ,
    p_old_ASSIGNMENT_ID in NUMBER,
    p_new_ASSIGNMENT_ID in NUMBER ,
    p_old_INFORMATION_TYPE in VARCHAR2,
    p_new_INFORMATION_TYPE in VARCHAR2
)
is
--
begin
  /* If the continuous calc is overriden then do nothing */
  if (pay_continuous_calc.g_override_cc = TRUE) then
    return;
Line: 2189

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_ATTRIBUTE1',
                                     p_old_AEI_ATTRIBUTE1,
                                     p_new_AEI_ATTRIBUTE1,
                                     p_effective_date
                                  );
Line: 2198

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_ATTRIBUTE10',
                                     p_old_AEI_ATTRIBUTE10,
                                     p_new_AEI_ATTRIBUTE10,
                                     p_effective_date
                                  );
Line: 2207

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_ATTRIBUTE11',
                                     p_old_AEI_ATTRIBUTE11,
                                     p_new_AEI_ATTRIBUTE11,
                                     p_effective_date
                                  );
Line: 2216

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_ATTRIBUTE12',
                                     p_old_AEI_ATTRIBUTE12,
                                     p_new_AEI_ATTRIBUTE12,
                                     p_effective_date
                                  );
Line: 2225

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_ATTRIBUTE13',
                                     p_old_AEI_ATTRIBUTE13,
                                     p_new_AEI_ATTRIBUTE13,
                                     p_effective_date
                                  );
Line: 2234

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_ATTRIBUTE14',
                                     p_old_AEI_ATTRIBUTE14,
                                     p_new_AEI_ATTRIBUTE14,
                                     p_effective_date
                                  );
Line: 2243

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_ATTRIBUTE15',
                                     p_old_AEI_ATTRIBUTE15,
                                     p_new_AEI_ATTRIBUTE15,
                                     p_effective_date
                                  );
Line: 2252

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_ATTRIBUTE16',
                                     p_old_AEI_ATTRIBUTE16,
                                     p_new_AEI_ATTRIBUTE16,
                                     p_effective_date
                                  );
Line: 2261

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_ATTRIBUTE17',
                                     p_old_AEI_ATTRIBUTE17,
                                     p_new_AEI_ATTRIBUTE17,
                                     p_effective_date
                                  );
Line: 2270

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_ATTRIBUTE18',
                                     p_old_AEI_ATTRIBUTE18,
                                     p_new_AEI_ATTRIBUTE18,
                                     p_effective_date
                                  );
Line: 2279

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_ATTRIBUTE19',
                                     p_old_AEI_ATTRIBUTE19,
                                     p_new_AEI_ATTRIBUTE19,
                                     p_effective_date
                                  );
Line: 2288

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_ATTRIBUTE2',
                                     p_old_AEI_ATTRIBUTE2,
                                     p_new_AEI_ATTRIBUTE2,
                                     p_effective_date
                                  );
Line: 2297

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_ATTRIBUTE20',
                                     p_old_AEI_ATTRIBUTE20,
                                     p_new_AEI_ATTRIBUTE20,
                                     p_effective_date
                                  );
Line: 2306

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_ATTRIBUTE3',
                                     p_old_AEI_ATTRIBUTE3,
                                     p_new_AEI_ATTRIBUTE3,
                                     p_effective_date
                                  );
Line: 2315

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_ATTRIBUTE4',
                                     p_old_AEI_ATTRIBUTE4,
                                     p_new_AEI_ATTRIBUTE4,
                                     p_effective_date
                                  );
Line: 2324

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_ATTRIBUTE5',
                                     p_old_AEI_ATTRIBUTE5,
                                     p_new_AEI_ATTRIBUTE5,
                                     p_effective_date
                                  );
Line: 2333

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_ATTRIBUTE6',
                                     p_old_AEI_ATTRIBUTE6,
                                     p_new_AEI_ATTRIBUTE6,
                                     p_effective_date
                                  );
Line: 2342

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_ATTRIBUTE7',
                                     p_old_AEI_ATTRIBUTE7,
                                     p_new_AEI_ATTRIBUTE7,
                                     p_effective_date
                                  );
Line: 2351

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_ATTRIBUTE8',
                                     p_old_AEI_ATTRIBUTE8,
                                     p_new_AEI_ATTRIBUTE8,
                                     p_effective_date
                                  );
Line: 2360

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_ATTRIBUTE9',
                                     p_old_AEI_ATTRIBUTE9,
                                     p_new_AEI_ATTRIBUTE9,
                                     p_effective_date
                                  );
Line: 2369

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_ATTRIBUTE_CATEGORY',
                                     p_old_AEI_ATTRIBUTE_CATEGORY,
                                     p_new_AEI_ATTRIBUTE_CATEGORY,
                                     p_effective_date
                                  );
Line: 2378

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_INFORMATION1',
                                     p_old_AEI_INFORMATION1,
                                     p_new_AEI_INFORMATION1,
                                     p_effective_date
                                  );
Line: 2387

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_INFORMATION10',
                                     p_old_AEI_INFORMATION10,
                                     p_new_AEI_INFORMATION10,
                                     p_effective_date
                                  );
Line: 2396

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_INFORMATION11',
                                     p_old_AEI_INFORMATION11,
                                     p_new_AEI_INFORMATION11,
                                     p_effective_date
                                  );
Line: 2405

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_INFORMATION12',
                                     p_old_AEI_INFORMATION12,
                                     p_new_AEI_INFORMATION12,
                                     p_effective_date
                                  );
Line: 2414

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_INFORMATION13',
                                     p_old_AEI_INFORMATION13,
                                     p_new_AEI_INFORMATION13,
                                     p_effective_date
                                  );
Line: 2423

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_INFORMATION14',
                                     p_old_AEI_INFORMATION14,
                                     p_new_AEI_INFORMATION14,
                                     p_effective_date
                                  );
Line: 2432

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_INFORMATION15',
                                     p_old_AEI_INFORMATION15,
                                     p_new_AEI_INFORMATION15,
                                     p_effective_date
                                  );
Line: 2441

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_INFORMATION16',
                                     p_old_AEI_INFORMATION16,
                                     p_new_AEI_INFORMATION16,
                                     p_effective_date
                                  );
Line: 2450

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_INFORMATION17',
                                     p_old_AEI_INFORMATION17,
                                     p_new_AEI_INFORMATION17,
                                     p_effective_date
                                  );
Line: 2459

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_INFORMATION18',
                                     p_old_AEI_INFORMATION18,
                                     p_new_AEI_INFORMATION18,
                                     p_effective_date
                                  );
Line: 2468

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_INFORMATION19',
                                     p_old_AEI_INFORMATION19,
                                     p_new_AEI_INFORMATION19,
                                     p_effective_date
                                  );
Line: 2477

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_INFORMATION2',
                                     p_old_AEI_INFORMATION2,
                                     p_new_AEI_INFORMATION2,
                                     p_effective_date
                                  );
Line: 2486

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_INFORMATION20',
                                     p_old_AEI_INFORMATION20,
                                     p_new_AEI_INFORMATION20,
                                     p_effective_date
                                  );
Line: 2495

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_INFORMATION21',
                                     p_old_AEI_INFORMATION21,
                                     p_new_AEI_INFORMATION21,
                                     p_effective_date
                                  );
Line: 2504

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_INFORMATION22',
                                     p_old_AEI_INFORMATION22,
                                     p_new_AEI_INFORMATION22,
                                     p_effective_date
                                  );
Line: 2513

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_INFORMATION23',
                                     p_old_AEI_INFORMATION23,
                                     p_new_AEI_INFORMATION23,
                                     p_effective_date
                                  );
Line: 2522

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_INFORMATION24',
                                     p_old_AEI_INFORMATION24,
                                     p_new_AEI_INFORMATION24,
                                     p_effective_date
                                  );
Line: 2531

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_INFORMATION25',
                                     p_old_AEI_INFORMATION25,
                                     p_new_AEI_INFORMATION25,
                                     p_effective_date
                                  );
Line: 2540

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_INFORMATION26',
                                     p_old_AEI_INFORMATION26,
                                     p_new_AEI_INFORMATION26,
                                     p_effective_date
                                  );
Line: 2549

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_INFORMATION27',
                                     p_old_AEI_INFORMATION27,
                                     p_new_AEI_INFORMATION27,
                                     p_effective_date
                                  );
Line: 2558

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_INFORMATION28',
                                     p_old_AEI_INFORMATION28,
                                     p_new_AEI_INFORMATION28,
                                     p_effective_date
                                  );
Line: 2567

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_INFORMATION29',
                                     p_old_AEI_INFORMATION29,
                                     p_new_AEI_INFORMATION29,
                                     p_effective_date
                                  );
Line: 2576

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_INFORMATION3',
                                     p_old_AEI_INFORMATION3,
                                     p_new_AEI_INFORMATION3,
                                     p_effective_date
                                  );
Line: 2585

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_INFORMATION30',
                                     p_old_AEI_INFORMATION30,
                                     p_new_AEI_INFORMATION30,
                                     p_effective_date
                                  );
Line: 2594

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_INFORMATION4',
                                     p_old_AEI_INFORMATION4,
                                     p_new_AEI_INFORMATION4,
                                     p_effective_date
                                  );
Line: 2603

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_INFORMATION5',
                                     p_old_AEI_INFORMATION5,
                                     p_new_AEI_INFORMATION5,
                                     p_effective_date
                                  );
Line: 2612

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_INFORMATION6',
                                     p_old_AEI_INFORMATION6,
                                     p_new_AEI_INFORMATION6,
                                     p_effective_date
                                  );
Line: 2621

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_INFORMATION7',
                                     p_old_AEI_INFORMATION7,
                                     p_new_AEI_INFORMATION7,
                                     p_effective_date
                                  );
Line: 2630

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_INFORMATION8',
                                     p_old_AEI_INFORMATION8,
                                     p_new_AEI_INFORMATION8,
                                     p_effective_date
                                  );
Line: 2639

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_INFORMATION9',
                                     p_old_AEI_INFORMATION9,
                                     p_new_AEI_INFORMATION9,
                                     p_effective_date
                                  );
Line: 2648

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'AEI_INFORMATION_CATEGORY',
                                     p_old_AEI_INFORMATION_CATEGORY,
                                     p_new_AEI_INFORMATION_CATEGORY,
                                     p_effective_date
                                  );
Line: 2657

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'ASSIGNMENT_EXTRA_INFO_ID',
                                     p_old_ASSIGNMENT_EXTRA_INFO_ID,
                                     p_new_ASSIGNMENT_EXTRA_INFO_ID,
                                     p_effective_date
                                  );
Line: 2666

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'ASSIGNMENT_ID',
                                     p_old_ASSIGNMENT_ID,
                                     p_new_ASSIGNMENT_ID,
                                     p_effective_date
                                  );
Line: 2675

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     'INFORMATION_TYPE',
                                     p_old_INFORMATION_TYPE,
                                     p_new_INFORMATION_TYPE,
                                     p_effective_date
                                  );
Line: 2700

             p_event_update_id       => pay_continuous_calc.g_event_list.event_update_id(cnt),
             p_business_group_id     => p_business_group_id,
             p_calculation_date      => pay_continuous_calc.g_event_list.calc_date(cnt),
             p_surrogate_key         => p_new_assignment_extra_info_id
           );
Line: 2714

   purpose : This is procedure that records any insert
             on assignment extra information.
*/
PROCEDURE PER_ASSIGNMENT_EXTRA_INFO_ari(  p_business_group_id       in number,
                                         p_legislation_code         in varchar2,
                                         p_assignment_id            in number,
                                         p_assignment_extra_info_id in number,
                                         p_effective_start_date     in date
                                        )
IS
  --
  l_process_event_id      number;
Line: 2737

  pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     NULL,
                                     NULL,
                                     NULL,
                                     p_effective_start_date,
                                     p_effective_start_date,
                                     'I'
                                    );
Line: 2765

             p_event_update_id       => pay_continuous_calc.g_event_list.event_update_id(cnt),
             p_business_group_id     => p_business_group_id,
             p_calculation_date      => pay_continuous_calc.g_event_list.calc_date(cnt),
             p_surrogate_key         => p_assignment_extra_info_id);
Line: 2783

   purpose : This is procedure that records any deletes
             on PER_ASSIGNMENT_EXTRA_INFO.
*/
  procedure PER_ASSIGNMENT_EXTRA_INFO_ard(
                       p_business_group_id in number,
                       p_legislation_code in varchar2,
                       p_assignment_id in number,
                       p_effective_start_date in date,
                       p_assignment_extra_info_id in number
                       )
  is
  --
  cursor asgcur (p_person_id number) is
  select distinct assignment_id
    from per_all_assignments_f
   where person_id = p_person_id;
Line: 2812

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ASSIGNMENT_EXTRA_INFO',
                                     NULL,
                                     NULL,
                                     NULL,
                                     p_effective_start_date,
                                     p_effective_start_date,
                                     'D'
                                    );
Line: 2838

                         p_event_update_id       => pay_continuous_calc.g_event_list.event_update_id(cnt),
                         p_surrogate_key         => p_assignment_extra_info_id,
                         p_calculation_date      => pay_continuous_calc.g_event_list.calc_date(cnt),
                         p_business_group_id     => p_business_group_id
                         );
Line: 2857

   purpose : This is the procedure that records any updates
             on per_periods_of_placement.
*/
procedure PER_PERIODS_OF_PLACEMENT_aru(
    p_business_group_id in number,
    p_legislation_code in varchar2,
    p_effective_date in date,
    p_old_ACTUAL_TERMINATION_DATE in DATE,
    p_new_ACTUAL_TERMINATION_DATE in DATE,
    p_old_ATTRIBUTE1 in VARCHAR2,
    p_new_ATTRIBUTE1 in VARCHAR2,
    p_old_ATTRIBUTE10 in VARCHAR2,
    p_new_ATTRIBUTE10 in VARCHAR2,
    p_old_ATTRIBUTE11 in VARCHAR2,
    p_new_ATTRIBUTE11 in VARCHAR2,
    p_old_ATTRIBUTE12 in VARCHAR2,
    p_new_ATTRIBUTE12 in VARCHAR2,
    p_old_ATTRIBUTE13 in VARCHAR2,
    p_new_ATTRIBUTE13 in VARCHAR2,
    p_old_ATTRIBUTE14 in VARCHAR2,
    p_new_ATTRIBUTE14 in VARCHAR2,
    p_old_ATTRIBUTE15 in VARCHAR2,
    p_new_ATTRIBUTE15 in VARCHAR2,
    p_old_ATTRIBUTE16 in VARCHAR2,
    p_new_ATTRIBUTE16 in VARCHAR2,
    p_old_ATTRIBUTE17 in VARCHAR2,
    p_new_ATTRIBUTE17 in VARCHAR2,
    p_old_ATTRIBUTE18 in VARCHAR2,
    p_new_ATTRIBUTE18 in VARCHAR2,
    p_old_ATTRIBUTE19 in VARCHAR2,
    p_new_ATTRIBUTE19 in VARCHAR2,
    p_old_ATTRIBUTE2 in VARCHAR2,
    p_new_ATTRIBUTE2 in VARCHAR2,
    p_old_ATTRIBUTE20 in VARCHAR2,
    p_new_ATTRIBUTE20 in VARCHAR2,
    p_old_ATTRIBUTE21 in VARCHAR2,
    p_new_ATTRIBUTE21 in VARCHAR2,
    p_old_ATTRIBUTE22 in VARCHAR2,
    p_new_ATTRIBUTE22 in VARCHAR2,
    p_old_ATTRIBUTE23 in VARCHAR2,
    p_new_ATTRIBUTE23 in VARCHAR2,
    p_old_ATTRIBUTE24 in VARCHAR2,
    p_new_ATTRIBUTE24 in VARCHAR2,
    p_old_ATTRIBUTE25 in VARCHAR2,
    p_new_ATTRIBUTE25 in VARCHAR2,
    p_old_ATTRIBUTE26 in VARCHAR2,
    p_new_ATTRIBUTE26 in VARCHAR2,
    p_old_ATTRIBUTE27 in VARCHAR2,
    p_new_ATTRIBUTE27 in VARCHAR2,
    p_old_ATTRIBUTE28 in VARCHAR2,
    p_new_ATTRIBUTE28 in VARCHAR2,
    p_old_ATTRIBUTE29 in VARCHAR2,
    p_new_ATTRIBUTE29 in VARCHAR2,
    p_old_ATTRIBUTE3 in VARCHAR2,
    p_new_ATTRIBUTE3 in VARCHAR2,
    p_old_ATTRIBUTE30 in VARCHAR2,
    p_new_ATTRIBUTE30 in VARCHAR2,
    p_old_ATTRIBUTE4 in VARCHAR2,
    p_new_ATTRIBUTE4 in VARCHAR2,
    p_old_ATTRIBUTE5 in VARCHAR2,
    p_new_ATTRIBUTE5 in VARCHAR2,
    p_old_ATTRIBUTE6 in VARCHAR2,
    p_new_ATTRIBUTE6 in VARCHAR2,
    p_old_ATTRIBUTE7 in VARCHAR2,
    p_new_ATTRIBUTE7 in VARCHAR2,
    p_old_ATTRIBUTE8 in VARCHAR2,
    p_new_ATTRIBUTE8 in VARCHAR2,
    p_old_ATTRIBUTE9 in VARCHAR2,
    p_new_ATTRIBUTE9 in VARCHAR2,
    p_old_ATTRIBUTE_CATEGORY in VARCHAR2,
    p_new_ATTRIBUTE_CATEGORY in VARCHAR2,
    p_old_BUSINESS_GROUP_ID in NUMBER,
    p_new_BUSINESS_GROUP_ID in NUMBER,
    p_old_FINAL_PROCESS_DATE in DATE,
    p_new_FINAL_PROCESS_DATE in DATE,
    p_old_INFORMATION1 in VARCHAR2,
    p_new_INFORMATION1 in VARCHAR2,
    p_old_INFORMATION10 in VARCHAR2,
    p_new_INFORMATION10 in VARCHAR2,
    p_old_INFORMATION11 in VARCHAR2,
    p_new_INFORMATION11 in VARCHAR2,
    p_old_INFORMATION12 in VARCHAR2,
    p_new_INFORMATION12 in VARCHAR2,
    p_old_INFORMATION13 in VARCHAR2,
    p_new_INFORMATION13 in VARCHAR2,
    p_old_INFORMATION14 in VARCHAR2,
    p_new_INFORMATION14 in VARCHAR2,
    p_old_INFORMATION15 in VARCHAR2,
    p_new_INFORMATION15 in VARCHAR2,
    p_old_INFORMATION16 in VARCHAR2,
    p_new_INFORMATION16 in VARCHAR2,
    p_old_INFORMATION17 in VARCHAR2,
    p_new_INFORMATION17 in VARCHAR2,
    p_old_INFORMATION18 in VARCHAR2,
    p_new_INFORMATION18 in VARCHAR2,
    p_old_INFORMATION19 in VARCHAR2,
    p_new_INFORMATION19 in VARCHAR2,
    p_old_INFORMATION2 in VARCHAR2,
    p_new_INFORMATION2 in VARCHAR2,
    p_old_INFORMATION20 in VARCHAR2,
    p_new_INFORMATION20 in VARCHAR2,
    p_old_INFORMATION21 in VARCHAR2,
    p_new_INFORMATION21 in VARCHAR2,
    p_old_INFORMATION22 in VARCHAR2,
    p_new_INFORMATION22 in VARCHAR2,
    p_old_INFORMATION23 in VARCHAR2,
    p_new_INFORMATION23 in VARCHAR2,
    p_old_INFORMATION24 in VARCHAR2,
    p_new_INFORMATION24 in VARCHAR2,
    p_old_INFORMATION25 in VARCHAR2,
    p_new_INFORMATION25 in VARCHAR2,
    p_old_INFORMATION26 in VARCHAR2,
    p_new_INFORMATION26 in VARCHAR2,
    p_old_INFORMATION27 in VARCHAR2,
    p_new_INFORMATION27 in VARCHAR2,
    p_old_INFORMATION28 in VARCHAR2,
    p_new_INFORMATION28 in VARCHAR2,
    p_old_INFORMATION29 in VARCHAR2,
    p_new_INFORMATION29 in VARCHAR2,
    p_old_INFORMATION3 in VARCHAR2,
    p_new_INFORMATION3 in VARCHAR2,
    p_old_INFORMATION30 in VARCHAR2,
    p_new_INFORMATION30 in VARCHAR2,
    p_old_INFORMATION4 in VARCHAR2,
    p_new_INFORMATION4 in VARCHAR2,
    p_old_INFORMATION5 in VARCHAR2,
    p_new_INFORMATION5 in VARCHAR2,
    p_old_INFORMATION6 in VARCHAR2,
    p_new_INFORMATION6 in VARCHAR2,
    p_old_INFORMATION7 in VARCHAR2,
    p_new_INFORMATION7 in VARCHAR2,
    p_old_INFORMATION8 in VARCHAR2,
    p_new_INFORMATION8 in VARCHAR2,
    p_old_INFORMATION9 in VARCHAR2,
    p_new_INFORMATION9 in VARCHAR2,
    p_old_INFORMATION_CATEGORY in VARCHAR2,
    p_new_INFORMATION_CATEGORY in VARCHAR2,
    p_old_LAST_STANDARD_PROCESS_DA in DATE,
    p_new_LAST_STANDARD_PROCESS_DA in DATE,
    p_old_PERIOD_OF_PLACEMENT_ID in NUMBER,
    p_new_PERIOD_OF_PLACEMENT_ID in NUMBER,
    p_old_PERSON_ID in NUMBER,
    p_new_PERSON_ID in NUMBER,
    p_old_PROJECTED_TERMINATION_DA in DATE,
    p_new_PROJECTED_TERMINATION_DA in DATE,
    p_old_TERMINATION_REASON in VARCHAR2,
    p_new_TERMINATION_REASON in VARCHAR2,
    p_old_DATE_START in DATE,
    p_new_DATE_START in DATE
)
is
--
  cursor asgcur (p_person_id number) is
  select distinct assignment_id
    from per_all_assignments_f
   where person_id = p_person_id;
Line: 3027

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'ACTUAL_TERMINATION_DATE',
                                     p_old_ACTUAL_TERMINATION_DATE,
                                     p_new_ACTUAL_TERMINATION_DATE,
                                     p_effective_date
                                  );
Line: 3036

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'ATTRIBUTE1',
                                     p_old_ATTRIBUTE1,
                                     p_new_ATTRIBUTE1,
                                     p_effective_date
                                  );
Line: 3045

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'ATTRIBUTE10',
                                     p_old_ATTRIBUTE10,
                                     p_new_ATTRIBUTE10,
                                     p_effective_date
                                  );
Line: 3054

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'ATTRIBUTE11',
                                     p_old_ATTRIBUTE11,
                                     p_new_ATTRIBUTE11,
                                     p_effective_date
                                  );
Line: 3063

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'ATTRIBUTE12',
                                     p_old_ATTRIBUTE12,
                                     p_new_ATTRIBUTE12,
                                     p_effective_date
                                  );
Line: 3072

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'ATTRIBUTE13',
                                     p_old_ATTRIBUTE13,
                                     p_new_ATTRIBUTE13,
                                     p_effective_date
                                  );
Line: 3081

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'ATTRIBUTE14',
                                     p_old_ATTRIBUTE14,
                                     p_new_ATTRIBUTE14,
                                     p_effective_date
                                  );
Line: 3090

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'ATTRIBUTE15',
                                     p_old_ATTRIBUTE15,
                                     p_new_ATTRIBUTE15,
                                     p_effective_date
                                  );
Line: 3099

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'ATTRIBUTE16',
                                     p_old_ATTRIBUTE16,
                                     p_new_ATTRIBUTE16,
                                     p_effective_date
                                  );
Line: 3108

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'ATTRIBUTE17',
                                     p_old_ATTRIBUTE17,
                                     p_new_ATTRIBUTE17,
                                     p_effective_date
                                  );
Line: 3117

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'ATTRIBUTE18',
                                     p_old_ATTRIBUTE18,
                                     p_new_ATTRIBUTE18,
                                     p_effective_date
                                  );
Line: 3126

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'ATTRIBUTE19',
                                     p_old_ATTRIBUTE19,
                                     p_new_ATTRIBUTE19,
                                     p_effective_date
                                  );
Line: 3135

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'ATTRIBUTE2',
                                     p_old_ATTRIBUTE2,
                                     p_new_ATTRIBUTE2,
                                     p_effective_date
                                  );
Line: 3144

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'ATTRIBUTE20',
                                     p_old_ATTRIBUTE20,
                                     p_new_ATTRIBUTE20,
                                     p_effective_date
                                  );
Line: 3153

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'ATTRIBUTE21',
                                     p_old_ATTRIBUTE21,
                                     p_new_ATTRIBUTE21,
                                     p_effective_date
                                  );
Line: 3162

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'ATTRIBUTE22',
                                     p_old_ATTRIBUTE22,
                                     p_new_ATTRIBUTE22,
                                     p_effective_date
                                  );
Line: 3171

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'ATTRIBUTE23',
                                     p_old_ATTRIBUTE23,
                                     p_new_ATTRIBUTE23,
                                     p_effective_date
                                  );
Line: 3180

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'ATTRIBUTE24',
                                     p_old_ATTRIBUTE24,
                                     p_new_ATTRIBUTE24,
                                     p_effective_date
                                  );
Line: 3189

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'ATTRIBUTE25',
                                     p_old_ATTRIBUTE25,
                                     p_new_ATTRIBUTE25,
                                     p_effective_date
                                  );
Line: 3198

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'ATTRIBUTE26',
                                     p_old_ATTRIBUTE26,
                                     p_new_ATTRIBUTE26,
                                     p_effective_date
                                  );
Line: 3207

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'ATTRIBUTE27',
                                     p_old_ATTRIBUTE27,
                                     p_new_ATTRIBUTE27,
                                     p_effective_date
                                  );
Line: 3216

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'ATTRIBUTE28',
                                     p_old_ATTRIBUTE28,
                                     p_new_ATTRIBUTE28,
                                     p_effective_date
                                  );
Line: 3225

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'ATTRIBUTE29',
                                     p_old_ATTRIBUTE29,
                                     p_new_ATTRIBUTE29,
                                     p_effective_date
                                  );
Line: 3234

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'ATTRIBUTE3',
                                     p_old_ATTRIBUTE3,
                                     p_new_ATTRIBUTE3,
                                     p_effective_date
                                  );
Line: 3243

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'ATTRIBUTE30',
                                     p_old_ATTRIBUTE30,
                                     p_new_ATTRIBUTE30,
                                     p_effective_date
                                  );
Line: 3252

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'ATTRIBUTE4',
                                     p_old_ATTRIBUTE4,
                                     p_new_ATTRIBUTE4,
                                     p_effective_date
                                  );
Line: 3261

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'ATTRIBUTE5',
                                     p_old_ATTRIBUTE5,
                                     p_new_ATTRIBUTE5,
                                     p_effective_date
                                  );
Line: 3270

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'ATTRIBUTE6',
                                     p_old_ATTRIBUTE6,
                                     p_new_ATTRIBUTE6,
                                     p_effective_date
                                  );
Line: 3279

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'ATTRIBUTE7',
                                     p_old_ATTRIBUTE7,
                                     p_new_ATTRIBUTE7,
                                     p_effective_date
                                  );
Line: 3288

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'ATTRIBUTE8',
                                     p_old_ATTRIBUTE8,
                                     p_new_ATTRIBUTE8,
                                     p_effective_date
                                  );
Line: 3297

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'ATTRIBUTE9',
                                     p_old_ATTRIBUTE9,
                                     p_new_ATTRIBUTE9,
                                     p_effective_date
                                  );
Line: 3306

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'ATTRIBUTE_CATEGORY',
                                     p_old_ATTRIBUTE_CATEGORY,
                                     p_new_ATTRIBUTE_CATEGORY,
                                     p_effective_date
                                  );
Line: 3315

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'BUSINESS_GROUP_ID',
                                     p_old_BUSINESS_GROUP_ID,
                                     p_new_BUSINESS_GROUP_ID,
                                     p_effective_date
                                  );
Line: 3324

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'FINAL_PROCESS_DATE',
                                     p_old_FINAL_PROCESS_DATE,
                                     p_new_FINAL_PROCESS_DATE,
                                     p_effective_date
                                  );
Line: 3333

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'INFORMATION1',
                                     p_old_INFORMATION1,
                                     p_new_INFORMATION1,
                                     p_effective_date
                                  );
Line: 3342

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'INFORMATION10',
                                     p_old_INFORMATION10,
                                     p_new_INFORMATION10,
                                     p_effective_date
                                  );
Line: 3351

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'INFORMATION11',
                                     p_old_INFORMATION11,
                                     p_new_INFORMATION11,
                                     p_effective_date
                                  );
Line: 3360

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'INFORMATION12',
                                     p_old_INFORMATION12,
                                     p_new_INFORMATION12,
                                     p_effective_date
                                  );
Line: 3369

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'INFORMATION13',
                                     p_old_INFORMATION13,
                                     p_new_INFORMATION13,
                                     p_effective_date
                                  );
Line: 3378

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'INFORMATION14',
                                     p_old_INFORMATION14,
                                     p_new_INFORMATION14,
                                     p_effective_date
                                  );
Line: 3387

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'INFORMATION15',
                                     p_old_INFORMATION15,
                                     p_new_INFORMATION15,
                                     p_effective_date
                                  );
Line: 3396

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'INFORMATION16',
                                     p_old_INFORMATION16,
                                     p_new_INFORMATION16,
                                     p_effective_date
                                  );
Line: 3405

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'INFORMATION17',
                                     p_old_INFORMATION17,
                                     p_new_INFORMATION17,
                                     p_effective_date
                                  );
Line: 3414

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'INFORMATION18',
                                     p_old_INFORMATION18,
                                     p_new_INFORMATION18,
                                     p_effective_date
                                  );
Line: 3423

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'INFORMATION19',
                                     p_old_INFORMATION19,
                                     p_new_INFORMATION19,
                                     p_effective_date
                                  );
Line: 3432

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'INFORMATION2',
                                     p_old_INFORMATION2,
                                     p_new_INFORMATION2,
                                     p_effective_date
                                  );
Line: 3441

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'INFORMATION20',
                                     p_old_INFORMATION20,
                                     p_new_INFORMATION20,
                                     p_effective_date
                                  );
Line: 3450

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'INFORMATION21',
                                     p_old_INFORMATION21,
                                     p_new_INFORMATION21,
                                     p_effective_date
                                  );
Line: 3459

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'INFORMATION22',
                                     p_old_INFORMATION22,
                                     p_new_INFORMATION22,
                                     p_effective_date
                                  );
Line: 3468

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'INFORMATION23',
                                     p_old_INFORMATION23,
                                     p_new_INFORMATION23,
                                     p_effective_date
                                  );
Line: 3477

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'INFORMATION24',
                                     p_old_INFORMATION24,
                                     p_new_INFORMATION24,
                                     p_effective_date
                                  );
Line: 3486

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'INFORMATION25',
                                     p_old_INFORMATION25,
                                     p_new_INFORMATION25,
                                     p_effective_date
                                  );
Line: 3495

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'INFORMATION26',
                                     p_old_INFORMATION26,
                                     p_new_INFORMATION26,
                                     p_effective_date
                                  );
Line: 3504

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'INFORMATION27',
                                     p_old_INFORMATION27,
                                     p_new_INFORMATION27,
                                     p_effective_date
                                  );
Line: 3513

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'INFORMATION28',
                                     p_old_INFORMATION28,
                                     p_new_INFORMATION28,
                                     p_effective_date
                                  );
Line: 3522

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'INFORMATION29',
                                     p_old_INFORMATION29,
                                     p_new_INFORMATION29,
                                     p_effective_date
                                  );
Line: 3531

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'INFORMATION3',
                                     p_old_INFORMATION3,
                                     p_new_INFORMATION3,
                                     p_effective_date
                                  );
Line: 3540

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'INFORMATION30',
                                     p_old_INFORMATION30,
                                     p_new_INFORMATION30,
                                     p_effective_date
                                  );
Line: 3549

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'INFORMATION4',
                                     p_old_INFORMATION4,
                                     p_new_INFORMATION4,
                                     p_effective_date
                                  );
Line: 3558

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'INFORMATION5',
                                     p_old_INFORMATION5,
                                     p_new_INFORMATION5,
                                     p_effective_date
                                  );
Line: 3567

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'INFORMATION6',
                                     p_old_INFORMATION6,
                                     p_new_INFORMATION6,
                                     p_effective_date
                                  );
Line: 3576

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'INFORMATION7',
                                     p_old_INFORMATION7,
                                     p_new_INFORMATION7,
                                     p_effective_date
                                  );
Line: 3585

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'INFORMATION8',
                                     p_old_INFORMATION8,
                                     p_new_INFORMATION8,
                                     p_effective_date
                                  );
Line: 3594

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'INFORMATION9',
                                     p_old_INFORMATION9,
                                     p_new_INFORMATION9,
                                     p_effective_date
                                  );
Line: 3603

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'INFORMATION_CATEGORY',
                                     p_old_INFORMATION_CATEGORY,
                                     p_new_INFORMATION_CATEGORY,
                                     p_effective_date
                                  );
Line: 3612

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'LAST_STANDARD_PROCESS_DATE',
                                     p_old_LAST_STANDARD_PROCESS_DA,
                                     p_new_LAST_STANDARD_PROCESS_DA,
                                     p_effective_date
                                  );
Line: 3621

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'PERIOD_OF_PLACEMENT_ID',
                                     p_old_PERIOD_OF_PLACEMENT_ID,
                                     p_new_PERIOD_OF_PLACEMENT_ID,
                                     p_effective_date
                                  );
Line: 3630

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'PERSON_ID',
                                     p_old_PERSON_ID,
                                     p_new_PERSON_ID,
                                     p_effective_date
                                  );
Line: 3639

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'PROJECTED_TERMINATION_DATE',
                                     p_old_PROJECTED_TERMINATION_DA,
                                     p_new_PROJECTED_TERMINATION_DA,
                                     p_effective_date
                                  );
Line: 3648

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'TERMINATION_REASON',
                                     p_old_TERMINATION_REASON,
                                     p_new_TERMINATION_REASON,
                                     p_effective_date
                                  );
Line: 3657

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_PERIODS_OF_PLACEMENT',
                                     'DATE_START',
                                     p_old_DATE_START,
                                     p_new_DATE_START,
                                     p_effective_date
                                  );
Line: 3683

             p_event_update_id       => pay_continuous_calc.g_event_list.event_update_id(cnt),
             p_business_group_id     => p_business_group_id,
             p_calculation_date      => pay_continuous_calc.g_event_list.calc_date(cnt),
             p_surrogate_key         => p_new_period_of_placement_id
           );
Line: 3789

  select distinct assignment_id
    from per_all_assignments_f
   where person_id = p_person_id
   and primary_flag = 'Y';
Line: 3812

    pay_continuous_calc.event_update
     (p_business_group_id,
      p_legislation_code,
      'PER_ABSENCE_ATTENDANCES',
      'ABSENCE_ATTENDANCE_ID',
      p_old_ABSENCE_ATTENDANCE_ID,
      p_new_ABSENCE_ATTENDANCE_ID,
      l_effective_date);
Line: 3821

    pay_continuous_calc.event_update
     (p_business_group_id,
      p_legislation_code,
      'PER_ABSENCE_ATTENDANCES',
      'ABS_ATTENDANCE_REASON_ID',
      p_old_ABS_ATTENDANCE_REASON_ID,
      p_new_ABS_ATTENDANCE_REASON_ID,
      l_effective_date);
Line: 3830

    pay_continuous_calc.event_update
     (p_business_group_id,
      p_legislation_code,
      'PER_ABSENCE_ATTENDANCES',
      'AUTHORISING_PERSON_ID',
      p_old_AUTHORISING_PERSON_ID,
      p_new_AUTHORISING_PERSON_ID,
      l_effective_date);
Line: 3839

    pay_continuous_calc.event_update
     (p_business_group_id,
      p_legislation_code,
      'PER_ABSENCE_ATTENDANCES',
      'REPLACEMENT_PERSON_ID',
      p_old_REPLACEMENT_PERSON_ID,
      p_new_REPLACEMENT_PERSON_ID,
      l_effective_date);
Line: 3848

    pay_continuous_calc.event_update
     (p_business_group_id,
      p_legislation_code,
      'PER_ABSENCE_ATTENDANCES',
      'PERIOD_OF_INCAPACITY_ID',
      p_old_PERIOD_OF_INCAPACITY_ID,
      p_new_PERIOD_OF_INCAPACITY_ID,
      l_effective_date);
Line: 3857

    pay_continuous_calc.event_update
     (p_business_group_id,
      p_legislation_code,
      'PER_ABSENCE_ATTENDANCES',
      'ABSENCE_DAYS',
      p_old_ABSENCE_DAYS,
      p_new_ABSENCE_DAYS,
      l_effective_date);
Line: 3866

    pay_continuous_calc.event_update
     (p_business_group_id,
      p_legislation_code,
      'PER_ABSENCE_ATTENDANCES',
      'ABSENCE_HOURS',
      p_old_ABSENCE_HOURS,
      p_new_ABSENCE_HOURS,
      l_effective_date);
Line: 3875

    pay_continuous_calc.event_update
     (p_business_group_id,
      p_legislation_code,
      'PER_ABSENCE_ATTENDANCES',
      'DATE_END',
      p_old_DATE_END,
      p_new_DATE_END,
      l_effective_date);
Line: 3884

    pay_continuous_calc.event_update
     (p_business_group_id,
      p_legislation_code,
      'PER_ABSENCE_ATTENDANCES',
      'DATE_NOTIFICATION',
      p_old_DATE_NOTIFICATION,
      p_new_DATE_NOTIFICATION,
      l_effective_date);
Line: 3893

    pay_continuous_calc.event_update
     (p_business_group_id,
      p_legislation_code,
      'PER_ABSENCE_ATTENDANCES',
      'DATE_PROJECTED_END',
      p_old_DATE_PROJECTED_END,
      p_new_DATE_PROJECTED_END,
      l_effective_date);
Line: 3902

    pay_continuous_calc.event_update
     (p_business_group_id,
      p_legislation_code,
      'PER_ABSENCE_ATTENDANCES',
      'DATE_PROJECTED_START',
      p_old_DATE_PROJECTED_START,
      p_new_DATE_PROJECTED_START,
      l_effective_date);
Line: 3911

    pay_continuous_calc.event_update
     (p_business_group_id,
      p_legislation_code,
      'PER_ABSENCE_ATTENDANCES',
      'DATE_START',
      p_old_DATE_START,
      p_new_DATE_START,
      l_effective_date);
Line: 3920

    pay_continuous_calc.event_update
     (p_business_group_id,
      p_legislation_code,
      'PER_ABSENCE_ATTENDANCES',
      'SSP1_ISSUED',
      p_old_SSP1_ISSUED,
      p_new_SSP1_ISSUED,
      l_effective_date);
Line: 3929

    pay_continuous_calc.event_update
     (p_business_group_id,
      p_legislation_code,
      'PER_ABSENCE_ATTENDANCES',
      'TIME_END',
      p_old_TIME_END,
      p_new_TIME_END,
      l_effective_date);
Line: 3938

    pay_continuous_calc.event_update
     (p_business_group_id,
      p_legislation_code,
      'PER_ABSENCE_ATTENDANCES',
      'TIME_PROJECTED_END',
      p_old_TIME_PROJECTED_END,
      p_new_TIME_PROJECTED_END,
      l_effective_date);
Line: 3947

    pay_continuous_calc.event_update
     (p_business_group_id,
      p_legislation_code,
      'PER_ABSENCE_ATTENDANCES',
      'TIME_PROJECTED_START',
      p_old_TIME_PROJECTED_START,
      p_new_TIME_PROJECTED_START,
      l_effective_date);
Line: 3956

    pay_continuous_calc.event_update
     (p_business_group_id,
      p_legislation_code,
      'PER_ABSENCE_ATTENDANCES',
      'TIME_START',
      p_old_TIME_START,
      p_new_TIME_START,
      l_effective_date);
Line: 3965

    pay_continuous_calc.event_update
     (p_business_group_id,
      p_legislation_code,
      'PER_ABSENCE_ATTENDANCES',
      'MATERNITY_ID',
      p_old_MATERNITY_ID,
      p_new_MATERNITY_ID,
      l_effective_date);
Line: 3974

    pay_continuous_calc.event_update
     (p_business_group_id,
      p_legislation_code,
      'PER_ABSENCE_ATTENDANCES',
      'SICKNESS_START_DATE',
      p_old_SICKNESS_START_DATE,
      p_new_SICKNESS_START_DATE,
      l_effective_date);
Line: 3983

    pay_continuous_calc.event_update
     (p_business_group_id,
      p_legislation_code,
      'PER_ABSENCE_ATTENDANCES',
      'SICKNESS_END_DATE',
      p_old_SICKNESS_END_DATE,
      p_new_SICKNESS_END_DATE,
      l_effective_date);
Line: 3992

    pay_continuous_calc.event_update
     (p_business_group_id,
      p_legislation_code,
      'PER_ABSENCE_ATTENDANCES',
      'LINKED_ABSENCE_ID',
      p_old_LINKED_ABSENCE_ID,
      p_new_LINKED_ABSENCE_ID,
      l_effective_date);
Line: 4001

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ABSENCE_ATTENDANCES',
                                     'ATTRIBUTE1',
                                     p_old_ATTRIBUTE1,
                                     p_new_ATTRIBUTE1,
                                     l_effective_date
                                  );
Line: 4010

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ABSENCE_ATTENDANCES',
                                     'ATTRIBUTE10',
                                     p_old_ATTRIBUTE10,
                                     p_new_ATTRIBUTE10,
                                     l_effective_date
                                  );
Line: 4019

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ABSENCE_ATTENDANCES',
                                     'ATTRIBUTE11',
                                     p_old_ATTRIBUTE11,
                                     p_new_ATTRIBUTE11,
                                     l_effective_date
                                  );
Line: 4028

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ABSENCE_ATTENDANCES',
                                     'ATTRIBUTE12',
                                     p_old_ATTRIBUTE12,
                                     p_new_ATTRIBUTE12,
                                     l_effective_date
                                  );
Line: 4037

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ABSENCE_ATTENDANCES',
                                     'ATTRIBUTE13',
                                     p_old_ATTRIBUTE13,
                                     p_new_ATTRIBUTE13,
                                     l_effective_date
                                  );
Line: 4046

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ABSENCE_ATTENDANCES',
                                     'ATTRIBUTE14',
                                     p_old_ATTRIBUTE14,
                                     p_new_ATTRIBUTE14,
                                     l_effective_date
                                  );
Line: 4055

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ABSENCE_ATTENDANCES',
                                     'ATTRIBUTE15',
                                     p_old_ATTRIBUTE15,
                                     p_new_ATTRIBUTE15,
                                     l_effective_date
                                  );
Line: 4064

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ABSENCE_ATTENDANCES',
                                     'ATTRIBUTE16',
                                     p_old_ATTRIBUTE16,
                                     p_new_ATTRIBUTE16,
                                     l_effective_date
                                  );
Line: 4073

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ABSENCE_ATTENDANCES',
                                     'ATTRIBUTE17',
                                     p_old_ATTRIBUTE17,
                                     p_new_ATTRIBUTE17,
                                     l_effective_date
                                  );
Line: 4082

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ABSENCE_ATTENDANCES',
                                     'ATTRIBUTE18',
                                     p_old_ATTRIBUTE18,
                                     p_new_ATTRIBUTE18,
                                     l_effective_date
                                  );
Line: 4091

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ABSENCE_ATTENDANCES',
                                     'ATTRIBUTE19',
                                     p_old_ATTRIBUTE19,
                                     p_new_ATTRIBUTE19,
                                     l_effective_date
                                  );
Line: 4100

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ABSENCE_ATTENDANCES',
                                     'ATTRIBUTE2',
                                     p_old_ATTRIBUTE2,
                                     p_new_ATTRIBUTE2,
                                     l_effective_date
                                  );
Line: 4109

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ABSENCE_ATTENDANCES',
                                     'ATTRIBUTE20',
                                     p_old_ATTRIBUTE20,
                                     p_new_ATTRIBUTE20,
                                     l_effective_date
                                  );
Line: 4118

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ABSENCE_ATTENDANCES',
                                     'ATTRIBUTE3',
                                     p_old_ATTRIBUTE3,
                                     p_new_ATTRIBUTE3,
                                     l_effective_date
                                  );
Line: 4127

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ABSENCE_ATTENDANCES',
                                     'ATTRIBUTE4',
                                     p_old_ATTRIBUTE4,
                                     p_new_ATTRIBUTE4,
                                     l_effective_date
                                  );
Line: 4136

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ABSENCE_ATTENDANCES',
                                     'ATTRIBUTE5',
                                     p_old_ATTRIBUTE5,
                                     p_new_ATTRIBUTE5,
                                     l_effective_date
                                  );
Line: 4145

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ABSENCE_ATTENDANCES',
                                     'ATTRIBUTE6',
                                     p_old_ATTRIBUTE6,
                                     p_new_ATTRIBUTE6,
                                     l_effective_date
                                  );
Line: 4154

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ABSENCE_ATTENDANCES',
                                     'ATTRIBUTE7',
                                     p_old_ATTRIBUTE7,
                                     p_new_ATTRIBUTE7,
                                     l_effective_date
                                  );
Line: 4163

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ABSENCE_ATTENDANCES',
                                     'ATTRIBUTE8',
                                     p_old_ATTRIBUTE8,
                                     p_new_ATTRIBUTE8,
                                     l_effective_date
                                  );
Line: 4172

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ABSENCE_ATTENDANCES',
                                     'ATTRIBUTE9',
                                     p_old_ATTRIBUTE9,
                                     p_new_ATTRIBUTE9,
                                     l_effective_date
                                  );
Line: 4181

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ABSENCE_ATTENDANCES',
                                     'ATTRIBUTE_CATEGORY',
                                     p_old_ATTRIBUTE_CATEGORY,
                                     p_new_ATTRIBUTE_CATEGORY,
                                     l_effective_date
                                  );
Line: 4207

             p_event_update_id       => pay_continuous_calc.g_event_list.event_update_id(cnt),
             p_business_group_id     => p_business_group_id,
             p_calculation_date      => pay_continuous_calc.g_event_list.calc_date(cnt),
             p_surrogate_key         => p_new_absence_attendance_id
           );
Line: 4234

  select distinct assignment_id
    from per_all_assignments_f
   where person_id = p_person_id
   and primary_flag = 'Y';
Line: 4252

  pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ABSENCE_ATTENDANCES',
                                     NULL,
                                     NULL,
                                     NULL,
                                     NVL(p_effective_start_date,TRUNC(SYSDATE)),
                                     NVL(p_effective_start_date,TRUNC(SYSDATE)),
                                     'I'
                                    );
Line: 4282

             p_event_update_id       => pay_continuous_calc.g_event_list.event_update_id(cnt),
             p_business_group_id     => p_business_group_id,
             p_calculation_date      => pay_continuous_calc.g_event_list.calc_date(cnt),
             p_surrogate_key         => p_absence_attendance_id);
Line: 4308

  select distinct assignment_id
    from per_all_assignments_f
   where person_id = p_person_id
   and primary_flag = 'Y';
Line: 4325

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PER_ABSENCE_ATTENDANCES',
                                     NULL,
                                     NULL,
                                     NULL,
                                     NVL(p_effective_start_date,TRUNC(SYSDATE)),
                                     NVL(p_effective_start_date,TRUNC(SYSDATE)),
                                     'D'
                                    );
Line: 4352

             p_event_update_id       => pay_continuous_calc.g_event_list.event_update_id(cnt),
             p_surrogate_key         => p_absence_attendance_id,
             p_calculation_date      => pay_continuous_calc.g_event_list.calc_date(cnt),
             p_business_group_id     => p_business_group_id);
Line: 4391

   pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PQP_GAP_DURATION_SUMMARY',
                                     NULL,
                                     NULL,
                                     NULL,
                                     p_effective_start_date,
                                     p_effective_start_date,
                                     'I'
                                    );
Line: 4421

             p_event_update_id       => pay_continuous_calc.g_event_list.event_update_id(cnt),
             p_business_group_id     => p_business_group_id,
             p_calculation_date      => pay_continuous_calc.g_event_list.calc_date(cnt),
             p_surrogate_key         => p_gap_duration_summary_id);
Line: 4466

    pay_continuous_calc.event_update
     (p_business_group_id,
      p_legislation_code,
      'PQP_GAP_DURATION_SUMMARY',
      'DURATION_IN_DAYS',
      p_old_DURATION_IN_DAYS,
      p_new_DURATION_IN_DAYS,
      p_effective_date);
Line: 4475

    pay_continuous_calc.event_update
     (p_business_group_id,
      p_legislation_code,
      'PQP_GAP_DURATION_SUMMARY',
      'DURATION_IN_HOURS',
      p_old_DURATION_IN_HOURS,
      p_new_DURATION_IN_HOURS,
      p_effective_date);
Line: 4484

    pay_continuous_calc.event_update
     (p_business_group_id,
      p_legislation_code,
      'PQP_GAP_DURATION_SUMMARY',
      'DATE_END',
      p_old_DATE_END,
      p_new_DATE_END,
      p_effective_date);
Line: 4493

    pay_continuous_calc.event_update
     (p_business_group_id,
      p_legislation_code,
      'PQP_GAP_DURATION_SUMMARY',
      'DATE_START',
      p_old_DATE_START,
      p_new_DATE_START,
      p_effective_date);
Line: 4520

             p_event_update_id       => pay_continuous_calc.g_event_list.event_update_id(cnt),
             p_business_group_id     => p_business_group_id,
             p_calculation_date      => pay_continuous_calc.g_event_list.calc_date(cnt),
             p_surrogate_key         => P_GAP_DURATION_SUMMARY_ID
           );
Line: 4561

    pay_continuous_calc.event_update(p_business_group_id,
                                     p_legislation_code,
                                     'PQP_GAP_DURATION_SUMMARY',
                                     NULL,
                                     NULL,
                                     NULL,
                                     p_effective_start_date,
                                     p_effective_start_date,
                                     'D'
                                    );
Line: 4588

             p_event_update_id       => pay_continuous_calc.g_event_list.event_update_id(cnt),
             p_surrogate_key         => P_GAP_DURATION_SUMMARY_ID,
             p_calculation_date      => pay_continuous_calc.g_event_list.calc_date(cnt),
             p_business_group_id     => p_business_group_id);