APPS.BEN_CWB_ASG_UPDATE dependencies on BEN_TRANSACTION

Line 7: * This package is used to insert record into ben_transaction table

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

Line 141: delete ben_transaction

137: procedure delete_transaction
138: (p_transaction_id in number
139: ,p_transaction_type in varchar2) is
140: begin
141: delete ben_transaction
142: where transaction_id = p_transaction_id
143: and transaction_type = p_transaction_type;
144: end;
145: --

Line 155: (p_txn_old in ben_transaction%rowtype

151: -- Description
152: -- This is an internal procedure
153: --
154: procedure create_audit_record_rating
155: (p_txn_old in ben_transaction%rowtype
156: ,p_group_pl_id in number
157: ) is
158:
159: l_txn_new ben_transaction%rowtype;

Line 159: l_txn_new ben_transaction%rowtype;

155: (p_txn_old in ben_transaction%rowtype
156: ,p_group_pl_id in number
157: ) is
158:
159: l_txn_new ben_transaction%rowtype;
160: l_cwb_audit_id ben_cwb_audit.cwb_audit_id%type;
161: l_object_version_number ben_cwb_audit.object_version_number%type;
162: l_cd_meaning_old hr_lookups.meaning%type;
163: l_cd_meaning_new hr_lookups.meaning%type;

Line 200: from ben_transaction

196: cursor c_collect_record_rating
197: (p_assgn_id number
198: ,p_trans_type varchar2) is
199: select *
200: from ben_transaction
201: where transaction_id = p_assgn_id
202: and transaction_type = p_trans_type;
203: --
204:

Line 235: from ben_transaction

231: end if;
232:
233: begin
234: select * into l_txn_new
235: from ben_transaction
236: where transaction_id = p_txn_old.transaction_id
237: and transaction_type = p_txn_old.transaction_type;
238: --
239: if( ((p_txn_old.attribute3 is null)

Line 313: (p_txn_old in ben_transaction%rowtype

309: -- Description
310: -- This is an internal procedure
311: --
312: procedure create_audit_record_promotion
313: (p_txn_old in ben_transaction%rowtype
314: ,p_group_pl_id in number
315: ) is
316:
317: l_txn_new ben_transaction%rowtype; --- line 118 ---

Line 317: l_txn_new ben_transaction%rowtype; --- line 118 ---

313: (p_txn_old in ben_transaction%rowtype
314: ,p_group_pl_id in number
315: ) is
316:
317: l_txn_new ben_transaction%rowtype; --- line 118 ---
318: l_cwb_audit_id ben_cwb_audit.cwb_audit_id%type;
319: l_object_version_number ben_cwb_audit.object_version_number%type;
320: l_cd_meaning_old varchar2(240);
321: l_cd_meaning_new varchar2(240);

Line 359: from ben_transaction

355: cursor c_collect_record_promotions
356: (v_assgn_id number
357: ,v_trans_type varchar2) is
358: select *
359: from ben_transaction
360: where transaction_id = v_assgn_id
361: and transaction_type = v_trans_type;
362: --
363: cursor c_job

Line 420: from ben_transaction

416: end if;
417:
418: begin
419: select * into l_txn_new
420: from ben_transaction
421: where transaction_id = p_txn_old.transaction_id
422: and transaction_type = p_txn_old.transaction_type;
423: --
424: if( ((p_txn_old.attribute5 is null)

Line 1998: from ben_transaction txn

1994: ,p_transaction_type in varchar2
1995: ,p_txn_rec in g_txn%rowtype) is
1996: cursor c_found is
1997: select txn.transaction_id
1998: from ben_transaction txn
1999: where txn.transaction_id = p_transaction_id
2000: and txn.transaction_type = p_transaction_type;
2001: l_transaction_id number;
2002: begin

Line 2009: insert into ben_transaction

2005: fetch c_found into l_transaction_id;
2006: close c_found;
2007:
2008: if l_transaction_id is null then
2009: insert into ben_transaction
2010: (transaction_id ,transaction_type
2011: ,attribute1 ,attribute2
2012: ,attribute3 ,attribute4
2013: ,attribute5 ,attribute6

Line 2054: update ben_transaction

2050: ,p_txn_rec.attribute35 ,p_txn_rec.attribute36
2051: ,p_txn_rec.attribute37 ,p_txn_rec.attribute38
2052: ,p_txn_rec.attribute39 ,p_txn_rec.attribute40);
2053: else
2054: update ben_transaction
2055: set attribute1 = p_txn_rec.attribute1
2056: ,attribute2 = p_txn_rec.attribute2
2057: ,attribute3 = p_txn_rec.attribute3
2058: ,attribute4 = p_txn_rec.attribute4

Line 2117: l_txn_record ben_transaction%rowtype;

2113: l_process_status varchar2(30) := null;
2114: l_save_status varchar2(30) := null;
2115:
2116: ---- audit changes begin ------------------------------
2117: l_txn_record ben_transaction%rowtype;
2118: cursor c_collect_record_rating
2119: (p_assgn_id number
2120: ,g_ws_perf_rec_typ varchar2
2121: ,p_perf_revw_dt varchar2

Line 2125: from ben_transaction

2121: ,p_perf_revw_dt varchar2
2122: ,p_perfor_type varchar2
2123: ) is
2124: select *
2125: from ben_transaction
2126: where transaction_id = p_assgn_id
2127: and transaction_type = g_ws_perf_rec_typ || p_perf_revw_dt || p_perfor_type;
2128: -------- end ------------------------------------------
2129:

Line 2290: l_txn_record ben_transaction%rowtype;

2286: l_process_status varchar2(30) := null;
2287: l_save_status varchar2(30) := null;
2288:
2289: ---- audit changes begin ------------------------------
2290: l_txn_record ben_transaction%rowtype;
2291: l_txn_record_n ben_transaction%rowtype;
2292: cursor c_collect_record_promotions
2293: (p_assgn_id number
2294: ,g_ws_perf_rec_typ varchar2

Line 2291: l_txn_record_n ben_transaction%rowtype;

2287: l_save_status varchar2(30) := null;
2288:
2289: ---- audit changes begin ------------------------------
2290: l_txn_record ben_transaction%rowtype;
2291: l_txn_record_n ben_transaction%rowtype;
2292: cursor c_collect_record_promotions
2293: (p_assgn_id number
2294: ,g_ws_perf_rec_typ varchar2
2295: ,p_asg_updt_eff_dt varchar2

Line 2298: from ben_transaction

2294: ,g_ws_perf_rec_typ varchar2
2295: ,p_asg_updt_eff_dt varchar2
2296: ) is
2297: select *
2298: from ben_transaction
2299: where transaction_id = p_assgn_id
2300: and transaction_type = g_ws_perf_rec_typ || p_asg_updt_eff_dt;
2301:
2302: -------- end ------------------------------------------