APPS.CSL_CSP_LOCATIONS_ACC_PKG dependencies on PO_LOCATION_ASSOCIATIONS_ALL

Line 20: -- PO_LOCATION_ASSOCIATIONS_ALL

16: g_acc_table_name3 CONSTANT VARCHAR2(30) := 'CSL_HZ_CUST_SITE_USES_ALL_ACC';
17: g_publication_item_name3 CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
18: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_HZ_CUST_SITE_USES');
19: g_pk1_name3 CONSTANT VARCHAR2(30) := 'SITE_USE_ID';
20: -- PO_LOCATION_ASSOCIATIONS_ALL
21: g_acc_table_name4 CONSTANT VARCHAR2(30) := 'JTM_PO_LOC_ASS_ALL_ACC';
22: g_publication_item_name4 CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
23: JTM_HOOK_UTIL_PKG.t_publication_item_list('PO_LOC_ASS_ALL');
24: g_pk1_name4 CONSTANT VARCHAR2(30) := 'LOCATION_ID';

Line 26: g_table_name CONSTANT VARCHAR2(30) := 'PO_LOCATION_ASSOCIATIONS_ALL';

22: g_publication_item_name4 CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
23: JTM_HOOK_UTIL_PKG.t_publication_item_list('PO_LOC_ASS_ALL');
24: g_pk1_name4 CONSTANT VARCHAR2(30) := 'LOCATION_ID';
25:
26: g_table_name CONSTANT VARCHAR2(30) := 'PO_LOCATION_ASSOCIATIONS_ALL';
27: g_debug_level NUMBER; -- debug level
28:
29: /*** Function that checks if location record(s) should be replicated. Returns TRUE if it should ***/
30: FUNCTION Replicate_Record

Line 39: FROM PO_LOCATION_ASSOCIATIONS_ALL PLA

35: CURSOR c_location (b_location_id NUMBER) IS
36: SELECT PLA.location_id LOCATION_ID
37: , CSU.status STATUS
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

Line 75: , 'Replicate_Record error: Could not find record associated with PO_LOCATION_ASSOCIATIONS_ALL.LOCATION_ID '

71: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
72: jtm_message_log_pkg.Log_Msg
73: ( p_location_id
74: , g_table_name
75: , 'Replicate_Record error: Could not find record associated with PO_LOCATION_ASSOCIATIONS_ALL.LOCATION_ID '
76: || p_location_id
77: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
78: END IF;
79:

Line 125: FROM PO_LOCATION_ASSOCIATIONS_ALL PLA

121: , CAS.cust_acct_site_id CAS_ID
122: , RCR.RS_CUST_RELATION_ID RCR_ID
123: , HPS.party_site_id HPS_ID
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

Line 165: , 'Insert ACC Record error: Could not find record associated with PO_LOCATION_ASSOCIATIONS_ALL.LOCATION_ID ' || p_location_id

161: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
162: jtm_message_log_pkg.Log_Msg
163: ( p_location_id
164: , g_table_name
165: , 'Insert ACC Record error: Could not find record associated with PO_LOCATION_ASSOCIATIONS_ALL.LOCATION_ID ' || p_location_id
166: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
167: END IF;
168: ELSE
169:

Line 196: -- PO_LOCATION_ASSOCIATIONS_ALL

192: , P_PK1_NAME => g_pk1_name3
193: , P_PK1_NUM_VALUE => r_location_ids.CSU_ID
194: , P_RESOURCE_ID => l_resource_id
195: );
196: -- PO_LOCATION_ASSOCIATIONS_ALL
197: JTM_HOOK_UTIL_PKG.Insert_Acc
198: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name4
199: , P_ACC_TABLE_NAME => g_acc_table_name4
200: , P_PK1_NAME => g_pk1_name4

Line 231: FROM PO_LOCATION_ASSOCIATIONS_ALL PLA

227: , RCR.RS_CUST_RELATION_ID RCR_ID
228: , HPS.party_site_id HPS_ID
229: , HZL.location_id HZL_ID
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

Line 280: , 'Update ACC Record error: Could not find record associated with PO_LOCATION_ASSOCIATIONS_ALL.LOCATION_ID '

276: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
277: jtm_message_log_pkg.Log_Msg
278: ( p_location_id
279: , g_table_name
280: , 'Update ACC Record error: Could not find record associated with PO_LOCATION_ASSOCIATIONS_ALL.LOCATION_ID '
281: || p_location_id
282: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
283: END IF;
284: ELSE

Line 323: -- PO_LOCATION_ASSOCIATIONS_ALL

319: ,g_acc_table_name3
320: ,l_resource_id
321: ,l_csu_acc_id
322: );
323: -- PO_LOCATION_ASSOCIATIONS_ALL
324: l_pla_acc_id := JTM_HOOK_UTIL_PKG.Get_Acc_Id(
325: P_ACC_TABLE_NAME => g_acc_table_name4
326: , P_PK1_NAME => g_pk1_name4
327: , P_PK1_NUM_VALUE => p_location_id

Line 365: FROM PO_LOCATION_ASSOCIATIONS_ALL PLA

361: , CAS.cust_acct_site_id CAS_ID
362: , RCR.RS_CUST_RELATION_ID RCR_ID
363: , HPS.party_site_id HPS_ID
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

Line 458: , 'Delete PO_LOCATION_ASSOCIATIONS_ALL acc record for user: ' || p_resource_id

454: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
455: jtm_message_log_pkg.Log_Msg
456: ( p_resource_id
457: , g_table_name
458: , 'Delete PO_LOCATION_ASSOCIATIONS_ALL acc record for user: ' || p_resource_id
459: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
460: END IF;
461: JTM_HOOK_UTIL_PKG.Delete_Acc
462: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name4

Line 657: FROM PO_LOCATION_ASSOCIATIONS_ALL PLA

653: )
654: IS
655: CURSOR c_location( b_resource_id NUMBER ) IS
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

Line 707: FROM PO_LOCATION_ASSOCIATIONS_ALL PLA

703: )
704: IS
705: CURSOR c_location( b_resource_id NUMBER ) IS
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