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.HR_360_MESSAGE dependencies on PER_ADDRESSES

Line 30: L_ADDRESS_TYPE PER_ADDRESSES.ADDRESS_TYPE%type;

26: L_TITLE VARCHAR2(30);
27: L_LAST_NAME PER_ALL_PEOPLE_F.LAST_NAME%type;
28: L_FIRST_NAME PER_ALL_PEOPLE_F.FIRST_NAME%type;
29: L_MIDDLE_NAMES PER_ALL_PEOPLE_F.MIDDLE_NAMES%type;
30: L_ADDRESS_TYPE PER_ADDRESSES.ADDRESS_TYPE%type;
31: L_DATE_FROM DATE;
32: L_COUNTRY PER_ADDRESSES.COUNTRY%type;
33: L_ADDRESS_LINE1 PER_ADDRESSES.ADDRESS_LINE1%type;
34: L_ADDRESS_LINE2 PER_ADDRESSES.ADDRESS_LINE2%type;

Line 32: L_COUNTRY PER_ADDRESSES.COUNTRY%type;

28: L_FIRST_NAME PER_ALL_PEOPLE_F.FIRST_NAME%type;
29: L_MIDDLE_NAMES PER_ALL_PEOPLE_F.MIDDLE_NAMES%type;
30: L_ADDRESS_TYPE PER_ADDRESSES.ADDRESS_TYPE%type;
31: L_DATE_FROM DATE;
32: L_COUNTRY PER_ADDRESSES.COUNTRY%type;
33: L_ADDRESS_LINE1 PER_ADDRESSES.ADDRESS_LINE1%type;
34: L_ADDRESS_LINE2 PER_ADDRESSES.ADDRESS_LINE2%type;
35: L_ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%type;
36: L_TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%type;

Line 33: L_ADDRESS_LINE1 PER_ADDRESSES.ADDRESS_LINE1%type;

29: L_MIDDLE_NAMES PER_ALL_PEOPLE_F.MIDDLE_NAMES%type;
30: L_ADDRESS_TYPE PER_ADDRESSES.ADDRESS_TYPE%type;
31: L_DATE_FROM DATE;
32: L_COUNTRY PER_ADDRESSES.COUNTRY%type;
33: L_ADDRESS_LINE1 PER_ADDRESSES.ADDRESS_LINE1%type;
34: L_ADDRESS_LINE2 PER_ADDRESSES.ADDRESS_LINE2%type;
35: L_ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%type;
36: L_TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%type;
37: L_TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%type;

Line 34: L_ADDRESS_LINE2 PER_ADDRESSES.ADDRESS_LINE2%type;

30: L_ADDRESS_TYPE PER_ADDRESSES.ADDRESS_TYPE%type;
31: L_DATE_FROM DATE;
32: L_COUNTRY PER_ADDRESSES.COUNTRY%type;
33: L_ADDRESS_LINE1 PER_ADDRESSES.ADDRESS_LINE1%type;
34: L_ADDRESS_LINE2 PER_ADDRESSES.ADDRESS_LINE2%type;
35: L_ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%type;
36: L_TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%type;
37: L_TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%type;
38: L_REGION_1 PER_ADDRESSES.REGION_1%type;

Line 35: L_ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%type;

31: L_DATE_FROM DATE;
32: L_COUNTRY PER_ADDRESSES.COUNTRY%type;
33: L_ADDRESS_LINE1 PER_ADDRESSES.ADDRESS_LINE1%type;
34: L_ADDRESS_LINE2 PER_ADDRESSES.ADDRESS_LINE2%type;
35: L_ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%type;
36: L_TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%type;
37: L_TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%type;
38: L_REGION_1 PER_ADDRESSES.REGION_1%type;
39: L_REGION_2 PER_ADDRESSES.REGION_1%type;

Line 36: L_TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%type;

32: L_COUNTRY PER_ADDRESSES.COUNTRY%type;
33: L_ADDRESS_LINE1 PER_ADDRESSES.ADDRESS_LINE1%type;
34: L_ADDRESS_LINE2 PER_ADDRESSES.ADDRESS_LINE2%type;
35: L_ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%type;
36: L_TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%type;
37: L_TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%type;
38: L_REGION_1 PER_ADDRESSES.REGION_1%type;
39: L_REGION_2 PER_ADDRESSES.REGION_1%type;
40: L_POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%type;

Line 37: L_TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%type;

33: L_ADDRESS_LINE1 PER_ADDRESSES.ADDRESS_LINE1%type;
34: L_ADDRESS_LINE2 PER_ADDRESSES.ADDRESS_LINE2%type;
35: L_ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%type;
36: L_TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%type;
37: L_TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%type;
38: L_REGION_1 PER_ADDRESSES.REGION_1%type;
39: L_REGION_2 PER_ADDRESSES.REGION_1%type;
40: L_POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%type;
41: L_EMAIL_ADDRESS PER_ALL_PEOPLE_F.EMAIL_ADDRESS%type;

Line 38: L_REGION_1 PER_ADDRESSES.REGION_1%type;

34: L_ADDRESS_LINE2 PER_ADDRESSES.ADDRESS_LINE2%type;
35: L_ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%type;
36: L_TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%type;
37: L_TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%type;
38: L_REGION_1 PER_ADDRESSES.REGION_1%type;
39: L_REGION_2 PER_ADDRESSES.REGION_1%type;
40: L_POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%type;
41: L_EMAIL_ADDRESS PER_ALL_PEOPLE_F.EMAIL_ADDRESS%type;
42: L_PHONE_TYPE PER_PHONES.PHONE_TYPE%type;

Line 39: L_REGION_2 PER_ADDRESSES.REGION_1%type;

35: L_ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%type;
36: L_TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%type;
37: L_TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%type;
38: L_REGION_1 PER_ADDRESSES.REGION_1%type;
39: L_REGION_2 PER_ADDRESSES.REGION_1%type;
40: L_POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%type;
41: L_EMAIL_ADDRESS PER_ALL_PEOPLE_F.EMAIL_ADDRESS%type;
42: L_PHONE_TYPE PER_PHONES.PHONE_TYPE%type;
43: L_PHONE_NUMBER PER_PHONES.PHONE_NUMBER%type;

Line 40: L_POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%type;

36: L_TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%type;
37: L_TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%type;
38: L_REGION_1 PER_ADDRESSES.REGION_1%type;
39: L_REGION_2 PER_ADDRESSES.REGION_1%type;
40: L_POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%type;
41: L_EMAIL_ADDRESS PER_ALL_PEOPLE_F.EMAIL_ADDRESS%type;
42: L_PHONE_TYPE PER_PHONES.PHONE_TYPE%type;
43: L_PHONE_NUMBER PER_PHONES.PHONE_NUMBER%type;
44: L_NATIONALITY VARCHAR2(30);

Line 47: L_CONTACT_ADDRESSLINE1 PER_ADDRESSES.ADDRESS_LINE1%type;

43: L_PHONE_NUMBER PER_PHONES.PHONE_NUMBER%type;
44: L_NATIONALITY VARCHAR2(30);
45: L_NATIONAL_IDENTIFIER PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER%type;
46: L_CONTACT_NAME VARCHAR2(240);
47: L_CONTACT_ADDRESSLINE1 PER_ADDRESSES.ADDRESS_LINE1%type;
48: L_CONTACT_ADDRESSLINE2 PER_ADDRESSES.ADDRESS_LINE2%type;
49: L_CONTACT_ADDRESSLINE3 PER_ADDRESSES.ADDRESS_LINE3%type;
50: L_CONTACT_COUNTRY PER_ADDRESSES.COUNTRY%type;
51: L_CONTACT_TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%type;

Line 48: L_CONTACT_ADDRESSLINE2 PER_ADDRESSES.ADDRESS_LINE2%type;

44: L_NATIONALITY VARCHAR2(30);
45: L_NATIONAL_IDENTIFIER PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER%type;
46: L_CONTACT_NAME VARCHAR2(240);
47: L_CONTACT_ADDRESSLINE1 PER_ADDRESSES.ADDRESS_LINE1%type;
48: L_CONTACT_ADDRESSLINE2 PER_ADDRESSES.ADDRESS_LINE2%type;
49: L_CONTACT_ADDRESSLINE3 PER_ADDRESSES.ADDRESS_LINE3%type;
50: L_CONTACT_COUNTRY PER_ADDRESSES.COUNTRY%type;
51: L_CONTACT_TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%type;
52: L_CONTACT_TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%type;

Line 49: L_CONTACT_ADDRESSLINE3 PER_ADDRESSES.ADDRESS_LINE3%type;

45: L_NATIONAL_IDENTIFIER PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER%type;
46: L_CONTACT_NAME VARCHAR2(240);
47: L_CONTACT_ADDRESSLINE1 PER_ADDRESSES.ADDRESS_LINE1%type;
48: L_CONTACT_ADDRESSLINE2 PER_ADDRESSES.ADDRESS_LINE2%type;
49: L_CONTACT_ADDRESSLINE3 PER_ADDRESSES.ADDRESS_LINE3%type;
50: L_CONTACT_COUNTRY PER_ADDRESSES.COUNTRY%type;
51: L_CONTACT_TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%type;
52: L_CONTACT_TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%type;
53: L_CONTACT_REGION_1 PER_ADDRESSES.REGION_1%type;

Line 50: L_CONTACT_COUNTRY PER_ADDRESSES.COUNTRY%type;

46: L_CONTACT_NAME VARCHAR2(240);
47: L_CONTACT_ADDRESSLINE1 PER_ADDRESSES.ADDRESS_LINE1%type;
48: L_CONTACT_ADDRESSLINE2 PER_ADDRESSES.ADDRESS_LINE2%type;
49: L_CONTACT_ADDRESSLINE3 PER_ADDRESSES.ADDRESS_LINE3%type;
50: L_CONTACT_COUNTRY PER_ADDRESSES.COUNTRY%type;
51: L_CONTACT_TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%type;
52: L_CONTACT_TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%type;
53: L_CONTACT_REGION_1 PER_ADDRESSES.REGION_1%type;
54: L_CONTACT_REGION_2 PER_ADDRESSES.REGION_1%type;

Line 51: L_CONTACT_TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%type;

47: L_CONTACT_ADDRESSLINE1 PER_ADDRESSES.ADDRESS_LINE1%type;
48: L_CONTACT_ADDRESSLINE2 PER_ADDRESSES.ADDRESS_LINE2%type;
49: L_CONTACT_ADDRESSLINE3 PER_ADDRESSES.ADDRESS_LINE3%type;
50: L_CONTACT_COUNTRY PER_ADDRESSES.COUNTRY%type;
51: L_CONTACT_TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%type;
52: L_CONTACT_TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%type;
53: L_CONTACT_REGION_1 PER_ADDRESSES.REGION_1%type;
54: L_CONTACT_REGION_2 PER_ADDRESSES.REGION_1%type;
55: L_CONTACT_POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%type;

Line 52: L_CONTACT_TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%type;

48: L_CONTACT_ADDRESSLINE2 PER_ADDRESSES.ADDRESS_LINE2%type;
49: L_CONTACT_ADDRESSLINE3 PER_ADDRESSES.ADDRESS_LINE3%type;
50: L_CONTACT_COUNTRY PER_ADDRESSES.COUNTRY%type;
51: L_CONTACT_TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%type;
52: L_CONTACT_TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%type;
53: L_CONTACT_REGION_1 PER_ADDRESSES.REGION_1%type;
54: L_CONTACT_REGION_2 PER_ADDRESSES.REGION_1%type;
55: L_CONTACT_POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%type;
56: L_RELATIONSHIP VARCHAR2(30);

Line 53: L_CONTACT_REGION_1 PER_ADDRESSES.REGION_1%type;

49: L_CONTACT_ADDRESSLINE3 PER_ADDRESSES.ADDRESS_LINE3%type;
50: L_CONTACT_COUNTRY PER_ADDRESSES.COUNTRY%type;
51: L_CONTACT_TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%type;
52: L_CONTACT_TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%type;
53: L_CONTACT_REGION_1 PER_ADDRESSES.REGION_1%type;
54: L_CONTACT_REGION_2 PER_ADDRESSES.REGION_1%type;
55: L_CONTACT_POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%type;
56: L_RELATIONSHIP VARCHAR2(30);
57: l_EMP_JOB_NAME VARCHAR2(700);

Line 54: L_CONTACT_REGION_2 PER_ADDRESSES.REGION_1%type;

50: L_CONTACT_COUNTRY PER_ADDRESSES.COUNTRY%type;
51: L_CONTACT_TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%type;
52: L_CONTACT_TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%type;
53: L_CONTACT_REGION_1 PER_ADDRESSES.REGION_1%type;
54: L_CONTACT_REGION_2 PER_ADDRESSES.REGION_1%type;
55: L_CONTACT_POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%type;
56: L_RELATIONSHIP VARCHAR2(30);
57: l_EMP_JOB_NAME VARCHAR2(700);
58: L_EMP_GRADE_NAME VARCHAR2(240);

Line 55: L_CONTACT_POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%type;

51: L_CONTACT_TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%type;
52: L_CONTACT_TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%type;
53: L_CONTACT_REGION_1 PER_ADDRESSES.REGION_1%type;
54: L_CONTACT_REGION_2 PER_ADDRESSES.REGION_1%type;
55: L_CONTACT_POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%type;
56: L_RELATIONSHIP VARCHAR2(30);
57: l_EMP_JOB_NAME VARCHAR2(700);
58: L_EMP_GRADE_NAME VARCHAR2(240);
59: L_POSITION_NAME VARCHAR2(240);

Line 132: from per_addresses padr, per_all_people_f papf

128: l_con_bgid number;
129:
130: cursor csr_check_person_add is
131: select style,ADDRESS_ID
132: from per_addresses padr, per_all_people_f papf
133: where papf.employee_number =P_EMPLOYEE_NUMBER
134: and papf.business_group_id =P_BUSINESS_GROUP_ID
135: AND P_EFFECTIVE_DATE BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.EFFECTIVE_END_DATE
136: AND PADR.PERSON_ID=PAPF.PERSON_ID

Line 152: from per_addresses padr

148: ORDER BY column_seq_num;
149:
150: CURSOR CSR_GET_CONTACT_ADD (P_PERSONID NUMBER, P_BG_ID NUMBER) IS
151: select style,ADDRESS_ID
152: from per_addresses padr
153: where person_id=P_PERSONID and BUSINESS_GROUP_ID =P_BG_ID;
154:
155: /*Modified the cursor to select the employee number for the ex-employees also
156: for the bug 6892089*/

Line 461: ' INTO :1 ,:2 FROM PER_ADDRESSES WHERE ADDRESS_ID = '||L_ADDRESS_ID ||';

457: LOOP
458:
459: L_SQL:= ' begin
460: SELECT ' ||G_ADD_ATTR(I).APPLICATION_COLUMN_NAME ||','||''''||G_ADD_ATTR(I).end_user_column_name||''''||
461: ' INTO :1 ,:2 FROM PER_ADDRESSES WHERE ADDRESS_ID = '||L_ADDRESS_ID ||';
462: end;';
463:
464: EXECUTE IMMEDIATE l_sql using in out L_APP_COL_VALUE,IN OUT l_end_user_col_name1 ;
465:

Line 515: ' INTO :1 ,:2 FROM PER_ADDRESSES WHERE ADDRESS_ID = '||L_ADDRESS_ID ||';

511: LOOP
512:
513: L_SQL:= ' begin
514: SELECT ' ||G_ADD_ATTR(I).APPLICATION_COLUMN_NAME ||','||''''||G_ADD_ATTR(I).end_user_column_name||''''||
515: ' INTO :1 ,:2 FROM PER_ADDRESSES WHERE ADDRESS_ID = '||L_ADDRESS_ID ||';
516: end;';
517:
518: -- EXECUTE IMMEDIATE l_sql using in out L_APP_COL_VALUE,IN OUT l_end_user_col_name1 ;
519: