DBA Data[Home] [Help]

APPS.WSH_DELIVERY_VALIDATIONS dependencies on WSH_DELIVERY_AUTOCREATE

Line 1912: l_group_by_attr wsh_delivery_autocreate.group_by_flags_rec_type;

1908: l_pickup_dep_date DATE;
1909: l_dropoff_arr_date DATE;
1910: l_dropoff_dep_date DATE;
1911:
1912: l_group_by_attr wsh_delivery_autocreate.group_by_flags_rec_type;
1913: l_return_status VARCHAR2(1);
1914:
1915: invalid_status EXCEPTION;
1916: INVALID_TRIPSHIPMETHOD_DEL_ORG EXCEPTION;

Line 2115: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.GET_GROUP_BY_ATTR',WSH_DEBUG_SV.C_PROC_LEVEL);

2111: --
2112: -- Debug Statements
2113: --
2114: IF l_debug_on THEN
2115: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.GET_GROUP_BY_ATTR',WSH_DEBUG_SV.C_PROC_LEVEL);
2116: END IF;
2117: --
2118: wsh_delivery_autocreate.get_group_by_attr( p_organization_id => l_org_id,
2119: x_group_by_flags => l_group_by_attr,

Line 2118: wsh_delivery_autocreate.get_group_by_attr( p_organization_id => l_org_id,

2114: IF l_debug_on THEN
2115: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.GET_GROUP_BY_ATTR',WSH_DEBUG_SV.C_PROC_LEVEL);
2116: END IF;
2117: --
2118: wsh_delivery_autocreate.get_group_by_attr( p_organization_id => l_org_id,
2119: x_group_by_flags => l_group_by_attr,
2120: x_return_status => l_return_status);
2121:
2122: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

Line 4889: l_group_by_attr wsh_delivery_autocreate.group_by_flags_rec_type;

4885: l_del_status VARCHAR2(2);
4886: l_detail_num NUMBER;
4887: l_org_id NUMBER;
4888:
4889: l_group_by_attr wsh_delivery_autocreate.group_by_flags_rec_type;
4890: l_return_status VARCHAR2(1);
4891: others EXCEPTION;
4892:
4893: --

Line 4958: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.GET_GROUP_BY_ATTR',WSH_DEBUG_SV.C_PROC_LEVEL);

4954: --
4955: -- Debug Statements
4956: --
4957: IF l_debug_on THEN
4958: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.GET_GROUP_BY_ATTR',WSH_DEBUG_SV.C_PROC_LEVEL);
4959: END IF;
4960: --
4961: wsh_delivery_autocreate.get_group_by_attr( p_organization_id => l_org_id,
4962: x_group_by_flags => l_group_by_attr,

Line 4961: wsh_delivery_autocreate.get_group_by_attr( p_organization_id => l_org_id,

4957: IF l_debug_on THEN
4958: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_AUTOCREATE.GET_GROUP_BY_ATTR',WSH_DEBUG_SV.C_PROC_LEVEL);
4959: END IF;
4960: --
4961: wsh_delivery_autocreate.get_group_by_attr( p_organization_id => l_org_id,
4962: x_group_by_flags => l_group_by_attr,
4963: x_return_status => l_return_status);
4964:
4965: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN