APPS.WSH_CREATE_CARRIERS_PKG dependencies on WSH_CARRIERS

Line 54: FROM wsh_carriers

50: l_sqlerr varchar2(2000);
51:
52: CURSOR Get_Rowid(p_carrier_id NUMBER) IS
53: SELECT rowid
54: FROM wsh_carriers
55: WHERE carrier_id = p_carrier_id;
56:
57: --
58: l_debug_on BOOLEAN;

Line 233: l_call_procedure := 'Inserting into WSH_CARRIERS table';

229:
230: -- End Party Usage
231:
232: l_position := 30;
233: l_call_procedure := 'Inserting into WSH_CARRIERS table';
234:
235: INSERT INTO WSH_CARRIERS
236: (
237: CARRIER_ID,

Line 235: INSERT INTO WSH_CARRIERS

231:
232: l_position := 30;
233: l_call_procedure := 'Inserting into WSH_CARRIERS table';
234:
235: INSERT INTO WSH_CARRIERS
236: (
237: CARRIER_ID,
238: --Bug2313801 NAME,
239: FREIGHT_CODE,

Line 508: FROM wsh_carriers_v

504: WHERE party_id = l_carrier_party_id;
505: -- Party Usage
506: CURSOR Get_Carrier_Status(l_carrier_party_id NUMBER) IS
507: SELECT active, party_usg_assignment_id
508: FROM wsh_carriers_v
509: WHERE carrier_id = l_carrier_party_id;
510:
511: l_party_usg_assignment_rec HZ_PARTY_USG_ASSIGNMENT_PVT.party_usg_assignment_rec_type;
512: l_party_usg_assignment_id NUMBER;

Line 683: l_call_procedure := 'Updating WSH_CARRIERS table';

679: END IF;
680:
681: -- END Party Usage
682: l_position := 30;
683: l_call_procedure := 'Updating WSH_CARRIERS table';
684: --bug 5598102 creation_date and created_by removed from update statement
685: UPDATE WSH_CARRIERS
686: SET scac_code = P_Carrier_info.SCAC_CODE,
687: currency_code = P_Carrier_info.CURRENCY_CODE,

Line 685: UPDATE WSH_CARRIERS

681: -- END Party Usage
682: l_position := 30;
683: l_call_procedure := 'Updating WSH_CARRIERS table';
684: --bug 5598102 creation_date and created_by removed from update statement
685: UPDATE WSH_CARRIERS
686: SET scac_code = P_Carrier_info.SCAC_CODE,
687: currency_code = P_Carrier_info.CURRENCY_CODE,
688: manifesting_enabled_flag = P_Carrier_info.MANIFESTING_ENABLED,
689: attribute_category = P_Carrier_info.Attribute_Category,

Line 857: FROM wsh_carriers

853: IS
854:
855: CURSOR C_lock_row IS
856: SELECT *
857: FROM wsh_carriers
858: WHERE rowid = p_rowid
859: FOR UPDATE of Carrier_id NOWAIT;
860: RecInfo C_Lock_Row%ROWTYPE;
861:

Line 865: FROM wsh_carriers_v

861:
862: --4708730
863: CURSOR get_carrier_details is
864: SELECT carrier_name,active
865: FROM wsh_carriers_v
866: WHERE carrier_id =P_Carrier_info.CARRIER_id;
867: Rec_carrier_details get_carrier_details%ROWTYPE;
868:
869: record_locked EXCEPTION;

Line 1537: FROM wsh_carriers

1533: lookupinfo C_lookup_row%ROWTYPE;
1534:
1535: CURSOR C_get_FREIGHT_code(p_carrier_id NUMBER) IS
1536: SELECT freight_code
1537: FROM wsh_carriers
1538: WHERE carrier_id = p_carrier_id;
1539:
1540: CURSOR C_get_ship_method_code(p_carrier_service_id NUMBER) IS
1541: SELECT ship_method_code