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_STH_HISTORY dependencies on BEN_EXT_PERSON

Line 816: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;

812: g_reported_claim_dates.DELETE;
813: g_reported_pay_periods.DELETE;
814:
815: -- set the global events table
816: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;
817:
818: -- set global assignment_id
819: g_assignment_id := p_assignment_id;
820: debug('g_assignment_id: '||g_assignment_id,10);

Line 935: ||'('||ben_ext_person.g_chg_surrogate_key||')',1,80)

931: (p_error_number => 94515
932: ,p_error_text => 'BEN_94515_NO_FTE_VALUE'
933: ,p_token1 => to_char(p_claim_date,'dd/mm/yyyy')
934: ,p_token2 => SUBSTR(g_curr_element_type_name
935: ||'('||ben_ext_person.g_chg_surrogate_key||')',1,80)
936: );
937:
938: ElSIF l_fte_value >= 1 THEN
939: debug('WARNING: Full Timer');

Line 945: ||'('||ben_ext_person.g_chg_surrogate_key||')',1,80)

941: (p_error_number => 94516
942: ,p_error_text => 'BEN_94516_STH_FULL_TIMER'
943: ,p_token1 => to_char(p_claim_date,'dd/mm/yyyy')
944: ,p_token2 => SUBSTR(g_curr_element_type_name
945: ||'('||ben_ext_person.g_chg_surrogate_key||')',1,80)
946: );
947: END IF;
948:
949: debug_exit(l_proc);

Line 1025: l_chg_table := ben_ext_person.g_chg_pay_table;

1021: AND ROWNUM = 1;
1022:
1023: BEGIN
1024: debug_enter(l_proc);
1025: l_chg_table := ben_ext_person.g_chg_pay_table;
1026: l_chg_type := ben_ext_person.g_chg_update_type;
1027: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
1028: l_chg_date := ben_ext_person.g_chg_eff_dt;
1029: debug('l_chg_table: '||l_chg_table,10);

Line 1026: l_chg_type := ben_ext_person.g_chg_update_type;

1022:
1023: BEGIN
1024: debug_enter(l_proc);
1025: l_chg_table := ben_ext_person.g_chg_pay_table;
1026: l_chg_type := ben_ext_person.g_chg_update_type;
1027: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
1028: l_chg_date := ben_ext_person.g_chg_eff_dt;
1029: debug('l_chg_table: '||l_chg_table,10);
1030: debug('l_chg_type: '||l_chg_type,10);

Line 1027: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;

1023: BEGIN
1024: debug_enter(l_proc);
1025: l_chg_table := ben_ext_person.g_chg_pay_table;
1026: l_chg_type := ben_ext_person.g_chg_update_type;
1027: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
1028: l_chg_date := ben_ext_person.g_chg_eff_dt;
1029: debug('l_chg_table: '||l_chg_table,10);
1030: debug('l_chg_type: '||l_chg_type,10);
1031: debug('l_chg_surrogate_key: '||l_chg_surrogate_key,10);

Line 1028: l_chg_date := ben_ext_person.g_chg_eff_dt;

1024: debug_enter(l_proc);
1025: l_chg_table := ben_ext_person.g_chg_pay_table;
1026: l_chg_type := ben_ext_person.g_chg_update_type;
1027: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
1028: l_chg_date := ben_ext_person.g_chg_eff_dt;
1029: debug('l_chg_table: '||l_chg_table,10);
1030: debug('l_chg_type: '||l_chg_type,10);
1031: debug('l_chg_surrogate_key: '||l_chg_surrogate_key,10);
1032: debug('l_chg_date: '||l_chg_date,10);

Line 1173: ||'('||ben_ext_person.g_chg_surrogate_key||')',1,80)

1169: (p_error_number => 94514
1170: ,p_error_text => 'BEN_94514_DUP_CLAIM_DATE'
1171: ,p_token1 => to_date(l_claim_date_dt,'dd/mm/yyyy')
1172: ,p_token2 => SUBSTR(g_curr_element_type_name
1173: ||'('||ben_ext_person.g_chg_surrogate_key||')',1,80)
1174: ,p_token3 => g_reported_claim_dates(l_claim_date_no)
1175: );
1176: debug('Returning : FALSE',30);
1177: debug_exit(l_proc);

Line 1355: TO_CHAR(ben_ext_person.g_chg_eff_dt,'ddmmyyyy')

1351: -- bug fix 5365237
1352: IF nvl(g_adj_hrs_source,' ') = 'BALANCE'
1353: AND g_reported_pay_periods.EXISTS(fnd_number.canonical_to_number
1354: (
1355: TO_CHAR(ben_ext_person.g_chg_eff_dt,'ddmmyyyy')
1356: )
1357: )THEN
1358: -- if the current pay period is already reported.
1359: debug('Current pay period starting on :'||ben_ext_person.g_chg_eff_dt||' is already processed');

Line 1359: debug('Current pay period starting on :'||ben_ext_person.g_chg_eff_dt||' is already processed');

1355: TO_CHAR(ben_ext_person.g_chg_eff_dt,'ddmmyyyy')
1356: )
1357: )THEN
1358: -- if the current pay period is already reported.
1359: debug('Current pay period starting on :'||ben_ext_person.g_chg_eff_dt||' is already processed');
1360: l_include := 'N';
1361: debug('Returning : '||l_include,20);
1362: debug_exit(l_proc);
1363: return l_include;

Line 1366: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;

1362: debug_exit(l_proc);
1363: return l_include;
1364: END IF;
1365:
1366: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;
1367: debug('----------');
1368: debug('Record :'||l_curr_evt_index);
1369: debug('----------');
1370: debug('surrogate_key :'||g_pay_proc_evt_tab(l_curr_evt_index).surrogate_key ,20);

Line 1544: ||'('||ben_ext_person.g_chg_surrogate_key||')',1,80)

1540: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_error
1541: (p_error_number => 94507
1542: ,p_error_text => 'BEN_94507_NO_CLAIM_DATE_SIN'
1543: ,p_token1 => SUBSTR(g_curr_element_type_name
1544: ||'('||ben_ext_person.g_chg_surrogate_key||')',1,80)
1545: );
1546: ELSE
1547: p_output_value := to_char(g_effective_date,'dd/mm/yyyy');
1548: END IF;

Line 1582: l_curr_index := ben_ext_person.g_chg_pay_evt_index;

1578: l_return NUMBER := 0;
1579: l_curr_index NUMBER;
1580: BEGIN
1581: debug_enter(l_proc);
1582: l_curr_index := ben_ext_person.g_chg_pay_evt_index;
1583: IF l_curr_index = g_pay_proc_evt_tab.LAST - 1 THEN
1584: debug('Last event on the current person');
1585: IF g_start_date IS NULL THEN
1586: p_output_value := NULL;

Line 1636: l_curr_index := ben_ext_person.g_chg_pay_evt_index;

1632: l_curr_index NUMBER;
1633: BEGIN
1634: debug_enter(l_proc);
1635:
1636: l_curr_index := ben_ext_person.g_chg_pay_evt_index;
1637:
1638: IF g_end_date IS NULL THEN
1639: p_output_value := NULL;
1640: ELSE

Line 1739: l_curr_index := ben_ext_person.g_chg_pay_evt_index;

1735: ---
1736: BEGIN
1737: debug_enter(l_proc);
1738:
1739: l_curr_index := ben_ext_person.g_chg_pay_evt_index;
1740:
1741: IF l_curr_index = g_pay_proc_evt_tab.LAST - 1
1742: AND g_current_layout = 'ACCUMULATED' THEN
1743: debug('Last event on the current person');

Line 1767: ||'('||ben_ext_person.g_chg_surrogate_key||')',1,80)

1763: l_return := PQP_GB_PSI_FUNCTIONS.raise_extract_error
1764: (p_error_number => 94511
1765: ,p_error_text => 'BEN_94511_NO_ADJ_HRS_SIN'
1766: ,p_token1 => SUBSTR(g_curr_element_type_name
1767: ||'('||ben_ext_person.g_chg_surrogate_key||')',1,80)
1768: );
1769: END IF;
1770: debug_exit(l_proc);
1771: return l_return;