101: | cover procedure to assign variables to record group and |
102: | call standard enetity handler |
103: +-------------------------------------------------------------------*/
104: PROCEDURE insert_note_cover (
105: p_note_type IN ar_notes.note_type%type,
106: p_text IN ar_notes.text%type,
107: p_customer_call_id IN ar_notes.customer_call_id%type,
108: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
109: p_call_action_id IN ar_notes.call_action_id%type,
102: | call standard enetity handler |
103: +-------------------------------------------------------------------*/
104: PROCEDURE insert_note_cover (
105: p_note_type IN ar_notes.note_type%type,
106: p_text IN ar_notes.text%type,
107: p_customer_call_id IN ar_notes.customer_call_id%type,
108: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
109: p_call_action_id IN ar_notes.call_action_id%type,
110: p_note_id OUT NOCOPY ar_notes.note_id%type
103: +-------------------------------------------------------------------*/
104: PROCEDURE insert_note_cover (
105: p_note_type IN ar_notes.note_type%type,
106: p_text IN ar_notes.text%type,
107: p_customer_call_id IN ar_notes.customer_call_id%type,
108: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
109: p_call_action_id IN ar_notes.call_action_id%type,
110: p_note_id OUT NOCOPY ar_notes.note_id%type
111: ) IS
104: PROCEDURE insert_note_cover (
105: p_note_type IN ar_notes.note_type%type,
106: p_text IN ar_notes.text%type,
107: p_customer_call_id IN ar_notes.customer_call_id%type,
108: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
109: p_call_action_id IN ar_notes.call_action_id%type,
110: p_note_id OUT NOCOPY ar_notes.note_id%type
111: ) IS
112:
105: p_note_type IN ar_notes.note_type%type,
106: p_text IN ar_notes.text%type,
107: p_customer_call_id IN ar_notes.customer_call_id%type,
108: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
109: p_call_action_id IN ar_notes.call_action_id%type,
110: p_note_id OUT NOCOPY ar_notes.note_id%type
111: ) IS
112:
113: l_note_rec ar_notes%rowtype;
106: p_text IN ar_notes.text%type,
107: p_customer_call_id IN ar_notes.customer_call_id%type,
108: p_customer_call_topic_id IN ar_notes.customer_call_topic_id%type,
109: p_call_action_id IN ar_notes.call_action_id%type,
110: p_note_id OUT NOCOPY ar_notes.note_id%type
111: ) IS
112:
113: l_note_rec ar_notes%rowtype;
114:
109: p_call_action_id IN ar_notes.call_action_id%type,
110: p_note_id OUT NOCOPY ar_notes.note_id%type
111: ) IS
112:
113: l_note_rec ar_notes%rowtype;
114:
115: BEGIN
116: /*-----------------------------------------+
117: | assign the variables to record group |