APPS.CSD_REPAIRS_PVT dependencies on DUAL

Line 113: FROM sys.dual;

109: l_repair_type_name VARCHAR2(80);
110: --
111: CURSOR C1 IS
112: SELECT CSD_REPAIRS_S1.NEXTVAL
113: FROM sys.dual;
114: --
115: CURSOR C2 IS
116: SELECT CSD_REPAIRS_S2.NEXTVAL
117: FROM sys.dual;

Line 117: FROM sys.dual;

113: FROM sys.dual;
114: --
115: CURSOR C2 IS
116: SELECT CSD_REPAIRS_S2.NEXTVAL
117: FROM sys.dual;
118: --
119: CURSOR get_draft_status_details IS
120: SELECT FS_B.flow_status_id,
121: FS_B.flow_status_code,

Line 4573: FROM DUAL;

4569: IF (l_wf_item_type IS NOT NULL) THEN
4570:
4571: SELECT TO_CHAR(CSD_WF_ITEM_KEY_S.NEXTVAL)
4572: INTO l_wf_item_key
4573: FROM DUAL;
4574:
4575: l_flwsts_wf_rec.repair_line_id := p_repair_line_id;
4576: l_flwsts_wf_rec.repair_type_id := p_repair_type_id;
4577: l_flwsts_wf_rec.from_flow_status_id := p_from_flow_status_id;

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

6019: -- Initialize API return status to success
6020: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
6021:
6022: -- Derive the Event Key
6023: Select csd_ro_status_bevent_key_s1.nextval into l_event_key from dual ;
6024:
6025: -- Initialize Parameters
6026: l_param_list.extend;
6027: l_param_list(1) := wf_parameter_t('REPAIR_LINE_ID',p_ro_status_bevent_rec.repair_line_id);

Line 6262: select CSD_WF_EXCEPTIONS_BEVENT_S1.nextval from dual;

6258: l_event_name varchar2(60) := 'oracle.apps.csd.repair.wfprocess.exceptions';
6259: l_message_code varchar2(3);
6260:
6261: Cursor get_event_key is
6262: select CSD_WF_EXCEPTIONS_BEVENT_S1.nextval from dual;
6263:
6264: BEGIN
6265:
6266: -- Derive the message from the message stack