APPS.ARP_CC_PKG dependencies on AR_CALL_ACTIONS

Line 329: | Insert row into ar_call_actions |

325: END insert_f_topics;
326:
327:
328: /*---------------------------------------------------------------+
329: | Insert row into ar_call_actions |
330: +---------------------------------------------------------------*/
331: PROCEDURE insert_f_actions (p_action_rec IN ar_call_actions%rowtype,
332: p_action_id OUT NOCOPY ar_call_actions.call_action_id%type) IS
333:

Line 331: PROCEDURE insert_f_actions (p_action_rec IN ar_call_actions%rowtype,

327:
328: /*---------------------------------------------------------------+
329: | Insert row into ar_call_actions |
330: +---------------------------------------------------------------*/
331: PROCEDURE insert_f_actions (p_action_rec IN ar_call_actions%rowtype,
332: p_action_id OUT NOCOPY ar_call_actions.call_action_id%type) IS
333:
334:
335:

Line 332: p_action_id OUT NOCOPY ar_call_actions.call_action_id%type) IS

328: /*---------------------------------------------------------------+
329: | Insert row into ar_call_actions |
330: +---------------------------------------------------------------*/
331: PROCEDURE insert_f_actions (p_action_rec IN ar_call_actions%rowtype,
332: p_action_id OUT NOCOPY ar_call_actions.call_action_id%type) IS
333:
334:
335:
336: l_created_by number;

Line 353: select ar_call_actions_s.nextval

349:
350: /*--------------------------+
351: | get unique identifier |
352: +--------------------------*/
353: select ar_call_actions_s.nextval
354: into p_action_id
355: from dual;
356:
357: /*--------------------------+

Line 360: insert into ar_call_actions (

356:
357: /*--------------------------+
358: | insert the row |
359: +--------------------------*/
360: insert into ar_call_actions (
361: call_action_id,
362: last_updated_by,
363: last_update_date,
364: last_update_login,

Line 523: | Update complete flag in AR_CALL_ACTIONS |

519:
520: END update_f_topics;
521:
522: /*----------------------------------------+
523: | Update complete flag in AR_CALL_ACTIONS |
524: +----------------------------------------*/
525: PROCEDURE update_f_actions (p_action_rec ar_call_actions%rowtype, p_rowid IN rowid) IS
526:
527: cursor c1 is

Line 525: PROCEDURE update_f_actions (p_action_rec ar_call_actions%rowtype, p_rowid IN rowid) IS

521:
522: /*----------------------------------------+
523: | Update complete flag in AR_CALL_ACTIONS |
524: +----------------------------------------*/
525: PROCEDURE update_f_actions (p_action_rec ar_call_actions%rowtype, p_rowid IN rowid) IS
526:
527: cursor c1 is
528: select customer_call_id
529: from ar_customer_calls

Line 552: update ar_call_actions

548:
549: open c1;
550: open c2;
551:
552: update ar_call_actions
553: set complete_flag = p_action_rec.complete_flag,
554: last_updated_by = l_last_updated_by,
555: last_update_date = l_last_update_date,
556: last_update_login = l_last_update_login

Line 576: from ar_call_actions

572: BEGIN
573:
574: Select call_action_id
575: into l_id
576: from ar_call_actions
577: where call_action_id in (select call_action_id
578: from ar_call_actions
579: where customer_call_id = 1049
580: and action_code = 'XDUNNING')

Line 578: from ar_call_actions

574: Select call_action_id
575: into l_id
576: from ar_call_actions
577: where call_action_id in (select call_action_id
578: from ar_call_actions
579: where customer_call_id = 1049
580: and action_code = 'XDUNNING')
581: or customer_call_topic_id in (select aca.customer_call_topic_id
582: from ar_call_actions aca, ar_customer_call_topics cct

Line 582: from ar_call_actions aca, ar_customer_call_topics cct

578: from ar_call_actions
579: where customer_call_id = 1049
580: and action_code = 'XDUNNING')
581: or customer_call_topic_id in (select aca.customer_call_topic_id
582: from ar_call_actions aca, ar_customer_call_topics cct
583: where action_code = 'XDUNNING'
584: and aca.customer_call_topic_id = cct.customer_call_topic_id
585: and cct.customer_call_id = 1049);
586: