DBA Data[Home] [Help]

APPS.CUG_GENERIC_WF_PKG dependencies on DUAL

Line 308: *) if the current sr does not have the gorup is filled , but individual owne

304:
305: /* begin - to fix bug # 2576759 -
306: *) if the current sr already has the group_id filled, do NOT update the inci
307: dent_owner id
308: *) if the current sr does not have the gorup is filled , but individual owne
309: r id filled - do not update the incident_owner id
310: *) if the current sr has no group and no current sr - update the incident_ow
311: ner id col with resp party id
312: */

Line 989: SELECT jtf_notes_s.NEXTVAL INTO l_note_context_id FROM dual;

985: RAISE fnd_api.g_exc_unexpected_error;
986: END IF;
987: */
988:
989: SELECT jtf_notes_s.NEXTVAL INTO l_note_context_id FROM dual;
990:
991: OPEN c_SR_Attr_Note_csr;
992: FETCH c_SR_Attr_Note_csr into l_note_id;
993:

Line 1675: FROM dual;

1671:
1672: CURSOR c_wf_processs_id
1673: IS
1674: SELECT jtf_task_workflow_process_s.nextval
1675: FROM dual;
1676:
1677: CURSOR c_task_details
1678: IS
1679: SELECT task_name, description, owner_type_code owner_code, owner_id, task_number