APPS.WSH_CARRIERS_GRP dependencies on WSH_ORG_CARRIER_SERVICES

Line 957: -- COMMENT : Creates or updates a record in wsh_org_carrier_services

953: -- p_rec_attr_tab Table of attributes for the organization carrier service entity
954: -- x_orgcar_ser_out_rec_tab Table of orgcarrier_service_id and ship_method_code.
955: -- VERSION : current version 1.0
956: -- initial version 1.0
957: -- COMMENT : Creates or updates a record in wsh_org_carrier_services
958: --========================================================================
959: PROCEDURE Assign_Org_Carrier_Service
960: ( p_api_version_number IN NUMBER,
961: p_init_msg_list IN VARCHAR2,

Line 996: l_org_car_ser_tab WSH_ORG_CARRIER_SERVICES_PKG.OCSRecType;

992:
993: l_input_param_flag BOOLEAN := TRUE;
994: l_param_name VARCHAR2(100);
995:
996: l_org_car_ser_tab WSH_ORG_CARRIER_SERVICES_PKG.OCSRecType;
997: l_car_info_tab WSH_ORG_CARRIER_SERVICES_PKG.CarRecType;
998: l_shp_method_rec WSH_CARRIER_SHIP_METHODS_PKG.CSMRecType;
999:
1000: l_org_carrier_service_id NUMBER;

Line 997: l_car_info_tab WSH_ORG_CARRIER_SERVICES_PKG.CarRecType;

993: l_input_param_flag BOOLEAN := TRUE;
994: l_param_name VARCHAR2(100);
995:
996: l_org_car_ser_tab WSH_ORG_CARRIER_SERVICES_PKG.OCSRecType;
997: l_car_info_tab WSH_ORG_CARRIER_SERVICES_PKG.CarRecType;
998: l_shp_method_rec WSH_CARRIER_SHIP_METHODS_PKG.CSMRecType;
999:
1000: l_org_carrier_service_id NUMBER;
1001: l_rowid VARCHAR2(4000);

Line 1024: FROM wsh_Org_Carrier_Services

1020: AND car.carrier_id = par.PARTY_ID;
1021:
1022: CURSOR get_org_carser_info(p_carrier_service_id NUMBER,p_org_id NUMBER) IS
1023: SELECT org_carrier_service_id,rowid
1024: FROM wsh_Org_Carrier_Services
1025: WHERE carrier_service_id = p_carrier_service_id
1026: AND organization_id = p_org_id;
1027:
1028: BEGIN

Line 1171: WSH_ORG_CARRIER_SERVICES_PKG.assign_org_carrier_service

1167: l_org_car_ser_tab.ENABLED_FLAG := 'N';
1168: END IF;
1169: IF p_action_code = 'ASSIGN' OR p_action_code = 'UNASSIGN' THEN
1170:
1171: WSH_ORG_CARRIER_SERVICES_PKG.assign_org_carrier_service
1172: (
1173: p_Org_Carrier_Service_info => l_org_car_ser_tab,
1174: p_carrier_info => l_car_info_tab,
1175: p_csm_info => l_shp_method_rec,

Line 1287: -- Creates or updates a record in wsh_org_carrier_services,org_freight_tl,wsh_carrier_ship_methods

1283: -- x_orgcar_ser_out_tab Table of orgcarrier_service_id and ship_method_code.
1284: -- VERSION : current version 1.0
1285: -- initial version 1.0
1286: -- COMMENT : The Organization is assigned to all present carrier services the carrier at that poing of time
1287: -- Creates or updates a record in wsh_org_carrier_services,org_freight_tl,wsh_carrier_ship_methods
1288: --========================================================================
1289: PROCEDURE Assign_Org_Carrier
1290: ( p_api_version_number IN NUMBER,
1291: p_init_msg_list IN VARCHAR2,