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) := 'ORG_ID';

Line 147: FROM csm_po_loc_ass_all_acc

143:
144: CURSOR l_location_access_csr(p_location_id IN NUMBER, p_user_id IN NUMBER)
145: IS
146: SELECT 1
147: FROM csm_po_loc_ass_all_acc
148: WHERE location_id = p_location_id
149: AND user_id = p_user_id;
150:
151: BEGIN

Line 202: -- insert into csm_po_loc_ass_all_acc

198: p_flowtype=>NULL,
199: p_error_msg=>l_error_msg,
200: x_return_status=>l_return_status);
201:
202: -- insert into csm_po_loc_ass_all_acc
203: csm_po_locations_event_pkg.csp_ship_to_addr_mdirty_i
204: (p_location_id=>r_cust_acc_site_upd_rec.location_id,
205: p_org_id=>r_cust_acc_site_upd_rec.org_id,
206: p_res_type=>r_cust_acc_site_upd_rec.resource_type,

Line 251: AND NOT EXISTS (SELECT 1 FROM csm_po_loc_ass_all_acc acc

247: AND cas.status = 'A' -- only active sites
248: AND rcr.resource_type='RS_GROUP' AND rcr.resource_id =p_group_id
249: AND au.resource_id=p_resource_id
250: AND au.enabled='Y'
251: AND NOT EXISTS (SELECT 1 FROM csm_po_loc_ass_all_acc acc
252: WHERE acc.user_id = au.user_id
253: AND acc.location_id = pla.location_id
254: AND acc.org_id = pla.org_id
255: AND acc.RESOURCE_TYPE= 'G');

Line 271: -- insert into csm_po_loc_ass_all_acc

267: p_flowtype=>NULL,
268: p_error_msg=>l_error_msg,
269: x_return_status=>l_return_status);
270:
271: -- insert into csm_po_loc_ass_all_acc
272: csm_po_locations_event_pkg.csp_ship_to_addr_mdirty_i
273: (p_location_id=>r_cust_acc_site_upd_rec.location_id,
274: p_org_id=>r_cust_acc_site_upd_rec.org_id,
275: p_res_type=>r_cust_acc_site_upd_rec.resource_type,

Line 292: csm_po_loc_ass_all_acc acc,

288: acc.resource_type,
289: acc.user_id,
290: cas.party_site_id
291: FROM po_location_associations_all pla,
292: csm_po_loc_ass_all_acc acc,
293: hz_cust_acct_sites_all cas,
294: asg_user au
295: WHERE acc.user_id = au.user_id AND acc.location_id = pla.location_id AND acc.org_id = pla.org_id AND acc.RESOURCE_TYPE= 'G'
296: AND pla.address_id = cas.cust_acct_site_id