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_DE_ORG_INFO dependencies on PER_ASSIGNMENTS_F

Line 44: Function get_liab_prov_details(p_assignment_id in per_assignments_f.assignment_id%TYPE,

40: Procedure chk_for_org_in_hierarchy(p_org_id in hr_organization_units.organization_id%TYPE,
41: p_exists out nocopy varchar2);
42:
43: -- Functions used in the view HR_DE_WORK_INCIDENTS_REPORT
44: Function get_liab_prov_details(p_assignment_id in per_assignments_f.assignment_id%TYPE,
45: p_incident_date in date)
46: Return varchar2;
47: Function get_liab_prov_name(p_assignment_id in per_assignments_f.assignment_id%TYPE)
48: Return varchar2;

Line 47: Function get_liab_prov_name(p_assignment_id in per_assignments_f.assignment_id%TYPE)

43: -- Functions used in the view HR_DE_WORK_INCIDENTS_REPORT
44: Function get_liab_prov_details(p_assignment_id in per_assignments_f.assignment_id%TYPE,
45: p_incident_date in date)
46: Return varchar2;
47: Function get_liab_prov_name(p_assignment_id in per_assignments_f.assignment_id%TYPE)
48: Return varchar2;
49: Function get_liab_prov_membership_no(p_assignment_id in per_assignments_f.assignment_id%TYPE)
50: Return varchar2;
51:

Line 49: Function get_liab_prov_membership_no(p_assignment_id in per_assignments_f.assignment_id%TYPE)

45: p_incident_date in date)
46: Return varchar2;
47: Function get_liab_prov_name(p_assignment_id in per_assignments_f.assignment_id%TYPE)
48: Return varchar2;
49: Function get_liab_prov_membership_no(p_assignment_id in per_assignments_f.assignment_id%TYPE)
50: Return varchar2;
51:
52: Function get_location(p_assignment_id in per_assignments_f.assignment_id%TYPE)
53: Return varchar2;

Line 52: Function get_location(p_assignment_id in per_assignments_f.assignment_id%TYPE)

48: Return varchar2;
49: Function get_liab_prov_membership_no(p_assignment_id in per_assignments_f.assignment_id%TYPE)
50: Return varchar2;
51:
52: Function get_location(p_assignment_id in per_assignments_f.assignment_id%TYPE)
53: Return varchar2;
54: Function get_addr_line1(p_assignment_id in per_assignments_f.assignment_id%TYPE)
55: Return varchar2;
56: Function get_addr_line2(p_assignment_id in per_assignments_f.assignment_id%TYPE)

Line 54: Function get_addr_line1(p_assignment_id in per_assignments_f.assignment_id%TYPE)

50: Return varchar2;
51:
52: Function get_location(p_assignment_id in per_assignments_f.assignment_id%TYPE)
53: Return varchar2;
54: Function get_addr_line1(p_assignment_id in per_assignments_f.assignment_id%TYPE)
55: Return varchar2;
56: Function get_addr_line2(p_assignment_id in per_assignments_f.assignment_id%TYPE)
57: Return varchar2;
58: Function get_addr_line3(p_assignment_id in per_assignments_f.assignment_id%TYPE)

Line 56: Function get_addr_line2(p_assignment_id in per_assignments_f.assignment_id%TYPE)

52: Function get_location(p_assignment_id in per_assignments_f.assignment_id%TYPE)
53: Return varchar2;
54: Function get_addr_line1(p_assignment_id in per_assignments_f.assignment_id%TYPE)
55: Return varchar2;
56: Function get_addr_line2(p_assignment_id in per_assignments_f.assignment_id%TYPE)
57: Return varchar2;
58: Function get_addr_line3(p_assignment_id in per_assignments_f.assignment_id%TYPE)
59: Return varchar2;
60: Function get_town(p_assignment_id in per_assignments_f.assignment_id%TYPE)

Line 58: Function get_addr_line3(p_assignment_id in per_assignments_f.assignment_id%TYPE)

54: Function get_addr_line1(p_assignment_id in per_assignments_f.assignment_id%TYPE)
55: Return varchar2;
56: Function get_addr_line2(p_assignment_id in per_assignments_f.assignment_id%TYPE)
57: Return varchar2;
58: Function get_addr_line3(p_assignment_id in per_assignments_f.assignment_id%TYPE)
59: Return varchar2;
60: Function get_town(p_assignment_id in per_assignments_f.assignment_id%TYPE)
61: Return varchar2;
62: Function get_country(p_assignment_id in per_assignments_f.assignment_id%TYPE)

Line 60: Function get_town(p_assignment_id in per_assignments_f.assignment_id%TYPE)

56: Function get_addr_line2(p_assignment_id in per_assignments_f.assignment_id%TYPE)
57: Return varchar2;
58: Function get_addr_line3(p_assignment_id in per_assignments_f.assignment_id%TYPE)
59: Return varchar2;
60: Function get_town(p_assignment_id in per_assignments_f.assignment_id%TYPE)
61: Return varchar2;
62: Function get_country(p_assignment_id in per_assignments_f.assignment_id%TYPE)
63: Return varchar2;
64: Function get_postal_code(p_assignment_id in per_assignments_f.assignment_id%TYPE)

Line 62: Function get_country(p_assignment_id in per_assignments_f.assignment_id%TYPE)

58: Function get_addr_line3(p_assignment_id in per_assignments_f.assignment_id%TYPE)
59: Return varchar2;
60: Function get_town(p_assignment_id in per_assignments_f.assignment_id%TYPE)
61: Return varchar2;
62: Function get_country(p_assignment_id in per_assignments_f.assignment_id%TYPE)
63: Return varchar2;
64: Function get_postal_code(p_assignment_id in per_assignments_f.assignment_id%TYPE)
65: Return varchar2;
66:

Line 64: Function get_postal_code(p_assignment_id in per_assignments_f.assignment_id%TYPE)

60: Function get_town(p_assignment_id in per_assignments_f.assignment_id%TYPE)
61: Return varchar2;
62: Function get_country(p_assignment_id in per_assignments_f.assignment_id%TYPE)
63: Return varchar2;
64: Function get_postal_code(p_assignment_id in per_assignments_f.assignment_id%TYPE)
65: Return varchar2;
66:
67: Function get_liab_prov_details2(p_assignment_id in per_assignments_f.assignment_id%TYPE,
68: p_incident_date in date)

Line 67: Function get_liab_prov_details2(p_assignment_id in per_assignments_f.assignment_id%TYPE,

63: Return varchar2;
64: Function get_postal_code(p_assignment_id in per_assignments_f.assignment_id%TYPE)
65: Return varchar2;
66:
67: Function get_liab_prov_details2(p_assignment_id in per_assignments_f.assignment_id%TYPE,
68: p_incident_date in date)
69: Return varchar2;
70:
71: Function get_supervising_off(p_assignment_id in per_assignments_f.assignment_id%TYPE,

Line 71: Function get_supervising_off(p_assignment_id in per_assignments_f.assignment_id%TYPE,

67: Function get_liab_prov_details2(p_assignment_id in per_assignments_f.assignment_id%TYPE,
68: p_incident_date in date)
69: Return varchar2;
70:
71: Function get_supervising_off(p_assignment_id in per_assignments_f.assignment_id%TYPE,
72: p_incident_date in date)
73: Return varchar2;
74: Function get_supervising_off_name(p_assignment_id in per_assignments_f.assignment_id%TYPE)
75: Return varchar2;

Line 74: Function get_supervising_off_name(p_assignment_id in per_assignments_f.assignment_id%TYPE)

70:
71: Function get_supervising_off(p_assignment_id in per_assignments_f.assignment_id%TYPE,
72: p_incident_date in date)
73: Return varchar2;
74: Function get_supervising_off_name(p_assignment_id in per_assignments_f.assignment_id%TYPE)
75: Return varchar2;
76: --
77:
78: END;