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.CSL_CSP_LOCATIONS_ACC_PKG dependencies on CSP_RS_CUST_RELATIONS

Line 5: -- CSP_RS_CUST_RELATIONS

1: PACKAGE BODY CSL_CSP_LOCATIONS_ACC_PKG AS
2: /* $Header: cslsaacb.pls 120.0 2005/05/25 11:02:56 appldev noship $ */
3:
4: /*** Globals ***/
5: -- CSP_RS_CUST_RELATIONS
6: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'JTM_CSP_RS_CUST_RELATIONS_ACC';
7: g_publication_item_name1 CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
8: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSP_RS_CUST_RELATIONS');
9: g_pk1_name1 CONSTANT VARCHAR2(30) := 'RS_CUST_RELATION_ID';

Line 6: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'JTM_CSP_RS_CUST_RELATIONS_ACC';

2: /* $Header: cslsaacb.pls 120.0 2005/05/25 11:02:56 appldev noship $ */
3:
4: /*** Globals ***/
5: -- CSP_RS_CUST_RELATIONS
6: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'JTM_CSP_RS_CUST_RELATIONS_ACC';
7: g_publication_item_name1 CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
8: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSP_RS_CUST_RELATIONS');
9: g_pk1_name1 CONSTANT VARCHAR2(30) := 'RS_CUST_RELATION_ID';
10: -- HZ_CUST_ACCT_SITES_ALL

Line 8: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSP_RS_CUST_RELATIONS');

4: /*** Globals ***/
5: -- CSP_RS_CUST_RELATIONS
6: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'JTM_CSP_RS_CUST_RELATIONS_ACC';
7: g_publication_item_name1 CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
8: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSP_RS_CUST_RELATIONS');
9: g_pk1_name1 CONSTANT VARCHAR2(30) := 'RS_CUST_RELATION_ID';
10: -- HZ_CUST_ACCT_SITES_ALL
11: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'CSL_HZ_CUST_ACCT_SITES_ALL_ACC';
12: g_publication_item_name2 CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=

Line 42: , CSP_RS_CUST_RELATIONS RCR

38: , RCR.resource_id RESOURCE_ID
39: FROM PO_LOCATION_ASSOCIATIONS_ALL PLA
40: , HZ_CUST_SITE_USES_ALL CSU
41: , HZ_CUST_ACCT_SITES_ALL CAS
42: , CSP_RS_CUST_RELATIONS RCR
43: , HZ_PARTY_SITES HPS
44: , HZ_LOCATIONS HZL
45: WHERE PLA.location_id = b_location_id
46: AND CSU.site_use_id = PLA.site_use_id

Line 128: , CSP_RS_CUST_RELATIONS RCR

124: , RCR.RESOURCE_ID RESOURCE_ID
125: FROM PO_LOCATION_ASSOCIATIONS_ALL PLA
126: , HZ_CUST_SITE_USES_ALL CSU
127: , HZ_CUST_ACCT_SITES_ALL CAS
128: , CSP_RS_CUST_RELATIONS RCR
129: , HZ_PARTY_SITES HPS
130: WHERE PLA.location_id = b_location_id
131: AND CSU.site_use_id = PLA.site_use_id
132: AND CSU.site_use_code = 'SHIP_TO'

Line 172: -- CSP_RS_CUST_RELATIONS

168: ELSE
169:
170: l_resource_id := r_location_ids.RESOURCE_ID;
171:
172: -- CSP_RS_CUST_RELATIONS
173: JTM_HOOK_UTIL_PKG.Insert_Acc
174: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
175: , P_ACC_TABLE_NAME => g_acc_table_name1
176: , P_PK1_NAME => g_pk1_name1

Line 234: , CSP_RS_CUST_RELATIONS RCR

230: , RCR.resource_id RESOURCE_ID
231: FROM PO_LOCATION_ASSOCIATIONS_ALL PLA
232: , HZ_CUST_SITE_USES_ALL CSU
233: , HZ_CUST_ACCT_SITES_ALL CAS
234: , CSP_RS_CUST_RELATIONS RCR
235: , HZ_PARTY_SITES HPS
236: , HZ_LOCATIONS HZL
237: WHERE PLA.location_id = b_location_id
238: AND CSU.site_use_id = PLA.site_use_id

Line 287: -- CSP_RS_CUST_RELATIONS

283: END IF;
284: ELSE
285: l_resource_id := r_location_ids.RESOURCE_ID;
286:
287: -- CSP_RS_CUST_RELATIONS
288: l_rcr_acc_id := JTM_HOOK_UTIL_PKG.Get_Acc_Id(
289: P_ACC_TABLE_NAME => g_acc_table_name1
290: , P_PK1_NAME => g_pk1_name1
291: , P_PK1_NUM_VALUE => r_location_ids.RCR_ID

Line 368: , CSP_RS_CUST_RELATIONS RCR

364: , RCR.RESOURCE_ID RESOURCE_ID
365: FROM PO_LOCATION_ASSOCIATIONS_ALL PLA
366: , HZ_CUST_SITE_USES_ALL CSU
367: , HZ_CUST_ACCT_SITES_ALL CAS
368: , CSP_RS_CUST_RELATIONS RCR
369: , HZ_PARTY_SITES HPS
370: WHERE PLA.location_id = b_location_id
371: AND CSU.site_use_id = PLA.site_use_id
372: AND CSU.site_use_code = 'SHIP_TO'

Line 413: , 'Delete CSP_RS_CUST_RELATIONS acc record for user: ' || p_resource_id

409: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
410: jtm_message_log_pkg.Log_Msg
411: ( p_resource_id
412: , g_table_name
413: , 'Delete CSP_RS_CUST_RELATIONS acc record for user: ' || p_resource_id
414: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
415: END IF;
416: JTM_HOOK_UTIL_PKG.Delete_Acc
417: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1

Line 660: , CSP_RS_CUST_RELATIONS RCR

656: SELECT PLA.LOCATION_ID
657: FROM PO_LOCATION_ASSOCIATIONS_ALL PLA
658: , HZ_CUST_SITE_USES_ALL CSU
659: , HZ_CUST_ACCT_SITES_ALL CAS
660: , CSP_RS_CUST_RELATIONS RCR
661: , HZ_PARTY_SITES HPS
662: WHERE CSU.site_use_id = PLA.site_use_id
663: AND CSU.site_use_code = 'SHIP_TO'
664: AND CSU.cust_acct_site_id = CAS.cust_acct_site_id

Line 710: , CSP_RS_CUST_RELATIONS RCR

706: SELECT PLA.LOCATION_ID
707: FROM PO_LOCATION_ASSOCIATIONS_ALL PLA
708: , HZ_CUST_SITE_USES_ALL CSU
709: , HZ_CUST_ACCT_SITES_ALL CAS
710: , CSP_RS_CUST_RELATIONS RCR
711: , HZ_PARTY_SITES HPS
712: WHERE CSU.site_use_id = PLA.site_use_id
713: AND CSU.site_use_code = 'SHIP_TO'
714: AND CSU.cust_acct_site_id = CAS.cust_acct_site_id