1 package ben_cwb_asg_update AUTHID CURRENT_USER as
2 /* $Header: bencwbau.pkh 120.1.12000000.1 2007/01/19 15:19:38 appldev noship $ */
3 /* ===========================================================================+
4 * Name
5 * Compensation Workbench Transaction Update Package
6 * Purpose
7 * This package is used to insert record into ben_transaction table
8 * when performance rating or promotion details
9 * are updated on the Worksheet.
10 *
11 * Version Date Author Comment
12 * -------+-----------+---------+----------------------------------------------
13 * 115.0 15-Feb-2003 maagrawa created
14 * 115.1 12-Jan-2004 maagrawa Global Budgeting change.
15 * 115.2 16-Mar-2004 aprabhak Added delete_transaction to specification
16 * 115.3 25-Mar-2004 maagrawa Add p_person_name as parameter.
17 * 115.4 29-Mar-2004 maagrawa Update ben_cwb_person_info with perf/promo
18 * ids when called from PP.
19 * 115.5 25-May-2004 maagrawa Perf/Promo record split.
20 * 115.6 10-Feb-2005 maagrawa Pass group_pl_id as plan reference to
21 * process_rating, process_promotions.
22 * 115.7 20-Sep-2006 steotia 5531065: Using Performance Overrides (but
23 * only if used through SS)
24 * ==========================================================================+
25 */
26 g_ws_asg_rec_type varchar2(30) := 'CWBASG';
27 g_ws_perf_rec_type varchar2(30) := 'CWBPERF';
28
29 cursor g_txn(v_txn_id number,
30 v_txn_type varchar2) is
31 select txn.attribute1
32 ,txn.attribute2
33 ,txn.attribute3
34 ,txn.attribute4
35 ,txn.attribute5
36 ,txn.attribute6
37 ,txn.attribute7
38 ,txn.attribute8
39 ,txn.attribute9
40 ,txn.attribute10
41 ,txn.attribute11
42 ,txn.attribute12
43 ,txn.attribute13
44 ,txn.attribute14
45 ,txn.attribute15
46 ,txn.attribute16
47 ,txn.attribute17
48 ,txn.attribute18
49 ,txn.attribute19
50 ,txn.attribute20
51 ,txn.attribute21
52 ,txn.attribute22
53 ,txn.attribute23
54 ,txn.attribute24
55 ,txn.attribute25
56 ,txn.attribute26
57 ,txn.attribute27
58 ,txn.attribute28
59 ,txn.attribute29
60 ,txn.attribute30
61 ,txn.attribute31
62 ,txn.attribute32
63 ,txn.attribute33
64 ,txn.attribute34
65 ,txn.attribute35
66 ,txn.attribute36
67 ,txn.attribute37
68 ,txn.attribute38
69 ,txn.attribute39
70 ,txn.attribute40
71 ,txn.transaction_id assignment_id
72 from ben_transaction txn
73 where txn.transaction_id = v_txn_id
74 and txn.transaction_type = v_txn_type;
75
76 procedure process_rating
77 (p_person_id in number
78 ,p_txn_rec in g_txn%rowtype
79 ,p_business_group_id in number
80 ,p_audit_log in varchar2 default 'N'
81 ,p_process_status in out nocopy varchar2
82 ,p_group_per_in_ler_id in number default null
83 ,p_effective_date in date);
84
85 procedure process_promotions
86 (p_person_id in number
87 ,p_asg_txn_rec in g_txn%rowtype
88 ,p_business_group_id in number
89 ,p_audit_log in varchar2 default 'N'
90 ,p_process_status in out nocopy varchar2
91 ,p_group_per_in_ler_id in number default null
92 ,p_effective_date in date);
93
94 procedure delete_transaction
95 (p_transaction_id in number
96 ,p_transaction_type in varchar2);
97
98
99 procedure process_rating
100 (p_validate_data in varchar2 default 'Y'
101 ,p_assignment_id in number
102 ,p_person_id in number
103 ,p_business_group_id in number
104 ,p_perf_revw_strt_dt in varchar2
105 ,p_perf_type in varchar2
106 ,p_perf_rating in varchar2
107 ,p_person_name in varchar2
108 ,p_update_person_id in number
109 ,p_update_date in date
110 ,p_group_pl_id in number);
111
112 procedure process_promotions
113 (p_validate_data in varchar2 default 'Y'
114 ,p_assignment_id in number
115 ,p_person_id in number
116 ,p_business_group_id in number
117 ,p_asg_updt_eff_date in varchar2
118 ,p_change_reason in varchar2
119 ,p_job_id in number
120 ,p_position_id in number
121 ,p_grade_id in number
122 ,p_people_group_id in number
123 ,p_soft_coding_keyflex_id in number
124 ,p_ass_attribute1 in varchar2
125 ,p_ass_attribute2 in varchar2
126 ,p_ass_attribute3 in varchar2
127 ,p_ass_attribute4 in varchar2
128 ,p_ass_attribute5 in varchar2
129 ,p_ass_attribute6 in varchar2
130 ,p_ass_attribute7 in varchar2
131 ,p_ass_attribute8 in varchar2
132 ,p_ass_attribute9 in varchar2
133 ,p_ass_attribute10 in varchar2
134 ,p_ass_attribute11 in varchar2
135 ,p_ass_attribute12 in varchar2
136 ,p_ass_attribute13 in varchar2
137 ,p_ass_attribute14 in varchar2
138 ,p_ass_attribute15 in varchar2
139 ,p_ass_attribute16 in varchar2
140 ,p_ass_attribute17 in varchar2
141 ,p_ass_attribute18 in varchar2
142 ,p_ass_attribute19 in varchar2
143 ,p_ass_attribute20 in varchar2
144 ,p_ass_attribute21 in varchar2
145 ,p_ass_attribute22 in varchar2
146 ,p_ass_attribute23 in varchar2
147 ,p_ass_attribute24 in varchar2
148 ,p_ass_attribute25 in varchar2
149 ,p_ass_attribute26 in varchar2
150 ,p_ass_attribute27 in varchar2
151 ,p_ass_attribute28 in varchar2
152 ,p_ass_attribute29 in varchar2
153 ,p_ass_attribute30 in varchar2
154 ,p_person_name in varchar2
155 ,p_update_person_id in number
156 ,p_update_date in date
157 ,p_group_pl_id in number);
158
159 end ben_cwb_asg_update;
[Home] [Help]