DBA Data[Home] [Help]

APPS.CSP_PARTS_REQUIREMENT dependencies on FND_PROFILE

Line 1652: l_rqmt_header_rec.order_type_id := nvl(l_header_rec.order_type_id, FND_PROFILE.value('CSP_ORDER_TYPE'));

1648: l_rqmt_header_Rec.destination_subinventory := nvl(l_header_rec.dest_subinventory, FND_API.G_MISS_CHAR);
1649: l_rqmt_header_Rec.shipping_method_code := FND_API.G_MISS_CHAR;
1650: l_rqmt_header_Rec.parts_defined := nvl(l_parts_defined, FND_API.G_MISS_CHAR);
1651: l_rqmt_header_Rec.open_requirement := 'W';
1652: l_rqmt_header_rec.order_type_id := nvl(l_header_rec.order_type_id, FND_PROFILE.value('CSP_ORDER_TYPE'));
1653: l_rqmt_header_rec.attribute_Category := nvl(l_header_rec.attribute_category, FND_API.G_MISS_CHAR);
1654: l_rqmt_header_rec.attribute1 := nvl(l_header_rec.attribute1, FND_API.G_MISS_CHAR);
1655: l_rqmt_header_rec.attribute2 := nvl(l_header_rec.attribute2, FND_API.G_MISS_CHAR);
1656: l_rqmt_header_rec.attribute3 := nvl(l_header_rec.attribute3, FND_API.G_MISS_CHAR);

Line 2352: nvl(order_type_id, FND_PROFILE.value('CSP_ORDER_TYPE')),

2348: IF (l_count > 0) THEN
2349: BEGIN
2350: SELECT
2351: requirement_header_id,
2352: nvl(order_type_id, FND_PROFILE.value('CSP_ORDER_TYPE')),
2353: ship_to_location_id,
2354: need_by_date,
2355: destination_organization_id,
2356: destination_subinventory