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 32: L_ADDRESS_TYPE PER_ADDRESSES.ADDRESS_TYPE%type;

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

Line 34: L_COUNTRY PER_ADDRESSES.COUNTRY%type;

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

Line 35: L_ADDRESS_LINE1 PER_ADDRESSES.ADDRESS_LINE1%type;

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

Line 36: L_ADDRESS_LINE2 PER_ADDRESSES.ADDRESS_LINE2%type;

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

Line 37: L_ADDRESS_LINE3 PER_ADDRESSES.ADDRESS_LINE3%type;

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

Line 38: L_TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%type;

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

Line 39: L_TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%type;

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

Line 40: L_REGION_1 PER_ADDRESSES.REGION_1%type;

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

Line 41: L_REGION_2 PER_ADDRESSES.REGION_1%type;

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

Line 42: L_POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%type;

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

Line 49: L_CONTACT_ADDRESSLINE1 PER_ADDRESSES.ADDRESS_LINE1%type;

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

Line 50: L_CONTACT_ADDRESSLINE2 PER_ADDRESSES.ADDRESS_LINE2%type;

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

Line 51: L_CONTACT_ADDRESSLINE3 PER_ADDRESSES.ADDRESS_LINE3%type;

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

Line 52: L_CONTACT_COUNTRY PER_ADDRESSES.COUNTRY%type;

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

Line 53: L_CONTACT_TOWN_OR_CITY PER_ADDRESSES.TOWN_OR_CITY%type;

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

Line 54: L_CONTACT_TELEPHONE_NUMBER_1 PER_ADDRESSES.TELEPHONE_NUMBER_1%type;

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

Line 55: L_CONTACT_REGION_1 PER_ADDRESSES.REGION_1%type;

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

Line 56: L_CONTACT_REGION_2 PER_ADDRESSES.REGION_1%type;

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

Line 57: L_CONTACT_POSTAL_CODE PER_ADDRESSES.POSTAL_CODE%type;

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

Line 134: from per_addresses padr, per_all_people_f papf

130: l_con_bgid number;
131:
132: cursor csr_check_person_add is
133: select style,ADDRESS_ID
134: from per_addresses padr, per_all_people_f papf
135: where (papf.employee_number = P_EMPLOYEE_NUMBER
136: or papf.npw_number = p_cwk_num )
137: and papf.business_group_id =P_BUSINESS_GROUP_ID
138: AND P_EFFECTIVE_DATE BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.EFFECTIVE_END_DATE

Line 155: from per_addresses padr

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

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

463: LOOP
464:
465: L_SQL:= ' begin
466: SELECT ' ||G_ADD_ATTR(I).APPLICATION_COLUMN_NAME ||','||''''||G_ADD_ATTR(I).end_user_column_name||''''||
467: ' INTO :1 ,:2 FROM PER_ADDRESSES WHERE ADDRESS_ID = '||L_ADDRESS_ID ||';
468: end;';
469:
470: EXECUTE IMMEDIATE l_sql using in out L_APP_COL_VALUE,IN OUT l_end_user_col_name1 ;
471:

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

517: LOOP
518:
519: L_SQL:= ' begin
520: SELECT ' ||G_ADD_ATTR(I).APPLICATION_COLUMN_NAME ||','||''''||G_ADD_ATTR(I).end_user_column_name||''''||
521: ' INTO :1 ,:2 FROM PER_ADDRESSES WHERE ADDRESS_ID = '||L_ADDRESS_ID ||';
522: end;';
523:
524: -- Added for the bug 7168149
525: EXECUTE IMMEDIATE l_sql using in out L_APP_COL_VALUE,IN OUT l_end_user_col_name1 ;