840: l_index PLS_INTEGER;
841: l_act_index PLS_INTEGER;
842: l_xml_index PLS_INTEGER;
843: l_csp_request_in WSH_U_CSPV.CSPValidateInRec;
844: l_rate_request_in WSH_U_RASS.RateServiceInRec;
845: wsh_u_proxy EXCEPTION;
846: wsh_u_host_failed EXCEPTION;
847: wsh_u_cityorzip EXCEPTION;
848: wsh_u_csp EXCEPTION;
1303: --G_UPS_ACCESS_TOKEN
1304: --G_ORA_WALLET_PATH
1305: --G_ORA_WALLET_PASSSWD
1306: PROCEDURE rate_shipment_services
1307: ( p_request_in IN WSH_U_RASS.RateServiceInRec
1308: , x_output OUT NOCOPY WSH_U_RASS.RateServTableTyp
1309: , x_msg_count OUT NOCOPY NUMBER
1310: , x_msg_data OUT NOCOPY VARCHAR2
1311: , x_return_status OUT NOCOPY VARCHAR2 )
1304: --G_ORA_WALLET_PATH
1305: --G_ORA_WALLET_PASSSWD
1306: PROCEDURE rate_shipment_services
1307: ( p_request_in IN WSH_U_RASS.RateServiceInRec
1308: , x_output OUT NOCOPY WSH_U_RASS.RateServTableTyp
1309: , x_msg_count OUT NOCOPY NUMBER
1310: , x_msg_data OUT NOCOPY VARCHAR2
1311: , x_return_status OUT NOCOPY VARCHAR2 )
1312: IS
1337: l_index PLS_INTEGER;
1338: l_act_index PLS_INTEGER;
1339: l_xml_index PLS_INTEGER;
1340: l_csp_request_in WSH_U_CSPV.CSPValidateInRec;
1341: l_rate_request_in WSH_U_RASS.RateServiceInRec;
1342: wsh_u_proxy EXCEPTION;
1343: wsh_u_host_failed EXCEPTION;
1344: wsh_u_srvlevcode EXCEPTION;
1345: wsh_u_pkgactwt EXCEPTION;
2198: l_index PLS_INTEGER;
2199: l_act_index PLS_INTEGER;
2200: l_xml_index PLS_INTEGER;
2201: l_csp_request_in WSH_U_CSPV.CSPValidateInRec;
2202: l_rate_request_in WSH_U_RASS.RateServiceInRec;
2203: wsh_u_proxy EXCEPTION;
2204: wsh_u_host_failed EXCEPTION;
2205: wsh_u_no_trk EXCEPTION;
2206: l_namespace VARCHAR2(1000);