[Home] [Help]
1: Package Body pay_psd_bus as
2: /* $Header: pypsdrhi.pkb 120.1 2005/12/08 05:08 ssekhar noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' pay_psd_bus.'; -- Global package name
9: --
10: -- The following two global variables are only to be
11: -- used by the return_legislation_code function.
12: --
118: ,p_argument => 'sii_details_id'
119: ,p_argument_value => p_sii_details_id
120: );
121: --
122: if ( nvl(pay_psd_bus.g_sii_details_id, hr_api.g_number)
123: = p_sii_details_id) then
124: --
125: -- The legislation code has already been found with a previous
126: -- call to this function. Just return the value in the global
125: -- The legislation code has already been found with a previous
126: -- call to this function. Just return the value in the global
127: -- variable.
128: --
129: l_legislation_code := pay_psd_bus.g_legislation_code;
130: hr_utility.set_location(l_proc, 20);
131: else
132: --
133: -- The ID is different to the last call to this function
149: -- Set the global variables so the values are
150: -- available for the next call to this function.
151: --
152: close csr_leg_code;
153: pay_psd_bus.g_sii_details_id := p_sii_details_id;
154: pay_psd_bus.g_legislation_code := l_legislation_code;
155: end if;
156: hr_utility.set_location(' Leaving:'|| l_proc, 40);
157: return l_legislation_code;
150: -- available for the next call to this function.
151: --
152: close csr_leg_code;
153: pay_psd_bus.g_sii_details_id := p_sii_details_id;
154: pay_psd_bus.g_legislation_code := l_legislation_code;
155: end if;
156: hr_utility.set_location(' Leaving:'|| l_proc, 40);
157: return l_legislation_code;
158: end return_legislation_code;
2856: -- Validate Dependent Attributes
2857: --
2858:
2859: -- Validate the Contract Category
2860: pay_psd_bus.chk_contract_category(p_sii_details_id => p_rec.sii_details_id,
2861: p_effective_date => p_effective_date,
2862: p_contract_category => p_rec.contract_category,
2863: p_validation_start_date => p_validation_start_date,
2864: p_validation_end_date => p_validation_end_date,
2866:
2867:
2868:
2869: -- Validate the Business Group Id
2870: pay_psd_bus.chk_business_group_id(p_sii_details_id => p_rec.sii_details_id,
2871: p_effective_date => p_effective_date,
2872: p_business_group_id => p_rec.business_group_id,
2873: p_validation_start_date => p_validation_start_date,
2874: p_validation_end_date => p_validation_end_date,
2876:
2877:
2878:
2879: -- Validate the Person/Assignment Id
2880: pay_psd_bus.chk_per_asg_id(p_effective_date => p_effective_date,
2881: p_per_or_asg_id => p_rec.per_or_asg_id,
2882: p_contract_category => p_rec.contract_category,
2883: p_business_group_id => p_rec.business_group_id,
2884: p_object_version_number => p_rec.object_version_number);
2884: p_object_version_number => p_rec.object_version_number);
2885:
2886:
2887: -- Validate the Old Age Contribution Values
2888: pay_psd_bus.chk_old_age_contribution(p_sii_details_id => p_rec.sii_details_id,
2889: p_effective_date => p_effective_date,
2890: p_old_age_contribution => p_rec.old_age_contribution,
2891: p_validation_start_date => p_validation_start_date,
2892: p_validation_end_date => p_validation_end_date,
2895:
2896:
2897:
2898: -- Validate the Pension Contribution Values
2899: pay_psd_bus.chk_pension_contribution(p_sii_details_id => p_rec.sii_details_id,
2900: p_effective_date => p_effective_date,
2901: p_pension_contribution => p_rec.pension_contribution,
2902: p_validation_start_date => p_validation_start_date,
2903: p_validation_end_date => p_validation_end_date,
2905: p_contract_category => p_rec.contract_category);
2906:
2907:
2908: -- Validate the Sickness Contribution Values
2909: pay_psd_bus.chk_sickness_contribution(p_sii_details_id => p_rec.sii_details_id,
2910: p_effective_date => p_effective_date,
2911: p_sickness_contribution => p_rec.sickness_contribution,
2912: p_validation_start_date => p_validation_start_date,
2913: p_validation_end_date => p_validation_end_date,
2916:
2917:
2918:
2919: -- Validate the Work Injury Contribution Values
2920: pay_psd_bus.chk_work_injury_contribution(p_sii_details_id => p_rec.sii_details_id,
2921: p_effective_date => p_effective_date,
2922: p_work_injury_contribution => p_rec.work_injury_contribution,
2923: p_validation_start_date => p_validation_start_date,
2924: p_validation_end_date => p_validation_end_date,
2927:
2928:
2929:
2930: -- Validate the Labor Contribution Values
2931: pay_psd_bus.chk_labor_contribution(p_sii_details_id => p_rec.sii_details_id,
2932: p_effective_date => p_effective_date,
2933: p_labor_contribution => p_rec.labor_contribution,
2934: p_validation_start_date => p_validation_start_date,
2935: p_validation_end_date => p_validation_end_date,
2938:
2939:
2940:
2941: -- Validate the Health Contribution Values
2942: pay_psd_bus.chk_health_contribution(p_sii_details_id => p_rec.sii_details_id,
2943: p_effective_date => p_effective_date,
2944: p_health_contribution => p_rec.health_contribution,
2945: p_validation_start_date => p_validation_start_date,
2946: p_validation_end_date => p_validation_end_date,
2948: p_contract_category => p_rec.contract_category);
2949:
2950:
2951: -- Validate the Unemployment Contribution Values
2952: pay_psd_bus.chk_unemployment_contribution(p_sii_details_id => p_rec.sii_details_id,
2953: p_effective_date => p_effective_date,
2954: p_unemployment_contribution =>
2955: p_rec.unemployment_contribution,
2956: p_validation_start_date => p_validation_start_date,
2959: p_contract_category => p_rec.contract_category);
2960:
2961:
2962: -- Validate the Old Age Contribution End Reason Values
2963: pay_psd_bus.chk_old_age_cont_end_reason(p_sii_details_id => p_rec.sii_details_id,
2964: p_effective_date => p_effective_date,
2965: p_old_age_contribution => p_rec.old_age_contribution,
2966: p_old_age_cont_end_reason => p_rec.old_age_cont_end_reason,
2967: p_validation_start_date => p_validation_start_date,
2969: p_object_version_number=> p_rec.object_version_number);
2970:
2971:
2972: -- Validate the Pension Contribution End Reason Values
2973: pay_psd_bus.chk_pension_cont_end_reason(p_sii_details_id => p_rec.sii_details_id,
2974: p_effective_date => p_effective_date,
2975: p_pension_contribution => p_rec.pension_contribution,
2976: p_pension_cont_end_reason => p_rec.pension_cont_end_reason,
2977: p_validation_start_date => p_validation_start_date,
2978: p_validation_end_date => p_validation_end_date,
2979: p_object_version_number=> p_rec.object_version_number);
2980:
2981: -- Validate the Sickness Contribution End Reason Values
2982: pay_psd_bus.chk_sickness_cont_end_reason(p_sii_details_id => p_rec.sii_details_id,
2983: p_effective_date => p_effective_date,
2984: p_sickness_contribution => p_rec.sickness_contribution,
2985: p_sickness_cont_end_reason => p_rec.sickness_cont_end_reason,
2986: p_validation_start_date => p_validation_start_date,
2988: p_object_version_number=> p_rec.object_version_number);
2989:
2990:
2991: -- Validate the Work Injury Contribution End Reason Values
2992: pay_psd_bus.chk_work_injury_cont_end(p_sii_details_id => p_rec.sii_details_id,
2993: p_effective_date => p_effective_date,
2994: p_work_injury_contribution =>
2995: p_rec.work_injury_contribution,
2996: p_work_injury_cont_end_reason =>
2999: p_validation_end_date => p_validation_end_date,
3000: p_object_version_number=> p_rec.object_version_number);
3001:
3002: -- Validate the Labor fund Contribution End Reason Values
3003: pay_psd_bus.chk_labor_fund_cont_end_reason(p_sii_details_id => p_rec.sii_details_id,
3004: p_effective_date => p_effective_date,
3005: p_labor_contribution => p_rec.labor_contribution,
3006: p_labor_fund_cont_end_reason =>
3007: p_rec.labor_fund_cont_end_reason,
3010: p_object_version_number=> p_rec.object_version_number);
3011:
3012:
3013: -- Validate the Health Contribution End Reason Values
3014: pay_psd_bus.chk_health_cont_end_reason(p_sii_details_id => p_rec.sii_details_id,
3015: p_effective_date => p_effective_date,
3016: p_health_contribution => p_rec.health_contribution,
3017: p_health_cont_end_reason => p_rec.health_cont_end_reason,
3018: p_validation_start_date => p_validation_start_date,
3020: p_object_version_number=> p_rec.object_version_number);
3021:
3022:
3023: -- Validate the Unemployment Contribution End Reason Values
3024: pay_psd_bus.chk_unemployment_cont_end(p_sii_details_id => p_rec.sii_details_id,
3025: p_effective_date => p_effective_date,
3026: p_unemployment_contribution =>
3027: p_rec.unemployment_contribution,
3028: p_unemployment_cont_end_reason =>
3086:
3087: --
3088:
3089: -- Validate the Employee Social Security Information Values
3090: pay_psd_bus.chk_emp_social_security_info(p_sii_details_id => p_rec.sii_details_id,
3091: p_effective_date => p_effective_date,
3092: p_emp_social_security_info => p_rec.emp_social_security_info,
3093: p_object_version_number => p_rec.object_version_number);
3094:
3093: p_object_version_number => p_rec.object_version_number);
3094:
3095:
3096: -- Validate the Old Age Contribution Values
3097: pay_psd_bus.chk_old_age_contribution(p_sii_details_id => p_rec.sii_details_id,
3098: p_effective_date => p_effective_date,
3099: p_old_age_contribution => p_rec.old_age_contribution,
3100: p_validation_start_date => p_validation_start_date,
3101: p_validation_end_date => p_validation_end_date,
3104:
3105:
3106:
3107: -- Validate the Pension Contribution Values
3108: pay_psd_bus.chk_pension_contribution(p_sii_details_id => p_rec.sii_details_id,
3109: p_effective_date => p_effective_date,
3110: p_pension_contribution => p_rec.pension_contribution,
3111: p_validation_start_date => p_validation_start_date,
3112: p_validation_end_date => p_validation_end_date,
3114: p_contract_category => p_rec.contract_category);
3115:
3116:
3117: -- Validate the Sickness Contribution Values
3118: pay_psd_bus.chk_sickness_contribution(p_sii_details_id => p_rec.sii_details_id,
3119: p_effective_date => p_effective_date,
3120: p_sickness_contribution => p_rec.sickness_contribution,
3121: p_validation_start_date => p_validation_start_date,
3122: p_validation_end_date => p_validation_end_date,
3125:
3126:
3127:
3128: -- Validate the Work Injury Contribution Values
3129: pay_psd_bus.chk_work_injury_contribution(p_sii_details_id => p_rec.sii_details_id,
3130: p_effective_date => p_effective_date,
3131: p_work_injury_contribution => p_rec.work_injury_contribution,
3132: p_validation_start_date => p_validation_start_date,
3133: p_validation_end_date => p_validation_end_date,
3136:
3137:
3138:
3139: -- Validate the Labor Contribution Values
3140: pay_psd_bus.chk_labor_contribution(p_sii_details_id => p_rec.sii_details_id,
3141: p_effective_date => p_effective_date,
3142: p_labor_contribution => p_rec.labor_contribution,
3143: p_validation_start_date => p_validation_start_date,
3144: p_validation_end_date => p_validation_end_date,
3147:
3148:
3149:
3150: -- Validate the Health Contribution Values
3151: pay_psd_bus.chk_health_contribution(p_sii_details_id => p_rec.sii_details_id,
3152: p_effective_date => p_effective_date,
3153: p_health_contribution => p_rec.health_contribution,
3154: p_validation_start_date => p_validation_start_date,
3155: p_validation_end_date => p_validation_end_date,
3157: p_contract_category => p_rec.contract_category);
3158:
3159:
3160: -- Validate the Unemployment Contribution Values
3161: pay_psd_bus.chk_unemployment_contribution(p_sii_details_id => p_rec.sii_details_id,
3162: p_effective_date => p_effective_date,
3163: p_unemployment_contribution =>
3164: p_rec.unemployment_contribution,
3165: p_validation_start_date => p_validation_start_date,
3167: p_object_version_number => p_rec.object_version_number,
3168: p_contract_category => p_rec.contract_category);
3169:
3170: -- Validate the Old Age Contribution End Reason Values
3171: pay_psd_bus.chk_old_age_cont_end_reason(p_sii_details_id => p_rec.sii_details_id,
3172: p_effective_date => p_effective_date,
3173: p_old_age_contribution => p_rec.old_age_contribution,
3174: p_old_age_cont_end_reason => p_rec.old_age_cont_end_reason,
3175: p_validation_start_date => p_validation_start_date,
3177: p_object_version_number=> p_rec.object_version_number);
3178:
3179:
3180: -- Validate the Pension Contribution End Reason Values
3181: pay_psd_bus.chk_pension_cont_end_reason(p_sii_details_id => p_rec.sii_details_id,
3182: p_effective_date => p_effective_date,
3183: p_pension_contribution => p_rec.pension_contribution,
3184: p_pension_cont_end_reason => p_rec.pension_cont_end_reason,
3185: p_validation_start_date => p_validation_start_date,
3186: p_validation_end_date => p_validation_end_date,
3187: p_object_version_number=> p_rec.object_version_number);
3188:
3189: -- Validate the Sickness Contribution End Reason Values
3190: pay_psd_bus.chk_sickness_cont_end_reason(p_sii_details_id => p_rec.sii_details_id,
3191: p_effective_date => p_effective_date,
3192: p_sickness_contribution => p_rec.sickness_contribution,
3193: p_sickness_cont_end_reason => p_rec.sickness_cont_end_reason,
3194: p_validation_start_date => p_validation_start_date,
3196: p_object_version_number=> p_rec.object_version_number);
3197:
3198:
3199: -- Validate the Work Injury Contribution End Reason Values
3200: pay_psd_bus.chk_work_injury_cont_end(p_sii_details_id => p_rec.sii_details_id,
3201: p_effective_date => p_effective_date,
3202: p_work_injury_contribution =>
3203: p_rec.work_injury_contribution,
3204: p_work_injury_cont_end_reason =>
3207: p_validation_end_date => p_validation_end_date,
3208: p_object_version_number=> p_rec.object_version_number);
3209:
3210: -- Validate the Labor fund Contribution End Reason Values
3211: pay_psd_bus.chk_labor_fund_cont_end_reason(p_sii_details_id => p_rec.sii_details_id,
3212: p_effective_date => p_effective_date,
3213: p_labor_contribution => p_rec.labor_contribution,
3214: p_labor_fund_cont_end_reason =>
3215: p_rec.labor_fund_cont_end_reason,
3218: p_object_version_number=> p_rec.object_version_number);
3219:
3220:
3221: -- Validate the Health Contribution End Reason Values
3222: pay_psd_bus.chk_health_cont_end_reason(p_sii_details_id => p_rec.sii_details_id,
3223: p_effective_date => p_effective_date,
3224: p_health_contribution => p_rec.health_contribution,
3225: p_health_cont_end_reason => p_rec.health_cont_end_reason,
3226: p_validation_start_date => p_validation_start_date,
3228: p_object_version_number=> p_rec.object_version_number);
3229:
3230:
3231: -- Validate the Unemployment Contribution End Reason Values
3232: pay_psd_bus.chk_unemployment_cont_end(p_sii_details_id => p_rec.sii_details_id,
3233: p_effective_date => p_effective_date,
3234: p_unemployment_contribution =>
3235: p_rec.unemployment_contribution,
3236: p_unemployment_cont_end_reason =>
3486:
3487:
3488: end get_contribution_values;
3489:
3490: end pay_psd_bus;