APPS.PQP_GB_PSI_ADDDRESS dependencies on PER_ALL_PEOPLE_F

Line 653: IF (l_change_table = 'PER_ALL_PEOPLE_F'

649: debug('l_change_table: '||l_change_table,20);
650: debug('l_change_column: '||l_change_column,20);
651: debug('g_current_run: '||g_current_run,20);
652:
653: IF (l_change_table = 'PER_ALL_PEOPLE_F'
654: AND (l_change_column IN ('EMAIL_ADDRESS','MAILSTOP','NATIONAL_IDENTIFIER')))
655: OR l_change_table = 'PER_ALL_ASSIGNMENTS_F'
656: THEN
657: g_office_address_id := NULL;

Line 749: IF (l_change_table = 'PER_ALL_PEOPLE_F'

745: debug('l_change_table: '||l_change_table,20);
746: debug('l_change_column: '||l_change_column,20);
747: debug('g_current_run: '||g_current_run,20);
748:
749: IF (l_change_table = 'PER_ALL_PEOPLE_F'
750: AND (l_change_column IN ('EMAIL_ADDRESS','MAILSTOP','NATIONAL_IDENTIFIER')))
751: OR l_change_table = 'PER_ALL_ASSIGNMENTS_F'
752: THEN
753: g_home_address_id := NULL;

Line 776: END IF;--IF (l_change_table = 'PER_ALL_PEOPLE_F'

772: debug('g_home_address_changed: '||g_home_address_changed,30);
773: debug('Returning: Y',30);
774: debug_exit(l_proc);
775: RETURN g_home_address_changed;
776: END IF;--IF (l_change_table = 'PER_ALL_PEOPLE_F'
777:
778: IF g_person_addresses.exists(l_chg_surrogate_key) THEN
779: IF g_person_addresses(l_chg_surrogate_key).address_type = g_home_address_type THEN
780: g_home_address_id := l_chg_surrogate_key;

Line 1398: l_mailstop PER_ALL_PEOPLE_F.mailstop%TYPE;

1394: p_address_mailstop OUT NOCOPY VARCHAR2
1395: ) RETURN NUMBER
1396: IS
1397: l_proc varchar2(72) := g_package||'.get_address_mailstop';
1398: l_mailstop PER_ALL_PEOPLE_F.mailstop%TYPE;
1399: BEGIN
1400: debug_enter(l_proc);
1401: l_mailstop := NULL;
1402: IF g_current_run = 'CUTOVER' THEN

Line 1467: l_email_address per_all_people_f.email_address%TYPE;

1463: p_emailaddress OUT NOCOPY VARCHAR2
1464: ) RETURN NUMBER
1465: IS
1466: l_proc varchar2(72) := g_package||'.get_emailaddress';
1467: l_email_address per_all_people_f.email_address%TYPE;
1468: BEGIN
1469: debug_enter(l_proc);
1470: l_email_address := NULL;
1471: IF g_current_run = 'CUTOVER' THEN

Line 1717: -- if the chaged values are on per_all_people_f, the surrogate key

1713: IF (g_current_layout = 'OFFICE' AND g_office_address_changed = 'Y') OR
1714: (g_current_layout = 'HOME' AND g_home_address_changed = 'Y') THEN
1715: debug('Record changed: '||g_current_layout,20);
1716:
1717: -- if the chaged values are on per_all_people_f, the surrogate key
1718: -- will be person_id. It is to be set to current address id.
1719: -- The home/office address id are picked up from the respective
1720: -- global variable. These values are set while setting the assignment
1721: -- globals for a cutover run. and during chk_xxx_address_changed function