APPS.ARP_CC_PKG dependencies on AR_CUSTOMER_CALLS

Line 4: | insert values into ar_customer_calls

1: PACKAGE BODY arp_cc_pkg AS
2: /* $Header: ARCIECCB.pls 120.2 2005/06/14 18:50:21 vcrisost ship $ */
3: /*-----------------------------------------------------------------------------
4: | insert values into ar_customer_calls
5: +----------------------------------------------------------------------------*/
6: PROCEDURE insert_p (p_call_rec IN ar_customer_calls%rowtype,
7: p_customer_call_id OUT NOCOPY ar_customer_calls.customer_call_id%type) IS
8:

Line 6: PROCEDURE insert_p (p_call_rec IN ar_customer_calls%rowtype,

2: /* $Header: ARCIECCB.pls 120.2 2005/06/14 18:50:21 vcrisost ship $ */
3: /*-----------------------------------------------------------------------------
4: | insert values into ar_customer_calls
5: +----------------------------------------------------------------------------*/
6: PROCEDURE insert_p (p_call_rec IN ar_customer_calls%rowtype,
7: p_customer_call_id OUT NOCOPY ar_customer_calls.customer_call_id%type) IS
8:
9: l_created_by number;
10: l_creation_date date;

Line 7: p_customer_call_id OUT NOCOPY ar_customer_calls.customer_call_id%type) IS

3: /*-----------------------------------------------------------------------------
4: | insert values into ar_customer_calls
5: +----------------------------------------------------------------------------*/
6: PROCEDURE insert_p (p_call_rec IN ar_customer_calls%rowtype,
7: p_customer_call_id OUT NOCOPY ar_customer_calls.customer_call_id%type) IS
8:
9: l_created_by number;
10: l_creation_date date;
11: l_last_updated_by number;

Line 27: SELECT ar_customer_calls_s.nextval

23: /*-----------------------------+
24: | get the unique identifier |
25: +-----------------------------*/
26: p_customer_call_id :='';
27: SELECT ar_customer_calls_s.nextval
28: INTO p_customer_call_id
29: FROM DUAL;
30:
31: /*-----------------------------+

Line 35: INSERT INTO ar_customer_calls

31: /*-----------------------------+
32: | insert the record |
33: +-----------------------------*/
34:
35: INSERT INTO ar_customer_calls
36: (customer_call_id,
37: customer_id,
38: collector_id,
39: call_date,

Line 459: PROCEDURE update_p (p_call_rec IN ar_customer_calls%rowtype, p_rowid IN VARCHAR2) IS

455:
456: /*------------------------------------------------+
457: | Update status of Customer Call |
458: +------------------------------------------------*/
459: PROCEDURE update_p (p_call_rec IN ar_customer_calls%rowtype, p_rowid IN VARCHAR2) IS
460:
461: l_last_updated_by number;
462: l_last_update_login number;
463: l_last_update_date date;

Line 472: update ar_customer_calls

468: l_last_update_date := sysdate;
469: l_last_updated_by := FND_GLOBAL.USER_ID;
470:
471:
472: update ar_customer_calls
473: set status = p_call_rec.status,
474: last_update_login = l_last_update_login,
475: last_update_date = l_last_update_date,
476: last_updated_by = l_last_updated_by,

Line 491: from ar_customer_calls

487: PROCEDURE update_f_topics (p_topic_rec ar_customer_call_topics%rowtype, p_rowid IN rowid) IS
488:
489: cursor c1 is
490: select customer_call_id
491: from ar_customer_calls
492: where customer_call_id = p_topic_rec.customer_call_id
493: for update of customer_call_id NOWAIT;
494:
495: l_last_updated_by number;

Line 529: from ar_customer_calls

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
530: where customer_call_id = p_action_rec.customer_call_id
531: for update of customer_call_id NOWAIT;
532:
533: cursor c2 is