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_CARRIERS

Line 1: PACKAGE BODY WSH_CARRIERS_GRP AS

1: PACKAGE BODY WSH_CARRIERS_GRP AS
2: /* $Header: WSHCAGPB.pls 120.5 2005/10/28 17:47:54 somanaam noship $ */
3: --===================
4: -- CONSTANTS
5: --===================

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_CARRIERS_GRP';

2: /* $Header: WSHCAGPB.pls 120.5 2005/10/28 17:47:54 somanaam noship $ */
3: --===================
4: -- CONSTANTS
5: --===================
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_CARRIERS_GRP';
7:
8: --========================================================================
9: -- PROCEDURE : Create_Update_Carrier
10: --

Line 24: -- COMMENT : Creates or updates a record in wsh_carriers

20: -- p_status status
21: -- x_car_out_rec_tab Table of carrier_id
22: -- VERSION : current version 1.0
23: -- initial version 1.0
24: -- COMMENT : Creates or updates a record in wsh_carriers
25: --========================================================================
26: PROCEDURE Create_Update_Carrier
27: ( p_api_version_number IN NUMBER,
28: p_init_msg_list IN VARCHAR2,

Line 42: FROM WSH_CARRIERS car, HZ_PARTIES par

38: IS
39:
40: CURSOR get_carrier_id(p_carrier_name VARCHAR2,fr_code VARCHAR2) is
41: SELECT carrier_id
42: FROM WSH_CARRIERS car, HZ_PARTIES par
43: WHERE car.carrier_id = par.PARTY_ID
44: AND par.PARTY_NAME = p_carrier_name
45: AND car.FREIGHT_CODE = fr_code;
46:

Line 49: FROM WSH_CARRIERS

45: AND car.FREIGHT_CODE = fr_code;
46:
47: CURSOR get_ftcode_carrier_id(fr_code VARCHAR2) is
48: SELECT carrier_id
49: FROM WSH_CARRIERS
50: WHERE FREIGHT_CODE = fr_code;
51:
52:
53: l_debug_on BOOLEAN;

Line 87: FROM wsh_carriers

83: -- Cursors for Carrier Validation
84:
85: CURSOR Get_SCAC_Code_Create(p_scac_code VARCHAR2) IS
86: SELECT carrier_id
87: FROM wsh_carriers
88: WHERE SCAC_CODE = p_scac_code;
89:
90: CURSOR Get_SCAC_Code_Update(p_carrier_id NUMBER, p_scac_code VARCHAR2) IS
91: SELECT carrier_id

Line 92: FROM wsh_carriers

88: WHERE SCAC_CODE = p_scac_code;
89:
90: CURSOR Get_SCAC_Code_Update(p_carrier_id NUMBER, p_scac_code VARCHAR2) IS
91: SELECT carrier_id
92: FROM wsh_carriers
93: WHERE SCAC_CODE = p_scac_code
94: AND carrier_id <> p_carrier_id;
95:
96:

Line 99: FROM wsh_carriers

95:
96:
97: CURSOR Get_Freight_Code_Create(p_freight_code VARCHAR2) IS
98: SELECT carrier_id
99: FROM wsh_carriers
100: WHERE upper(FREIGHT_CODE) = upper(p_freight_code);
101:
102: CURSOR Get_Freight_Code_Update(p_carrier_id NUMBER, p_freight_code VARCHAR2) IS
103: SELECT carrier_id

Line 104: FROM wsh_carriers

100: WHERE upper(FREIGHT_CODE) = upper(p_freight_code);
101:
102: CURSOR Get_Freight_Code_Update(p_carrier_id NUMBER, p_freight_code VARCHAR2) IS
103: SELECT carrier_id
104: FROM wsh_carriers
105: WHERE upper(FREIGHT_CODE) = upper(p_freight_code)
106: AND carrier_id <> p_carrier_id;
107:
108: CURSOR Get_Carrier_Name_Create(p_carrier_name VARCHAR2) IS

Line 110: FROM wsh_carriers_v wc

106: AND carrier_id <> p_carrier_id;
107:
108: CURSOR Get_Carrier_Name_Create(p_carrier_name VARCHAR2) IS
109: SELECT carrier_id
110: FROM wsh_carriers_v wc
111: WHERE wc.active= 'A' AND
112: upper(wc.carrier_name) = upper(p_carrier_name);
113:
114: CURSOR Get_Carrier_Name_Update(p_carrier_id NUMBER,p_carrier_name VARCHAR2) IS

Line 116: FROM wsh_carriers_v wc

112: upper(wc.carrier_name) = upper(p_carrier_name);
113:
114: CURSOR Get_Carrier_Name_Update(p_carrier_id NUMBER,p_carrier_name VARCHAR2) IS
115: SELECT carrier_id
116: FROM wsh_carriers_v wc
117: WHERE wc.active = 'A'
118: AND upper(wc.carrier_name) = upper(p_carrier_name)
119: AND wc.carrier_id <> p_carrier_id;
120:

Line 123: FROM wsh_carriers_v

119: AND wc.carrier_id <> p_carrier_id;
120:
121: CURSOR Check_Generic_Carr(p_freight_code VARCHAR2) IS
122: SELECT carrier_name
123: FROM wsh_carriers_v
124: WHERE nvl(generic_flag, 'N') = 'Y' AND
125: freight_code <> nvl(p_freight_code, ' ') AND
126: active = 'A';
127:

Line 583: FROM WSH_CARRIERS

579:
580:
581: CURSOR get_freight_code(p_carrier_id INTEGER) is
582: SELECT freight_code
583: FROM WSH_CARRIERS
584: WHERE carrier_id = p_carrier_id;
585:
586:
587:

Line 1018: FROM WSH_CARRIERS car, HZ_PARTIES par

1014: AND enabled_flag = 'Y';
1015:
1016: CURSOR get_carrier_info(p_carrier_id NUMBER) IS
1017: SELECT car.freight_code,par.PARTY_NAME
1018: FROM WSH_CARRIERS car, HZ_PARTIES par
1019: WHERE car.carrier_id = p_carrier_id
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

Line 1330: p_car_ser_out_rec WSH_CARRIERS_GRP.Org_Carrier_Ser_Out_Rec_Type;

1326:
1327: p_rec_org_car_ser_tab Org_Carrier_Service_Rec_Type;
1328: p_rec_car_info_tab Carrier_Info_Dff_Type;
1329: p_car_shp_methods Ship_Method_Dff_Type;
1330: p_car_ser_out_rec WSH_CARRIERS_GRP.Org_Carrier_Ser_Out_Rec_Type;
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

Line 1647: -- x_freight_code carrier freight code given id from wsh_carriers

1643: --
1644: --
1645: -- PARAMETERS: p_carrier_id carrier_id for which name is desired
1646: -- x_carrier_name carrier name given id
1647: -- x_freight_code carrier freight code given id from wsh_carriers
1648: --
1649: --========================================================================
1650: PROCEDURE Get_Carrier_Name
1651: (

Line 1659: FROM wsh_carriers, hz_parties

1655: ) IS
1656:
1657: CURSOR get_carrier_name IS
1658: SELECT party_name, freight_code
1659: FROM wsh_carriers, hz_parties
1660: WHERE carrier_id =party_id
1661: AND carrier_id= p_carrier_id;
1662:
1663: --

Line 1714: FROM wsh_carriers wc,

1710: wcs.carrier_service_id,
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);

Line 1778: END WSH_CARRIERS_GRP;

1774: END IF;
1775: --
1776: END get_carrier_service_mode;
1777:
1778: END WSH_CARRIERS_GRP;
1779: