eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_GB_PSI_BON_HISTORY dependencies on BEN_EXT_PERSON

Line 241: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;

237: g_first_approved_event := NULL;
238:
239:
240: -- set the global events table
241: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;
242: -- clear the global cache for the duplicate bonus codes check
243: g_proc_bon_codes.DELETE;
244:
245: -- set global assignment_id

Line 383: l_chg_table := ben_ext_person.g_chg_pay_table;

379: debug_enter(l_proc);
380:
381: IF g_current_layout = 'PERIODIC' THEN
382: -- person repeating level
383: l_chg_table := ben_ext_person.g_chg_pay_table;
384: l_chg_type := ben_ext_person.g_chg_update_type;
385: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
386: l_chg_date := ben_ext_person.g_chg_eff_dt;
387: debug('l_chg_table: '||l_chg_table,10);

Line 384: l_chg_type := ben_ext_person.g_chg_update_type;

380:
381: IF g_current_layout = 'PERIODIC' THEN
382: -- person repeating level
383: l_chg_table := ben_ext_person.g_chg_pay_table;
384: l_chg_type := ben_ext_person.g_chg_update_type;
385: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
386: l_chg_date := ben_ext_person.g_chg_eff_dt;
387: debug('l_chg_table: '||l_chg_table,10);
388: debug('l_chg_type: '||l_chg_type,10);

Line 385: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;

381: IF g_current_layout = 'PERIODIC' THEN
382: -- person repeating level
383: l_chg_table := ben_ext_person.g_chg_pay_table;
384: l_chg_type := ben_ext_person.g_chg_update_type;
385: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
386: l_chg_date := ben_ext_person.g_chg_eff_dt;
387: debug('l_chg_table: '||l_chg_table,10);
388: debug('l_chg_type: '||l_chg_type,10);
389: debug('l_chg_surrogate_key: '||l_chg_surrogate_key,10);

Line 386: l_chg_date := ben_ext_person.g_chg_eff_dt;

382: -- person repeating level
383: l_chg_table := ben_ext_person.g_chg_pay_table;
384: l_chg_type := ben_ext_person.g_chg_update_type;
385: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
386: l_chg_date := ben_ext_person.g_chg_eff_dt;
387: debug('l_chg_table: '||l_chg_table,10);
388: debug('l_chg_type: '||l_chg_type,10);
389: debug('l_chg_surrogate_key: '||l_chg_surrogate_key,10);
390: debug('l_chg_date: '||l_chg_date,10);

Line 405: g_curr_element_type_id := ben_ext_person.g_element_id;

401:
402:
403: ELSIF g_current_layout = 'CUTOVER' THEN
404: -- element repeating level
405: g_curr_element_type_id := ben_ext_person.g_element_id;
406: g_curr_ee_start_date := ben_ext_person.g_element_entry_eff_start_date;
407: g_curr_ee_end_date := ben_ext_person.g_element_entry_eff_end_date;
408: g_curr_element_type_name := ben_ext_person.g_element_name;
409: END IF;

Line 406: g_curr_ee_start_date := ben_ext_person.g_element_entry_eff_start_date;

402:
403: ELSIF g_current_layout = 'CUTOVER' THEN
404: -- element repeating level
405: g_curr_element_type_id := ben_ext_person.g_element_id;
406: g_curr_ee_start_date := ben_ext_person.g_element_entry_eff_start_date;
407: g_curr_ee_end_date := ben_ext_person.g_element_entry_eff_end_date;
408: g_curr_element_type_name := ben_ext_person.g_element_name;
409: END IF;
410:

Line 407: g_curr_ee_end_date := ben_ext_person.g_element_entry_eff_end_date;

403: ELSIF g_current_layout = 'CUTOVER' THEN
404: -- element repeating level
405: g_curr_element_type_id := ben_ext_person.g_element_id;
406: g_curr_ee_start_date := ben_ext_person.g_element_entry_eff_start_date;
407: g_curr_ee_end_date := ben_ext_person.g_element_entry_eff_end_date;
408: g_curr_element_type_name := ben_ext_person.g_element_name;
409: END IF;
410:
411: IF g_current_layout = 'PERIODIC' THEN

Line 408: g_curr_element_type_name := ben_ext_person.g_element_name;

404: -- element repeating level
405: g_curr_element_type_id := ben_ext_person.g_element_id;
406: g_curr_ee_start_date := ben_ext_person.g_element_entry_eff_start_date;
407: g_curr_ee_end_date := ben_ext_person.g_element_entry_eff_end_date;
408: g_curr_element_type_name := ben_ext_person.g_element_name;
409: END IF;
410:
411: IF g_current_layout = 'PERIODIC' THEN
412: g_curr_element_entry_id := fnd_number.canonical_to_number(l_chg_surrogate_key);

Line 429: g_curr_element_entry_id := ben_ext_person.g_element_entry_id;

425: debug('element_entry_id: '||g_curr_element_entry_id,20);
426: END IF;
427: END IF;
428: ELSE
429: g_curr_element_entry_id := ben_ext_person.g_element_entry_id;
430: END IF;
431:
432: debug('g_curr_element_entry_id: '||g_curr_element_entry_id,10);
433: debug('g_curr_element_type_id: '||g_curr_element_type_id,10);

Line 722: -- ben_ext_person.g_chg_pay_evt_index with current value later on

718: ,p_effective_date => p_effective_date
719: );
720: --For BUG 5998129
721: -- store in l_bon_curr_evt_index, so that we can restore
722: -- ben_ext_person.g_chg_pay_evt_index with current value later on
723: l_bon_effective_date := NULL;
724: l_bon_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;
725:
726: debug('l_bon_effective_date : '||l_bon_effective_date);

Line 724: l_bon_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;

720: --For BUG 5998129
721: -- store in l_bon_curr_evt_index, so that we can restore
722: -- ben_ext_person.g_chg_pay_evt_index with current value later on
723: l_bon_effective_date := NULL;
724: l_bon_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;
725:
726: debug('l_bon_effective_date : '||l_bon_effective_date);
727: debug('total events : '||g_pay_proc_evt_tab.count);
728: debug('l_bon_curr_evt_index : '||l_bon_curr_evt_index);

Line 769: -- incrementing ben_ext_person.g_chg_pay_evt_index now,

765:
766: END IF;
767:
768: debug('i value :'||i);
769: -- incrementing ben_ext_person.g_chg_pay_evt_index now,
770: -- will be restored after the FOR loop
771: ben_ext_person.g_chg_pay_evt_index := ben_ext_person.g_chg_pay_evt_index + 1;
772: END LOOP;
773:

Line 771: ben_ext_person.g_chg_pay_evt_index := ben_ext_person.g_chg_pay_evt_index + 1;

767:
768: debug('i value :'||i);
769: -- incrementing ben_ext_person.g_chg_pay_evt_index now,
770: -- will be restored after the FOR loop
771: ben_ext_person.g_chg_pay_evt_index := ben_ext_person.g_chg_pay_evt_index + 1;
772: END LOOP;
773:
774: debug('after loop l_bon_effective_date :'||l_bon_effective_date);
775:

Line 776: -- restoring ben_ext_person.g_chg_pay_evt_index

772: END LOOP;
773:
774: debug('after loop l_bon_effective_date :'||l_bon_effective_date);
775:
776: -- restoring ben_ext_person.g_chg_pay_evt_index
777: ben_ext_person.g_chg_pay_evt_index := l_bon_curr_evt_index;
778: --END For BUG 5998129
779: END IF;
780:

Line 777: ben_ext_person.g_chg_pay_evt_index := l_bon_curr_evt_index;

773:
774: debug('after loop l_bon_effective_date :'||l_bon_effective_date);
775:
776: -- restoring ben_ext_person.g_chg_pay_evt_index
777: ben_ext_person.g_chg_pay_evt_index := l_bon_curr_evt_index;
778: --END For BUG 5998129
779: END IF;
780:
781: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;

Line 781: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;

777: ben_ext_person.g_chg_pay_evt_index := l_bon_curr_evt_index;
778: --END For BUG 5998129
779: END IF;
780:
781: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;
782: debug('----------');
783: debug('Record :'||l_curr_evt_index);
784: debug('----------');
785: debug('surrogate_key :'||g_pay_proc_evt_tab(l_curr_evt_index).surrogate_key ,20);

Line 945: p_output_value := to_char(ben_ext_person.g_element_entry_eff_start_date,'dd/mm/yyyy');

941: BEGIN
942: debug_enter(l_proc);
943:
944: /*IF g_current_layout = 'CUTOVER' THEN
945: p_output_value := to_char(ben_ext_person.g_element_entry_eff_start_date,'dd/mm/yyyy');
946: ELSE
947: p_output_value := to_char(g_effective_date,'dd/mm/yyyy');
948: END IF;*/
949: