DBA Data[Home] [Help]

APPS.BEN_CWB_WF_NTF dependencies on BEN_CWB_WF_NTF

Line 1: PACKAGE BODY BEN_CWB_WF_NTF AS

1: PACKAGE BODY BEN_CWB_WF_NTF AS
2: /* $Header: bencwbfy.pkb 120.1 2011/02/11 12:04:27 sgnanama ship $ */
3: g_package VARCHAR2 (60) := 'BEN_CWB_WF_NTF';
4: g_itemtype VARCHAR2 (60) := 'BENCWBFY';
5: g_wfprocess VARCHAR2 (60) := 'CWBFYINTF';

Line 3: g_package VARCHAR2 (60) := 'BEN_CWB_WF_NTF';

1: PACKAGE BODY BEN_CWB_WF_NTF AS
2: /* $Header: bencwbfy.pkb 120.1 2011/02/11 12:04:27 sgnanama ship $ */
3: g_package VARCHAR2 (60) := 'BEN_CWB_WF_NTF';
4: g_itemtype VARCHAR2 (60) := 'BENCWBFY';
5: g_wfprocess VARCHAR2 (60) := 'CWBFYINTF';
6:
7: FUNCTION get_issue_bdgt_ntf_comment(p_transaction_id NUMBER)

Line 590: SELECT ben_cwb_wf_ntf_s.NEXTVAL

586:
587: --
588: -- A unique itemkey is generated for every workflow transaction
589: --
590: SELECT ben_cwb_wf_ntf_s.NEXTVAL
591: INTO l_itemkey
592: FROM DUAL;
593:
594: hr_utility.TRACE ('l_itemkey : ' || l_itemkey);