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.CSM_PARTY_DOWNLOAD_PUB dependencies on CSM_PARTY_ASSIGNMENT

Line 66: --calling the package to insert records into CSM_PARTY_ASSIGNMENT table

62: IF p_operation = 'INSERT'
63:
64: THEN
65:
66: --calling the package to insert records into CSM_PARTY_ASSIGNMENT table
67:
68: csm_party_assignment_pkg.insert_party_assg
69: ( P_USER_ID => p_user_id,
70: P_PARTY_ID => p_party_id,

Line 68: csm_party_assignment_pkg.insert_party_assg

64: THEN
65:
66: --calling the package to insert records into CSM_PARTY_ASSIGNMENT table
67:
68: csm_party_assignment_pkg.insert_party_assg
69: ( P_USER_ID => p_user_id,
70: P_PARTY_ID => p_party_id,
71: P_OWNER_ID => l_owner_id,
72: P_PARTY_SITE_ID => l_party_site_id,

Line 80: --calling the package to delete records from CSM_PARTY_ASSIGNMENT table

76: ELSIF p_operation = 'DELETE'
77:
78: THEN
79:
80: --calling the package to delete records from CSM_PARTY_ASSIGNMENT table
81:
82: csm_party_assignment_pkg.delete_party_assg
83: ( P_USER_ID => p_user_id,
84: P_PARTY_ID => p_party_id,

Line 82: csm_party_assignment_pkg.delete_party_assg

78: THEN
79:
80: --calling the package to delete records from CSM_PARTY_ASSIGNMENT table
81:
82: csm_party_assignment_pkg.delete_party_assg
83: ( P_USER_ID => p_user_id,
84: P_PARTY_ID => p_party_id,
85: P_OWNER_ID => l_owner_id,
86: P_PARTY_SITE_ID => l_party_site_id,

Line 118: x_error_message := 'Assigning customer to single user through CSM_PARTY_ASSIGNMENT_PKG is done successfully';

114: END IF;
115:
116: x_return_status := FND_API.G_RET_STS_SUCCESS;
117: x_msg_count := 0;
118: x_error_message := 'Assigning customer to single user through CSM_PARTY_ASSIGNMENT_PKG is done successfully';
119: CSM_UTIL_PKG.LOG('Leaving CSM_PARTY_DOWNLOAD_PUB.ASSIGN_CUST_TO_USER Package ', 'CSM_PARTY_DOWNLOAD_PUB.ASSIGN_CUST_TO_USER ',FND_LOG.LEVEL_EXCEPTION);
120:
121: EXCEPTION
122:

Line 247: --calling the package to insert records into CSM_PARTY_ASSIGNMENT table

243: IF p_operation = 'INSERT'
244:
245: THEN
246:
247: --calling the package to insert records into CSM_PARTY_ASSIGNMENT table
248:
249: csm_party_assignment_pkg.insert_party_assg
250: ( P_USER_ID => l_user_id,
251: P_PARTY_ID => l_party_id,

Line 249: csm_party_assignment_pkg.insert_party_assg

245: THEN
246:
247: --calling the package to insert records into CSM_PARTY_ASSIGNMENT table
248:
249: csm_party_assignment_pkg.insert_party_assg
250: ( P_USER_ID => l_user_id,
251: P_PARTY_ID => l_party_id,
252: P_OWNER_ID => l_owner_id,
253: P_PARTY_SITE_ID => l_party_site_id,

Line 261: --calling the package to delete records from CSM_PARTY_ASSIGNMENT table

257: ELSIF p_operation = 'DELETE'
258:
259: THEN
260:
261: --calling the package to delete records from CSM_PARTY_ASSIGNMENT table
262:
263: csm_party_assignment_pkg.delete_party_assg
264: ( P_USER_ID => l_user_id,
265: P_PARTY_ID => l_party_id,

Line 263: csm_party_assignment_pkg.delete_party_assg

259: THEN
260:
261: --calling the package to delete records from CSM_PARTY_ASSIGNMENT table
262:
263: csm_party_assignment_pkg.delete_party_assg
264: ( P_USER_ID => l_user_id,
265: P_PARTY_ID => l_party_id,
266: P_OWNER_ID => l_owner_id,
267: P_PARTY_SITE_ID => l_party_site_id,

Line 303: x_error_message := 'Assigning multiple customers to multiple users through CSM_PARTY_ASSIGNMENT_PKG is done successfully';

299: END IF;
300:
301: x_return_status := FND_API.G_RET_STS_SUCCESS;
302: x_msg_count := 0;
303: x_error_message := 'Assigning multiple customers to multiple users through CSM_PARTY_ASSIGNMENT_PKG is done successfully';
304: CSM_UTIL_PKG.LOG('Leaving CSM_PARTY_DOWNLOAD_PUB.ASSIGN_MUL_CUST_TO_USERS Package ', 'CSM_PARTY_DOWNLOAD_PUB.ASSIGN_MUL_CUST_TO_USERS ',FND_LOG.LEVEL_EXCEPTION);
305:
306: EXCEPTION
307:

Line 402: --calling the package to insert records into CSM_PARTY_ASSIGNMENT table

398: IF p_operation = 'INSERT'
399:
400: THEN
401:
402: --calling the package to insert records into CSM_PARTY_ASSIGNMENT table
403:
404: csm_party_assignment_pkg.insert_party_assg
405: ( P_USER_ID => p_user_id,
406: P_PARTY_ID => p_party_id,

Line 404: csm_party_assignment_pkg.insert_party_assg

400: THEN
401:
402: --calling the package to insert records into CSM_PARTY_ASSIGNMENT table
403:
404: csm_party_assignment_pkg.insert_party_assg
405: ( P_USER_ID => p_user_id,
406: P_PARTY_ID => p_party_id,
407: P_OWNER_ID => l_owner_id,
408: P_PARTY_SITE_ID => p_location_id,

Line 416: --calling the package to delete records from CSM_PARTY_ASSIGNMENT table

412: ELSIF p_operation = 'DELETE'
413:
414: THEN
415:
416: --calling the package to delete records from CSM_PARTY_ASSIGNMENT table
417:
418: csm_party_assignment_pkg.delete_party_assg
419: ( P_USER_ID => p_user_id,
420: P_PARTY_ID => p_party_id,

Line 418: csm_party_assignment_pkg.delete_party_assg

414: THEN
415:
416: --calling the package to delete records from CSM_PARTY_ASSIGNMENT table
417:
418: csm_party_assignment_pkg.delete_party_assg
419: ( P_USER_ID => p_user_id,
420: P_PARTY_ID => p_party_id,
421: P_OWNER_ID => l_owner_id,
422: P_PARTY_SITE_ID => p_location_id,

Line 454: x_error_message := 'Assigning customer with a location to single user through CSM_PARTY_ASSIGNMENT_PKG is done successfully';

450: END IF;
451:
452: x_return_status := FND_API.G_RET_STS_SUCCESS;
453: x_msg_count := 0;
454: x_error_message := 'Assigning customer with a location to single user through CSM_PARTY_ASSIGNMENT_PKG is done successfully';
455: CSM_UTIL_PKG.LOG('Leaving CSM_PARTY_DOWNLOAD_PUB.ASSIGN_CUST_LOC_TO_USER Package ', 'CSM_PARTY_DOWNLOAD_PUB.ASSIGN_CUST_LOC_TO_USER',FND_LOG.LEVEL_EXCEPTION);
456:
457: EXCEPTION
458:

Line 588: --calling the package to insert records into CSM_PARTY_ASSIGNMENT table

584: IF p_operation = 'INSERT'
585:
586: THEN
587:
588: --calling the package to insert records into CSM_PARTY_ASSIGNMENT table
589:
590: csm_party_assignment_pkg.insert_party_assg
591: ( P_USER_ID => l_user_id,
592: P_PARTY_ID => l_party_id,

Line 590: csm_party_assignment_pkg.insert_party_assg

586: THEN
587:
588: --calling the package to insert records into CSM_PARTY_ASSIGNMENT table
589:
590: csm_party_assignment_pkg.insert_party_assg
591: ( P_USER_ID => l_user_id,
592: P_PARTY_ID => l_party_id,
593: P_OWNER_ID => l_owner_id,
594: P_PARTY_SITE_ID => l_party_site_id,

Line 602: --calling the package to delete records from CSM_PARTY_ASSIGNMENT table

598: ELSIF p_operation = 'DELETE'
599:
600: THEN
601:
602: --calling the package to delete records from CSM_PARTY_ASSIGNMENT table
603:
604: csm_party_assignment_pkg.delete_party_assg
605: ( P_USER_ID => l_user_id,
606: P_PARTY_ID => l_party_id,

Line 604: csm_party_assignment_pkg.delete_party_assg

600: THEN
601:
602: --calling the package to delete records from CSM_PARTY_ASSIGNMENT table
603:
604: csm_party_assignment_pkg.delete_party_assg
605: ( P_USER_ID => l_user_id,
606: P_PARTY_ID => l_party_id,
607: P_OWNER_ID => l_owner_id,
608: P_PARTY_SITE_ID => l_party_site_id,

Line 644: x_error_message := 'Assigning customer with multiple locations to multiple users through CSM_PARTY_ASSIGNMENT_PKG is done successfully';

640: END IF;
641:
642: x_return_status := FND_API.G_RET_STS_SUCCESS;
643: x_msg_count := 0;
644: x_error_message := 'Assigning customer with multiple locations to multiple users through CSM_PARTY_ASSIGNMENT_PKG is done successfully';
645: CSM_UTIL_PKG.LOG('Leaving CSM_PARTY_DOWNLOAD_PUB.ASSIGN_MUL_CUST_LOC_TO_USER Package ', 'CSM_PARTY_DOWNLOAD_PUB.ASSIGN_MUL_CUST_LOC_TO_USER',FND_LOG.LEVEL_EXCEPTION);
646:
647: EXCEPTION
648:

Line 704: FROM csm_party_assignment cpa

700:
701: CURSOR csr_get_party_id (p_user_id IN NUMBER)
702: IS
703: SELECT cpa.party_id
704: FROM csm_party_assignment cpa
705: WHERE cpa.user_id = p_user_id
706: AND cpa.party_site_id in (-1,-2)
707: AND cpa.deleted_flag = 'N';
708:

Line 822: FROM csm_party_assignment cpa

818:
819: CURSOR csr_get_party_site_id (p_user_id IN NUMBER, p_party_id IN NUMBER)
820: IS
821: SELECT cpa.party_site_id
822: FROM csm_party_assignment cpa
823: WHERE cpa.user_id = p_user_id
824: AND cpa.party_id = p_party_id
825: AND cpa.party_site_id not in (-1,-2)
826: AND cpa.deleted_flag = 'N';