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.PER_INC_BUS dependencies on PER_WORK_INCIDENTS

Line 28: from per_work_incidents inc

24: -- Declare cursor
25: --
26: cursor csr_sec_grp is
27: select null
28: from per_work_incidents inc
29: ,per_people_f per
30: ,hr_organization_information hoi
31: where inc.incident_id = p_incident_id
32: and per.person_id = inc.person_id

Line 91: from per_work_incidents inc,

87: -- Declare cursor
88: --
89: cursor csr_leg_code is
90: select pbg.legislation_code
91: from per_work_incidents inc,
92: per_people_f per,
93: per_business_groups pbg
94: where inc.incident_id = p_incident_id
95: and inc.person_id = per.person_id

Line 439: ,p_descflex_name => 'PER_WORK_INCIDENTS'

435: -- b) During insert.
436: --
437: hr_dflex_utility.ins_or_upd_descflex_attribs
438: (p_appl_short_name => 'PER'
439: ,p_descflex_name => 'PER_WORK_INCIDENTS'
440: ,p_attribute_category => p_rec.ATTRIBUTE_CATEGORY
441: ,p_attribute1_name => 'ATTRIBUTE1'
442: ,p_attribute1_value => p_rec.attribute1
443: ,p_attribute2_name => 'ATTRIBUTE2'

Line 610: (p_incident_id in per_work_incidents.incident_id%TYPE,

606: -- {End of Comments}
607: --
608: -- ---------------------------------------------------------------------------
609: procedure chk_person_id
610: (p_incident_id in per_work_incidents.incident_id%TYPE,
611: p_person_id in per_work_incidents.person_id%TYPE,
612: p_effective_date in date
613: ) is
614: --

Line 611: p_person_id in per_work_incidents.person_id%TYPE,

607: --
608: -- ---------------------------------------------------------------------------
609: procedure chk_person_id
610: (p_incident_id in per_work_incidents.incident_id%TYPE,
611: p_person_id in per_work_incidents.person_id%TYPE,
612: p_effective_date in date
613: ) is
614: --
615: l_proc varchar2(72) := g_package||'chk_person_id';

Line 691: (p_incident_date in per_work_incidents.incident_date%TYPE

687: -- {End of Comments}
688: --
689: -- ---------------------------------------------------------------------------
690: procedure chk_incident_date
691: (p_incident_date in per_work_incidents.incident_date%TYPE
692: ) is
693: --
694: l_proc varchar2(72) := g_package||'chk_incident_date';
695: --

Line 739: (p_incident_time in per_work_incidents.incident_time%TYPE

735: -- {End of Comments}
736: --
737: -- ---------------------------------------------------------------------------
738: procedure chk_incident_time
739: (p_incident_time in per_work_incidents.incident_time%TYPE
740: ) is
741: --
742: l_proc varchar2(72) := g_package||'chk_incident_time';
743: l_value varchar2(60) := p_incident_time;

Line 797: l_case_num per_work_incidents.incident_reference%type;

793: FOR UPDATE OF next_value NOWAIT;
794: --
795: -- Declare local variables
796: --
797: l_case_num per_work_incidents.incident_reference%type;
798: l_next_num per_us_osha_numbers.next_value%type;
799: p_year number;
800: l_proc varchar2(72) := g_package||'get_osha_case_number';
801: --

Line 869: (p_incident_id in per_work_incidents.incident_id%TYPE

865: -- {End of Comments}
866: --
867: -- ---------------------------------------------------------------------------
868: procedure chk_incident_reference
869: (p_incident_id in per_work_incidents.incident_id%TYPE
870: ,p_incident_reference in per_work_incidents.incident_reference%TYPE
871: ,p_object_version_number in per_work_incidents.object_version_number%TYPE) is
872: --
873: cursor csr_ref_unique is

Line 870: ,p_incident_reference in per_work_incidents.incident_reference%TYPE

866: --
867: -- ---------------------------------------------------------------------------
868: procedure chk_incident_reference
869: (p_incident_id in per_work_incidents.incident_id%TYPE
870: ,p_incident_reference in per_work_incidents.incident_reference%TYPE
871: ,p_object_version_number in per_work_incidents.object_version_number%TYPE) is
872: --
873: cursor csr_ref_unique is
874: select null

Line 871: ,p_object_version_number in per_work_incidents.object_version_number%TYPE) is

867: -- ---------------------------------------------------------------------------
868: procedure chk_incident_reference
869: (p_incident_id in per_work_incidents.incident_id%TYPE
870: ,p_incident_reference in per_work_incidents.incident_reference%TYPE
871: ,p_object_version_number in per_work_incidents.object_version_number%TYPE) is
872: --
873: cursor csr_ref_unique is
874: select null
875: from per_work_incidents pwi

Line 875: from per_work_incidents pwi

871: ,p_object_version_number in per_work_incidents.object_version_number%TYPE) is
872: --
873: cursor csr_ref_unique is
874: select null
875: from per_work_incidents pwi
876: where upper(pwi.incident_reference) = upper(p_incident_reference);
877: --
878: l_proc varchar2(72) := g_package||'chk_incident_reference';
879: l_dummy varchar2(30);

Line 966: (p_incident_id in per_work_incidents.incident_id%TYPE,

962: --
963: -- {End Of Comments}
964: -- ----------------------------------------------------------------------------
965: procedure chk_incident_type
966: (p_incident_id in per_work_incidents.incident_id%TYPE,
967: p_incident_type in per_work_incidents.incident_type%TYPE,
968: p_effective_date in date) is
969: --
970: l_proc varchar2(72) := g_package||'chk_incident_type';

Line 967: p_incident_type in per_work_incidents.incident_type%TYPE,

963: -- {End Of Comments}
964: -- ----------------------------------------------------------------------------
965: procedure chk_incident_type
966: (p_incident_id in per_work_incidents.incident_id%TYPE,
967: p_incident_type in per_work_incidents.incident_type%TYPE,
968: p_effective_date in date) is
969: --
970: l_proc varchar2(72) := g_package||'chk_incident_type';
971: --

Line 1078: (p_incident_id in per_work_incidents.incident_id%TYPE

1074: -- {End of Comments}
1075: --
1076: -- ---------------------------------------------------------------------------
1077: procedure chk_related_incident_id
1078: (p_incident_id in per_work_incidents.incident_id%TYPE
1079: ,p_related_incident_id in per_work_incidents.related_incident_id%TYPE
1080: ,p_person_id in per_work_incidents.person_id%TYPE
1081: ,p_incident_date in per_work_incidents.incident_date%TYPE) is
1082: --

Line 1079: ,p_related_incident_id in per_work_incidents.related_incident_id%TYPE

1075: --
1076: -- ---------------------------------------------------------------------------
1077: procedure chk_related_incident_id
1078: (p_incident_id in per_work_incidents.incident_id%TYPE
1079: ,p_related_incident_id in per_work_incidents.related_incident_id%TYPE
1080: ,p_person_id in per_work_incidents.person_id%TYPE
1081: ,p_incident_date in per_work_incidents.incident_date%TYPE) is
1082: --
1083: cursor csr_rel_inc is

Line 1080: ,p_person_id in per_work_incidents.person_id%TYPE

1076: -- ---------------------------------------------------------------------------
1077: procedure chk_related_incident_id
1078: (p_incident_id in per_work_incidents.incident_id%TYPE
1079: ,p_related_incident_id in per_work_incidents.related_incident_id%TYPE
1080: ,p_person_id in per_work_incidents.person_id%TYPE
1081: ,p_incident_date in per_work_incidents.incident_date%TYPE) is
1082: --
1083: cursor csr_rel_inc is
1084: select null

Line 1081: ,p_incident_date in per_work_incidents.incident_date%TYPE) is

1077: procedure chk_related_incident_id
1078: (p_incident_id in per_work_incidents.incident_id%TYPE
1079: ,p_related_incident_id in per_work_incidents.related_incident_id%TYPE
1080: ,p_person_id in per_work_incidents.person_id%TYPE
1081: ,p_incident_date in per_work_incidents.incident_date%TYPE) is
1082: --
1083: cursor csr_rel_inc is
1084: select null
1085: from per_work_incidents pwi

Line 1085: from per_work_incidents pwi

1081: ,p_incident_date in per_work_incidents.incident_date%TYPE) is
1082: --
1083: cursor csr_rel_inc is
1084: select null
1085: from per_work_incidents pwi
1086: where pwi.incident_id = p_related_incident_id
1087: and pwi.person_id = p_person_id
1088: and pwi.incident_date <= p_incident_date;
1089: --

Line 1154: (p_org_notified_date in per_work_incidents.org_notified_date%TYPE

1150: -- {End of Comments}
1151: --
1152: -- ---------------------------------------------------------------------------
1153: procedure chk_org_notified_date
1154: (p_org_notified_date in per_work_incidents.org_notified_date%TYPE
1155: ,p_incident_date in per_work_incidents.incident_date%TYPE
1156: ) is
1157: --
1158: l_proc varchar2(72) := g_package||'chk_org_notified_date';

Line 1155: ,p_incident_date in per_work_incidents.incident_date%TYPE

1151: --
1152: -- ---------------------------------------------------------------------------
1153: procedure chk_org_notified_date
1154: (p_org_notified_date in per_work_incidents.org_notified_date%TYPE
1155: ,p_incident_date in per_work_incidents.incident_date%TYPE
1156: ) is
1157: --
1158: l_proc varchar2(72) := g_package||'chk_org_notified_date';
1159: --

Line 1199: (p_over_time_flag in per_work_incidents.over_time_flag%TYPE) is

1195: --
1196: -- {End Of Comments}
1197: -- ----------------------------------------------------------------------------
1198: procedure chk_over_time_flag
1199: (p_over_time_flag in per_work_incidents.over_time_flag%TYPE) is
1200: --
1201: l_proc varchar2(72) := g_package||'chk_over_time_flag';
1202: --
1203: begin

Line 1243: (p_incident_id in per_work_incidents.incident_id%TYPE,

1239: --
1240: -- {End Of Comments}
1241: -- ----------------------------------------------------------------------------
1242: procedure chk_at_work_flag
1243: (p_incident_id in per_work_incidents.incident_id%TYPE,
1244: p_at_work_flag in per_work_incidents.at_work_flag%TYPE,
1245: p_effective_date in date) is
1246: --
1247: l_proc varchar2(72) := g_package||'chk_at_work_flag';

Line 1244: p_at_work_flag in per_work_incidents.at_work_flag%TYPE,

1240: -- {End Of Comments}
1241: -- ----------------------------------------------------------------------------
1242: procedure chk_at_work_flag
1243: (p_incident_id in per_work_incidents.incident_id%TYPE,
1244: p_at_work_flag in per_work_incidents.at_work_flag%TYPE,
1245: p_effective_date in date) is
1246: --
1247: l_proc varchar2(72) := g_package||'chk_at_work_flag';
1248: --

Line 1329: (p_incident_id in per_work_incidents.incident_id%TYPE,

1325: --
1326: -- {End Of Comments}
1327: -- ----------------------------------------------------------------------------
1328: procedure chk_hazard_type
1329: (p_incident_id in per_work_incidents.incident_id%TYPE,
1330: p_hazard_type in per_work_incidents.at_work_flag%TYPE,
1331: p_effective_date in date) is
1332: --
1333: l_proc varchar2(72) := g_package||'chk_hazard_type';

Line 1330: p_hazard_type in per_work_incidents.at_work_flag%TYPE,

1326: -- {End Of Comments}
1327: -- ----------------------------------------------------------------------------
1328: procedure chk_hazard_type
1329: (p_incident_id in per_work_incidents.incident_id%TYPE,
1330: p_hazard_type in per_work_incidents.at_work_flag%TYPE,
1331: p_effective_date in date) is
1332: --
1333: l_proc varchar2(72) := g_package||'chk_hazard_type';
1334: --

Line 1404: (p_incident_id in per_work_incidents.incident_id%TYPE,

1400: --
1401: -- {End Of Comments}
1402: -- ----------------------------------------------------------------------------
1403: procedure chk_injury_type
1404: (p_incident_id in per_work_incidents.incident_id%TYPE,
1405: p_injury_type in per_work_incidents.at_work_flag%TYPE,
1406: p_effective_date in date) is
1407: --
1408: l_proc varchar2(72) := g_package||'chk_injury_type';

Line 1405: p_injury_type in per_work_incidents.at_work_flag%TYPE,

1401: -- {End Of Comments}
1402: -- ----------------------------------------------------------------------------
1403: procedure chk_injury_type
1404: (p_incident_id in per_work_incidents.incident_id%TYPE,
1405: p_injury_type in per_work_incidents.at_work_flag%TYPE,
1406: p_effective_date in date) is
1407: --
1408: l_proc varchar2(72) := g_package||'chk_injury_type';
1409: --

Line 1479: (p_incident_id in per_work_incidents.incident_id%TYPE,

1475: --
1476: -- {End Of Comments}
1477: -- ----------------------------------------------------------------------------
1478: procedure chk_disease_type
1479: (p_incident_id in per_work_incidents.incident_id%TYPE,
1480: p_disease_type in per_work_incidents.at_work_flag%TYPE,
1481: p_effective_date in date) is
1482: --
1483: l_proc varchar2(72) := g_package||'chk_disease_type';

Line 1480: p_disease_type in per_work_incidents.at_work_flag%TYPE,

1476: -- {End Of Comments}
1477: -- ----------------------------------------------------------------------------
1478: procedure chk_disease_type
1479: (p_incident_id in per_work_incidents.incident_id%TYPE,
1480: p_disease_type in per_work_incidents.at_work_flag%TYPE,
1481: p_effective_date in date) is
1482: --
1483: l_proc varchar2(72) := g_package||'chk_disease_type';
1484: --

Line 1556: (p_work_start_time in per_work_incidents.work_start_time%TYPE

1552: -- {End of Comments}
1553: --
1554: -- ---------------------------------------------------------------------------
1555: procedure chk_work_start_time
1556: (p_work_start_time in per_work_incidents.work_start_time%TYPE
1557: ) is
1558: --
1559: l_proc varchar2(72) := g_package||'chk_work_start_time';
1560: l_value varchar2(60) := p_work_start_time;

Line 1622: (p_incident_date in per_work_incidents.incident_date%TYPE

1618: -- {End of Comments}
1619: --
1620: -- ---------------------------------------------------------------------------
1621: procedure chk_date_of_death
1622: (p_incident_date in per_work_incidents.incident_date%TYPE
1623: ,p_date_of_death in per_work_incidents.date_of_death%TYPE
1624: ) is
1625: --
1626: l_proc varchar2(72) := g_package||'chk_date_of_death';

Line 1623: ,p_date_of_death in per_work_incidents.date_of_death%TYPE

1619: --
1620: -- ---------------------------------------------------------------------------
1621: procedure chk_date_of_death
1622: (p_incident_date in per_work_incidents.incident_date%TYPE
1623: ,p_date_of_death in per_work_incidents.date_of_death%TYPE
1624: ) is
1625: --
1626: l_proc varchar2(72) := g_package||'chk_date_of_death';
1627: l_dummy varchar2(1);

Line 1670: (p_hospitalized_flag in per_work_incidents.hospitalized_flag%TYPE) is

1666: --
1667: -- {End Of Comments}
1668: -- ----------------------------------------------------------------------------
1669: procedure chk_hospitalized_flag
1670: (p_hospitalized_flag in per_work_incidents.hospitalized_flag%TYPE) is
1671: --
1672: l_proc varchar2(72) := g_package||'chk_hospitalized_flag';
1673: --
1674: begin

Line 1713: (p_privacy_issue in per_work_incidents.privacy_issue%TYPE) is

1709: --
1710: -- {End Of Comments}
1711: -- ----------------------------------------------------------------------------
1712: procedure chk_privacy_issue
1713: (p_privacy_issue in per_work_incidents.privacy_issue%TYPE) is
1714: --
1715: l_proc varchar2(72) := g_package||'chk_privacy_issue';
1716: --
1717: begin

Line 1756: (p_emergency_code in per_work_incidents.emergency_code%TYPE) is

1752: --
1753: -- {End Of Comments}
1754: -- ----------------------------------------------------------------------------
1755: procedure chk_emergency_code
1756: (p_emergency_code in per_work_incidents.emergency_code%TYPE) is
1757: --
1758: l_proc varchar2(72) := g_package||'chk_emergency_code';
1759: --
1760: begin

Line 1812: (p_incident_id in per_work_incidents.incident_id%TYPE

1808: -- {End of Comments}
1809: --
1810: -- ---------------------------------------------------------------------------
1811: procedure chk_person_reported_date_time
1812: (p_incident_id in per_work_incidents.incident_id%TYPE
1813: ,p_incident_date in per_work_incidents.incident_date%TYPE
1814: ,p_incident_time in per_work_incidents.incident_time%TYPE
1815: ,p_person_reported_by in per_work_incidents.person_reported_by%TYPE
1816: ,p_report_date in per_work_incidents.report_date%TYPE

Line 1813: ,p_incident_date in per_work_incidents.incident_date%TYPE

1809: --
1810: -- ---------------------------------------------------------------------------
1811: procedure chk_person_reported_date_time
1812: (p_incident_id in per_work_incidents.incident_id%TYPE
1813: ,p_incident_date in per_work_incidents.incident_date%TYPE
1814: ,p_incident_time in per_work_incidents.incident_time%TYPE
1815: ,p_person_reported_by in per_work_incidents.person_reported_by%TYPE
1816: ,p_report_date in per_work_incidents.report_date%TYPE
1817: ,p_report_time in per_work_incidents.report_time%TYPE

Line 1814: ,p_incident_time in per_work_incidents.incident_time%TYPE

1810: -- ---------------------------------------------------------------------------
1811: procedure chk_person_reported_date_time
1812: (p_incident_id in per_work_incidents.incident_id%TYPE
1813: ,p_incident_date in per_work_incidents.incident_date%TYPE
1814: ,p_incident_time in per_work_incidents.incident_time%TYPE
1815: ,p_person_reported_by in per_work_incidents.person_reported_by%TYPE
1816: ,p_report_date in per_work_incidents.report_date%TYPE
1817: ,p_report_time in per_work_incidents.report_time%TYPE
1818: ,p_business_group_id in per_all_people_f.business_group_id%TYPE

Line 1815: ,p_person_reported_by in per_work_incidents.person_reported_by%TYPE

1811: procedure chk_person_reported_date_time
1812: (p_incident_id in per_work_incidents.incident_id%TYPE
1813: ,p_incident_date in per_work_incidents.incident_date%TYPE
1814: ,p_incident_time in per_work_incidents.incident_time%TYPE
1815: ,p_person_reported_by in per_work_incidents.person_reported_by%TYPE
1816: ,p_report_date in per_work_incidents.report_date%TYPE
1817: ,p_report_time in per_work_incidents.report_time%TYPE
1818: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
1819: ,p_object_version_number in per_work_incidents.object_version_number%TYPE

Line 1816: ,p_report_date in per_work_incidents.report_date%TYPE

1812: (p_incident_id in per_work_incidents.incident_id%TYPE
1813: ,p_incident_date in per_work_incidents.incident_date%TYPE
1814: ,p_incident_time in per_work_incidents.incident_time%TYPE
1815: ,p_person_reported_by in per_work_incidents.person_reported_by%TYPE
1816: ,p_report_date in per_work_incidents.report_date%TYPE
1817: ,p_report_time in per_work_incidents.report_time%TYPE
1818: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
1819: ,p_object_version_number in per_work_incidents.object_version_number%TYPE
1820: ) is

Line 1817: ,p_report_time in per_work_incidents.report_time%TYPE

1813: ,p_incident_date in per_work_incidents.incident_date%TYPE
1814: ,p_incident_time in per_work_incidents.incident_time%TYPE
1815: ,p_person_reported_by in per_work_incidents.person_reported_by%TYPE
1816: ,p_report_date in per_work_incidents.report_date%TYPE
1817: ,p_report_time in per_work_incidents.report_time%TYPE
1818: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
1819: ,p_object_version_number in per_work_incidents.object_version_number%TYPE
1820: ) is
1821: --

Line 1819: ,p_object_version_number in per_work_incidents.object_version_number%TYPE

1815: ,p_person_reported_by in per_work_incidents.person_reported_by%TYPE
1816: ,p_report_date in per_work_incidents.report_date%TYPE
1817: ,p_report_time in per_work_incidents.report_time%TYPE
1818: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
1819: ,p_object_version_number in per_work_incidents.object_version_number%TYPE
1820: ) is
1821: --
1822: cursor c_person is
1823: select null

Line 1918: (p_incident_id in per_work_incidents.incident_id%TYPE,

1914: --
1915: -- {End Of Comments}
1916: -- ----------------------------------------------------------------------------
1917: procedure chk_report_method
1918: (p_incident_id in per_work_incidents.incident_id%TYPE,
1919: p_report_method in per_work_incidents.report_method%TYPE,
1920: p_effective_date in date) is
1921: --
1922: l_proc varchar2(72) := g_package||'chk_report_method';

Line 1919: p_report_method in per_work_incidents.report_method%TYPE,

1915: -- {End Of Comments}
1916: -- ----------------------------------------------------------------------------
1917: procedure chk_report_method
1918: (p_incident_id in per_work_incidents.incident_id%TYPE,
1919: p_report_method in per_work_incidents.report_method%TYPE,
1920: p_effective_date in date) is
1921: --
1922: l_proc varchar2(72) := g_package||'chk_report_method';
1923: --

Line 1998: (p_incident_id in per_work_incidents.incident_id%TYPE

1994: -- {End of Comments}
1995: --
1996: -- ---------------------------------------------------------------------------
1997: procedure chk_notified_hsrep_and_date
1998: (p_incident_id in per_work_incidents.incident_id%TYPE
1999: ,p_incident_date in per_work_incidents.incident_date%TYPE
2000: ,p_notified_hsrep_id in per_work_incidents.notified_hsrep_id%TYPE
2001: ,p_notified_hsrep_date in per_work_incidents.notified_hsrep_date%TYPE
2002: ,p_business_group_id in per_all_people_f.business_group_id%TYPE

Line 1999: ,p_incident_date in per_work_incidents.incident_date%TYPE

1995: --
1996: -- ---------------------------------------------------------------------------
1997: procedure chk_notified_hsrep_and_date
1998: (p_incident_id in per_work_incidents.incident_id%TYPE
1999: ,p_incident_date in per_work_incidents.incident_date%TYPE
2000: ,p_notified_hsrep_id in per_work_incidents.notified_hsrep_id%TYPE
2001: ,p_notified_hsrep_date in per_work_incidents.notified_hsrep_date%TYPE
2002: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
2003: ,p_object_version_number in per_work_incidents.object_version_number%TYPE

Line 2000: ,p_notified_hsrep_id in per_work_incidents.notified_hsrep_id%TYPE

1996: -- ---------------------------------------------------------------------------
1997: procedure chk_notified_hsrep_and_date
1998: (p_incident_id in per_work_incidents.incident_id%TYPE
1999: ,p_incident_date in per_work_incidents.incident_date%TYPE
2000: ,p_notified_hsrep_id in per_work_incidents.notified_hsrep_id%TYPE
2001: ,p_notified_hsrep_date in per_work_incidents.notified_hsrep_date%TYPE
2002: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
2003: ,p_object_version_number in per_work_incidents.object_version_number%TYPE
2004: ) is

Line 2001: ,p_notified_hsrep_date in per_work_incidents.notified_hsrep_date%TYPE

1997: procedure chk_notified_hsrep_and_date
1998: (p_incident_id in per_work_incidents.incident_id%TYPE
1999: ,p_incident_date in per_work_incidents.incident_date%TYPE
2000: ,p_notified_hsrep_id in per_work_incidents.notified_hsrep_id%TYPE
2001: ,p_notified_hsrep_date in per_work_incidents.notified_hsrep_date%TYPE
2002: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
2003: ,p_object_version_number in per_work_incidents.object_version_number%TYPE
2004: ) is
2005: --

Line 2003: ,p_object_version_number in per_work_incidents.object_version_number%TYPE

1999: ,p_incident_date in per_work_incidents.incident_date%TYPE
2000: ,p_notified_hsrep_id in per_work_incidents.notified_hsrep_id%TYPE
2001: ,p_notified_hsrep_date in per_work_incidents.notified_hsrep_date%TYPE
2002: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
2003: ,p_object_version_number in per_work_incidents.object_version_number%TYPE
2004: ) is
2005: --
2006: cursor c_person is
2007: select null

Line 2112: (p_incident_id in per_work_incidents.incident_id%TYPE

2108: -- {End of Comments}
2109: --
2110: -- ---------------------------------------------------------------------------
2111: procedure chk_notified_rep_org_date
2112: (p_incident_id in per_work_incidents.incident_id%TYPE
2113: ,p_incident_date in per_work_incidents.incident_date%TYPE
2114: ,p_notified_rep_org_id in per_work_incidents.notified_rep_org_id%TYPE
2115: ,p_notified_rep_id in per_work_incidents.notified_rep_id%TYPE
2116: ,p_notified_rep_date in per_work_incidents.notified_rep_date%TYPE

Line 2113: ,p_incident_date in per_work_incidents.incident_date%TYPE

2109: --
2110: -- ---------------------------------------------------------------------------
2111: procedure chk_notified_rep_org_date
2112: (p_incident_id in per_work_incidents.incident_id%TYPE
2113: ,p_incident_date in per_work_incidents.incident_date%TYPE
2114: ,p_notified_rep_org_id in per_work_incidents.notified_rep_org_id%TYPE
2115: ,p_notified_rep_id in per_work_incidents.notified_rep_id%TYPE
2116: ,p_notified_rep_date in per_work_incidents.notified_rep_date%TYPE
2117: ,p_business_group_id in per_all_people_f.business_group_id%TYPE

Line 2114: ,p_notified_rep_org_id in per_work_incidents.notified_rep_org_id%TYPE

2110: -- ---------------------------------------------------------------------------
2111: procedure chk_notified_rep_org_date
2112: (p_incident_id in per_work_incidents.incident_id%TYPE
2113: ,p_incident_date in per_work_incidents.incident_date%TYPE
2114: ,p_notified_rep_org_id in per_work_incidents.notified_rep_org_id%TYPE
2115: ,p_notified_rep_id in per_work_incidents.notified_rep_id%TYPE
2116: ,p_notified_rep_date in per_work_incidents.notified_rep_date%TYPE
2117: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
2118: ,p_object_version_number in per_work_incidents.object_version_number%TYPE

Line 2115: ,p_notified_rep_id in per_work_incidents.notified_rep_id%TYPE

2111: procedure chk_notified_rep_org_date
2112: (p_incident_id in per_work_incidents.incident_id%TYPE
2113: ,p_incident_date in per_work_incidents.incident_date%TYPE
2114: ,p_notified_rep_org_id in per_work_incidents.notified_rep_org_id%TYPE
2115: ,p_notified_rep_id in per_work_incidents.notified_rep_id%TYPE
2116: ,p_notified_rep_date in per_work_incidents.notified_rep_date%TYPE
2117: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
2118: ,p_object_version_number in per_work_incidents.object_version_number%TYPE
2119: ) is

Line 2116: ,p_notified_rep_date in per_work_incidents.notified_rep_date%TYPE

2112: (p_incident_id in per_work_incidents.incident_id%TYPE
2113: ,p_incident_date in per_work_incidents.incident_date%TYPE
2114: ,p_notified_rep_org_id in per_work_incidents.notified_rep_org_id%TYPE
2115: ,p_notified_rep_id in per_work_incidents.notified_rep_id%TYPE
2116: ,p_notified_rep_date in per_work_incidents.notified_rep_date%TYPE
2117: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
2118: ,p_object_version_number in per_work_incidents.object_version_number%TYPE
2119: ) is
2120: --

Line 2118: ,p_object_version_number in per_work_incidents.object_version_number%TYPE

2114: ,p_notified_rep_org_id in per_work_incidents.notified_rep_org_id%TYPE
2115: ,p_notified_rep_id in per_work_incidents.notified_rep_id%TYPE
2116: ,p_notified_rep_date in per_work_incidents.notified_rep_date%TYPE
2117: ,p_business_group_id in per_all_people_f.business_group_id%TYPE
2118: ,p_object_version_number in per_work_incidents.object_version_number%TYPE
2119: ) is
2120: --
2121: -- get valid organizations with class of rep body.
2122: --

Line 2279: (p_treatment_received_flag in per_work_incidents.treatment_received_flag%TYPE

2275: -- {End of Comments}
2276: --
2277: -- ---------------------------------------------------------------------------
2278: procedure chk_hospital_doctor_details
2279: (p_treatment_received_flag in per_work_incidents.treatment_received_flag%TYPE
2280: ,p_hospital_details in per_work_incidents.hospital_details%TYPE
2281: ,p_doctor_name in per_work_incidents.doctor_name%TYPE
2282: ) is
2283: --

Line 2280: ,p_hospital_details in per_work_incidents.hospital_details%TYPE

2276: --
2277: -- ---------------------------------------------------------------------------
2278: procedure chk_hospital_doctor_details
2279: (p_treatment_received_flag in per_work_incidents.treatment_received_flag%TYPE
2280: ,p_hospital_details in per_work_incidents.hospital_details%TYPE
2281: ,p_doctor_name in per_work_incidents.doctor_name%TYPE
2282: ) is
2283: --
2284: l_proc varchar2(72) := g_package||'chk_hospital_doctor_details';

Line 2281: ,p_doctor_name in per_work_incidents.doctor_name%TYPE

2277: -- ---------------------------------------------------------------------------
2278: procedure chk_hospital_doctor_details
2279: (p_treatment_received_flag in per_work_incidents.treatment_received_flag%TYPE
2280: ,p_hospital_details in per_work_incidents.hospital_details%TYPE
2281: ,p_doctor_name in per_work_incidents.doctor_name%TYPE
2282: ) is
2283: --
2284: l_proc varchar2(72) := g_package||'chk_hospital_doctor_details';
2285: --

Line 2341: (p_report_time in per_work_incidents.report_time%TYPE

2337: -- {End of Comments}
2338: --
2339: -- ---------------------------------------------------------------------------
2340: procedure chk_report_time
2341: (p_report_time in per_work_incidents.report_time%TYPE
2342: ) is
2343: --
2344: l_proc varchar2(72) := g_package||'chk_report_time';
2345: l_value varchar2(60) := p_report_time;

Line 2409: (p_incident_id in per_work_incidents.incident_id%TYPE,

2405: -- {End of Comments}
2406: --
2407: -- ---------------------------------------------------------------------------
2408: procedure chk_assignment_id
2409: (p_incident_id in per_work_incidents.incident_id%TYPE,
2410: p_assignment_id in per_work_incidents.assignment_id%TYPE,
2411: p_person_id in per_work_incidents.person_id%TYPE,
2412: p_incident_date in per_work_incidents.incident_date%TYPE
2413: ) is

Line 2410: p_assignment_id in per_work_incidents.assignment_id%TYPE,

2406: --
2407: -- ---------------------------------------------------------------------------
2408: procedure chk_assignment_id
2409: (p_incident_id in per_work_incidents.incident_id%TYPE,
2410: p_assignment_id in per_work_incidents.assignment_id%TYPE,
2411: p_person_id in per_work_incidents.person_id%TYPE,
2412: p_incident_date in per_work_incidents.incident_date%TYPE
2413: ) is
2414: --

Line 2411: p_person_id in per_work_incidents.person_id%TYPE,

2407: -- ---------------------------------------------------------------------------
2408: procedure chk_assignment_id
2409: (p_incident_id in per_work_incidents.incident_id%TYPE,
2410: p_assignment_id in per_work_incidents.assignment_id%TYPE,
2411: p_person_id in per_work_incidents.person_id%TYPE,
2412: p_incident_date in per_work_incidents.incident_date%TYPE
2413: ) is
2414: --
2415: l_proc varchar2(72) := g_package||'chk_assignment_id';

Line 2412: p_incident_date in per_work_incidents.incident_date%TYPE

2408: procedure chk_assignment_id
2409: (p_incident_id in per_work_incidents.incident_id%TYPE,
2410: p_assignment_id in per_work_incidents.assignment_id%TYPE,
2411: p_person_id in per_work_incidents.person_id%TYPE,
2412: p_incident_date in per_work_incidents.incident_date%TYPE
2413: ) is
2414: --
2415: l_proc varchar2(72) := g_package||'chk_assignment_id';
2416: l_dummy number;

Line 2500: (p_incident_id in per_work_incidents.incident_id%TYPE,

2496: -- {End of Comments}
2497: --
2498: -- ---------------------------------------------------------------------------
2499: procedure chk_compensation_details
2500: (p_incident_id in per_work_incidents.incident_id%TYPE,
2501: p_compensation_currency in per_work_incidents.compensation_currency%TYPE,
2502: p_compensation_amount in per_work_incidents.compensation_amount%TYPE,
2503: p_compensation_date in per_work_incidents.compensation_date%TYPE,
2504: p_incident_date in per_work_incidents.incident_date%TYPE

Line 2501: p_compensation_currency in per_work_incidents.compensation_currency%TYPE,

2497: --
2498: -- ---------------------------------------------------------------------------
2499: procedure chk_compensation_details
2500: (p_incident_id in per_work_incidents.incident_id%TYPE,
2501: p_compensation_currency in per_work_incidents.compensation_currency%TYPE,
2502: p_compensation_amount in per_work_incidents.compensation_amount%TYPE,
2503: p_compensation_date in per_work_incidents.compensation_date%TYPE,
2504: p_incident_date in per_work_incidents.incident_date%TYPE
2505: ) is

Line 2502: p_compensation_amount in per_work_incidents.compensation_amount%TYPE,

2498: -- ---------------------------------------------------------------------------
2499: procedure chk_compensation_details
2500: (p_incident_id in per_work_incidents.incident_id%TYPE,
2501: p_compensation_currency in per_work_incidents.compensation_currency%TYPE,
2502: p_compensation_amount in per_work_incidents.compensation_amount%TYPE,
2503: p_compensation_date in per_work_incidents.compensation_date%TYPE,
2504: p_incident_date in per_work_incidents.incident_date%TYPE
2505: ) is
2506: --

Line 2503: p_compensation_date in per_work_incidents.compensation_date%TYPE,

2499: procedure chk_compensation_details
2500: (p_incident_id in per_work_incidents.incident_id%TYPE,
2501: p_compensation_currency in per_work_incidents.compensation_currency%TYPE,
2502: p_compensation_amount in per_work_incidents.compensation_amount%TYPE,
2503: p_compensation_date in per_work_incidents.compensation_date%TYPE,
2504: p_incident_date in per_work_incidents.incident_date%TYPE
2505: ) is
2506: --
2507: l_proc varchar2(72) := g_package||'chk_compensation_details';

Line 2504: p_incident_date in per_work_incidents.incident_date%TYPE

2500: (p_incident_id in per_work_incidents.incident_id%TYPE,
2501: p_compensation_currency in per_work_incidents.compensation_currency%TYPE,
2502: p_compensation_amount in per_work_incidents.compensation_amount%TYPE,
2503: p_compensation_date in per_work_incidents.compensation_date%TYPE,
2504: p_incident_date in per_work_incidents.incident_date%TYPE
2505: ) is
2506: --
2507: l_proc varchar2(72) := g_package||'chk_compensation_details';
2508: l_dummy number;

Line 2593: (p_absence_exists_flag in per_work_incidents.absence_exists_flag%TYPE

2589: -- {End of Comments}
2590: --
2591: -- ---------------------------------------------------------------------------
2592: procedure chk_absence_exists_flag
2593: (p_absence_exists_flag in per_work_incidents.absence_exists_flag%TYPE
2594: ) is
2595: --
2596: l_proc varchar2(72) := g_package||'chk_absence_exists_flag';
2597: --

Line 3095: from per_work_incidents pwi

3091: function GET_INCIDENT_REFERENCE (p_incident_id in number) return varchar2 is
3092: --
3093: cursor csr_incident is
3094: select incident_reference
3095: from per_work_incidents pwi
3096: where pwi.incident_id = p_incident_id;
3097: --
3098: v_reference per_work_incidents.incident_reference%TYPE := null;
3099: --

Line 3098: v_reference per_work_incidents.incident_reference%TYPE := null;

3094: select incident_reference
3095: from per_work_incidents pwi
3096: where pwi.incident_id = p_incident_id;
3097: --
3098: v_reference per_work_incidents.incident_reference%TYPE := null;
3099: --
3100: begin
3101: --
3102: -- Only open the cursor if the parameters are going to retrieve anything