1: PACKAGE BEN_ELIG_OBJ_ELIG_PROFL_SWI AUTHID CURRENT_USER as
2: /* $Header: bebepswi.pkh 120.0 2005/05/28 00:39:45 appldev noship $ */
3: procedure create_ELIG_OBJ_ELIG_PROFL
4: (
5: p_validate in number default hr_api.g_false_num
6: ,p_elig_obj_elig_prfl_id in number
7: ,p_effective_start_date out nocopy date
8: ,p_effective_end_date out nocopy date
9: ,p_business_group_id in number default null
40: -- ----------------------------------------------------------------------------
41: --
42: procedure update_ELIG_OBJ_ELIG_PROFL
43: (
44: p_validate in number default hr_api.g_false_num
45: ,p_elig_obj_elig_prfl_id in number
46: ,p_effective_start_date out nocopy date
47: ,p_effective_end_date out nocopy date
48: ,p_business_group_id in number default hr_api.g_number
44: p_validate in number default hr_api.g_false_num
45: ,p_elig_obj_elig_prfl_id in number
46: ,p_effective_start_date out nocopy date
47: ,p_effective_end_date out nocopy date
48: ,p_business_group_id in number default hr_api.g_number
49: ,p_elig_obj_id in number default hr_api.g_number
50: ,p_elig_prfl_id in number default hr_api.g_number
51: ,p_mndtry_flag in varchar2 default 'N'
52: ,p_bep_attribute_category in varchar2 default hr_api.g_varchar2
45: ,p_elig_obj_elig_prfl_id in number
46: ,p_effective_start_date out nocopy date
47: ,p_effective_end_date out nocopy date
48: ,p_business_group_id in number default hr_api.g_number
49: ,p_elig_obj_id in number default hr_api.g_number
50: ,p_elig_prfl_id in number default hr_api.g_number
51: ,p_mndtry_flag in varchar2 default 'N'
52: ,p_bep_attribute_category in varchar2 default hr_api.g_varchar2
53: ,p_bep_attribute1 in varchar2 default hr_api.g_varchar2
46: ,p_effective_start_date out nocopy date
47: ,p_effective_end_date out nocopy date
48: ,p_business_group_id in number default hr_api.g_number
49: ,p_elig_obj_id in number default hr_api.g_number
50: ,p_elig_prfl_id in number default hr_api.g_number
51: ,p_mndtry_flag in varchar2 default 'N'
52: ,p_bep_attribute_category in varchar2 default hr_api.g_varchar2
53: ,p_bep_attribute1 in varchar2 default hr_api.g_varchar2
54: ,p_bep_attribute2 in varchar2 default hr_api.g_varchar2
48: ,p_business_group_id in number default hr_api.g_number
49: ,p_elig_obj_id in number default hr_api.g_number
50: ,p_elig_prfl_id in number default hr_api.g_number
51: ,p_mndtry_flag in varchar2 default 'N'
52: ,p_bep_attribute_category in varchar2 default hr_api.g_varchar2
53: ,p_bep_attribute1 in varchar2 default hr_api.g_varchar2
54: ,p_bep_attribute2 in varchar2 default hr_api.g_varchar2
55: ,p_bep_attribute3 in varchar2 default hr_api.g_varchar2
56: ,p_bep_attribute4 in varchar2 default hr_api.g_varchar2
49: ,p_elig_obj_id in number default hr_api.g_number
50: ,p_elig_prfl_id in number default hr_api.g_number
51: ,p_mndtry_flag in varchar2 default 'N'
52: ,p_bep_attribute_category in varchar2 default hr_api.g_varchar2
53: ,p_bep_attribute1 in varchar2 default hr_api.g_varchar2
54: ,p_bep_attribute2 in varchar2 default hr_api.g_varchar2
55: ,p_bep_attribute3 in varchar2 default hr_api.g_varchar2
56: ,p_bep_attribute4 in varchar2 default hr_api.g_varchar2
57: ,p_bep_attribute5 in varchar2 default hr_api.g_varchar2
50: ,p_elig_prfl_id in number default hr_api.g_number
51: ,p_mndtry_flag in varchar2 default 'N'
52: ,p_bep_attribute_category in varchar2 default hr_api.g_varchar2
53: ,p_bep_attribute1 in varchar2 default hr_api.g_varchar2
54: ,p_bep_attribute2 in varchar2 default hr_api.g_varchar2
55: ,p_bep_attribute3 in varchar2 default hr_api.g_varchar2
56: ,p_bep_attribute4 in varchar2 default hr_api.g_varchar2
57: ,p_bep_attribute5 in varchar2 default hr_api.g_varchar2
58: ,p_bep_attribute6 in varchar2 default hr_api.g_varchar2
51: ,p_mndtry_flag in varchar2 default 'N'
52: ,p_bep_attribute_category in varchar2 default hr_api.g_varchar2
53: ,p_bep_attribute1 in varchar2 default hr_api.g_varchar2
54: ,p_bep_attribute2 in varchar2 default hr_api.g_varchar2
55: ,p_bep_attribute3 in varchar2 default hr_api.g_varchar2
56: ,p_bep_attribute4 in varchar2 default hr_api.g_varchar2
57: ,p_bep_attribute5 in varchar2 default hr_api.g_varchar2
58: ,p_bep_attribute6 in varchar2 default hr_api.g_varchar2
59: ,p_bep_attribute7 in varchar2 default hr_api.g_varchar2
52: ,p_bep_attribute_category in varchar2 default hr_api.g_varchar2
53: ,p_bep_attribute1 in varchar2 default hr_api.g_varchar2
54: ,p_bep_attribute2 in varchar2 default hr_api.g_varchar2
55: ,p_bep_attribute3 in varchar2 default hr_api.g_varchar2
56: ,p_bep_attribute4 in varchar2 default hr_api.g_varchar2
57: ,p_bep_attribute5 in varchar2 default hr_api.g_varchar2
58: ,p_bep_attribute6 in varchar2 default hr_api.g_varchar2
59: ,p_bep_attribute7 in varchar2 default hr_api.g_varchar2
60: ,p_bep_attribute8 in varchar2 default hr_api.g_varchar2
53: ,p_bep_attribute1 in varchar2 default hr_api.g_varchar2
54: ,p_bep_attribute2 in varchar2 default hr_api.g_varchar2
55: ,p_bep_attribute3 in varchar2 default hr_api.g_varchar2
56: ,p_bep_attribute4 in varchar2 default hr_api.g_varchar2
57: ,p_bep_attribute5 in varchar2 default hr_api.g_varchar2
58: ,p_bep_attribute6 in varchar2 default hr_api.g_varchar2
59: ,p_bep_attribute7 in varchar2 default hr_api.g_varchar2
60: ,p_bep_attribute8 in varchar2 default hr_api.g_varchar2
61: ,p_bep_attribute9 in varchar2 default hr_api.g_varchar2
54: ,p_bep_attribute2 in varchar2 default hr_api.g_varchar2
55: ,p_bep_attribute3 in varchar2 default hr_api.g_varchar2
56: ,p_bep_attribute4 in varchar2 default hr_api.g_varchar2
57: ,p_bep_attribute5 in varchar2 default hr_api.g_varchar2
58: ,p_bep_attribute6 in varchar2 default hr_api.g_varchar2
59: ,p_bep_attribute7 in varchar2 default hr_api.g_varchar2
60: ,p_bep_attribute8 in varchar2 default hr_api.g_varchar2
61: ,p_bep_attribute9 in varchar2 default hr_api.g_varchar2
62: ,p_bep_attribute10 in varchar2 default hr_api.g_varchar2
55: ,p_bep_attribute3 in varchar2 default hr_api.g_varchar2
56: ,p_bep_attribute4 in varchar2 default hr_api.g_varchar2
57: ,p_bep_attribute5 in varchar2 default hr_api.g_varchar2
58: ,p_bep_attribute6 in varchar2 default hr_api.g_varchar2
59: ,p_bep_attribute7 in varchar2 default hr_api.g_varchar2
60: ,p_bep_attribute8 in varchar2 default hr_api.g_varchar2
61: ,p_bep_attribute9 in varchar2 default hr_api.g_varchar2
62: ,p_bep_attribute10 in varchar2 default hr_api.g_varchar2
63: ,p_bep_attribute11 in varchar2 default hr_api.g_varchar2
56: ,p_bep_attribute4 in varchar2 default hr_api.g_varchar2
57: ,p_bep_attribute5 in varchar2 default hr_api.g_varchar2
58: ,p_bep_attribute6 in varchar2 default hr_api.g_varchar2
59: ,p_bep_attribute7 in varchar2 default hr_api.g_varchar2
60: ,p_bep_attribute8 in varchar2 default hr_api.g_varchar2
61: ,p_bep_attribute9 in varchar2 default hr_api.g_varchar2
62: ,p_bep_attribute10 in varchar2 default hr_api.g_varchar2
63: ,p_bep_attribute11 in varchar2 default hr_api.g_varchar2
64: ,p_bep_attribute12 in varchar2 default hr_api.g_varchar2
57: ,p_bep_attribute5 in varchar2 default hr_api.g_varchar2
58: ,p_bep_attribute6 in varchar2 default hr_api.g_varchar2
59: ,p_bep_attribute7 in varchar2 default hr_api.g_varchar2
60: ,p_bep_attribute8 in varchar2 default hr_api.g_varchar2
61: ,p_bep_attribute9 in varchar2 default hr_api.g_varchar2
62: ,p_bep_attribute10 in varchar2 default hr_api.g_varchar2
63: ,p_bep_attribute11 in varchar2 default hr_api.g_varchar2
64: ,p_bep_attribute12 in varchar2 default hr_api.g_varchar2
65: ,p_bep_attribute13 in varchar2 default hr_api.g_varchar2
58: ,p_bep_attribute6 in varchar2 default hr_api.g_varchar2
59: ,p_bep_attribute7 in varchar2 default hr_api.g_varchar2
60: ,p_bep_attribute8 in varchar2 default hr_api.g_varchar2
61: ,p_bep_attribute9 in varchar2 default hr_api.g_varchar2
62: ,p_bep_attribute10 in varchar2 default hr_api.g_varchar2
63: ,p_bep_attribute11 in varchar2 default hr_api.g_varchar2
64: ,p_bep_attribute12 in varchar2 default hr_api.g_varchar2
65: ,p_bep_attribute13 in varchar2 default hr_api.g_varchar2
66: ,p_bep_attribute14 in varchar2 default hr_api.g_varchar2
59: ,p_bep_attribute7 in varchar2 default hr_api.g_varchar2
60: ,p_bep_attribute8 in varchar2 default hr_api.g_varchar2
61: ,p_bep_attribute9 in varchar2 default hr_api.g_varchar2
62: ,p_bep_attribute10 in varchar2 default hr_api.g_varchar2
63: ,p_bep_attribute11 in varchar2 default hr_api.g_varchar2
64: ,p_bep_attribute12 in varchar2 default hr_api.g_varchar2
65: ,p_bep_attribute13 in varchar2 default hr_api.g_varchar2
66: ,p_bep_attribute14 in varchar2 default hr_api.g_varchar2
67: ,p_bep_attribute15 in varchar2 default hr_api.g_varchar2
60: ,p_bep_attribute8 in varchar2 default hr_api.g_varchar2
61: ,p_bep_attribute9 in varchar2 default hr_api.g_varchar2
62: ,p_bep_attribute10 in varchar2 default hr_api.g_varchar2
63: ,p_bep_attribute11 in varchar2 default hr_api.g_varchar2
64: ,p_bep_attribute12 in varchar2 default hr_api.g_varchar2
65: ,p_bep_attribute13 in varchar2 default hr_api.g_varchar2
66: ,p_bep_attribute14 in varchar2 default hr_api.g_varchar2
67: ,p_bep_attribute15 in varchar2 default hr_api.g_varchar2
68: ,p_bep_attribute16 in varchar2 default hr_api.g_varchar2
61: ,p_bep_attribute9 in varchar2 default hr_api.g_varchar2
62: ,p_bep_attribute10 in varchar2 default hr_api.g_varchar2
63: ,p_bep_attribute11 in varchar2 default hr_api.g_varchar2
64: ,p_bep_attribute12 in varchar2 default hr_api.g_varchar2
65: ,p_bep_attribute13 in varchar2 default hr_api.g_varchar2
66: ,p_bep_attribute14 in varchar2 default hr_api.g_varchar2
67: ,p_bep_attribute15 in varchar2 default hr_api.g_varchar2
68: ,p_bep_attribute16 in varchar2 default hr_api.g_varchar2
69: ,p_bep_attribute17 in varchar2 default hr_api.g_varchar2
62: ,p_bep_attribute10 in varchar2 default hr_api.g_varchar2
63: ,p_bep_attribute11 in varchar2 default hr_api.g_varchar2
64: ,p_bep_attribute12 in varchar2 default hr_api.g_varchar2
65: ,p_bep_attribute13 in varchar2 default hr_api.g_varchar2
66: ,p_bep_attribute14 in varchar2 default hr_api.g_varchar2
67: ,p_bep_attribute15 in varchar2 default hr_api.g_varchar2
68: ,p_bep_attribute16 in varchar2 default hr_api.g_varchar2
69: ,p_bep_attribute17 in varchar2 default hr_api.g_varchar2
70: ,p_bep_attribute18 in varchar2 default hr_api.g_varchar2
63: ,p_bep_attribute11 in varchar2 default hr_api.g_varchar2
64: ,p_bep_attribute12 in varchar2 default hr_api.g_varchar2
65: ,p_bep_attribute13 in varchar2 default hr_api.g_varchar2
66: ,p_bep_attribute14 in varchar2 default hr_api.g_varchar2
67: ,p_bep_attribute15 in varchar2 default hr_api.g_varchar2
68: ,p_bep_attribute16 in varchar2 default hr_api.g_varchar2
69: ,p_bep_attribute17 in varchar2 default hr_api.g_varchar2
70: ,p_bep_attribute18 in varchar2 default hr_api.g_varchar2
71: ,p_bep_attribute19 in varchar2 default hr_api.g_varchar2
64: ,p_bep_attribute12 in varchar2 default hr_api.g_varchar2
65: ,p_bep_attribute13 in varchar2 default hr_api.g_varchar2
66: ,p_bep_attribute14 in varchar2 default hr_api.g_varchar2
67: ,p_bep_attribute15 in varchar2 default hr_api.g_varchar2
68: ,p_bep_attribute16 in varchar2 default hr_api.g_varchar2
69: ,p_bep_attribute17 in varchar2 default hr_api.g_varchar2
70: ,p_bep_attribute18 in varchar2 default hr_api.g_varchar2
71: ,p_bep_attribute19 in varchar2 default hr_api.g_varchar2
72: ,p_bep_attribute20 in varchar2 default hr_api.g_varchar2
65: ,p_bep_attribute13 in varchar2 default hr_api.g_varchar2
66: ,p_bep_attribute14 in varchar2 default hr_api.g_varchar2
67: ,p_bep_attribute15 in varchar2 default hr_api.g_varchar2
68: ,p_bep_attribute16 in varchar2 default hr_api.g_varchar2
69: ,p_bep_attribute17 in varchar2 default hr_api.g_varchar2
70: ,p_bep_attribute18 in varchar2 default hr_api.g_varchar2
71: ,p_bep_attribute19 in varchar2 default hr_api.g_varchar2
72: ,p_bep_attribute20 in varchar2 default hr_api.g_varchar2
73: ,p_object_version_number in out nocopy number
66: ,p_bep_attribute14 in varchar2 default hr_api.g_varchar2
67: ,p_bep_attribute15 in varchar2 default hr_api.g_varchar2
68: ,p_bep_attribute16 in varchar2 default hr_api.g_varchar2
69: ,p_bep_attribute17 in varchar2 default hr_api.g_varchar2
70: ,p_bep_attribute18 in varchar2 default hr_api.g_varchar2
71: ,p_bep_attribute19 in varchar2 default hr_api.g_varchar2
72: ,p_bep_attribute20 in varchar2 default hr_api.g_varchar2
73: ,p_object_version_number in out nocopy number
74: ,p_effective_date in date
67: ,p_bep_attribute15 in varchar2 default hr_api.g_varchar2
68: ,p_bep_attribute16 in varchar2 default hr_api.g_varchar2
69: ,p_bep_attribute17 in varchar2 default hr_api.g_varchar2
70: ,p_bep_attribute18 in varchar2 default hr_api.g_varchar2
71: ,p_bep_attribute19 in varchar2 default hr_api.g_varchar2
72: ,p_bep_attribute20 in varchar2 default hr_api.g_varchar2
73: ,p_object_version_number in out nocopy number
74: ,p_effective_date in date
75: ,p_datetrack_mode in varchar2
68: ,p_bep_attribute16 in varchar2 default hr_api.g_varchar2
69: ,p_bep_attribute17 in varchar2 default hr_api.g_varchar2
70: ,p_bep_attribute18 in varchar2 default hr_api.g_varchar2
71: ,p_bep_attribute19 in varchar2 default hr_api.g_varchar2
72: ,p_bep_attribute20 in varchar2 default hr_api.g_varchar2
73: ,p_object_version_number in out nocopy number
74: ,p_effective_date in date
75: ,p_datetrack_mode in varchar2
76: ,p_return_status out nocopy varchar2
80: -- ----------------------------------------------------------------------------
81: --
82: procedure delete_ELIG_OBJ_ELIG_PROFL
83: (
84: p_validate in number default hr_api.g_false_num
85: ,p_elig_obj_elig_prfl_id in number
86: ,p_effective_start_date out nocopy date
87: ,p_effective_end_date out nocopy date
88: ,p_object_version_number in out nocopy number