APPS.CSM_PO_LOCATIONS_EVENT_PKG dependencies on CSM_PO_LOC_ASS_ALL_ACC

Line 16: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_PO_LOC_ASS_ALL_ACC';

12: -- --------- ------ ------------------------------------------
13: -- Enter procedure, function bodies as shown below
14:
15: g_table_name1 CONSTANT VARCHAR2(30) := 'PO_LOCATION_ASSOCIATIONS_ALL';
16: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_PO_LOC_ASS_ALL_ACC';
17: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_PO_LOC_ASS_ALL_ACC_S';
18: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
19: CSM_ACC_PKG.t_publication_item_list('CSM_PO_LOC_ASS_ALL');
20: g_pk1_name1 CONSTANT VARCHAR2(30) := 'LOCATION_ID';

Line 17: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_PO_LOC_ASS_ALL_ACC_S';

13: -- Enter procedure, function bodies as shown below
14:
15: g_table_name1 CONSTANT VARCHAR2(30) := 'PO_LOCATION_ASSOCIATIONS_ALL';
16: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_PO_LOC_ASS_ALL_ACC';
17: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_PO_LOC_ASS_ALL_ACC_S';
18: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
19: CSM_ACC_PKG.t_publication_item_list('CSM_PO_LOC_ASS_ALL');
20: g_pk1_name1 CONSTANT VARCHAR2(30) := 'LOCATION_ID';
21: g_pk2_name1 CONSTANT VARCHAR2(30) := 'SITE_USE_ID';

Line 139: FROM csm_po_loc_ass_all_acc

135:
136: CURSOR l_location_access_csr(p_location_id IN NUMBER, p_site_use_id IN NUMBER, p_user_id IN NUMBER)
137: IS
138: SELECT 1
139: FROM csm_po_loc_ass_all_acc
140: WHERE location_id = p_location_id
141: AND site_use_id = p_site_use_id
142: AND user_id = p_user_id;
143:

Line 194: -- insert into csm_po_loc_ass_all_acc

190: p_flowtype=>NULL,
191: p_error_msg=>l_error_msg,
192: x_return_status=>l_return_status);
193:
194: -- insert into csm_po_loc_ass_all_acc
195: csm_po_locations_event_pkg.csp_ship_to_addr_mdirty_i
196: (p_location_id=>r_cust_acc_site_upd_rec.location_id,
197: p_site_use_id=>r_cust_acc_site_upd_rec.site_use_id,
198: p_user_id=>r_cust_acc_site_upd_rec.user_id);