18: TYPE rate_tab_type IS TABLE OF rate_rec_type INDEX BY BINARY_INTEGER;
19:
20: CURSOR c_get_ship_method_code (c_carrier_id VARCHAR2, c_mode_of_trans VARCHAR2, c_service_level VARCHAR2, c_org_id NUMBER) IS
21: SELECT a.ship_method_code
22: FROM wsh_carrier_services a, wsh_org_carrier_services b
23: WHERE a.carrier_service_id = b.carrier_service_id
24: AND b.organization_id = c_org_id
25: AND b.enabled_flag = 'Y'
26: AND a.enabled_flag = 'Y'
39: WHERE carrier_id = c_carrier_id;
40:
41: CURSOR c_get_generic_carrier_flag2 (c_ship_method_code VARCHAR2) IS
42: SELECT a.generic_flag
43: FROM wsh_carriers a, wsh_carrier_services b
44: WHERE a.carrier_id = b.carrier_id
45: AND b.ship_method_code = c_ship_method_code;
46:
47: CURSOR c_carrier_services(c_shp_mthd_cd VARCHAR2)
46:
47: CURSOR c_carrier_services(c_shp_mthd_cd VARCHAR2)
48: IS
49: SELECT ship_method_code,carrier_id, service_level, mode_of_transport, ship_method_meaning
50: FROM wsh_carrier_services
51: WHERE ship_method_code = c_shp_mthd_cd;
52:
53: PROCEDURE convert_amount(
54: p_from_currency IN VARCHAR2,
1039: l_generic_carrier VARCHAR2(1);
1040: l_carrier_id NUMBER;
1041:
1042: c_carr_srv_rec c_carrier_services%ROWTYPE;
1043: l_ship_method_meaning wsh_carrier_services.ship_method_meaning%type;
1044: l_mode_of_transport wsh_carrier_services.mode_of_transport%type;
1045: l_service_level wsh_carrier_services.service_level%type;
1046:
1047: BEGIN
1040: l_carrier_id NUMBER;
1041:
1042: c_carr_srv_rec c_carrier_services%ROWTYPE;
1043: l_ship_method_meaning wsh_carrier_services.ship_method_meaning%type;
1044: l_mode_of_transport wsh_carrier_services.mode_of_transport%type;
1045: l_service_level wsh_carrier_services.service_level%type;
1046:
1047: BEGIN
1048: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1041:
1042: c_carr_srv_rec c_carrier_services%ROWTYPE;
1043: l_ship_method_meaning wsh_carrier_services.ship_method_meaning%type;
1044: l_mode_of_transport wsh_carrier_services.mode_of_transport%type;
1045: l_service_level wsh_carrier_services.service_level%type;
1046:
1047: BEGIN
1048: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1049: