DBA Data[Home] [Help]

APPS.PAY_SID_BUS dependencies on PAY_SID_BUS

Line 1: Package Body pay_sid_bus as

1: Package Body pay_sid_bus as
2: /* $Header: pysidrhi.pkb 120.1 2005/07/05 06:26:10 vikgupta noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' pay_sid_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 114: if ( nvl(pay_sid_bus.g_prsi_details_id, hr_api.g_number)

110: ,p_argument => 'prsi_details_id'
111: ,p_argument_value => p_prsi_details_id
112: );
113: --
114: if ( nvl(pay_sid_bus.g_prsi_details_id, hr_api.g_number)
115: = p_prsi_details_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

Line 121: l_legislation_code := pay_sid_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 := pay_sid_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: pay_sid_bus.g_prsi_details_id := p_prsi_details_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: pay_sid_bus.g_prsi_details_id := p_prsi_details_id;
146: pay_sid_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: pay_sid_bus.g_legislation_code := l_legislation_code;

142: -- available for the next call to this function.
143: --
144: close csr_leg_code;
145: pay_sid_bus.g_prsi_details_id := p_prsi_details_id;
146: pay_sid_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 1037: pay_sid_bus.chk_assignment_id(p_effective_date => p_effective_date

1033: -- Call all supporting business operations
1034: --
1035: per_asg_bus1.set_security_group_id(p_rec.assignment_id);
1036: --
1037: pay_sid_bus.chk_assignment_id(p_effective_date => p_effective_date
1038: , p_assignment_id => p_rec.assignment_id);
1039: --
1040: pay_sid_bus.chk_director_flag(p_effective_date => p_effective_date
1041: , p_director_flag => p_rec.director_flag);

Line 1040: pay_sid_bus.chk_director_flag(p_effective_date => p_effective_date

1036: --
1037: pay_sid_bus.chk_assignment_id(p_effective_date => p_effective_date
1038: , p_assignment_id => p_rec.assignment_id);
1039: --
1040: pay_sid_bus.chk_director_flag(p_effective_date => p_effective_date
1041: , p_director_flag => p_rec.director_flag);
1042: --
1043: pay_sid_bus.chk_contribution_class(p_effective_date => p_effective_date
1044: , p_contribution_class => p_rec.contribution_class);

Line 1043: pay_sid_bus.chk_contribution_class(p_effective_date => p_effective_date

1039: --
1040: pay_sid_bus.chk_director_flag(p_effective_date => p_effective_date
1041: , p_director_flag => p_rec.director_flag);
1042: --
1043: pay_sid_bus.chk_contribution_class(p_effective_date => p_effective_date
1044: , p_contribution_class => p_rec.contribution_class);
1045: --
1046: pay_sid_bus.chk_overridden_subclass(p_effective_date => p_effective_date
1047: , p_overridden_subclass => p_rec.overridden_subclass );

Line 1046: pay_sid_bus.chk_overridden_subclass(p_effective_date => p_effective_date

1042: --
1043: pay_sid_bus.chk_contribution_class(p_effective_date => p_effective_date
1044: , p_contribution_class => p_rec.contribution_class);
1045: --
1046: pay_sid_bus.chk_overridden_subclass(p_effective_date => p_effective_date
1047: , p_overridden_subclass => p_rec.overridden_subclass );
1048: --
1049: pay_sid_bus.chk_soc_ben_flag(p_effective_date => p_effective_date
1050: , p_soc_ben_flag => p_rec.soc_ben_flag );

Line 1049: pay_sid_bus.chk_soc_ben_flag(p_effective_date => p_effective_date

1045: --
1046: pay_sid_bus.chk_overridden_subclass(p_effective_date => p_effective_date
1047: , p_overridden_subclass => p_rec.overridden_subclass );
1048: --
1049: pay_sid_bus.chk_soc_ben_flag(p_effective_date => p_effective_date
1050: , p_soc_ben_flag => p_rec.soc_ben_flag );
1051: --
1052: pay_sid_bus.chk_soc_ben_start_date(p_effective_date => p_effective_date
1053: , p_soc_ben_flag => p_rec.soc_ben_flag

Line 1052: pay_sid_bus.chk_soc_ben_start_date(p_effective_date => p_effective_date

1048: --
1049: pay_sid_bus.chk_soc_ben_flag(p_effective_date => p_effective_date
1050: , p_soc_ben_flag => p_rec.soc_ben_flag );
1051: --
1052: pay_sid_bus.chk_soc_ben_start_date(p_effective_date => p_effective_date
1053: , p_soc_ben_flag => p_rec.soc_ben_flag
1054: , p_soc_ben_start_date => p_rec.soc_ben_start_date);
1055: --
1056: pay_sid_bus.chk_overridden_ins_weeks(p_effective_date => p_effective_date

Line 1056: pay_sid_bus.chk_overridden_ins_weeks(p_effective_date => p_effective_date

1052: pay_sid_bus.chk_soc_ben_start_date(p_effective_date => p_effective_date
1053: , p_soc_ben_flag => p_rec.soc_ben_flag
1054: , p_soc_ben_start_date => p_rec.soc_ben_start_date);
1055: --
1056: pay_sid_bus.chk_overridden_ins_weeks(p_effective_date => p_effective_date
1057: , p_assignment_id => p_rec.assignment_id
1058: , p_overridden_ins_weeks => p_rec.overridden_ins_weeks);
1059: --
1060: pay_sid_bus.chk_exemption_start_end_dates( p_exemption_start_Date => p_rec.exemption_start_date

Line 1060: pay_sid_bus.chk_exemption_start_end_dates( p_exemption_start_Date => p_rec.exemption_start_date

1056: pay_sid_bus.chk_overridden_ins_weeks(p_effective_date => p_effective_date
1057: , p_assignment_id => p_rec.assignment_id
1058: , p_overridden_ins_weeks => p_rec.overridden_ins_weeks);
1059: --
1060: pay_sid_bus.chk_exemption_start_end_dates( p_exemption_start_Date => p_rec.exemption_start_date
1061: , p_exemption_end_date => p_rec.exemption_end_date) ;
1062: --
1063: pay_sid_bus.chk_community_flag(p_effective_date => p_effective_date
1064: , p_community_flag => p_rec.community_flag);

Line 1063: pay_sid_bus.chk_community_flag(p_effective_date => p_effective_date

1059: --
1060: pay_sid_bus.chk_exemption_start_end_dates( p_exemption_start_Date => p_rec.exemption_start_date
1061: , p_exemption_end_date => p_rec.exemption_end_date) ;
1062: --
1063: pay_sid_bus.chk_community_flag(p_effective_date => p_effective_date
1064: , p_community_flag => p_rec.community_flag);
1065: --
1066: hr_utility.set_location('p_assignment_id...'||p_rec.assignment_id,100);
1067: hr_utility.set_location('p_validation_start_date...'||p_validation_start_date,101);

Line 1070: pay_sid_bus.chk_overlapping_record(p_assignment_id => p_rec.assignment_id

1066: hr_utility.set_location('p_assignment_id...'||p_rec.assignment_id,100);
1067: hr_utility.set_location('p_validation_start_date...'||p_validation_start_date,101);
1068: hr_utility.set_location('p_validation_end_date...'||p_validation_end_date,102);
1069:
1070: pay_sid_bus.chk_overlapping_record(p_assignment_id => p_rec.assignment_id
1071: ,p_validation_start_date => p_validation_start_date
1072: ,p_validation_end_date => p_validation_end_date);
1073:
1074: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 1098: pay_sid_bus.chk_director_flag(p_effective_date => p_effective_date

1094: --
1095: per_asg_bus1.set_security_group_id(p_rec.assignment_id);
1096: --
1097: --
1098: pay_sid_bus.chk_director_flag(p_effective_date => p_effective_date
1099: , p_director_flag => p_rec.director_flag);
1100: --
1101: pay_sid_bus.chk_contribution_class(p_effective_date => p_effective_date
1102: , p_contribution_class => p_rec.contribution_class);

Line 1101: pay_sid_bus.chk_contribution_class(p_effective_date => p_effective_date

1097: --
1098: pay_sid_bus.chk_director_flag(p_effective_date => p_effective_date
1099: , p_director_flag => p_rec.director_flag);
1100: --
1101: pay_sid_bus.chk_contribution_class(p_effective_date => p_effective_date
1102: , p_contribution_class => p_rec.contribution_class);
1103: --
1104: pay_sid_bus.chk_overridden_subclass(p_effective_date => p_effective_date
1105: , p_overridden_subclass => p_rec.overridden_subclass );

Line 1104: pay_sid_bus.chk_overridden_subclass(p_effective_date => p_effective_date

1100: --
1101: pay_sid_bus.chk_contribution_class(p_effective_date => p_effective_date
1102: , p_contribution_class => p_rec.contribution_class);
1103: --
1104: pay_sid_bus.chk_overridden_subclass(p_effective_date => p_effective_date
1105: , p_overridden_subclass => p_rec.overridden_subclass );
1106: --
1107: pay_sid_bus.chk_soc_ben_flag(p_effective_date => p_effective_date
1108: , p_soc_ben_flag => p_rec.soc_ben_flag );

Line 1107: pay_sid_bus.chk_soc_ben_flag(p_effective_date => p_effective_date

1103: --
1104: pay_sid_bus.chk_overridden_subclass(p_effective_date => p_effective_date
1105: , p_overridden_subclass => p_rec.overridden_subclass );
1106: --
1107: pay_sid_bus.chk_soc_ben_flag(p_effective_date => p_effective_date
1108: , p_soc_ben_flag => p_rec.soc_ben_flag );
1109: --
1110: pay_sid_bus.chk_soc_ben_start_date(p_effective_date => p_effective_date
1111: , p_soc_ben_flag => p_rec.soc_ben_flag

Line 1110: pay_sid_bus.chk_soc_ben_start_date(p_effective_date => p_effective_date

1106: --
1107: pay_sid_bus.chk_soc_ben_flag(p_effective_date => p_effective_date
1108: , p_soc_ben_flag => p_rec.soc_ben_flag );
1109: --
1110: pay_sid_bus.chk_soc_ben_start_date(p_effective_date => p_effective_date
1111: , p_soc_ben_flag => p_rec.soc_ben_flag
1112: , p_soc_ben_start_date => p_rec.soc_ben_start_date);
1113: --
1114: pay_sid_bus.chk_overridden_ins_weeks(p_effective_date => p_effective_date

Line 1114: pay_sid_bus.chk_overridden_ins_weeks(p_effective_date => p_effective_date

1110: pay_sid_bus.chk_soc_ben_start_date(p_effective_date => p_effective_date
1111: , p_soc_ben_flag => p_rec.soc_ben_flag
1112: , p_soc_ben_start_date => p_rec.soc_ben_start_date);
1113: --
1114: pay_sid_bus.chk_overridden_ins_weeks(p_effective_date => p_effective_date
1115: , p_assignment_id => p_rec.assignment_id
1116: , p_overridden_ins_weeks => p_rec.overridden_ins_weeks);
1117: --
1118: pay_sid_bus.chk_exemption_start_end_dates( p_exemption_start_Date => p_rec.exemption_start_date

Line 1118: pay_sid_bus.chk_exemption_start_end_dates( p_exemption_start_Date => p_rec.exemption_start_date

1114: pay_sid_bus.chk_overridden_ins_weeks(p_effective_date => p_effective_date
1115: , p_assignment_id => p_rec.assignment_id
1116: , p_overridden_ins_weeks => p_rec.overridden_ins_weeks);
1117: --
1118: pay_sid_bus.chk_exemption_start_end_dates( p_exemption_start_Date => p_rec.exemption_start_date
1119: , p_exemption_end_date => p_rec.exemption_end_date) ;
1120: --
1121: pay_sid_bus.chk_community_flag(p_effective_date => p_effective_date
1122: , p_community_flag => p_rec.community_flag);

Line 1121: pay_sid_bus.chk_community_flag(p_effective_date => p_effective_date

1117: --
1118: pay_sid_bus.chk_exemption_start_end_dates( p_exemption_start_Date => p_rec.exemption_start_date
1119: , p_exemption_end_date => p_rec.exemption_end_date) ;
1120: --
1121: pay_sid_bus.chk_community_flag(p_effective_date => p_effective_date
1122: , p_community_flag => p_rec.community_flag);
1123: --
1124: -- Call the datetrack update integrity operation
1125: --

Line 1170: end pay_sid_bus;

1166: --
1167: hr_utility.set_location(' Leaving:'||l_proc, 10);
1168: End delete_validate;
1169: --
1170: end pay_sid_bus;