1014: funcmode IN VARCHAR2,
1015: resultout OUT NOCOPY VARCHAR2 ) IS
1016:
1017: l_screening_flag VARCHAR2(1);
1018: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
1019: l_organization_id NUMBER;
1020:
1021: l_return_status VARCHAR2(30);
1022: e_param_not_defined EXCEPTION;
1045: IF (funcmode = 'RUN') THEN
1046:
1047: l_screening_flag := 'N';
1048: IF l_debug_on THEN
1049: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.GET',
1050: WSH_DEBUG_SV.C_PROC_LEVEL);
1051: END IF;
1052:
1053: l_organization_id := WF_ENGINE.GetItemAttrText(itemtype,itemkey,'ORG_ID',FALSE);
1050: WSH_DEBUG_SV.C_PROC_LEVEL);
1051: END IF;
1052:
1053: l_organization_id := WF_ENGINE.GetItemAttrText(itemtype,itemkey,'ORG_ID',FALSE);
1054: WSH_SHIPPING_PARAMS_PVT.Get(p_organization_id => l_organization_id,
1055: x_param_info => l_param_info,
1056: x_return_status => l_return_status);
1057: IF l_debug_on THEN
1058: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1129: funcmode IN VARCHAR2,
1130: resultout OUT NOCOPY VARCHAR2 ) IS
1131:
1132: l_screening_flag VARCHAR2(1);
1133: l_param_info WSH_SHIPPING_PARAMS_PVT.Parameter_Rec_Typ;
1134: l_organization_id NUMBER;
1135:
1136: l_return_status VARCHAR2(30);
1137: e_param_not_defined EXCEPTION;
1160: IF (funcmode = 'RUN') THEN
1161:
1162: l_screening_flag := 'N';
1163: IF l_debug_on THEN
1164: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.GET',
1165: WSH_DEBUG_SV.C_PROC_LEVEL);
1166: END IF;
1167:
1168: l_organization_id := WF_ENGINE.GetItemAttrText(itemtype,itemkey,'ORG_ID',FALSE);
1165: WSH_DEBUG_SV.C_PROC_LEVEL);
1166: END IF;
1167:
1168: l_organization_id := WF_ENGINE.GetItemAttrText(itemtype,itemkey,'ORG_ID',FALSE);
1169: WSH_SHIPPING_PARAMS_PVT.Get(p_organization_id => l_organization_id,
1170: x_param_info => l_param_info,
1171: x_return_status => l_return_status);
1172: IF l_debug_on THEN
1173: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);