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.

[Home] [Help]

APPS.CSM_WF_PKG dependencies on PO_LOCATION_ASSOCIATIONS_ALL

Line 2371: l_location_id po_location_associations_all.location_id%TYPE;

2367:
2368:
2369: PROCEDURE CSP_SHIP_TO_ADDRESS_POST_INS(x_return_status OUT NOCOPY VARCHAR2)
2370: IS
2371: l_location_id po_location_associations_all.location_id%TYPE;
2372: l_sqlerrno varchar2(20);
2373: l_sqlerrmsg varchar2(2000);
2374: l_error_msg VARCHAR2(4000);
2375: l_return_status VARCHAR2(2000);

Line 2383: FROM po_location_associations_all pla,

2379: csu.site_use_id site_use_id,
2380: rcr.resource_id resource_id,
2381: jtrs.user_id user_id,
2382: hps.party_site_id party_site_id
2383: FROM po_location_associations_all pla,
2384: hz_cust_site_uses_all csu,
2385: hz_cust_acct_sites_all cas,
2386: csp_rs_cust_relations rcr,
2387: jtf_rs_resource_extns jtrs,

Line 2448: l_location_id po_location_associations_all.location_id%TYPE;

2444: END CSP_SHIP_TO_ADDRESS_POST_INS;
2445:
2446: PROCEDURE CSP_SHIP_TO_ADDRESS_POST_UPD(x_return_status OUT NOCOPY varchar2)
2447: IS
2448: l_location_id po_location_associations_all.location_id%TYPE;
2449: l_sqlerrno varchar2(20);
2450: l_sqlerrmsg varchar2(2000);
2451: l_error_msg VARCHAR2(4000);
2452: l_return_status VARCHAR2(2000);

Line 2460: FROM po_location_associations_all pla,

2456: csu.site_use_id site_use_id,
2457: rcr.resource_id resource_id,
2458: jtrs.user_id user_id,
2459: hps.party_site_id party_site_id
2460: FROM po_location_associations_all pla,
2461: hz_cust_site_uses_all csu,
2462: hz_cust_acct_sites_all cas,
2463: csp_rs_cust_relations rcr,
2464: jtf_rs_resource_extns jtrs,