DBA Data[Home] [Help]

APPS.BIS_PMF_ALERT_REG_PVT dependencies on DUAL

Line 79: select bis_alert_registration_s.NextVal into l_registration_id from dual;

75:
76: --
77: -- Selecting the Next Registion Id from Sequence Generator
78: --
79: select bis_alert_registration_s.NextVal into l_registration_id from dual;
80: --
81: --BIS_UTILITIES_PUB.put_line(p_text =>'creating paramter set. notifier code: '
82: --||p_Param_Set_Rec.NOTIFIERS_CODE);
83:

Line 109: from dual;

105: BEGIN
106: null;
107: select '~WF_ADHOC-' ||WF_ADHOC_ROLE_S.NEXTVAL
108: into l_null_role_name
109: from dual;
110: l_null_role_name_p := l_null_role_name;
111: wf_directory.CreateAdHocRole
112: ( role_name => l_null_role_name_p
113: -- , role_display_name => l_role_display_name