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_CUSTOMIZED_PLANS

Line 9: -- CSC_CUSTOMIZED_PLANS, CSC_CUST_PLANS,

5: -- Purpose : Merges duplicate parties in Customer Care tables. The
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

Line 620: PROCEDURE CSC_CUSTOMIZED_PLANS_MERGE (

616:
617: END CSC_CUST_PLANS_MERGE;
618:
619:
620: PROCEDURE CSC_CUSTOMIZED_PLANS_MERGE (
621: p_entity_name IN VARCHAR2,
622: p_from_id IN NUMBER,
623: x_to_id OUT NOCOPY NUMBER,
624: p_from_fk_id IN NUMBER,

Line 634: from csc_customized_plans

630: IS
631:
632: cursor c1 is
633: select 1
634: from csc_customized_plans
635: where party_id = p_from_fk_id
636: for update nowait;
637:
638: G_PROC_NAME CONSTANT VARCHAR2(30) := 'CSC_PARTY_MERGE_PKG';

Line 643: l_api_name VARCHAR2(30) := 'CSC_CUSTOMIZED_PLANS_MERGE';

639: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cscvmpts.pls';
640: G_USER_ID CONSTANT NUMBER(15) := FND_GLOBAL.USER_ID;
641: G_LOGIN_ID CONSTANT NUMBER(15) := FND_GLOBAL.CONC_LOGIN_ID;
642:
643: l_api_name VARCHAR2(30) := 'CSC_CUSTOMIZED_PLANS_MERGE';
644: l_count NUMBER(10) := 0;
645:
646: RESOURCE_BUSY EXCEPTION;
647: PRAGMA EXCEPTION_INIT(RESOURCE_BUSY, -0054);

Line 652: --arp_message.set_line('CSC_PARTY_MERGE_PKG.CSC_CUSTOMIZED_PLANS_MERGE()+');

648:
649: g_mesg VARCHAR2(1000) := '';
650:
651: BEGIN
652: --arp_message.set_line('CSC_PARTY_MERGE_PKG.CSC_CUSTOMIZED_PLANS_MERGE()+');
653: g_mesg := 'CSC_PARTY_MERGE_PKG.CSC_CUSTOMIZED_PLANS_MERGE';
654: fnd_file.put_line(fnd_file.log, g_mesg);
655:
656: x_return_status := CSC_CORE_UTILS_PVT.G_RET_STS_SUCCESS;

Line 653: g_mesg := 'CSC_PARTY_MERGE_PKG.CSC_CUSTOMIZED_PLANS_MERGE';

649: g_mesg VARCHAR2(1000) := '';
650:
651: BEGIN
652: --arp_message.set_line('CSC_PARTY_MERGE_PKG.CSC_CUSTOMIZED_PLANS_MERGE()+');
653: g_mesg := 'CSC_PARTY_MERGE_PKG.CSC_CUSTOMIZED_PLANS_MERGE';
654: fnd_file.put_line(fnd_file.log, g_mesg);
655:
656: x_return_status := CSC_CORE_UTILS_PVT.G_RET_STS_SUCCESS;
657:

Line 698: update csc_customized_plans

694:
695: -- Perform transfer if duplicate plans do not exist between the TO and FROM
696: -- parties
697:
698: update csc_customized_plans
699: set party_id = p_to_fk_id,
700: request_id = G_REQUEST_ID,
701: program_application_id = ARP_STANDARD.PROFILE.PROGRAM_APPLICATION_ID,
702: program_id = ARP_STANDARD.PROFILE.PROGRAM_ID,

Line 707: from csc_customized_plans

703: program_update_date = SYSDATE,
704: plan_status_code = G_TRANSFER_PLAN
705: where party_id = p_from_fk_id
706: and plan_id not in ( select plan_id
707: from csc_customized_plans
708: where party_id = p_to_fk_id );
709:
710: l_count := sql%rowcount;
711:

Line 712: g_mesg := 'Number of CSC_CUSTOMIZED_PLANS records transferred = ' || to_char(l_count) ;

708: where party_id = p_to_fk_id );
709:
710: l_count := sql%rowcount;
711:
712: g_mesg := 'Number of CSC_CUSTOMIZED_PLANS records transferred = ' || to_char(l_count) ;
713: fnd_file.put_line(fnd_file.log, g_mesg);
714:
715: --arp_message.set_line('Number of CSC_CUSTOMIZED_PLANS records transferred = ' ||
716: --to_char(sql%rowcount) );

Line 715: --arp_message.set_line('Number of CSC_CUSTOMIZED_PLANS records transferred = ' ||

711:
712: g_mesg := 'Number of CSC_CUSTOMIZED_PLANS records transferred = ' || to_char(l_count) ;
713: fnd_file.put_line(fnd_file.log, g_mesg);
714:
715: --arp_message.set_line('Number of CSC_CUSTOMIZED_PLANS records transferred = ' ||
716: --to_char(sql%rowcount) );
717:
718: -- Delete records if duplicate customized plans exist between the TO
719: -- and FROM parties.

Line 721: -- columns are added to the CSC_CUSTOMIZED_PLANS table to denote the merge

717:
718: -- Delete records if duplicate customized plans exist between the TO
719: -- and FROM parties.
720: -- The delete operation is being performed temperorily until some additional
721: -- columns are added to the CSC_CUSTOMIZED_PLANS table to denote the merge
722: -- or transfer operation.
723:
724: delete from csc_customized_plans
725: where party_id = p_from_fk_id

Line 724: delete from csc_customized_plans

720: -- The delete operation is being performed temperorily until some additional
721: -- columns are added to the CSC_CUSTOMIZED_PLANS table to denote the merge
722: -- or transfer operation.
723:
724: delete from csc_customized_plans
725: where party_id = p_from_fk_id
726: and plan_id in ( select plan_id
727: from csc_customized_plans
728: where party_id = p_to_fk_id );

Line 727: from csc_customized_plans

723:
724: delete from csc_customized_plans
725: where party_id = p_from_fk_id
726: and plan_id in ( select plan_id
727: from csc_customized_plans
728: where party_id = p_to_fk_id );
729:
730: l_count := sql%rowcount;
731:

Line 732: g_mesg := 'Number of CSC_CUSTOMIZED_PLANS records deleted = ' || to_char(l_count);

728: where party_id = p_to_fk_id );
729:
730: l_count := sql%rowcount;
731:
732: g_mesg := 'Number of CSC_CUSTOMIZED_PLANS records deleted = ' || to_char(l_count);
733: fnd_file.put_line(fnd_file.log, g_mesg);
734:
735: --arp_message.set_line('Number of CSC_CUSTOMIZED_PLANS records deleted = ' ||
736: --to_char(sql%rowcount) );

Line 735: --arp_message.set_line('Number of CSC_CUSTOMIZED_PLANS records deleted = ' ||

731:
732: g_mesg := 'Number of CSC_CUSTOMIZED_PLANS records deleted = ' || to_char(l_count);
733: fnd_file.put_line(fnd_file.log, g_mesg);
734:
735: --arp_message.set_line('Number of CSC_CUSTOMIZED_PLANS records deleted = ' ||
736: --to_char(sql%rowcount) );
737:
738: end if;
739:

Line 744: || 'records in table CSC_CUSTOMIZED_PLANS for party_id = '

740: EXCEPTION
741: when RESOURCE_BUSY then
742: -- x_return_status := CSC_CORE_UTILS_PVT.G_RET_STS_ERROR;
743: g_mesg := g_proc_name || '.' || l_api_name || '; Could not obtain lock for '
744: || 'records in table CSC_CUSTOMIZED_PLANS for party_id = '
745: || p_from_fk_id;
746: fnd_file.put_line(fnd_file.log, g_mesg);
747:
748: --arp_message.set_line(g_proc_name || '.' || l_api_name ||

Line 750: --'CSC_CUSTOMIZED_PLANS for party_id = ' || p_from_fk_id );

746: fnd_file.put_line(fnd_file.log, g_mesg);
747:
748: --arp_message.set_line(g_proc_name || '.' || l_api_name ||
749: --'; Could not obtain lock for records in table ' ||
750: --'CSC_CUSTOMIZED_PLANS for party_id = ' || p_from_fk_id );
751: raise;
752:
753: when OTHERS then
754: -- x_return_status := CSC_CORE_UTILS_PVT.G_RET_STS_UNEXP_ERROR;

Line 760: END CSC_CUSTOMIZED_PLANS_MERGE;

756: fnd_file.put_line(fnd_file.log, g_mesg);
757: -- arp_message.set_line(g_proc_name || '.' || l_api_name || ': ' || sqlerrm);
758: raise;
759:
760: END CSC_CUSTOMIZED_PLANS_MERGE;
761:
762:
763: END CSC_PARTY_MERGE_PKG;