25: +-----------------------------*/
26: p_customer_call_id :='';
27: SELECT ar_customer_calls_s.nextval
28: INTO p_customer_call_id
29: FROM DUAL;
30:
31: /*-----------------------------+
32: | insert the record |
33: +-----------------------------*/
152: | get the unique id |
153: +------------------------------*/
154: select ar_notes_s.nextval
155: into p_note_id
156: from dual;
157:
158: /*------------------------------+
159: | insert the record |
160: +------------------------------*/
217: | get the unique id |
218: +-----------------------*/
219: select ar_customer_call_topics_s.nextval
220: into p_topic_id
221: from dual;
222:
223:
224: /*-----------------------+
225: | insert the row |
351: | get unique identifier |
352: +--------------------------*/
353: select ar_call_actions_s.nextval
354: into p_action_id
355: from dual;
356:
357: /*--------------------------+
358: | insert the row |
359: +--------------------------*/
417: | insert the unique id |
418: +-------------------------*/
419: select ar_action_notifications_s.nextval
420: into l_notif_id
421: from dual;
422:
423: /*------------------------+\
424: | insert the row |
425: +-------------------------*/