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

Line 492: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;

488: );
489:
490:
491: -- set the global events table
492: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;
493:
494: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;
495:
496: debug('----------');

Line 494: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;

490:
491: -- set the global events table
492: g_pay_proc_evt_tab := ben_ext_person.g_pay_proc_evt_tab;
493:
494: l_curr_evt_index := ben_ext_person.g_chg_pay_evt_index;
495:
496: debug('----------');
497: debug('Record :'||l_curr_evt_index);
498: debug('----------');

Line 686: debug('ben_ext_person.g_chg_pay_table:' || ben_ext_person.g_chg_pay_table, 30);

682: l_ret_location := '******';
683: ELSE
684:
685: debug('location:' || l_ret_location, 30);
686: debug('ben_ext_person.g_chg_pay_table:' || ben_ext_person.g_chg_pay_table, 30);
687: debug('ben_ext_person.g_chg_pay_column:' || ben_ext_person.g_chg_pay_column, 30);
688: debug('ben_ext_person.g_chg_update_type:' || ben_ext_person.g_chg_update_type, 30);
689:
690: --

Line 687: debug('ben_ext_person.g_chg_pay_column:' || ben_ext_person.g_chg_pay_column, 30);

683: ELSE
684:
685: debug('location:' || l_ret_location, 30);
686: debug('ben_ext_person.g_chg_pay_table:' || ben_ext_person.g_chg_pay_table, 30);
687: debug('ben_ext_person.g_chg_pay_column:' || ben_ext_person.g_chg_pay_column, 30);
688: debug('ben_ext_person.g_chg_update_type:' || ben_ext_person.g_chg_update_type, 30);
689:
690: --
691: IF ben_ext_person.g_chg_pay_table = 'PER_ALL_ASSIGNMENTS_F'

Line 688: debug('ben_ext_person.g_chg_update_type:' || ben_ext_person.g_chg_update_type, 30);

684:
685: debug('location:' || l_ret_location, 30);
686: debug('ben_ext_person.g_chg_pay_table:' || ben_ext_person.g_chg_pay_table, 30);
687: debug('ben_ext_person.g_chg_pay_column:' || ben_ext_person.g_chg_pay_column, 30);
688: debug('ben_ext_person.g_chg_update_type:' || ben_ext_person.g_chg_update_type, 30);
689:
690: --
691: IF ben_ext_person.g_chg_pay_table = 'PER_ALL_ASSIGNMENTS_F'
692: AND ben_ext_person.g_chg_pay_column = 'LOCATION_ID'

Line 691: IF ben_ext_person.g_chg_pay_table = 'PER_ALL_ASSIGNMENTS_F'

687: debug('ben_ext_person.g_chg_pay_column:' || ben_ext_person.g_chg_pay_column, 30);
688: debug('ben_ext_person.g_chg_update_type:' || ben_ext_person.g_chg_update_type, 30);
689:
690: --
691: IF ben_ext_person.g_chg_pay_table = 'PER_ALL_ASSIGNMENTS_F'
692: AND ben_ext_person.g_chg_pay_column = 'LOCATION_ID'
693: AND ben_ext_person.g_chg_update_type <> 'I'
694: THEN -- this is checking location_event for case (3) and (4)
695:

Line 692: AND ben_ext_person.g_chg_pay_column = 'LOCATION_ID'

688: debug('ben_ext_person.g_chg_update_type:' || ben_ext_person.g_chg_update_type, 30);
689:
690: --
691: IF ben_ext_person.g_chg_pay_table = 'PER_ALL_ASSIGNMENTS_F'
692: AND ben_ext_person.g_chg_pay_column = 'LOCATION_ID'
693: AND ben_ext_person.g_chg_update_type <> 'I'
694: THEN -- this is checking location_event for case (3) and (4)
695:
696: l_ret_location := '******';

Line 693: AND ben_ext_person.g_chg_update_type <> 'I'

689:
690: --
691: IF ben_ext_person.g_chg_pay_table = 'PER_ALL_ASSIGNMENTS_F'
692: AND ben_ext_person.g_chg_pay_column = 'LOCATION_ID'
693: AND ben_ext_person.g_chg_update_type <> 'I'
694: THEN -- this is checking location_event for case (3) and (4)
695:
696: l_ret_location := '******';
697: g_location_change_exists := 'Y';

Line 845: debug('ben_ext_person.g_chg_pay_table:' || ben_ext_person.g_chg_pay_table, 30);

841: l_ret_person_decoration := '********';
842: ELSE
843:
844: debug('honors:' || l_ret_person_decoration, 30);
845: debug('ben_ext_person.g_chg_pay_table:' || ben_ext_person.g_chg_pay_table, 30);
846: debug('ben_ext_person.g_chg_pay_column:' || ben_ext_person.g_chg_pay_column, 30);
847: debug('ben_ext_person.g_chg_update_type:' || ben_ext_person.g_chg_update_type, 30);
848:
849: --

Line 846: debug('ben_ext_person.g_chg_pay_column:' || ben_ext_person.g_chg_pay_column, 30);

842: ELSE
843:
844: debug('honors:' || l_ret_person_decoration, 30);
845: debug('ben_ext_person.g_chg_pay_table:' || ben_ext_person.g_chg_pay_table, 30);
846: debug('ben_ext_person.g_chg_pay_column:' || ben_ext_person.g_chg_pay_column, 30);
847: debug('ben_ext_person.g_chg_update_type:' || ben_ext_person.g_chg_update_type, 30);
848:
849: --
850: IF ben_ext_person.g_chg_pay_table = 'PER_ALL_PEOPLE_F'

Line 847: debug('ben_ext_person.g_chg_update_type:' || ben_ext_person.g_chg_update_type, 30);

843:
844: debug('honors:' || l_ret_person_decoration, 30);
845: debug('ben_ext_person.g_chg_pay_table:' || ben_ext_person.g_chg_pay_table, 30);
846: debug('ben_ext_person.g_chg_pay_column:' || ben_ext_person.g_chg_pay_column, 30);
847: debug('ben_ext_person.g_chg_update_type:' || ben_ext_person.g_chg_update_type, 30);
848:
849: --
850: IF ben_ext_person.g_chg_pay_table = 'PER_ALL_PEOPLE_F'
851: AND

Line 850: IF ben_ext_person.g_chg_pay_table = 'PER_ALL_PEOPLE_F'

846: debug('ben_ext_person.g_chg_pay_column:' || ben_ext_person.g_chg_pay_column, 30);
847: debug('ben_ext_person.g_chg_update_type:' || ben_ext_person.g_chg_update_type, 30);
848:
849: --
850: IF ben_ext_person.g_chg_pay_table = 'PER_ALL_PEOPLE_F'
851: AND
852: ben_ext_person.g_chg_pay_column = 'HONORS'
853: AND
854: ben_ext_person.g_chg_update_type <> 'I'

Line 852: ben_ext_person.g_chg_pay_column = 'HONORS'

848:
849: --
850: IF ben_ext_person.g_chg_pay_table = 'PER_ALL_PEOPLE_F'
851: AND
852: ben_ext_person.g_chg_pay_column = 'HONORS'
853: AND
854: ben_ext_person.g_chg_update_type <> 'I'
855: THEN -- this is checking location_event for case (3) and (4)
856: l_ret_person_decoration := '********';

Line 854: ben_ext_person.g_chg_update_type <> 'I'

850: IF ben_ext_person.g_chg_pay_table = 'PER_ALL_PEOPLE_F'
851: AND
852: ben_ext_person.g_chg_pay_column = 'HONORS'
853: AND
854: ben_ext_person.g_chg_update_type <> 'I'
855: THEN -- this is checking location_event for case (3) and (4)
856: l_ret_person_decoration := '********';
857: g_honors_change_exists := 'Y';
858: ELSE

Line 959: debug('ben_ext_person.g_chg_pay_table:' || ben_ext_person.g_chg_pay_table, 44);

955: l_ret_title := '******';
956: ELSE
957:
958: debug('title:' || l_ret_title, 30);
959: debug('ben_ext_person.g_chg_pay_table:' || ben_ext_person.g_chg_pay_table, 44);
960: debug('ben_ext_person.g_chg_pay_column:' || ben_ext_person.g_chg_pay_column, 44);
961: debug('ben_ext_person.g_chg_update_type:' || ben_ext_person.g_chg_update_type, 44);
962: --
963: IF ben_ext_person.g_chg_pay_table = 'PER_ALL_PEOPLE_F'

Line 960: debug('ben_ext_person.g_chg_pay_column:' || ben_ext_person.g_chg_pay_column, 44);

956: ELSE
957:
958: debug('title:' || l_ret_title, 30);
959: debug('ben_ext_person.g_chg_pay_table:' || ben_ext_person.g_chg_pay_table, 44);
960: debug('ben_ext_person.g_chg_pay_column:' || ben_ext_person.g_chg_pay_column, 44);
961: debug('ben_ext_person.g_chg_update_type:' || ben_ext_person.g_chg_update_type, 44);
962: --
963: IF ben_ext_person.g_chg_pay_table = 'PER_ALL_PEOPLE_F'
964: AND ben_ext_person.g_chg_pay_column = 'TITLE'

Line 961: debug('ben_ext_person.g_chg_update_type:' || ben_ext_person.g_chg_update_type, 44);

957:
958: debug('title:' || l_ret_title, 30);
959: debug('ben_ext_person.g_chg_pay_table:' || ben_ext_person.g_chg_pay_table, 44);
960: debug('ben_ext_person.g_chg_pay_column:' || ben_ext_person.g_chg_pay_column, 44);
961: debug('ben_ext_person.g_chg_update_type:' || ben_ext_person.g_chg_update_type, 44);
962: --
963: IF ben_ext_person.g_chg_pay_table = 'PER_ALL_PEOPLE_F'
964: AND ben_ext_person.g_chg_pay_column = 'TITLE'
965: AND ben_ext_person.g_chg_update_type <> 'I'

Line 963: IF ben_ext_person.g_chg_pay_table = 'PER_ALL_PEOPLE_F'

959: debug('ben_ext_person.g_chg_pay_table:' || ben_ext_person.g_chg_pay_table, 44);
960: debug('ben_ext_person.g_chg_pay_column:' || ben_ext_person.g_chg_pay_column, 44);
961: debug('ben_ext_person.g_chg_update_type:' || ben_ext_person.g_chg_update_type, 44);
962: --
963: IF ben_ext_person.g_chg_pay_table = 'PER_ALL_PEOPLE_F'
964: AND ben_ext_person.g_chg_pay_column = 'TITLE'
965: AND ben_ext_person.g_chg_update_type <> 'I'
966: THEN
967: l_ret_title := '******';

Line 964: AND ben_ext_person.g_chg_pay_column = 'TITLE'

960: debug('ben_ext_person.g_chg_pay_column:' || ben_ext_person.g_chg_pay_column, 44);
961: debug('ben_ext_person.g_chg_update_type:' || ben_ext_person.g_chg_update_type, 44);
962: --
963: IF ben_ext_person.g_chg_pay_table = 'PER_ALL_PEOPLE_F'
964: AND ben_ext_person.g_chg_pay_column = 'TITLE'
965: AND ben_ext_person.g_chg_update_type <> 'I'
966: THEN
967: l_ret_title := '******';
968: g_title_change_exists := 'Y';

Line 965: AND ben_ext_person.g_chg_update_type <> 'I'

961: debug('ben_ext_person.g_chg_update_type:' || ben_ext_person.g_chg_update_type, 44);
962: --
963: IF ben_ext_person.g_chg_pay_table = 'PER_ALL_PEOPLE_F'
964: AND ben_ext_person.g_chg_pay_column = 'TITLE'
965: AND ben_ext_person.g_chg_update_type <> 'I'
966: THEN
967: l_ret_title := '******';
968: g_title_change_exists := 'Y';
969: ELSE

Line 1098: IF (ben_ext_person.g_chg_pay_table = 'PAY_PERSONAL_PAYMENT_METHODS_F'

1094: IF g_current_run = 'CUTOVER'
1095: THEN
1096: p_return := 'X';
1097: ELSE --run is PERIODIC
1098: IF (ben_ext_person.g_chg_pay_table = 'PAY_PERSONAL_PAYMENT_METHODS_F'
1099: AND ben_ext_person.g_chg_update_type = 'I')
1100: OR ben_ext_person.g_chg_pay_table <> 'PAY_PERSONAL_PAYMENT_METHODS_F'
1101: THEN
1102: p_return := 'X';

Line 1099: AND ben_ext_person.g_chg_update_type = 'I')

1095: THEN
1096: p_return := 'X';
1097: ELSE --run is PERIODIC
1098: IF (ben_ext_person.g_chg_pay_table = 'PAY_PERSONAL_PAYMENT_METHODS_F'
1099: AND ben_ext_person.g_chg_update_type = 'I')
1100: OR ben_ext_person.g_chg_pay_table <> 'PAY_PERSONAL_PAYMENT_METHODS_F'
1101: THEN
1102: p_return := 'X';
1103: END IF;

Line 1100: OR ben_ext_person.g_chg_pay_table <> 'PAY_PERSONAL_PAYMENT_METHODS_F'

1096: p_return := 'X';
1097: ELSE --run is PERIODIC
1098: IF (ben_ext_person.g_chg_pay_table = 'PAY_PERSONAL_PAYMENT_METHODS_F'
1099: AND ben_ext_person.g_chg_update_type = 'I')
1100: OR ben_ext_person.g_chg_pay_table <> 'PAY_PERSONAL_PAYMENT_METHODS_F'
1101: THEN
1102: p_return := 'X';
1103: END IF;
1104: END IF;

Line 1641: debug('ben_ext_person.g_chg_pay_table:' || ben_ext_person.g_chg_pay_table, 30);

1637: THEN
1638: l_ret_prevsur := '********************';
1639: ELSE
1640: debug('prev surname:' || l_ret_prevsur, 30);
1641: debug('ben_ext_person.g_chg_pay_table:' || ben_ext_person.g_chg_pay_table, 30);
1642: debug('ben_ext_person.g_chg_pay_column:' || ben_ext_person.g_chg_pay_column, 30);
1643: debug('ben_ext_person.g_chg_update_type:' || ben_ext_person.g_chg_update_type, 30);
1644: --
1645: IF ben_ext_person.g_chg_pay_table = 'PER_ALL_PEOPLE_F'

Line 1642: debug('ben_ext_person.g_chg_pay_column:' || ben_ext_person.g_chg_pay_column, 30);

1638: l_ret_prevsur := '********************';
1639: ELSE
1640: debug('prev surname:' || l_ret_prevsur, 30);
1641: debug('ben_ext_person.g_chg_pay_table:' || ben_ext_person.g_chg_pay_table, 30);
1642: debug('ben_ext_person.g_chg_pay_column:' || ben_ext_person.g_chg_pay_column, 30);
1643: debug('ben_ext_person.g_chg_update_type:' || ben_ext_person.g_chg_update_type, 30);
1644: --
1645: IF ben_ext_person.g_chg_pay_table = 'PER_ALL_PEOPLE_F'
1646: AND ben_ext_person.g_chg_pay_column = 'PREVIOUS_LAST_NAME'

Line 1643: debug('ben_ext_person.g_chg_update_type:' || ben_ext_person.g_chg_update_type, 30);

1639: ELSE
1640: debug('prev surname:' || l_ret_prevsur, 30);
1641: debug('ben_ext_person.g_chg_pay_table:' || ben_ext_person.g_chg_pay_table, 30);
1642: debug('ben_ext_person.g_chg_pay_column:' || ben_ext_person.g_chg_pay_column, 30);
1643: debug('ben_ext_person.g_chg_update_type:' || ben_ext_person.g_chg_update_type, 30);
1644: --
1645: IF ben_ext_person.g_chg_pay_table = 'PER_ALL_PEOPLE_F'
1646: AND ben_ext_person.g_chg_pay_column = 'PREVIOUS_LAST_NAME'
1647: AND ben_ext_person.g_chg_update_type <> 'I'

Line 1645: IF ben_ext_person.g_chg_pay_table = 'PER_ALL_PEOPLE_F'

1641: debug('ben_ext_person.g_chg_pay_table:' || ben_ext_person.g_chg_pay_table, 30);
1642: debug('ben_ext_person.g_chg_pay_column:' || ben_ext_person.g_chg_pay_column, 30);
1643: debug('ben_ext_person.g_chg_update_type:' || ben_ext_person.g_chg_update_type, 30);
1644: --
1645: IF ben_ext_person.g_chg_pay_table = 'PER_ALL_PEOPLE_F'
1646: AND ben_ext_person.g_chg_pay_column = 'PREVIOUS_LAST_NAME'
1647: AND ben_ext_person.g_chg_update_type <> 'I'
1648: THEN -- this is checking location_event for case (3) and (4)
1649: l_ret_prevsur := '********************';

Line 1646: AND ben_ext_person.g_chg_pay_column = 'PREVIOUS_LAST_NAME'

1642: debug('ben_ext_person.g_chg_pay_column:' || ben_ext_person.g_chg_pay_column, 30);
1643: debug('ben_ext_person.g_chg_update_type:' || ben_ext_person.g_chg_update_type, 30);
1644: --
1645: IF ben_ext_person.g_chg_pay_table = 'PER_ALL_PEOPLE_F'
1646: AND ben_ext_person.g_chg_pay_column = 'PREVIOUS_LAST_NAME'
1647: AND ben_ext_person.g_chg_update_type <> 'I'
1648: THEN -- this is checking location_event for case (3) and (4)
1649: l_ret_prevsur := '********************';
1650: g_prevsur_change_exists := 'Y';

Line 1647: AND ben_ext_person.g_chg_update_type <> 'I'

1643: debug('ben_ext_person.g_chg_update_type:' || ben_ext_person.g_chg_update_type, 30);
1644: --
1645: IF ben_ext_person.g_chg_pay_table = 'PER_ALL_PEOPLE_F'
1646: AND ben_ext_person.g_chg_pay_column = 'PREVIOUS_LAST_NAME'
1647: AND ben_ext_person.g_chg_update_type <> 'I'
1648: THEN -- this is checking location_event for case (3) and (4)
1649: l_ret_prevsur := '********************';
1650: g_prevsur_change_exists := 'Y';
1651: ELSE

Line 1684: debug('ben_ext_person.g_chg_pay_table:' || ben_ext_person.g_chg_pay_table, 30);

1680: l_ret_midname := '********************';
1681: ELSE
1682:
1683: debug('middle name:' || l_ret_midname, 30);
1684: debug('ben_ext_person.g_chg_pay_table:' || ben_ext_person.g_chg_pay_table, 30);
1685: debug('ben_ext_person.g_chg_pay_column:' || ben_ext_person.g_chg_pay_column, 30);
1686: debug('ben_ext_person.g_chg_update_type:' || ben_ext_person.g_chg_update_type, 30);
1687:
1688: --

Line 1685: debug('ben_ext_person.g_chg_pay_column:' || ben_ext_person.g_chg_pay_column, 30);

1681: ELSE
1682:
1683: debug('middle name:' || l_ret_midname, 30);
1684: debug('ben_ext_person.g_chg_pay_table:' || ben_ext_person.g_chg_pay_table, 30);
1685: debug('ben_ext_person.g_chg_pay_column:' || ben_ext_person.g_chg_pay_column, 30);
1686: debug('ben_ext_person.g_chg_update_type:' || ben_ext_person.g_chg_update_type, 30);
1687:
1688: --
1689: IF ben_ext_person.g_chg_pay_table = 'PER_ALL_PEOPLE_F'

Line 1686: debug('ben_ext_person.g_chg_update_type:' || ben_ext_person.g_chg_update_type, 30);

1682:
1683: debug('middle name:' || l_ret_midname, 30);
1684: debug('ben_ext_person.g_chg_pay_table:' || ben_ext_person.g_chg_pay_table, 30);
1685: debug('ben_ext_person.g_chg_pay_column:' || ben_ext_person.g_chg_pay_column, 30);
1686: debug('ben_ext_person.g_chg_update_type:' || ben_ext_person.g_chg_update_type, 30);
1687:
1688: --
1689: IF ben_ext_person.g_chg_pay_table = 'PER_ALL_PEOPLE_F'
1690: AND ben_ext_person.g_chg_pay_column = 'MIDDLE_NAMES'

Line 1689: IF ben_ext_person.g_chg_pay_table = 'PER_ALL_PEOPLE_F'

1685: debug('ben_ext_person.g_chg_pay_column:' || ben_ext_person.g_chg_pay_column, 30);
1686: debug('ben_ext_person.g_chg_update_type:' || ben_ext_person.g_chg_update_type, 30);
1687:
1688: --
1689: IF ben_ext_person.g_chg_pay_table = 'PER_ALL_PEOPLE_F'
1690: AND ben_ext_person.g_chg_pay_column = 'MIDDLE_NAMES'
1691: AND ben_ext_person.g_chg_update_type <> 'I'
1692: THEN -- this is checking location_event for case (3) and (4)
1693: l_ret_midname := '********************';

Line 1690: AND ben_ext_person.g_chg_pay_column = 'MIDDLE_NAMES'

1686: debug('ben_ext_person.g_chg_update_type:' || ben_ext_person.g_chg_update_type, 30);
1687:
1688: --
1689: IF ben_ext_person.g_chg_pay_table = 'PER_ALL_PEOPLE_F'
1690: AND ben_ext_person.g_chg_pay_column = 'MIDDLE_NAMES'
1691: AND ben_ext_person.g_chg_update_type <> 'I'
1692: THEN -- this is checking location_event for case (3) and (4)
1693: l_ret_midname := '********************';
1694: g_midname_change_exists := 'Y';

Line 1691: AND ben_ext_person.g_chg_update_type <> 'I'

1687:
1688: --
1689: IF ben_ext_person.g_chg_pay_table = 'PER_ALL_PEOPLE_F'
1690: AND ben_ext_person.g_chg_pay_column = 'MIDDLE_NAMES'
1691: AND ben_ext_person.g_chg_update_type <> 'I'
1692: THEN -- this is checking location_event for case (3) and (4)
1693: l_ret_midname := '********************';
1694: g_midname_change_exists := 'Y';
1695: ELSE

Line 1719: ben_ext_person.g_chg_pay_table = 'PER_ALL_ASSIGNMENTS_F'

1715: -- the logic below is to handle new_hires
1716: -- if new_hire, asterisk behaviour should be like "CUTOVER"
1717: IF g_current_run = 'PERIODIC'
1718: and
1719: ben_ext_person.g_chg_pay_table = 'PER_ALL_ASSIGNMENTS_F'
1720: and
1721: ben_ext_person.g_chg_update_type = 'I'
1722: THEN
1723: p_output := 'CUTOVER';

Line 1721: ben_ext_person.g_chg_update_type = 'I'

1717: IF g_current_run = 'PERIODIC'
1718: and
1719: ben_ext_person.g_chg_pay_table = 'PER_ALL_ASSIGNMENTS_F'
1720: and
1721: ben_ext_person.g_chg_update_type = 'I'
1722: THEN
1723: p_output := 'CUTOVER';
1724: ELSE
1725: p_output := g_current_run;