APPS.WSH_FLEXFIELD_UTILS dependencies on WSH_NEW_DELIVERIES

Line 185: -- IF l_table_name <> 'WSH_NEW_DELIVERIES' THEN

181:
182: l_table_name := UPPER(p_table_name);
183:
184: -- 2530743 : Commenting this as this Fn./Proc. will be needed for other DFFs too
185: -- IF l_table_name <> 'WSH_NEW_DELIVERIES' THEN
186: -- RAISE Invalid_Table;
187: -- END IF;
188:
189: IF g_def_attributes.count <> 0 THEN

Line 530: IF (UPPER(p_table_name) = 'WSH_NEW_DELIVERIES') THEN

526: END IF;
527:
528: IF update_flag = 'Y' THEN
529:
530: IF (UPPER(p_table_name) = 'WSH_NEW_DELIVERIES') THEN
531: UPDATE wsh_new_deliveries
532: SET Attribute_Category = context,
533: Attribute1 = attributes(1),
534: Attribute2 = attributes(2),

Line 531: UPDATE wsh_new_deliveries

527:
528: IF update_flag = 'Y' THEN
529:
530: IF (UPPER(p_table_name) = 'WSH_NEW_DELIVERIES') THEN
531: UPDATE wsh_new_deliveries
532: SET Attribute_Category = context,
533: Attribute1 = attributes(1),
534: Attribute2 = attributes(2),
535: Attribute3 = attributes(3),

Line 644: from wsh_new_deliveries

640:
641: cursor c_wnd_attributes(c_delivery_id NUMBER) is
642: select attribute_category, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7,
643: attribute8, attribute9, attribute10, attribute11, attribute12, attribute13, attribute14, attribute15
644: from wsh_new_deliveries
645: where delivery_id = c_delivery_id;
646:
647: -- Cussor added for Bug 3118519
648: cursor c_wdd_attributes(c_delivery_detail_id NUMBER) is

Line 689: IF (UPPER(p_table_name) = 'WSH_NEW_DELIVERIES') THEN

685: END IF;
686: --
687: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
688:
689: IF (UPPER(p_table_name) = 'WSH_NEW_DELIVERIES') THEN
690:
691: open c_wnd_attributes(p_primary_id);
692: fetch c_wnd_attributes into
693: l_context, l_attribute1, l_attribute2, l_attribute3, l_attribute4, l_attribute5,

Line 877: -- IF l_table_name <> 'WSH_NEW_DELIVERIES' THEN

873:
874: l_table_name := UPPER(p_table_name);
875:
876: -- 2530743 : Commenting this as this Fn./Proc. will be needed for other DFFs too
877: -- IF l_table_name <> 'WSH_NEW_DELIVERIES' THEN
878: -- RAISE Invalid_Table;
879: -- END IF;
880:
881: IF g_check_req.count <> 0 THEN

Line 1047: -- IF l_table_name <> 'WSH_NEW_DELIVERIES' THEN

1043:
1044: l_table_name := UPPER(p_table_name);
1045:
1046: -- 2530743 : Commenting this as this Fn./Proc. will be needed for other DFFs too
1047: -- IF l_table_name <> 'WSH_NEW_DELIVERIES' THEN
1048: -- RAISE Invalid_Table;
1049: -- END IF;
1050:
1051: IF g_validate_context.count <> 0 THEN

Line 1224: IF (p_table_name = 'WSH_NEW_DELIVERIES') THEN

1220: WSH_DEBUG_SV.log(l_module_name,'P_PRIMARY_ID',P_PRIMARY_ID);
1221: END IF;
1222: --
1223: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1224: IF (p_table_name = 'WSH_NEW_DELIVERIES') THEN
1225: l_token := FND_MESSAGE.Get_String('WSH', 'WSH_DELIVERY_DFF_TITLE');
1226: END IF;
1227:
1228: j := Check_DFF_Req(p_table_name => p_table_name,

Line 1298: IF ( UPPER(p_table_name) = 'WSH_NEW_DELIVERIES' ) THEN

1294: EXCEPTION
1295: WHEN Required_Attributes_Empty THEN
1296: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1297: -- IF condition Added for Bug 3118519
1298: IF ( UPPER(p_table_name) = 'WSH_NEW_DELIVERIES' ) THEN
1299: FND_MESSAGE.Set_Name('WSH', 'WSH_DFF_ATTRIBUTE_EMPTY');
1300: FND_MESSAGE.Set_Token('DFF_TITLE', l_token);
1301: WSH_UTIL_CORE.Add_Message(x_return_status);
1302: END IF;