APPS.ARP_CCE_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 3

PROCEDURE insert_call (p_call_rec        IN  ar_customer_calls%rowtype,
                    p_customer_call_id  OUT NOCOPY ar_customer_calls.customer_call_id%type) IS

BEGIN

arp_cc_pkg.insert_p(p_call_rec,p_customer_call_id);

Line: 14

END insert_call;

Line: 20

PROCEDURE insert_note (p_note_rec IN  ar_notes%rowtype,
                       p_note_id  OUT NOCOPY ar_notes.note_id%type) IS

BEGIN

arp_cc_pkg.insert_f_notes(p_note_rec,p_note_id);

Line: 31

END insert_note;

Line: 38

PROCEDURE insert_topic (p_topic_rec IN  ar_customer_call_topics%rowtype,
                        p_topic_id  OUT NOCOPY ar_customer_call_topics.customer_call_topic_id%type) IS

BEGIN

arp_cc_pkg.insert_f_topics(p_topic_rec,p_topic_id);

Line: 49

END insert_topic;

Line: 55

PROCEDURE insert_action(p_action_rec IN ar_call_actions%rowtype,
                        p_action_id IN OUT NOCOPY ar_call_actions.call_action_id%type,
                        p_notif_id IN ar_action_notifications.employee_id%type) IS

BEGIN

  arp_cc_pkg.insert_f_actions(p_action_rec, p_action_id);

Line: 64

     /* update customer or site profile */
    null;

Line: 70

   arp_ccc_pkg.insert_notification_cover(p_action_id,p_notif_id);

Line: 78

END insert_action;

Line: 84

PROCEDURE insert_notification (p_notification_rec IN ar_action_notifications%rowtype) IS
BEGIN

 arp_cc_pkg.insert_f_notifications(p_notification_rec);

Line: 93

END insert_notification;