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.

APPS.WSH_CARRIERS_GRP dependencies on WSH_CARRIER_SERVICES

Line 525: -- COMMENT : Creates or updates a record in wsh_carrier_services

521: -- p_rec_attr_tab Table of attributes for the carrier service entity
522: -- x_car_ser_out_rec_tab Table of carrier_service_id, and ship_method_code.
523: -- VERSION : current version 1.0
524: -- initial version 1.0
525: -- COMMENT : Creates or updates a record in wsh_carrier_services
526: --========================================================================
527: PROCEDURE Create_Update_Carrier_Service
528: ( p_api_version_number IN NUMBER,
529: p_init_msg_list IN VARCHAR2,

Line 562: l_carrier_ser_tab WSH_CARRIER_SERVICES_PKG.CSRecType;

558:
559: l_input_param_flag BOOLEAN := TRUE;
560: l_param_name VARCHAR2(100);
561:
562: l_carrier_ser_tab WSH_CARRIER_SERVICES_PKG.CSRecType;
563: l_carrier_service_id NUMBER;
564: l_rowid VARCHAR2(4000) := NULL;
565:
566: l_service_level_code VARCHAR2(4000);

Line 575: FROM WSH_CARRIER_SERVICES

571: l_ship_method_meaning VARCHAR2(4000);
572:
573: CURSOR get_carrier_ser_id(p_carrier_id INTEGER,p_service_level_code VARCHAR2, p_mode_of_transport VARCHAR2) is
574: SELECT carrier_id
575: FROM WSH_CARRIER_SERVICES
576: WHERE carrier_id = p_carrier_id
577: AND service_level = p_service_level_code
578: AND MODE_OF_TRANSPORT = p_mode_of_transport;
579:

Line 590: FROM wsh_carrier_services

586:
587:
588: CURSOR get_rowid_shpcode(p_carrier_id INTEGER, p_service_level VARCHAR2, p_mode_of_transport VARCHAR2) is
589: SELECT rowid,ship_method_code
590: FROM wsh_carrier_services
591: WHERE carrier_id= p_carrier_id
592: AND service_level = p_service_level
593: AND mode_of_transport = p_mode_of_transport;
594:

Line 600: FROM wsh_carrier_services

596: -- Cursors for Services Validation
597:
598: CURSOR Check_Duplicate(p_mode_of_transport VARCHAR2, p_service_level VARCHAR2, p_carrier_id NUMBER) IS
599: SELECT count(*)
600: FROM wsh_carrier_services
601: WHERE mode_of_transport = p_mode_of_transport AND
602: service_level = p_service_level AND
603: carrier_id = p_carrier_id;
604:

Line 607: FROM wsh_carrier_services

603: carrier_id = p_carrier_id;
604:
605: CURSOR Check_Duplicate_SMM_Create(p_ship_method_meaning VARCHAR2) IS
606: SELECT rowid
607: FROM wsh_carrier_services
608: WHERE SHIP_METHOD_MEANING = p_ship_method_meaning;
609:
610: CURSOR Check_Duplicate_SMM_Update(p_rowid VARCHAR2, p_ship_method_meaning VARCHAR2) IS
611: SELECT rowid

Line 612: FROM wsh_carrier_services

608: WHERE SHIP_METHOD_MEANING = p_ship_method_meaning;
609:
610: CURSOR Check_Duplicate_SMM_Update(p_rowid VARCHAR2, p_ship_method_meaning VARCHAR2) IS
611: SELECT rowid
612: FROM wsh_carrier_services
613: WHERE SHIP_METHOD_MEANING = p_ship_method_meaning
614: AND rowid <> p_rowid;
615:
616: l_count NUMBER := 0;

Line 805: WSH_CARRIER_SERVICES_PKG.Create_Carrier_Service

801: CLOSE Check_Duplicate_SMM_Create;
802: --- Bug 3392826 End: Validation for Services
803:
804:
805: WSH_CARRIER_SERVICES_PKG.Create_Carrier_Service
806: (
807: p_Carrier_Service_Info => l_carrier_ser_tab,
808: P_COMMIT => p_commit,
809: X_ROWID => l_rowid,

Line 843: WSH_CARRIER_SERVICES_PKG.Update_Carrier_Service

839:
840:
841: IF l_rowid IS NOT NULL THEN
842: l_carrier_ser_tab.ship_method_code := l_ship_method_code;
843: WSH_CARRIER_SERVICES_PKG.Update_Carrier_Service
844: (
845: p_Carrier_Service_Info => l_carrier_ser_tab,
846: P_ROWID => l_rowid,
847: P_COMMIT => p_commit,

Line 1012: FROM WSH_CARRIER_SERVICES

1008: l_carrier_name VARCHAR2(4000);
1009:
1010: CURSOR get_carrier_ser_info(p_carrier_service_id NUMBER) IS
1011: SELECT CARRIER_ID,SERVICE_LEVEL,SHIP_METHOD_CODE
1012: FROM WSH_CARRIER_SERVICES
1013: WHERE carrier_service_id = p_carrier_service_id
1014: AND enabled_flag = 'Y';
1015:
1016: CURSOR get_carrier_info(p_carrier_id NUMBER) IS

Line 1335: FROM WSH_CARRIER_SERVICES

1331: p_car_ser_out_rec_tab Org_Carrier_Ser_Out_Tab_Type;
1332:
1333: CURSOR get_carrier_service_ids(p_carrier_id NUMBER) IS
1334: SELECT carrier_service_id
1335: FROM WSH_CARRIER_SERVICES
1336: WHERE carrier_id = p_carrier_id
1337: AND enabled_flag = 'Y';
1338:
1339: BEGIN

Line 1585: -- if this Ship_Method_Meaning exists in WSH_CARRIER_SERVICES

1581: BEGIN
1582:
1583: -- iSetup bug 3924555
1584: -- return the existing Ship_Method for the given Ship_Method_Meaning
1585: -- if this Ship_Method_Meaning exists in WSH_CARRIER_SERVICES
1586: -- error will be caught by Check_Duplicate_SMM_Create cursor
1587: -- otherwise, it means the lookup value exists but no Carrier Service
1588: -- exists in WSH_CARRIER_SERVICES, which is the bug case.
1589:

Line 1588: -- exists in WSH_CARRIER_SERVICES, which is the bug case.

1584: -- return the existing Ship_Method for the given Ship_Method_Meaning
1585: -- if this Ship_Method_Meaning exists in WSH_CARRIER_SERVICES
1586: -- error will be caught by Check_Duplicate_SMM_Create cursor
1587: -- otherwise, it means the lookup value exists but no Carrier Service
1588: -- exists in WSH_CARRIER_SERVICES, which is the bug case.
1589:
1590: IF (ship_method_meaning IS NOT NULL) THEN
1591:
1592: OPEN Get_Ship_Method_By_Meaning(ship_method_meaning);

Line 1715: wsh_carrier_services wcs

1711: wcs.service_level,
1712: wcs.mode_of_transport,
1713: wcs.ship_method_code
1714: FROM wsh_carriers wc,
1715: wsh_carrier_services wcs
1716: WHERE wc.carrier_id = wcs.carrier_id
1717: AND ( wcs.ship_method_code = p_carrier_service_inout_rec.ship_method_code OR
1718: wcs.carrier_service_id = p_carrier_service_inout_rec.carrier_service_id);
1719: