DBA Data[Home] [Help]

APPS.WSH_CARRIER_SERVICES_PKG dependencies on WSH_ORG_CARRIER_SERVICES

Line 1400: l_procedure := 'Updating WSH_ORG_CARRIER_SERVICES';

1396: WHERE ship_method_code = p_ship_method_code
1397: AND freight_code = p_freight_code;
1398:
1399: l_position := 20;
1400: l_procedure := 'Updating WSH_ORG_CARRIER_SERVICES';
1401:
1402: UPDATE wsh_org_carrier_services
1403: SET enabled_flag = 'N'
1404: WHERE carrier_service_id= p_carrier_service_id;

Line 1402: UPDATE wsh_org_carrier_services

1398:
1399: l_position := 20;
1400: l_procedure := 'Updating WSH_ORG_CARRIER_SERVICES';
1401:
1402: UPDATE wsh_org_carrier_services
1403: SET enabled_flag = 'N'
1404: WHERE carrier_service_id= p_carrier_service_id;
1405:
1406: --

Line 1456: --DESCRIPTION: This function is called from the wsh_org_carrier_services_v to get the value of global variable G_carrier_service_id

1452: -- VERSION : current version 1.0
1453: -- initial version 1.0
1454: -- COMMENT : This function returns value of global variable G_carrier_service_id
1455: --
1456: --DESCRIPTION: This function is called from the wsh_org_carrier_services_v to get the value of global variable G_carrier_service_id
1457: --========================================================================
1458: FUNCTION Get_carrier_service_id Return Number
1459: IS
1460: BEGIN