APPS.CSM_WF_PKG dependencies on PO_LOCATION_ASSOCIATIONS_ALL

Line 2386: l_location_id po_location_associations_all.location_id%TYPE;

2382: END CSP_Inv_Loc_Assg_Post_Del;
2383:
2384: PROCEDURE CSP_SHIP_TO_ADDRESS_POST_INS(x_return_status OUT NOCOPY VARCHAR2)
2385: IS
2386: l_location_id po_location_associations_all.location_id%TYPE;
2387: l_sqlerrno varchar2(20);
2388: l_sqlerrmsg varchar2(2000);
2389: l_error_msg VARCHAR2(4000);
2390: l_return_status VARCHAR2(2000);

Line 2398: FROM po_location_associations_all pla,

2394: pla.org_id ,
2395: decode(rcr.resource_type,'RS_GROUP','G','E') resource_type,
2396: au.user_id user_id,
2397: cas.party_site_id party_site_id
2398: FROM po_location_associations_all pla,
2399: hz_cust_site_uses_all csu,
2400: hz_cust_acct_sites_all cas,
2401: csp_rs_cust_relations rcr,
2402: asg_user au

Line 2458: l_location_id po_location_associations_all.location_id%TYPE;

2454: END CSP_SHIP_TO_ADDRESS_POST_INS;
2455:
2456: PROCEDURE CSP_SHIP_TO_ADDRESS_POST_UPD(x_return_status OUT NOCOPY varchar2)
2457: IS
2458: l_location_id po_location_associations_all.location_id%TYPE;
2459: l_sqlerrno varchar2(20);
2460: l_sqlerrmsg varchar2(2000);
2461: l_error_msg VARCHAR2(4000);
2462: l_return_status VARCHAR2(2000);