APPS.BEN_CWB_MASS_NOTIFN_PKG dependencies on BEN_TRANSACTION

Line 35: FROM ben_transaction txn

31: ,v_messg_txt_body IN VARCHAR2
32: )
33: IS
34: SELECT txn.transaction_id
35: FROM ben_transaction txn
36: WHERE txn.transaction_type = 'CWBMASSNOTIF'
37: AND txn.attribute1 = v_user_name
38: AND txn.attribute2 = v_plan_id||','||to_char(v_lf_evt_orcd_date,'yyyy/mm/dd')
39: AND txn.attribute3 = v_messg_txt_body;

Line 532: l_trans_rec ben_transaction%rowtype;

528: l_notify boolean;
529: l_transaction_id number;
530: l_wf_key number;
531: l_transaction_key number;
532: l_trans_rec ben_transaction%rowtype;
533: l_user_name varchar2(100);
534: l_reject_reason varchar2(30);
535: l_system_person_type per_person_types.system_person_type%type;
536: l_assignment_id ben_cwb_person_info.assignment_id%type;

Line 667: select BEN_TRANSACTION_S.NEXTVAL into l_transaction_key from dual;

663: WF_DIRECTORY.AddUsersToAdHocRole(adhocRole,v_users(element));
664: */
665: --insert into nt values (v_users(element));
666:
667: select BEN_TRANSACTION_S.NEXTVAL into l_transaction_key from dual;
668: l_trans_rec.attribute1 := v_users(element);
669: l_trans_rec.attribute2 := p_pl_id ||','|| to_char(p_lf_evt_ocrd_dt,'yyyy/mm/dd');
670: l_trans_rec.attribute3 := p_messg_txt_body;
671: l_trans_rec.attribute4 := sysdate;

Line 672: insert into ben_transaction

668: l_trans_rec.attribute1 := v_users(element);
669: l_trans_rec.attribute2 := p_pl_id ||','|| to_char(p_lf_evt_ocrd_dt,'yyyy/mm/dd');
670: l_trans_rec.attribute3 := p_messg_txt_body;
671: l_trans_rec.attribute4 := sysdate;
672: insert into ben_transaction
673: (transaction_id ,transaction_type
674: ,attribute1 ,attribute2
675: ,attribute3 ,attribute4
676: ,attribute5 ,attribute6