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 136: delete ben_transaction

132: procedure delete_transaction
133: (p_transaction_id in number
134: ,p_transaction_type in varchar2) is
135: begin
136: delete ben_transaction
137: where transaction_id = p_transaction_id
138: and transaction_type = p_transaction_type;
139: end;
140: --

Line 150: (p_txn_old in ben_transaction%rowtype

146: -- Description
147: -- This is an internal procedure
148: --
149: procedure create_audit_record_rating
150: (p_txn_old in ben_transaction%rowtype
151: ,p_group_pl_id in number
152: ) is
153:
154: l_txn_new ben_transaction%rowtype;

Line 154: l_txn_new ben_transaction%rowtype;

150: (p_txn_old in ben_transaction%rowtype
151: ,p_group_pl_id in number
152: ) is
153:
154: l_txn_new ben_transaction%rowtype;
155: l_cwb_audit_id ben_cwb_audit.cwb_audit_id%type;
156: l_object_version_number ben_cwb_audit.object_version_number%type;
157: l_cd_meaning_old hr_lookups.meaning%type;
158: l_cd_meaning_new hr_lookups.meaning%type;

Line 195: from ben_transaction

191: cursor c_collect_record_rating
192: (p_assgn_id number
193: ,p_trans_type varchar2) is
194: select *
195: from ben_transaction
196: where transaction_id = p_assgn_id
197: and transaction_type = p_trans_type;
198: --
199:

Line 230: from ben_transaction

226: end if;
227:
228: begin
229: select * into l_txn_new
230: from ben_transaction
231: where transaction_id = p_txn_old.transaction_id
232: and transaction_type = p_txn_old.transaction_type;
233: --
234: if( ((p_txn_old.attribute3 is null)

Line 308: (p_txn_old in ben_transaction%rowtype

304: -- Description
305: -- This is an internal procedure
306: --
307: procedure create_audit_record_promotion
308: (p_txn_old in ben_transaction%rowtype
309: ,p_group_pl_id in number
310: ) is
311:
312: l_txn_new ben_transaction%rowtype; --- line 118 ---

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

308: (p_txn_old in ben_transaction%rowtype
309: ,p_group_pl_id in number
310: ) is
311:
312: l_txn_new ben_transaction%rowtype; --- line 118 ---
313: l_cwb_audit_id ben_cwb_audit.cwb_audit_id%type;
314: l_object_version_number ben_cwb_audit.object_version_number%type;
315: l_cd_meaning_old varchar2(240);
316: l_cd_meaning_new varchar2(240);

Line 354: from ben_transaction

350: cursor c_collect_record_promotions
351: (v_assgn_id number
352: ,v_trans_type varchar2) is
353: select *
354: from ben_transaction
355: where transaction_id = v_assgn_id
356: and transaction_type = v_trans_type;
357: --
358: cursor c_job

Line 415: from ben_transaction

411: end if;
412:
413: begin
414: select * into l_txn_new
415: from ben_transaction
416: where transaction_id = p_txn_old.transaction_id
417: and transaction_type = p_txn_old.transaction_type;
418: --
419: if( ((p_txn_old.attribute5 is null)

Line 1993: from ben_transaction txn

1989: ,p_transaction_type in varchar2
1990: ,p_txn_rec in g_txn%rowtype) is
1991: cursor c_found is
1992: select txn.transaction_id
1993: from ben_transaction txn
1994: where txn.transaction_id = p_transaction_id
1995: and txn.transaction_type = p_transaction_type;
1996: l_transaction_id number;
1997: begin

Line 2004: insert into ben_transaction

2000: fetch c_found into l_transaction_id;
2001: close c_found;
2002:
2003: if l_transaction_id is null then
2004: insert into ben_transaction
2005: (transaction_id ,transaction_type
2006: ,attribute1 ,attribute2
2007: ,attribute3 ,attribute4
2008: ,attribute5 ,attribute6

Line 2049: update ben_transaction

2045: ,p_txn_rec.attribute35 ,p_txn_rec.attribute36
2046: ,p_txn_rec.attribute37 ,p_txn_rec.attribute38
2047: ,p_txn_rec.attribute39 ,p_txn_rec.attribute40);
2048: else
2049: update ben_transaction
2050: set attribute1 = p_txn_rec.attribute1
2051: ,attribute2 = p_txn_rec.attribute2
2052: ,attribute3 = p_txn_rec.attribute3
2053: ,attribute4 = p_txn_rec.attribute4

Line 2112: l_txn_record ben_transaction%rowtype;

2108: l_process_status varchar2(30) := null;
2109: l_save_status varchar2(30) := null;
2110:
2111: ---- audit changes begin ------------------------------
2112: l_txn_record ben_transaction%rowtype;
2113: cursor c_collect_record_rating
2114: (p_assgn_id number
2115: ,g_ws_perf_rec_typ varchar2
2116: ,p_perf_revw_dt varchar2

Line 2120: from ben_transaction

2116: ,p_perf_revw_dt varchar2
2117: ,p_perfor_type varchar2
2118: ) is
2119: select *
2120: from ben_transaction
2121: where transaction_id = p_assgn_id
2122: and transaction_type = g_ws_perf_rec_typ || p_perf_revw_dt || p_perfor_type;
2123: -------- end ------------------------------------------
2124:

Line 2285: l_txn_record ben_transaction%rowtype;

2281: l_process_status varchar2(30) := null;
2282: l_save_status varchar2(30) := null;
2283:
2284: ---- audit changes begin ------------------------------
2285: l_txn_record ben_transaction%rowtype;
2286: l_txn_record_n ben_transaction%rowtype;
2287: cursor c_collect_record_promotions
2288: (p_assgn_id number
2289: ,g_ws_perf_rec_typ varchar2

Line 2286: l_txn_record_n ben_transaction%rowtype;

2282: l_save_status varchar2(30) := null;
2283:
2284: ---- audit changes begin ------------------------------
2285: l_txn_record ben_transaction%rowtype;
2286: l_txn_record_n ben_transaction%rowtype;
2287: cursor c_collect_record_promotions
2288: (p_assgn_id number
2289: ,g_ws_perf_rec_typ varchar2
2290: ,p_asg_updt_eff_dt varchar2

Line 2293: from ben_transaction

2289: ,g_ws_perf_rec_typ varchar2
2290: ,p_asg_updt_eff_dt varchar2
2291: ) is
2292: select *
2293: from ben_transaction
2294: where transaction_id = p_assgn_id
2295: and transaction_type = g_ws_perf_rec_typ || p_asg_updt_eff_dt;
2296:
2297: -------- end ------------------------------------------