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;
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:
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;
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)
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)
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)
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)
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)
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:
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)
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,
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;
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;