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_INC_BUS

Line 1: Package Body per_inc_bus as

1: Package Body per_inc_bus as
2: /* $Header: peincrhi.pkb 115.29 2003/08/31 00:49:48 kjagadee noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package varchar2(33) := ' per_inc_bus.'; -- Global package name

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' per_inc_bus.'; -- Global package name
9: --
10: -- The following two global variables are only to be
11: -- used by the return_legislation_code function.
12: --

Line 115: if ( nvl(per_inc_bus.g_incident_id, hr_api.g_number) = p_incident_id) then

111: ,p_argument => 'incident_id'
112: ,p_argument_value => p_incident_id
113: );
114: --
115: if ( nvl(per_inc_bus.g_incident_id, hr_api.g_number) = p_incident_id) then
116: --
117: -- The legislation code has already been found with a previous
118: -- call to this function. Just return the value in the global
119: -- variable.

Line 121: l_legislation_code := per_inc_bus.g_legislation_code;

117: -- The legislation code has already been found with a previous
118: -- call to this function. Just return the value in the global
119: -- variable.
120: --
121: l_legislation_code := per_inc_bus.g_legislation_code;
122: hr_utility.set_location(l_proc, 20);
123: else
124: --
125: -- The ID is different to the last call to this function

Line 145: per_inc_bus.g_incident_id := p_incident_id;

141: -- Set the global variables so the values are
142: -- available for the next call to this function.
143: --
144: close csr_leg_code;
145: per_inc_bus.g_incident_id := p_incident_id;
146: per_inc_bus.g_legislation_code := l_legislation_code;
147: end if;
148: hr_utility.set_location(' Leaving:'|| l_proc, 40);
149: return l_legislation_code;

Line 146: per_inc_bus.g_legislation_code := l_legislation_code;

142: -- available for the next call to this function.
143: --
144: close csr_leg_code;
145: per_inc_bus.g_incident_id := p_incident_id;
146: per_inc_bus.g_legislation_code := l_legislation_code;
147: end if;
148: hr_utility.set_location(' Leaving:'|| l_proc, 40);
149: return l_legislation_code;
150: end return_legislation_code;

Line 2687: per_inc_bus.chk_person_id

2683: per_per_bus.set_security_group_id(p_person_id => to_number(p_rec.person_id));
2684: --
2685: -- Validate person id
2686: --
2687: per_inc_bus.chk_person_id
2688: (p_incident_id => p_rec.incident_id,
2689: p_person_id => p_rec.person_id,
2690: p_effective_date => p_effective_date);
2691: --

Line 2694: per_inc_bus.chk_incident_date

2690: p_effective_date => p_effective_date);
2691: --
2692: -- Validate incident date
2693: --
2694: per_inc_bus.chk_incident_date
2695: (p_incident_date => p_rec.incident_date);
2696: --
2697: -- Validate incident time
2698: --

Line 2699: per_inc_bus.chk_incident_time

2695: (p_incident_date => p_rec.incident_date);
2696: --
2697: -- Validate incident time
2698: --
2699: per_inc_bus.chk_incident_time
2700: (p_incident_time => p_rec.incident_time);
2701: --
2702: -- Start of changes for additional columns
2703: --

Line 2706: per_inc_bus.chk_hospitalized_flag

2702: -- Start of changes for additional columns
2703: --
2704: -- Validate hospitalized flag
2705: --
2706: per_inc_bus.chk_hospitalized_flag
2707: (p_hospitalized_flag => p_rec.hospitalized_flag);
2708:
2709: --
2710: -- Validate privacy issue

Line 2712: per_inc_bus.chk_privacy_issue

2708:
2709: --
2710: -- Validate privacy issue
2711: --
2712: per_inc_bus.chk_privacy_issue
2713: (p_privacy_issue => p_rec.privacy_issue);
2714: --
2715: -- Validate emergency_code
2716: --

Line 2717: per_inc_bus.chk_emergency_code

2713: (p_privacy_issue => p_rec.privacy_issue);
2714: --
2715: -- Validate emergency_code
2716: --
2717: per_inc_bus.chk_emergency_code
2718: (p_emergency_code => p_rec.emergency_code);
2719: --
2720: -- Validate date of death
2721: --

Line 2722: per_inc_bus.chk_date_of_death

2718: (p_emergency_code => p_rec.emergency_code);
2719: --
2720: -- Validate date of death
2721: --
2722: per_inc_bus.chk_date_of_death
2723: (p_incident_date => p_rec.incident_date
2724: ,p_date_of_death => p_rec.date_of_death);
2725: --
2726: -- Validate work start time

Line 2728: per_inc_bus.chk_work_start_time

2724: ,p_date_of_death => p_rec.date_of_death);
2725: --
2726: -- Validate work start time
2727: --
2728: per_inc_bus.chk_work_start_time
2729: (p_work_start_time => p_rec.work_start_time);
2730:
2731: --
2732: -- End of changes for additional columns

Line 2736: per_inc_bus.chk_incident_reference(p_incident_id => p_rec.incident_id,

2732: -- End of changes for additional columns
2733: --
2734: -- Validate incident reference
2735: --
2736: per_inc_bus.chk_incident_reference(p_incident_id => p_rec.incident_id,
2737: p_incident_reference => p_rec.incident_reference,
2738: p_object_version_number => p_rec.object_version_number);
2739: --
2740: -- Validate incident type

Line 2742: per_inc_bus.chk_incident_type(p_incident_id => p_rec.incident_id,

2738: p_object_version_number => p_rec.object_version_number);
2739: --
2740: -- Validate incident type
2741: --
2742: per_inc_bus.chk_incident_type(p_incident_id => p_rec.incident_id,
2743: p_incident_type => p_rec.incident_type,
2744: p_effective_date => p_effective_date);
2745: --
2746: -- Validate Over Time Flag

Line 2748: per_inc_bus.chk_over_time_flag

2744: p_effective_date => p_effective_date);
2745: --
2746: -- Validate Over Time Flag
2747: --
2748: per_inc_bus.chk_over_time_flag
2749: (p_over_time_flag => p_rec.over_time_flag);
2750:
2751: --
2752: -- Validate related incident

Line 2754: per_inc_bus.chk_related_incident_id(p_incident_id => p_rec.incident_id,

2750:
2751: --
2752: -- Validate related incident
2753: --
2754: per_inc_bus.chk_related_incident_id(p_incident_id => p_rec.incident_id,
2755: p_related_incident_id => p_rec.related_incident_id,
2756: p_person_id => p_rec.person_id,
2757: p_incident_date => p_rec.incident_date);
2758: --

Line 2761: per_inc_bus.chk_org_notified_date(p_org_notified_date => p_rec.org_notified_date,

2757: p_incident_date => p_rec.incident_date);
2758: --
2759: -- Validate Org Notified Date
2760: --
2761: per_inc_bus.chk_org_notified_date(p_org_notified_date => p_rec.org_notified_date,
2762: p_incident_date => p_rec.incident_date);
2763: --
2764: -- Validate At Work Flag
2765: --

Line 2766: per_inc_bus.chk_at_work_flag(p_incident_id => p_rec.incident_id,

2762: p_incident_date => p_rec.incident_date);
2763: --
2764: -- Validate At Work Flag
2765: --
2766: per_inc_bus.chk_at_work_flag(p_incident_id => p_rec.incident_id,
2767: p_at_work_flag => p_rec.at_work_flag,
2768: p_effective_date => p_effective_date);
2769: --
2770: -- Validate Hazard Type

Line 2772: per_inc_bus.chk_hazard_type(p_incident_id => p_rec.incident_id,

2768: p_effective_date => p_effective_date);
2769: --
2770: -- Validate Hazard Type
2771: --
2772: per_inc_bus.chk_hazard_type(p_incident_id => p_rec.incident_id,
2773: p_hazard_type => p_rec.hazard_type,
2774: p_effective_date => p_effective_date);
2775:
2776: --

Line 2779: per_inc_bus.chk_injury_type(p_incident_id => p_rec.incident_id,

2775:
2776: --
2777: -- Validate Injury Type
2778: --
2779: per_inc_bus.chk_injury_type(p_incident_id => p_rec.incident_id,
2780: p_injury_type => p_rec.injury_type,
2781: p_effective_date => p_effective_date);
2782:
2783: --

Line 2786: per_inc_bus.chk_disease_type(p_incident_id => p_rec.incident_id,

2782:
2783: --
2784: -- Validate Disease Type
2785: --
2786: per_inc_bus.chk_disease_type(p_incident_id => p_rec.incident_id,
2787: p_disease_type => p_rec.disease_type,
2788: p_effective_date => p_effective_date);
2789:
2790: --

Line 2793: per_inc_bus.chk_hospital_doctor_details

2789:
2790: --
2791: -- Validate Hopsital Details and Doctor Name
2792: --
2793: per_inc_bus.chk_hospital_doctor_details
2794: (p_treatment_received_flag => p_rec.treatment_received_flag,
2795: p_hospital_details => p_rec.hospital_details,
2796: p_doctor_name => p_rec.doctor_name);
2797: --

Line 2800: per_inc_bus.chk_report_time

2796: p_doctor_name => p_rec.doctor_name);
2797: --
2798: -- Validate report time
2799: --
2800: per_inc_bus.chk_report_time
2801: (p_report_time => p_rec.report_time);
2802: --
2803: -- Validate person reported by, report date and time
2804: --

Line 2808: per_inc_bus.chk_person_reported_date_time

2804: --
2805: open csr_bg;
2806: fetch csr_bg into l_bg_id;
2807: close csr_bg;
2808: per_inc_bus.chk_person_reported_date_time
2809: (p_incident_id => p_rec.incident_id
2810: ,p_incident_date => p_rec.incident_date
2811: ,p_incident_time => p_rec.incident_time
2812: ,p_person_reported_by => p_rec.person_reported_by

Line 2820: per_inc_bus.chk_report_method(p_incident_id => p_rec.incident_id,

2816: ,p_object_version_number => p_rec.object_version_number);
2817: --
2818: -- Validate report method
2819: --
2820: per_inc_bus.chk_report_method(p_incident_id => p_rec.incident_id,
2821: p_report_method => p_rec.report_method,
2822: p_effective_date => p_effective_date);
2823: --
2824: -- Validate notified_hsrep_id, notified_hsrep_date

Line 2826: per_inc_bus.chk_notified_hsrep_and_date

2822: p_effective_date => p_effective_date);
2823: --
2824: -- Validate notified_hsrep_id, notified_hsrep_date
2825: --
2826: per_inc_bus.chk_notified_hsrep_and_date
2827: (p_incident_id => p_rec.incident_id
2828: ,p_incident_date => p_rec.incident_date
2829: ,p_notified_hsrep_id => p_rec.notified_hsrep_id
2830: ,p_notified_hsrep_date => p_rec.notified_hsrep_date

Line 2836: per_inc_bus.chk_notified_rep_org_date

2832: ,p_object_version_number => p_rec.object_version_number);
2833: --
2834: -- Validate notified_rep_org, notified_rep_id, notified_rep_date
2835: --
2836: per_inc_bus.chk_notified_rep_org_date
2837: (p_incident_id => p_rec.incident_id
2838: ,p_incident_date => p_rec.incident_date
2839: ,p_notified_rep_org_id => p_rec.notified_rep_org_id
2840: ,p_notified_rep_id => p_rec.notified_rep_id

Line 2847: per_inc_bus.chk_compensation_details

2843: ,p_object_version_number => p_rec.object_version_number);
2844: --
2845: -- Validate compensation details
2846: --
2847: per_inc_bus.chk_compensation_details
2848: (p_incident_id => p_rec.incident_id,
2849: p_compensation_currency => p_rec.compensation_currency,
2850: p_compensation_amount => p_rec.compensation_amount,
2851: p_compensation_date => p_rec.compensation_date,

Line 2856: per_inc_bus.chk_assignment_id(p_incident_id => p_rec.incident_id

2852: p_incident_date => p_rec.incident_date);
2853: --
2854: -- Validate assignment_id
2855: --
2856: per_inc_bus.chk_assignment_id(p_incident_id => p_rec.incident_id
2857: ,p_assignment_id => p_rec.assignment_id
2858: ,p_person_id => p_rec.person_id
2859: ,p_incident_date => p_rec.incident_date);
2860: --

Line 2863: per_inc_bus.chk_absence_exists_flag

2859: ,p_incident_date => p_rec.incident_date);
2860: --
2861: -- Check absence exists flag
2862: --
2863: per_inc_bus.chk_absence_exists_flag
2864: (p_absence_exists_flag => p_rec.absence_exists_flag);
2865: --
2866: -- Validate Developer Descriptive Flexfield
2867: --

Line 2868: per_inc_bus.chk_ddf(p_rec);

2864: (p_absence_exists_flag => p_rec.absence_exists_flag);
2865: --
2866: -- Validate Developer Descriptive Flexfield
2867: --
2868: per_inc_bus.chk_ddf(p_rec);
2869: --
2870: -- Validate Descriptive Flexfield
2871: --
2872: per_inc_bus.chk_df(p_rec);

Line 2872: per_inc_bus.chk_df(p_rec);

2868: per_inc_bus.chk_ddf(p_rec);
2869: --
2870: -- Validate Descriptive Flexfield
2871: --
2872: per_inc_bus.chk_df(p_rec);
2873: --
2874: hr_utility.set_location(' Leaving:'||l_proc, 10);
2875: End insert_validate;
2876: --

Line 2906: per_inc_bus.chk_person_id

2902: ,p_rec => p_rec);
2903: --
2904: -- Validate person id
2905: --
2906: per_inc_bus.chk_person_id
2907: (p_incident_id => p_rec.incident_id,
2908: p_person_id => p_rec.person_id,
2909: p_effective_date => p_effective_date);
2910: --

Line 2913: per_inc_bus.chk_incident_date

2909: p_effective_date => p_effective_date);
2910: --
2911: -- Validate incident date
2912: --
2913: per_inc_bus.chk_incident_date
2914: (p_incident_date => p_rec.incident_date);
2915: --
2916: -- Validate incident time
2917: --

Line 2918: per_inc_bus.chk_incident_time

2914: (p_incident_date => p_rec.incident_date);
2915: --
2916: -- Validate incident time
2917: --
2918: per_inc_bus.chk_incident_time
2919: (p_incident_time => p_rec.incident_time);
2920: --
2921: -- Validate incident reference
2922: --

Line 2923: per_inc_bus.chk_incident_reference(p_incident_id => p_rec.incident_id,

2919: (p_incident_time => p_rec.incident_time);
2920: --
2921: -- Validate incident reference
2922: --
2923: per_inc_bus.chk_incident_reference(p_incident_id => p_rec.incident_id,
2924: p_incident_reference => p_rec.incident_reference,
2925: p_object_version_number => p_rec.object_version_number);
2926: --
2927: -- Validate incident type

Line 2929: per_inc_bus.chk_incident_type

2925: p_object_version_number => p_rec.object_version_number);
2926: --
2927: -- Validate incident type
2928: --
2929: per_inc_bus.chk_incident_type
2930: (p_incident_id => p_rec.incident_id,
2931: p_incident_type => p_rec.incident_type,
2932: p_effective_date => p_effective_date);
2933:

Line 2937: per_inc_bus.chk_over_time_flag

2933:
2934: --
2935: -- Validate Over Time Flag
2936: --
2937: per_inc_bus.chk_over_time_flag
2938: (p_over_time_flag => p_rec.over_time_flag);
2939:
2940: --
2941: -- Validate related incident

Line 2943: per_inc_bus.chk_related_incident_id(p_incident_id => p_rec.incident_id,

2939:
2940: --
2941: -- Validate related incident
2942: --
2943: per_inc_bus.chk_related_incident_id(p_incident_id => p_rec.incident_id,
2944: p_related_incident_id => p_rec.related_incident_id,
2945: p_person_id => p_rec.person_id,
2946: p_incident_date => p_rec.incident_date);
2947: --

Line 2950: per_inc_bus.chk_org_notified_date(p_org_notified_date => p_rec.org_notified_date,

2946: p_incident_date => p_rec.incident_date);
2947: --
2948: -- Validate Org Notified Date
2949: --
2950: per_inc_bus.chk_org_notified_date(p_org_notified_date => p_rec.org_notified_date,
2951: p_incident_date => p_rec.incident_date);
2952: --
2953: -- Validate At Work flag
2954: --

Line 2955: per_inc_bus.chk_at_work_flag(p_incident_id => p_rec.incident_id,

2951: p_incident_date => p_rec.incident_date);
2952: --
2953: -- Validate At Work flag
2954: --
2955: per_inc_bus.chk_at_work_flag(p_incident_id => p_rec.incident_id,
2956: p_at_work_flag => p_rec.at_work_flag,
2957: p_effective_date => p_effective_date);
2958: --
2959: -- Validate Hazard Type

Line 2961: per_inc_bus.chk_hazard_type(p_incident_id => p_rec.incident_id,

2957: p_effective_date => p_effective_date);
2958: --
2959: -- Validate Hazard Type
2960: --
2961: per_inc_bus.chk_hazard_type(p_incident_id => p_rec.incident_id,
2962: p_hazard_type => p_rec.hazard_type,
2963: p_effective_date => p_effective_date);
2964: --
2965: -- Validate Injury Type

Line 2967: per_inc_bus.chk_injury_type(p_incident_id => p_rec.incident_id,

2963: p_effective_date => p_effective_date);
2964: --
2965: -- Validate Injury Type
2966: --
2967: per_inc_bus.chk_injury_type(p_incident_id => p_rec.incident_id,
2968: p_injury_type => p_rec.injury_type,
2969: p_effective_date => p_effective_date);
2970: --
2971: -- Validate Disease Type

Line 2973: per_inc_bus.chk_disease_type(p_incident_id => p_rec.incident_id,

2969: p_effective_date => p_effective_date);
2970: --
2971: -- Validate Disease Type
2972: --
2973: per_inc_bus.chk_disease_type(p_incident_id => p_rec.incident_id,
2974: p_disease_type => p_rec.disease_type,
2975: p_effective_date => p_effective_date);
2976: --
2977: -- Validate Hopsital Details and Doctor Name

Line 2979: per_inc_bus.chk_hospital_doctor_details

2975: p_effective_date => p_effective_date);
2976: --
2977: -- Validate Hopsital Details and Doctor Name
2978: --
2979: per_inc_bus.chk_hospital_doctor_details
2980: (p_treatment_received_flag => p_rec.treatment_received_flag,
2981: p_hospital_details => p_rec.hospital_details,
2982: p_doctor_name => p_rec.doctor_name);
2983: --

Line 2986: per_inc_bus.chk_report_time

2982: p_doctor_name => p_rec.doctor_name);
2983: --
2984: -- Validate report time
2985: --
2986: per_inc_bus.chk_report_time
2987: (p_report_time => p_rec.report_time);
2988: --
2989: -- Validate person reported by, report date and time
2990: --

Line 2994: per_inc_bus.chk_person_reported_date_time

2990: --
2991: open csr_bg;
2992: fetch csr_bg into l_bg_id;
2993: close csr_bg;
2994: per_inc_bus.chk_person_reported_date_time
2995: (p_incident_id => p_rec.incident_id
2996: ,p_incident_date => p_rec.incident_date
2997: ,p_incident_time => p_rec.incident_time
2998: ,p_person_reported_by => p_rec.person_reported_by

Line 3006: per_inc_bus.chk_report_method(p_incident_id => p_rec.incident_id,

3002: ,p_object_version_number => p_rec.object_version_number);
3003: --
3004: -- Validate report method
3005: --
3006: per_inc_bus.chk_report_method(p_incident_id => p_rec.incident_id,
3007: p_report_method => p_rec.report_method,
3008: p_effective_date => p_effective_date);
3009: --
3010: -- Validate notified_hsrep_id, notified_hsrep_date

Line 3012: per_inc_bus.chk_notified_hsrep_and_date

3008: p_effective_date => p_effective_date);
3009: --
3010: -- Validate notified_hsrep_id, notified_hsrep_date
3011: --
3012: per_inc_bus.chk_notified_hsrep_and_date
3013: (p_incident_id => p_rec.incident_id
3014: ,p_incident_date => p_rec.incident_date
3015: ,p_notified_hsrep_id => p_rec.notified_hsrep_id
3016: ,p_notified_hsrep_date => p_rec.notified_hsrep_date

Line 3023: per_inc_bus.chk_notified_rep_org_date

3019: --
3020: --
3021: -- Validate notified_rep_org, notified_rep_id, notified_rep_date
3022: --
3023: per_inc_bus.chk_notified_rep_org_date
3024: (p_incident_id => p_rec.incident_id
3025: ,p_incident_date => p_rec.incident_date
3026: ,p_notified_rep_org_id => p_rec.notified_rep_org_id
3027: ,p_notified_rep_id => p_rec.notified_rep_id

Line 3034: per_inc_bus.chk_compensation_details

3030: ,p_object_version_number => p_rec.object_version_number);
3031: --
3032: -- Validate compensation details
3033: --
3034: per_inc_bus.chk_compensation_details
3035: (p_incident_id => p_rec.incident_id,
3036: p_compensation_currency => p_rec.compensation_currency,
3037: p_compensation_amount => p_rec.compensation_amount,
3038: p_compensation_date => p_rec.compensation_date,

Line 3043: per_inc_bus.chk_assignment_id(p_incident_id => p_rec.incident_id

3039: p_incident_date => p_rec.incident_date);
3040: --
3041: -- Validate assignment_id
3042: --
3043: per_inc_bus.chk_assignment_id(p_incident_id => p_rec.incident_id
3044: ,p_assignment_id => p_rec.assignment_id
3045: ,p_person_id => p_rec.person_id
3046: ,p_incident_date => p_rec.incident_date);
3047: --

Line 3050: per_inc_bus.chk_absence_exists_flag

3046: ,p_incident_date => p_rec.incident_date);
3047: --
3048: -- Check absence exists flag
3049: --
3050: per_inc_bus.chk_absence_exists_flag
3051: (p_absence_exists_flag => p_rec.absence_exists_flag);
3052: --
3053: -- Validate Developer Descriptive Flexfield
3054: --

Line 3055: per_inc_bus.chk_ddf(p_rec);

3051: (p_absence_exists_flag => p_rec.absence_exists_flag);
3052: --
3053: -- Validate Developer Descriptive Flexfield
3054: --
3055: per_inc_bus.chk_ddf(p_rec);
3056: --
3057: -- Validate Descriptive Flexfield
3058: --
3059: per_inc_bus.chk_df(p_rec);

Line 3059: per_inc_bus.chk_df(p_rec);

3055: per_inc_bus.chk_ddf(p_rec);
3056: --
3057: -- Validate Descriptive Flexfield
3058: --
3059: per_inc_bus.chk_df(p_rec);
3060: --
3061: hr_utility.set_location(' Leaving:'||l_proc, 10);
3062: End update_validate;
3063: --

Line 3193: end per_inc_bus;

3189: End create_osha_numbers;
3190: --
3191: --
3192:
3193: end per_inc_bus;