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_PARTY_MERGE_PKG

Line 1: PACKAGE BODY CSC_PARTY_MERGE_PKG AS

1: PACKAGE BODY CSC_PARTY_MERGE_PKG AS
2: /* $Header: cscvmptb.pls 115.8 2004/04/28 08:09:51 bhroy ship $ */
3: -- Start of Comments
4: -- Package name : CSC_PARTY_MERGE_PKG
5: -- Purpose : Merges duplicate parties in Customer Care tables. The

Line 4: -- Package name : CSC_PARTY_MERGE_PKG

1: PACKAGE BODY CSC_PARTY_MERGE_PKG AS
2: /* $Header: cscvmptb.pls 115.8 2004/04/28 08:09:51 bhroy ship $ */
3: -- Start of Comments
4: -- Package name : CSC_PARTY_MERGE_PKG
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,

Line 89: G_PROC_NAME CONSTANT VARCHAR2(30) := 'CSC_PARTY_MERGE_PKG';

85: overridden_critical_flag to_overridden_critical_flag
86: from csc_customers
87: where party_id = p_to_fk_id;
88:
89: G_PROC_NAME CONSTANT VARCHAR2(30) := 'CSC_PARTY_MERGE_PKG';
90: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cscvmpts.pls';
91: G_USER_ID CONSTANT NUMBER(15) := FND_GLOBAL.USER_ID;
92: G_LOGIN_ID CONSTANT NUMBER(15) := FND_GLOBAL.CONC_LOGIN_ID;
93:

Line 112: g_mesg := 'CSC_PARTY_MERGE_PKG.CSC_CUSTOMERS_MERGE';

108: g_mesg VARCHAR2(1000) := '';
109:
110: BEGIN
111:
112: g_mesg := 'CSC_PARTY_MERGE_PKG.CSC_CUSTOMERS_MERGE';
113: fnd_file.put_line(fnd_file.log, g_mesg);
114:
115: x_return_status := CSC_CORE_UTILS_PVT.G_RET_STS_SUCCESS;
116:

Line 331: G_PROC_NAME CONSTANT VARCHAR2(30) := 'CSC_PARTY_MERGE_PKG';

327: from csc_cust_plans
328: where party_id = p_from_fk_id
329: for update nowait;
330:
331: G_PROC_NAME CONSTANT VARCHAR2(30) := 'CSC_PARTY_MERGE_PKG';
332: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cscvmpts.pls';
333: G_USER_ID CONSTANT NUMBER(15) := FND_GLOBAL.USER_ID;
334: G_LOGIN_ID CONSTANT NUMBER(15) := FND_GLOBAL.CONC_LOGIN_ID;
335:

Line 346: --arp_message.set_line('CSC_PARTY_MERGE_PKG.CSC_CUST_PLANS_MERGE()+');

342:
343: g_mesg VARCHAR2(1000) := '';
344:
345: BEGIN
346: --arp_message.set_line('CSC_PARTY_MERGE_PKG.CSC_CUST_PLANS_MERGE()+');
347: g_mesg := 'CSC_PARTY_MERGE_PKG.CSC_CUST_PLANS_MERGE';
348: fnd_file.put_line(fnd_file.log, g_mesg);
349:
350: x_return_status := CSC_CORE_UTILS_PVT.G_RET_STS_SUCCESS;

Line 347: g_mesg := 'CSC_PARTY_MERGE_PKG.CSC_CUST_PLANS_MERGE';

343: g_mesg VARCHAR2(1000) := '';
344:
345: BEGIN
346: --arp_message.set_line('CSC_PARTY_MERGE_PKG.CSC_CUST_PLANS_MERGE()+');
347: g_mesg := 'CSC_PARTY_MERGE_PKG.CSC_CUST_PLANS_MERGE';
348: fnd_file.put_line(fnd_file.log, g_mesg);
349:
350: x_return_status := CSC_CORE_UTILS_PVT.G_RET_STS_SUCCESS;
351:

Line 638: G_PROC_NAME CONSTANT VARCHAR2(30) := 'CSC_PARTY_MERGE_PKG';

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';
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:

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 763: END CSC_PARTY_MERGE_PKG;

759:
760: END CSC_CUSTOMIZED_PLANS_MERGE;
761:
762:
763: END CSC_PARTY_MERGE_PKG;