APPS.CSD_REPAIRS_PVT dependencies on DUAL

Line 105: FROM sys.dual;

101: --
102: --
103: CURSOR C1 IS
104: SELECT CSD_REPAIRS_S1.NEXTVAL
105: FROM sys.dual;
106: --
107: CURSOR C2 IS
108: SELECT CSD_REPAIRS_S2.NEXTVAL
109: FROM sys.dual;

Line 109: FROM sys.dual;

105: FROM sys.dual;
106: --
107: CURSOR C2 IS
108: SELECT CSD_REPAIRS_S2.NEXTVAL
109: FROM sys.dual;
110: --
111: CURSOR get_draft_status_details IS
112: SELECT FS_B.flow_status_id,
113: FS_B.flow_status_code,

Line 4265: FROM DUAL;

4261: IF (l_wf_item_type IS NOT NULL) THEN
4262:
4263: SELECT TO_CHAR(CSD_WF_ITEM_KEY_S.NEXTVAL)
4264: INTO l_wf_item_key
4265: FROM DUAL;
4266:
4267: l_flwsts_wf_rec.repair_line_id := p_repair_line_id;
4268: l_flwsts_wf_rec.repair_type_id := p_repair_type_id;
4269: l_flwsts_wf_rec.from_flow_status_id := p_from_flow_status_id;

Line 5712: Select csd_ro_status_bevent_key_s1.nextval into l_event_key from dual ;

5708: -- Initialize API return status to success
5709: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
5710:
5711: -- Derive the Event Key
5712: Select csd_ro_status_bevent_key_s1.nextval into l_event_key from dual ;
5713:
5714: -- Initialize Parameters
5715: l_param_list.extend;
5716: l_param_list(1) := wf_parameter_t('REPAIR_LINE_ID',p_ro_status_bevent_rec.repair_line_id);

Line 5896: select CSD_WF_EXCEPTIONS_BEVENT_S1.nextval from dual;

5892: l_event_name varchar2(60) := 'oracle.apps.csd.repair.wfprocess.exceptions';
5893: l_message_code varchar2(3);
5894:
5895: Cursor get_event_key is
5896: select CSD_WF_EXCEPTIONS_BEVENT_S1.nextval from dual;
5897:
5898: BEGIN
5899:
5900: -- Derive the message from the message stack