DBA Data[Home] [Help]

APPS.BEN_CWB_MASS_NOTIFN_PKG dependencies on DUAL

Line 613: select BEN_CWB_WF_NTF_S.NEXTVAL into l_wf_key from dual;

609: end if;
610: if(l_notify = TRUE) then
611: if(p_withhold_notifn = 'N') then
612:
613: select BEN_CWB_WF_NTF_S.NEXTVAL into l_wf_key from dual;
614: wf_engine.createProcess (ItemType => 'BENCWBFY',
615: ItemKey => l_wf_key,
616: process => 'MASS_NOTIFICATION_PROC');
617: -----------------------------------------------------------------

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;