eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSC_PARTY_MERGE_PKG dependencies on CSC_CUST_PLANS_AUDIT

Line 10: -- CSC_CUST_PLANS_AUDIT

6: -- Customer Care table that need to be considered for
7: -- Party Merge are:
8: -- CSC_CUSTOMERS, CSC_CUSTOMERS_AUDIT_HIST,
9: -- CSC_CUSTOMIZED_PLANS, CSC_CUST_PLANS,
10: -- CSC_CUST_PLANS_AUDIT
11: --
12: -- History
13: -- MM-DD-YYYY NAME MODIFICATIONS
14: -- 10-10-2000 dejoseph Created.

Line 392: insert into csc_cust_plans_audit (

388: -- parties
389: -- Bug# 2919377, if plan is transfered then one record will be inserted for
390: -- p_to_fk_id with status transferred, one record will be inserted for
391: -- p_from_fk_id with status merged.Update the Audit table first in case of plan transfer.
392: insert into csc_cust_plans_audit (
393: plan_audit_id, plan_id, party_id, cust_account_id,
394: plan_status_code, request_id, creation_date,
395: created_by, last_update_date, last_updated_by,
396: last_update_login, program_application_id,

Line 399: csc_cust_plans_audit_s.nextval, plan_id, p_to_fk_id, cust_account_id,

395: created_by, last_update_date, last_updated_by,
396: last_update_login, program_application_id,
397: program_id, program_update_date, object_version_number )
398: select
399: csc_cust_plans_audit_s.nextval, plan_id, p_to_fk_id, cust_account_id,
400: G_TRANSFER_PLAN, G_REQUEST_ID, SYSDATE,
401: G_USER_ID, SYSDATE, G_USER_ID,
402: G_LOGIN_ID, ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,
403: ARP_STANDARD.PROFILE.PROGRAM_ID, SYSDATE, 1

Line 409: insert into csc_cust_plans_audit (

405: where party_id = p_from_fk_id
406: and cust_account_id is not null;
407: audit_count := sql%rowcount;
408:
409: insert into csc_cust_plans_audit (
410: plan_audit_id, plan_id, party_id, cust_account_id,
411: plan_status_code, request_id, creation_date,
412: created_by, last_update_date, last_updated_by,
413: last_update_login, program_application_id,

Line 416: csc_cust_plans_audit_s.nextval, plan_id, p_to_fk_id, cust_account_id,

412: created_by, last_update_date, last_updated_by,
413: last_update_login, program_application_id,
414: program_id, program_update_date, object_version_number )
415: select
416: csc_cust_plans_audit_s.nextval, plan_id, p_to_fk_id, cust_account_id,
417: G_TRANSFER_PLAN, G_REQUEST_ID, SYSDATE,
418: G_USER_ID, SYSDATE, G_USER_ID,
419: G_LOGIN_ID, ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,
420: ARP_STANDARD.PROFILE.PROGRAM_ID, SYSDATE, 1

Line 428: insert into csc_cust_plans_audit (

424: from csc_cust_plans
425: where party_id = p_to_fk_id );
426: audit_count := audit_count+sql%rowcount;
427:
428: insert into csc_cust_plans_audit (
429: plan_audit_id, plan_id, party_id, cust_account_id,
430: plan_status_code, request_id, creation_date,
431: created_by, last_update_date, last_updated_by,
432: last_update_login, program_application_id,

Line 435: csc_cust_plans_audit_s.nextval, plan_id, p_from_fk_id, cust_account_id,

431: created_by, last_update_date, last_updated_by,
432: last_update_login, program_application_id,
433: program_id, program_update_date, object_version_number )
434: select
435: csc_cust_plans_audit_s.nextval, plan_id, p_from_fk_id, cust_account_id,
436: G_MERGE_PLAN, G_REQUEST_ID, SYSDATE,
437: G_USER_ID, SYSDATE, G_USER_ID,
438: G_LOGIN_ID, ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,
439: ARP_STANDARD.PROFILE.PROGRAM_ID, SYSDATE, 1

Line 445: insert into csc_cust_plans_audit (

441: where party_id = p_from_fk_id
442: and cust_account_id is not null;
443: audit_count := audit_count+sql%rowcount;
444:
445: insert into csc_cust_plans_audit (
446: plan_audit_id, plan_id, party_id, cust_account_id,
447: plan_status_code, request_id, creation_date,
448: created_by, last_update_date, last_updated_by,
449: last_update_login, program_application_id,

Line 452: csc_cust_plans_audit_s.nextval, plan_id, p_from_fk_id, cust_account_id,

448: created_by, last_update_date, last_updated_by,
449: last_update_login, program_application_id,
450: program_id, program_update_date, object_version_number )
451: select
452: csc_cust_plans_audit_s.nextval, plan_id, p_from_fk_id, cust_account_id,
453: G_MERGE_PLAN, G_REQUEST_ID, SYSDATE,
454: G_USER_ID, SYSDATE, G_USER_ID,
455: G_LOGIN_ID, ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,
456: ARP_STANDARD.PROFILE.PROGRAM_ID, SYSDATE, 1

Line 507: g_mesg := 'Number of CSC_CUST_PLANS_AUDIT records inserted coresponding to the '

503: --to_char(sql%rowcount) );
504:
505:
506: if ( ( l_count > 0 ) AND (audit_count > 0) ) then
507: g_mesg := 'Number of CSC_CUST_PLANS_AUDIT records inserted coresponding to the '
508: || 'CSC_CUST_PLANS records transferred = ' || to_char(audit_count) ;
509: fnd_file.put_line(fnd_file.log, g_mesg);
510: end if;
511:

Line 513: -- insert into csc_cust_plans_audit (

509: fnd_file.put_line(fnd_file.log, g_mesg);
510: end if;
511:
512: -- if ( l_count > 0 ) then
513: -- insert into csc_cust_plans_audit (
514: -- plan_audit_id, plan_id, party_id,
515: -- plan_status_code, request_id, creation_date,
516: -- created_by, last_update_date, last_updated_by,
517: -- last_update_login, program_application_id,

Line 520: -- csc_cust_plans_audit_s.nextval, plan_id, p_to_fk_id,

516: -- created_by, last_update_date, last_updated_by,
517: -- last_update_login, program_application_id,
518: -- program_id, program_update_date, object_version_number )
519: -- select
520: -- csc_cust_plans_audit_s.nextval, plan_id, p_to_fk_id,
521: -- G_TRANSFER_PLAN, G_REQUEST_ID, SYSDATE,
522: -- G_USER_ID, SYSDATE, G_USER_ID,
523: -- G_LOGIN_ID, ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,
524: -- ARP_STANDARD.PROFILE.PROGRAM_ID, SYSDATE, 1

Line 531: -- g_mesg := 'Number of CSC_CUST_PLANS_AUDIT records inserted coresponding to the '

527: -- and plan_id not in ( select plan_id
528: -- from csc_cust_plans
529: -- where party_id = p_to_fk_id );
530:
531: -- g_mesg := 'Number of CSC_CUST_PLANS_AUDIT records inserted coresponding to the '
532: -- || 'CSC_CUST_PLANS records transferred = ' || to_char(sql%rowcount) ;
533: -- fnd_file.put_line(fnd_file.log, g_mesg);
534:
535: --arp_message.set_line('Number of CSC_CUST_PLANS_AUDIT records inserted ' ||

Line 535: --arp_message.set_line('Number of CSC_CUST_PLANS_AUDIT records inserted ' ||

531: -- g_mesg := 'Number of CSC_CUST_PLANS_AUDIT records inserted coresponding to the '
532: -- || 'CSC_CUST_PLANS records transferred = ' || to_char(sql%rowcount) ;
533: -- fnd_file.put_line(fnd_file.log, g_mesg);
534:
535: --arp_message.set_line('Number of CSC_CUST_PLANS_AUDIT records inserted ' ||
536: --'coresponding to the CSC_CUST_PLANS records ' ||
537: --'transferred = ' || to_char(sql%rowcount) );
538:
539: -- end if;

Line 569: insert into csc_cust_plans_audit (

565: --to_char(sql%rowcount) );
566:
567: -- Bug# 2919377, insert a record for FROM party with MERGE flag
568: if ( sql%rowcount > 0 ) then
569: insert into csc_cust_plans_audit (
570: plan_audit_id, plan_id, party_id,
571: plan_status_code, request_id, creation_date,
572: created_by, last_update_date, last_updated_by,
573: last_update_login, program_application_id,

Line 576: csc_cust_plans_audit_s.nextval, plan_id, p_from_fk_id,

572: created_by, last_update_date, last_updated_by,
573: last_update_login, program_application_id,
574: program_id, program_update_date, object_version_number )
575: select
576: csc_cust_plans_audit_s.nextval, plan_id, p_from_fk_id,
577: G_MERGE_PLAN, G_REQUEST_ID, SYSDATE,
578: G_USER_ID, SYSDATE, G_USER_ID,
579: G_LOGIN_ID, ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,
580: ARP_STANDARD.PROFILE.PROGRAM_ID, SYSDATE, 1

Line 587: g_mesg := 'Number of CSC_CUST_PLANS_AUDIT records inserted coresponding to the '

583: and plan_id in ( select plan_id
584: from csc_cust_plans
585: where party_id = p_to_fk_id );
586:
587: g_mesg := 'Number of CSC_CUST_PLANS_AUDIT records inserted coresponding to the '
588: || 'CSC_CUST_PLANS records merged = ' || to_char(sql%rowcount) ;
589: fnd_file.put_line(fnd_file.log, g_mesg);
590: --arp_message.set_line('Number of CSC_CUST_PLANS_AUDIT records inserted ' ||
591: --'coresponding to the CSC_CUST_PLANS records ' ||

Line 590: --arp_message.set_line('Number of CSC_CUST_PLANS_AUDIT records inserted ' ||

586:
587: g_mesg := 'Number of CSC_CUST_PLANS_AUDIT records inserted coresponding to the '
588: || 'CSC_CUST_PLANS records merged = ' || to_char(sql%rowcount) ;
589: fnd_file.put_line(fnd_file.log, g_mesg);
590: --arp_message.set_line('Number of CSC_CUST_PLANS_AUDIT records inserted ' ||
591: --'coresponding to the CSC_CUST_PLANS records ' ||
592: --'merged = ' || to_char(sql%rowcount) );
593: end if;
594: end if;