APPS.ARP_CC_PKG dependencies on AR_CUSTOMER_CALL_TOPICS

Line 196: | Table handler to insert records in the ar_customer_call_topics table |

192:
193:
194:
195: /* ---------------------------------------------------------------------+
196: | Table handler to insert records in the ar_customer_call_topics table |
197: +----------------------------------------------------------------------*/
198: PROCEDURE insert_f_topics (p_topic_rec IN ar_customer_call_topics%rowtype,
199: p_topic_id OUT NOCOPY ar_customer_Call_topics.customer_call_topic_id%type) IS
200:

Line 198: PROCEDURE insert_f_topics (p_topic_rec IN ar_customer_call_topics%rowtype,

194:
195: /* ---------------------------------------------------------------------+
196: | Table handler to insert records in the ar_customer_call_topics table |
197: +----------------------------------------------------------------------*/
198: PROCEDURE insert_f_topics (p_topic_rec IN ar_customer_call_topics%rowtype,
199: p_topic_id OUT NOCOPY ar_customer_Call_topics.customer_call_topic_id%type) IS
200:
201: l_created_by number;
202: l_creation_date date;

Line 199: p_topic_id OUT NOCOPY ar_customer_Call_topics.customer_call_topic_id%type) IS

195: /* ---------------------------------------------------------------------+
196: | Table handler to insert records in the ar_customer_call_topics table |
197: +----------------------------------------------------------------------*/
198: PROCEDURE insert_f_topics (p_topic_rec IN ar_customer_call_topics%rowtype,
199: p_topic_id OUT NOCOPY ar_customer_Call_topics.customer_call_topic_id%type) IS
200:
201: l_created_by number;
202: l_creation_date date;
203: l_last_updated_by number;

Line 219: select ar_customer_call_topics_s.nextval

215:
216: /*-----------------------+
217: | get the unique id |
218: +-----------------------*/
219: select ar_customer_call_topics_s.nextval
220: into p_topic_id
221: from dual;
222:
223:

Line 227: INSERT INTO ar_customer_call_topics (

223:
224: /*-----------------------+
225: | insert the row |
226: +-----------------------*/
227: INSERT INTO ar_customer_call_topics (
228: customer_call_topic_id,
229: last_updated_by,
230: last_update_date,
231: last_update_login,

Line 485: | Update complete flag in AR_CUSTOMER_CALL_TOPICS |

481:
482:
483:
484: /*------------------------------------------+
485: | Update complete flag in AR_CUSTOMER_CALL_TOPICS |
486: +------------------------------------------------*/
487: PROCEDURE update_f_topics (p_topic_rec ar_customer_call_topics%rowtype, p_rowid IN rowid) IS
488:
489: cursor c1 is

Line 487: PROCEDURE update_f_topics (p_topic_rec ar_customer_call_topics%rowtype, p_rowid IN rowid) IS

483:
484: /*------------------------------------------+
485: | Update complete flag in AR_CUSTOMER_CALL_TOPICS |
486: +------------------------------------------------*/
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

Line 507: update ar_customer_call_topics

503: l_last_updated_by := FND_GLOBAL.USER_ID;
504:
505: open c1;
506:
507: update ar_customer_call_topics
508: set complete_flag = p_topic_rec.complete_flag,
509: last_updated_by = l_last_updated_by,
510: last_update_date = l_last_update_date,
511: last_update_login = l_last_update_login

Line 535: from ar_customer_call_topics

531: for update of customer_call_id NOWAIT;
532:
533: cursor c2 is
534: select customer_call_topic_id
535: from ar_customer_call_topics
536: where customer_call_topic_id = p_action_rec.customer_call_topic_id
537: for update of customer_call_topic_id NOWAIT;
538:
539: l_last_updated_by number;

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: